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.