Dividend Income Tracker & Analyzer
Dividend Income Tracker & Analyzer
Track Every Dividend. Grow Your Passive Income. Build Real Wealth.
Dividend investing is one of the most reliable paths to financial freedom — but only if you track it properly.
This is a complete, professional-grade dividend portfolio management system — 13 integrated sheets with 40+ automated calculations, scenario modeling, DRIP projections, and tax reporting. Built for serious dividend investors who want institutional-quality tracking.
What Makes This Different
📊 Live Dashboard — 8 auto-calculating KPI cards: total income, portfolio yield, YOC, growth rate, monthly average, holdings count, next payout, and goal progress
📋 13 Integrated Sheets — Holdings entry, dividend calendar, monthly income tracker, YOC analysis, sector heatmap, income goals, DRIP simulator, scenario planner, dividend aristocrats watchlist, and tax summary
🔄 DRIP Compound Growth Simulator — 20-year projection with configurable yield, growth rate, contributions, and price appreciation
🔮 Scenario Planner — Best/base/worst case income projections over 5 years with adjustable assumptions
🗺️ Portfolio Heatmap — Sector allocation analysis with diversification scorecard and concentration warnings
🎯 Income Goal Tracker — Set target monthly income, track milestones, visualize progress with a built-in progress bar
🧾 Tax Summary Sheet — Annual consolidated view with qualified/ordinary breakdown and per-holding detail
📚 Dividend Aristocrats Watchlist — 18 pre-loaded blue-chip companies with priority ratings based on yield, streak, and growth
What's Inside — All 13 Sheets
- Dashboard — Central command center with 8 KPI cards, top payers, sector breakdown, and navigation to all sheets
- How To Use — Step-by-step walkthrough with color-coded input cell guide
- Changelog — Full version history documenting every upgrade
- Dividend Holdings — Main data entry for 50 holdings with dropdowns (sector, exchange, frequency), 15 auto-calculated columns including YOC, yield, unrealized gains, and portfolio concentration
- Dividend Calendar — Monthly calendar view of incoming payouts with expected vs. actual tracking and variance analysis
- Monthly Income — Month-by-month income tracking with category breakdowns (qualified, ordinary, foreign tax), cumulative totals, year-over-year comparison, and embedded bar chart
- Yield on Cost — YOC analysis for each holding with star ratings and growth tracking
- Portfolio Heatmap — Sector allocation table with # holdings, total value, % of portfolio, sector yield, concentration warnings, diversification scorecard, embedded pie chart, and bar chart
- Income Goals — Set monthly target, see gap analysis, track 6 income milestones with ✅/❌ status, and visual progress bar
- DRIP Simulator — 20-year compound growth projection with 6 configurable inputs (initial value, yield, growth rate, contributions, price growth)
- Scenario Planner — Best/base/worst case 5-year income projections with adjustable growth, yield, contribution, and inflation assumptions
- Dividend Aristocrats — 18 pre-loaded aristocrats and kings with yield, consecutive years, 5yr growth, payout ratio, and priority ratings
- Tax Summary — Annual tax reporting view with total ordinary/qualified/capital gain/ROC totals, estimated tax calculations, and per-holding breakdown
Technical Features
- 40+ automated formulas — INDEX/MATCH lookups, SUMIFS aggregations, IFERROR error handling, compound growth projections
- Data validation dropdowns — Sector (12 options), exchange (6 options), payment frequency (4 options), priority ratings
- Conditional formatting — High-yield warnings (>8%), unrealized gain/loss coloring, concentration alerts, priority badges
- Embedded charts — Monthly income bar chart, sector allocation pie chart, income-by-sector bar chart, DRIP projection line chart, scenario comparison chart
- Named ranges — TotalPortfolioValue, HoldingsData, IncomeData for clean cross-sheet references
- Color-coded cells — Light blue = input, light green = calculated, yellow = warnings, dark navy = headers
- Print-ready formatting — Landscape orientation, fit-to-page, proper margins on all sheets
- Frozen panes — Headers stay visible while scrolling on every data sheet
Who It's For
Dividend investors at any level — from beginners building their first dividend portfolio to experienced investors managing 30+ holdings across multiple sectors. If you want to see exactly how much passive income you're generating, where it's coming from, and how fast it's growing, this tracker gives you the complete picture.
Technical Details
- Compatible with Excel, Google Sheets, and LibreOffice Calc
- XLSX format — no special software or plugins needed
- All formulas included — just enter your holdings and the calculations work automatically
- Supports up to 50 individual holdings
- Works offline — no internet connection or API keys required
Recent Updates
- v2.0 (April 2026): Complete overhaul — expanded from 6 sheets to 13 integrated sheets. Added Dashboard with 8 KPI cards, How To Use guide, Changelog, Dividend Holdings with full data validation, Dividend Calendar with monthly variance tracking, Yield on Cost with star ratings, Portfolio Heatmap with diversification scorecard, Income Goal milestone tracker, DRIP Simulator (20-year projections), Scenario Planner (best/base/worst case), Dividend Aristocrats watchlist (18 companies), and Tax Summary. Added 40+ automated formulas, embedded charts, conditional formatting, named ranges, and print-ready formatting.
🛡️ 30-Day Money Back Guarantee
Not satisfied? Full refund, no questions asked.
Instant digital download • Works with Excel, Google Sheets & LibreOffice