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. 

*Note that the financial data (e.g., revenue, expenses, etc) is not dynamic and must be entered manually. But the margins, valuations, growth rates, and other metrics will auto-populate.

Click here to buy the Excel spreadsheet