# Dividend Discount Model Build a dividend discount model with multi-stage growth dynamics, sustainable payout ratio analysis, and CAPM-based discounting to estimate intrinsic value for income-generating equities. - Canonical: https://finamodel.com/templates/dividend-discount-model - Excel download: https://finamodel.com/templates/dividend-discount.xlsx - Category: Capital Markets - Model type: Valuation - Difficulty: Intermediate - Audiences: Investors & analysts, CFOs & FP&A, Equity analysts, Income investors, Portfolio managers, Equity research - Tags: valuation, dividend, income, yield, growth ## Overview The dividend discount model (DDM) values a mature, dividend-paying stock by projecting future dividend payments and discounting them back to present value. It is the preferred valuation method for companies with stable dividend policies (utilities, REITs, dividend aristocrats), where cash returns to shareholders are predictable and less subject to reinvestment risk than retained earnings. The model projects dividends through explicit forecast years (typically 5–10 years) using an assumed growth rate, then applies a terminal growth rate (usually 2–3%, aligned with long-run GDP growth) to estimate dividends in perpetuity. The workbook begins with historical payout ratios and analyzes dividend sustainability: if a company pays 80% of earnings as dividends and earnings growth is positive, the payout ratio will shrink and the dividend is safe. The discount rate (required return) is derived from the capital asset pricing model (CAPM), capturing the investor's cost of equity. Sensitivity analysis shows how the fair value per share changes across a range of growth rates and required returns, allowing you to see whether the stock is cheap, fair, or expensive at the current market price. This model is standard for income-focused investors, pension funds, and dividend-growth strategies. It works for any dividend-paying stock with at least 5–10 years of stable history and predictable payout policy. ## What's included - Multi-stage (2 or 3 stage) dividend growth forecast - Cost of equity build-up using CAPM inputs - Sustainable growth rate calculation from ROE and retention ratio - Terminal value using the Gordon Growth method - Sensitivity analysis for discount rates and terminal growth - Historical dividend data and payout ratio analysis - Multi-stage dividend growth forecast (high-growth, transition, terminal) - Terminal dividend yield calculation - Discount rate (required return) derivation - Per-share valuation and sensitivity to key assumptions - Comparison to market price and upside/downside analysis ## Dividend Discount Model: How This Equity Valuation Template Works This dividend discount model template estimates a company's intrinsic share value by projecting dividends over five years and extending them with a Gordon Growth terminal stage. It includes driver assumptions, cost of equity build-up, a dividend schedule, an H-model cross-check, a sensitivity grid, and eight validation checks to support income-focused equity analysis. ### Operating drivers and scenario layer The model uses a driver-based income statement: revenue is split across Products, Services, and Licensing, each with a base and five per-year growth rates. - COGS follows a linear glide from a starting to a target percentage, and operating expenses combine fixed growth patterns with revenue-linked marketing and R&D. - A four-row debt rollforward feeds interest expense, while a share rollforward drives both DPS and EPS on average shares. - A scenario selector flexes four key drivers: a uniform revenue growth delta, terminal growth, equity beta, and a payout delta that shifts cost of equity, the dividend path, and terminal value without altering the underlying formulas. ### Calculation flow from dividends to value Net income from the income statement links to the dividend schedule, where total dividends are calculated as net income times the payout ratio, floored at zero. DPS is derived using average shares from the buyback rollforward. - The valuation then discounts each year's DPS at the CAPM cost of equity and adds the present value of the terminal value, computed as the Year 5 DPS times one plus terminal growth, divided by the cost of equity minus terminal growth. - An H-model provides a cross-check using trailing DPS and peak short-term growth, with a visible variance row to highlight differences between the two approaches. ### Outputs and diagnostics The headline output is the implied share price, broken into the present value of explicit dividends and the terminal value contribution. Additional outputs include the terminal value as a percentage of total value, the implied steady-state payout, and an H-model variance. - A market context section compares the implied price to a current share price input to generate upside or downside and a buy, hold, or sell recommendation. Implied multiples like forward P/E, Gordon-justified P/E, and implied P/B provide valuation context. - A 7x7 sensitivity grid sweeps cost of equity and terminal growth to show how value responds to discount rate and growth assumptions. ### Practical use and validation checks Eight validation checks monitor payout ratios, dividend non-negativity, the Gordon constraint, terminal value percentage, EBITDA margin, EPS positivity, dividend coverage, and whether assumed terminal growth exceeds sustainable growth. - These checks help users avoid common pitfalls such as setting terminal growth above the cost of equity or pushing payout beyond feasible limits. - The model is scoped to equity valuation only and does not include a full balance sheet or cash flow statement. - Public templates are provided as values-only previews; the underlying model captures the full calculation logic but does not automatically recalculate in the free download. ## Built for income stock valuation Use this model when dividends are a reliable proxy for cash flow and the company has an established payout history. ## Grounded in fundamental drivers A useful DDM links the sustainable growth rate to ROE and retention rather than relying on arbitrary growth assumptions. ## Useful alongside other valuation methods This gives you a structured dividend-based view that complements DCF and comparable company analysis. ## Built for income stock valuation Use this model when dividends are a reliable proxy for cash flow and the company has an established payout history. ## Grounded in fundamental drivers A useful DDM links the sustainable growth rate to ROE and retention rather than relying on arbitrary growth assumptions. ## Useful alongside other valuation methods This gives you a structured dividend-based view that complements DCF and comparable company analysis. ## Features - **Multi-stage dividend modeling:** Separately forecast high-growth dividends in years 1-5, transition growth in years 6-10, and perpetual growth beyond. - **Payout sustainability check:** Ensure dividend growth assumptions align with earnings growth and capital needs to validate dividend sustainability. - **Sensitivity across growth and discount rates:** Test valuation across a range of terminal growth (2–4%) and discount rates (7–12%) to establish valuation range. ## Use cases - **Income portfolio selection:** Rank dividend stocks by yield and dividend growth safety to build a high-income, low-risk portfolio. - **Dividend cut risk assessment:** Model whether earnings growth supports current dividend; identify candidates for cut risk. - **Long-term retirement income planning:** Forecast dividend streams to beneficiaries and test whether they meet income needs. ## Frequently asked questions ### What is a dividend discount model? It is a valuation model that estimates the intrinsic value of a stock by discounting expected future dividends back to present value. ### When should I use a DDM instead of a DCF? DDM is most effective for mature companies where dividends are closely aligned with free cash flow to equity and there is an established payout history. ### What should a DDM include? It should include dividend growth assumptions, cost of equity, sustainable growth rate logic, terminal value, and sensitivity analysis. ### How does the model handle growth transitions? The model uses multi-stage logic to transition from a high-growth phase to a stable maturity stage, reflecting how payout capabilities shift over time. ### Can I test different payout ratios? Yes. The model shows how changing the payout ratio affects immediate dividends, the sustainable growth rate, and total intrinsic value. ## Related templates - [DCF Model](https://finamodel.com/templates/dcf-model) - [Comparable Companies Analysis](https://finamodel.com/templates/comparable-company-analysis) - [Equity Portfolio Analysis](https://finamodel.com/templates/equity-portfolio-model)