Dividend Per Share 5 Year CAGR
Returns the five-year Compound Annual Growth Rate (CAGR) of dividend per share for a company. This metric is essential for dividend growth investors.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT, JNJ |
Formula
CAGR = (Ending DPS / Beginning DPS)^(1/5) - 1
Dividend Growth Classifications
| CAGR Level | Classification |
|---|---|
| > 10% | High dividend growth |
| 5-10% | Moderate growth |
| 2-5% | Slow growth |
| < 2% | Stagnant |
Notes
- Returns value as a decimal (0.08 = 8%)
- Non-dividend-paying stocks will show N/A
- Dividend Aristocrats typically have 5%+ CAGR
Syntax
=DividendPerShareFiveYearCAGR(Symbol)Returns
Five-year dividend per share CAGR as a decimal
Examples
=DividendPerShareFiveYearCAGR("AAPL")=DividendPerShareFiveYearCAGR("MSFT")=DividendPerShareFiveYearCAGR("JNJ")=DividendPerShareFiveYearCAGR("KO")*100When to Use
- Dividend growth investing analysis
- Identify consistent dividend growers
- Screen for Dividend Aristocrats/Kings
- Income portfolio building
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current dividend amount | DividendPerShare() |
| Dividend yield | DividendYield() |
| One-year dividend growth | DividendOneYearGrowth() |
| Ex-dividend date | Ex_DividendDate() |
Common Issues & FAQ
Why am I getting N/A?
The company may not pay dividends, or may not have a 5-year dividend history. Growth stocks often don't pay dividends.
Why is the value less than 1?
CAGR is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.08 = 8% annual growth).
What is a Dividend Aristocrat?
A company that has increased dividends for 25+ consecutive years. They typically have consistent dividend CAGR above inflation.
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Dividend Rate (Forward)
- Ex-Dividend Date
- Forward Annual Dividend Rate
- Forward Annual Dividend Yield
- Total Dividends Between Two Dates
- Consecutive Period of Increasing Dividend Payout
- Consecutive Period of Uninterrupted Dividend
- Dividend Date
See DividendPerShareFiveYearCAGR used in a complete workbook: Dividend Data in Excel: Late May 2026 Quality, Yield, and Payout Coverage Screen
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today