← Back to Templates

Capitalization of Earnings Valuation Model

Description

Capitalization of Earnings Valuation Model thumbnail

Values a business by capitalizing a normalized earnings figure at a rate you set. EBIT is pulled for the company along with return on capital and current market capitalization, so the capitalization rate can be checked against the returns the business actually earns rather than picked in isolation. Enter your own normalization adjustments and required return and the sheet produces an indicated value to compare directly against market capitalization. The method fits stable, cash generative companies better than cyclicals, where one earnings number is a poor proxy for the future.

Template Screenshots

Capitalization of Earnings Valuation Model screenshot 1

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
How does MarketXLS work?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found