← Back to Templates


Dividend Growth Model (Gordon Method
Description

Uses the Gordon growth model on a dividend payer: trailing dividend per share, a growth rate and a required return produce an intrinsic value that sits next to the current ask price. Sector and industry labels travel with it so the growth assumption can be judged against the kind of business it is.
A sensitivity grid varies growth and discount rate together, which is the honest way to show this model, because the output moves violently once those two inputs get close.
Template Screenshots

Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found