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.