The AI-powered dividend tracker Excel template built for income investors. Automatically track dividends across your entire portfolio, forecast passive income 12–36 months out, and identify underperforming yield positions — all in one spreadsheet. Stop guessing what your dividend income will look like next year.
Instant download · Unlimited holdings · Excel 2016+ · Free 2026 updates
Get this template + 3 more in the Finance Pro Bundle — $249 (save $65)
View the Bundle →Projects your dividend income 12 to 36 months forward based on historical payout data, dividend growth rates, and your current holdings. Model flat, growth, and cut scenarios side by side.
See exactly which dividends land in which month. The calendar normalizes monthly, quarterly, semi-annual, and annual payers so you can plan your cash flow with precision.
AI compares yield-on-cost vs current yield across your portfolio and flags positions where capital could be redeployed for higher income without increasing risk.
Track dividend CAGR for every holding over 1, 3, and 5-year periods. Quickly identify dividend growers, cutters, and stagnant payers that may be falling behind inflation.
Never miss a dividend again. Log ex-dividend dates for every holding and the template flags upcoming payouts so you can make informed buy/sell decisions before the record date.
Model the compounding impact of dividend reinvestment plans. See how DRIP participation affects your income trajectory and total return over 5–20 year horizons.
The Dividend Income Tracker & Forecaster Pro 2026 is an AI-powered Excel spreadsheet that transforms how dividend investors manage their portfolios. Whether you're building a retirement income stream, running a covered call portfolio, or managing client income accounts — this template automates the tracking, surfaces the insights, and gives you a clear picture of your passive income for the year ahead.
At its core is the AI income forecasting engine. It takes your current holdings, analyzes historical payout data and dividend growth rates, and projects your income forward 12 to 36 months. You get three scenarios: flat dividends (conservative), historical growth rate maintained (base), and accelerated growth (optimistic). The result is a precise monthly income projection you can actually plan around — not the vague "estimated annual yield" number your brokerage shows you.
The monthly income calendar is the feature users cite most. It normalizes every payout frequency — monthly REITs, quarterly blue chips, semi-annual international stocks — into a unified cash flow view. You can see at a glance which months are heavy and which are light, and adjust allocations accordingly. For retirees or income-dependent investors, this replaces hours of manual tracking with a single dashboard.
The yield optimization module goes beyond simple current yield. It tracks yield-on-cost (what you're actually earning on your original investment) alongside current yield (what a new buyer would earn), and flags positions where the gap suggests it's time to rotate. If you bought a position at $20 that's now at $45, your yield-on-cost looks great — but the AI will tell you if redeploying that capital into a current higher-yielder would increase your actual income.
For long-term compounders, the DRIP reinvestment model shows the power of automatic dividend reinvestment over time. Input your current holdings, dividend growth rate assumptions, and DRIP participation percentage, and the model projects your income trajectory and share accumulation over 5, 10, and 20-year horizons. It's the clearest visualization of why dividend reinvestment matters that most investors have ever seen.
Everything runs inside Excel. No external APIs, no subscriptions, no cloud uploads. Your portfolio data stays on your machine. Supports Excel 2016 and above on both Windows and Mac.
The Dividend Income Tracker & Forecaster Pro gives you AI-powered income projections, a monthly cash flow calendar, and yield optimization in one Excel template. $59, one-time.