Dividend Input Method
$
Expected dividend in next 12 months
Growth & Discount
%/yr
Long-term sustainable growth rate
%
WACC, CAPM, or personal hurdle rate
Market Price optional
$
Intrinsic Value (Gordon Growth)
Enter D₁ (or D₀), growth rate and required return
D₁ Applied
Spread (r − g)
Market Price
Margin of Safety
Upside / Downside
Implied Yield at IV
Intrinsic Value vs Required Return (r)

What each tab calculates

01

Gordon Growth

Single-stage DDM using the Gordon Growth Model. Enter D₁ or compute it from D₀ × (1+g). Supports direct D₁ entry or D₀ with auto-calculation. Results include intrinsic value, spread, margin of safety, upside/downside, and a value vs required return curve.

02

Two-Stage DDM

Models a high-growth period (Stage 1) followed by a stable terminal growth phase (Stage 2). Shows PV of each stage, terminal value, year-by-year dividend stream table, and a PV breakdown chart split between Stage 1 and the terminal value component.

03

Sensitivity Matrix

Generates a full grid of intrinsic values across a range of growth rates (g) and discount rates (r). Color-codes each cell as undervalued or overvalued against the current market price. Identifies the number of scenarios where the stock is undervalued.

04

Compare

Side-by-side Gordon Growth DDM for up to 6 stocks. Each row calculates intrinsic value, margin of safety, and verdict automatically. A grouped bar chart compares intrinsic value vs market price for all stocks simultaneously.

05

Reverse DDM

Works backwards from market price to find either the implied growth rate (given r) or the implied required return (given g). Compares the implied value against your target assumption to assess whether the market's embedded expectations are realistic.