FCFE (Free Cash Flow to Equity) Valuation Model

A complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model

fcfefinancefirmfree cash flow to equityoptionspresent valuer&dvaluation

Description
FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model with the following assumptions:

1. The firm is expected to grow at a higher growth rate in the first period.
2. The growth rate will drop at the end of the first period to the stable growth rate.
3. The dividend payout ratio is consistent with the expected growth rate.

Option: You can make this model into a three stage model by answering yes to the question of whether you want me to adjust the inputs in the second half of the high growth period. If you do, I will adjust the growth rate, the payout ratio and the cost of equity from high-growth levels to stable growth levels gradually.
You can also make this a stable growth model by setting the high
growth period to zero.

Note: this model is being shared with the authorization of Professor Aswath Damodaran from NYU Stern Business School (www.damodaran.com)

This business tool includes
1 Excel Model File

Prof. Aswath Damodaran offers you this business tool for free!

Download for free

Ask a question

Further information

The objective of this model is to get the following output values for a firm:

- Present Value of FCFEs in high growth phase
- Present Value of Terminal Equity Value
- Value of equity in operating assets
- Value of cash and marketable securities
- Value of equity in firm
- Value per share


How it works:

The expected dividends are estimated for the high growth period, using the payout
ratio for the high growth period and the expected growth rate in earnings per share.
The expected growth rate is estimated either using fundamentals:
Expected growth = Retention Ratio * Return on Equity
Alternatively, you can input the expected growth rate.

At the end of the high growth phase, the expected terminal price is estimated using
dividends per share one year after the high growth period, using the growth rate
in stable growth, the payout ratio in stable growth and the cost of equity in stable
growth.

The dividends per share and the terminal price are discounted back to the present at
the cost of equity changes.

If your cost of equity in stable growth is different from your cost of equity in high
growth, the cost of equity in the second half of the stable growth period will be
adjusted gradually from the high growth cost of equity to a stable growth cost of
equity.

INPUTS NEEDED:
1. Length of high growth period
2. Expected growth rate in earnings during the high growth period.
3. Dividend payout ratio during the high growth period.
4. Expected growth rate in earnings during the stable growth period.
5. Expected payout ratio during the stable growth period.
6. Current Earnings per share
7. Inputs for the Cost of Equity

Reviews

  • No review yet!

Any questions on FCFE (Free Cash Flow To Equity) Valuation Model?

The user community and author are here to help. Go ahead!

please wait...