Focused Valuation Spreadsheets

ABOUT THIS CONTENT

If you have a clear choice in terms of models - stable growth dividend discount, 2-stage FCFE etc. - you can download a spreadsheet for the specific model in this section.

Spreadsheets included:
• ddmst.xls - Stable growth, dividend discount model; best suited for firms growing at the same rate as the economy and paying residual cash as dividends.

• ddm2st.xls - Two-stage DDM; best suited for firms paying residual cash in dividends while having moderate growth.

• ddm3st.xls - Three-stage DDM; best suited for firms paying residual cash in dividends, while having high growth.

• fcfest.xls - Stable growth, FCFE discount model; best suited for firms in stable leverage and growing at the same rate as the economy.

• fcfe2st.xls - Two-stage FCFE discount model; best suited for firms with stable leverage and having moderate growth.

• fcfe3st.xls - Three-stage FCFE discount model; best suited for firms with stable leverage and having high growth.

• fcffst.xls - Stable growth FCFF discount model; best suited for firms growing at the same rate as the economy.

• fcff2st.xls - Two-stage FCFF discount model; best suited for firms with shifting leverage and growing at a moderate rate.

• fcff3st.xls - Three-stage FCFF discount model; best suited for firms with shifting leverage and high growth.

• evavaln.xls - Three-stage FCFF valuation model, also presented in terms of projected EVA.

• fcffgen.xls - A generalized FCFF model, where the operating margins are allowed to change each year; best suited for firms in transition.
Subjects: Finance, Spreadsheets
Source: Damodaran Online (visit original source)  
This content is for Premium, Lifetime Access members only.
Log In Register