StableBread Logo

Dividend Growth Analysis (DGA)

Relevant: How to Estimate the Perpetual Dividend Growth Rate

DGA Overview

The Dividend Growth Analysis (DGA) tab analyzes historical dividends and earnings to help inform the stable (perpetual) dividend growth rate used in the Dividend Discount Model (DDM) tab.

ROE DuPont Analysis

Decomposes ROE into its profitability, efficiency, and leverage drivers to better understand what's sustaining or limiting dividend growth capacity:

ROE = Net Income Margin × Asset Turnover Ratio × Equity Multiplier

Dga: Roe Dupont Analysis
DGA: ROE DuPont Analysis

Sustainable Growth Rates

DPR and ROE are calculated across the last 10 fiscal years from IS, BS, and CFS data:

  • DPR shows what portion of earnings is paid as dividends.
  • ROE shows the return generated on shareholders' equity.

Both feed directly into the three sustainable growth rate (SGR) formulas below:

Dga: Sustainable Growth Rates
DGA: Sustainable Growth Rates

SGR = ROE × (1 - DPR)

Augmented DPR = (Dividends + Stock Buybacks) / Net Income

Augmented SGR = ROE × (1 - Augmented DPR)

Augmented DPR = (Dividends + Stock Buybacks - New Long-Term Debt Issued) / Net Income

Augmented SGR = ROE × (1 - Augmented DPR)

M#2 accounts for companies funding buybacks with debt, which overstates sustainable growth under M#1.

Growth Rate Analysis

Avg Growth Rate Analysis

Displays average DPS growth rates across 1Y to 9Y periods, with average and median summary rows.

Dga: Avg Growth Rate Analysis
DGA: Avg Growth Rate Analysis

Conditional formatting highlights growth rate magnitude.

CAGR Analysis

Displays DPS CAGRs across 1Y to 9Y periods, with average and median summary rows.

Dga: Cagr Analysis
DGA: CAGR Analysis

Same conditional formatting as the Avg Growth Rate section.

chevron-downchevron-down-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram