Building a Dividend Growth Portfolio? Here's How to Project Your Future Income
As a retail investor, one of the most powerful tools in your arsenal is the ability to project your dividend income over time. Whether you're saving for retirement or building passive income, understanding how dividend growth compounds is essential.
The problem? Most spreadsheets are either too complex (10-tab monsters with macros) or too simple (just multiply shares × dividend). Today I want to share a practical approach using Google Sheets.
The Core Formula
The magic of dividend growth investing comes from this simple formula:
Future Dividend = Current Dividend × (1 + Growth Rate)^Years
But that's just for one stock. A real portfolio has 15-30 positions, each growing at different rates. That's where a spreadsheet template saves hours of manual work.
What You Need
To project dividend income, you need three things:
- Current dividend per share for each stock you own
- Historical growth rates (1Y, 3Y, 5Y, 10Y) - available free on Seeking Alpha or Simply Safe Dividends
- Number of shares you own (or plan to buy)
The Process
The most reliable approach is to use multiple growth rate scenarios:
- Conservative: Use the lowest growth rate from the last 5 years (or 25th percentile)
- Moderate: Use the CAGR from the last 5-10 years
- Aggressive: Use the highest growth rate from the last 3 years (or 75th percentile)
Then project each scenario forward 5, 10, 15, and 20 years. The difference between conservative and aggressive projections gives you a realistic range.
Sample Projection (JNJ - Johnson & Johnson)
Current dividend: $4.76/share
Recent growth rate: ~5.5% annually
If you own 100 shares:
- Year 1: $476.00
- Year 5 (conservative 3%): $551.00
- Year 5 (moderate 5.5%): $621.00
- Year 10 (moderate 5.5%): $812.00
- Year 20 (moderate 5.5%): $1,387.00
Do this for 15-20 stocks in your portfolio and you'll see your income snowball.
Free Template
I've built a complete Google Sheets template with all these formulas pre-loaded, plus 30 dividend stocks already entered (JNJ, KO, PEP, PG, AAPL, MSFT, V, and more). It includes:
- 20-year projection with 3 growth scenarios
- Pre-filled dividend safety scores
- Portfolio dashboard with year-over-year comparisons
- Conditional formatting for safety scoring
You can grab it here: https://microtoolsb2b.gumroad.com/l/DTZAM (it's $24, not free, but saves you 2-3 hours of spreadsheet building)
Getting Started
The hardest part is entering the first few stocks. Start with your top 5 positions. Once you see the projected income for Year 10 and Year 20, you'll be motivated to add the rest.
Happy investing! 🚀
