← Back to Templates

Dividend Growth Model (Gordon Method

Description

Dividend Growth Model (Gordon Method thumbnail

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

Dividend Growth Model (Gordon Method screenshot 1

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?
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found