Value Enhancement Spreadsheet


In this section, you will find a spreadsheet that reconciles EVA and DCF valuation, a model for estimating CFROI and a DCF version of a value enhancement spreadsheet.

Spreadsheets included:
• valenh.xls - This spreadsheet allows you to make a quick (and dirty) estimate of the effect of restructuring a firm in a discounted cashflow framework.

• fcffeva.xls - This spreadsheet shows the equivalence of the DCF and EVA approaches to valuation.

• cfroi.xls - This model uses a 2-stage FCFF model to estimate the appropriate firm value multiples for your firm. It will give you identical answers (in terms of value) as the 2-stage FCFF model.

Subjects: Finance, Spreadsheets
Source: Damodaran Online (visit original source)  
This content is for Premium, Lifetime Access members only.
Log In Register