← 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

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found