VALUATION MODEL

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. 

Click here to buy the Excel spreadsheet