Gordon Growth Excel Model
  • Gordon Growth Excel Model
Originally published: 22/06/2016 08:25
Last version published: 02/02/2018 14:49
Publication number: ELQ-60016-2
View all versions & Certificate
certified

Gordon Growth Excel Model

An Excel Valuation Model to value the equity in a stable firm paying dividends, with stable growth

dividendsfcfefinancefree cash flow to equitygordongrowthmodelstable growthvaluation

Description
This Gordon Growth Excel Valuation model is designed to value the equity in a stable firm paying dividends, which are roughly equal to Free Cashflows to Equity.

The user has to define the following inputs to the model:
1. Current Earnings per share and Payout ratio (Dividends/Earnings)
2. Cost of Equity or Inputs to the CAPM (Beta, Riskfree rate, Risk Premium)
3. Expected Growth Rate in Earnings and dividends forever.

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This business tool includes
1 Excel Model File

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

download for free

Add to bookmarks

Discuss

Further information

This is the output from the Gordon Growth Model

- Current Dividends per share
- Cost of Equity
- Expected Growth rate

Best suited for firms growing at the same rate as the economy and paying residual cash as dividends.

Assumptions in the model:
1. The firm is in steady state and will grow at a stable rate forever.
2. The firm pays out what it can afford to in dividends, i.e., Dividends = FCFE.

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Gordon Growth Excel Model?

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

please wait...