The model contains a few methods for analyzing the value of a business: EV/EBITDA, DCF, Residual Income (i.e., excess earnings). Additionally, there are measures for ROE, RNOA (Return on Net Operating Assets), and RONTC (Return on Net Tangible Capital).

By entering a required rate of return, desired multiples, and expected sales growth and margin estimates, analysts can better understand the true drivers of value for a given company. 

The model is pre-populated with placeholder data and formulas, so once you input your own estimates, it will automatically recalculate all of the values. 

In addition to the Income Statement, Balance Sheet, Shareholder's Equity and Cash Flow statements, there are also tabs for Segment Data, and how much return the company is able to generate on incremental capital. 

Click here to see the model.