Dividend Tracker Spreadsheet, Stock Income Calculator, Portfolio Yield Planner (Excel, Google Sheets)

Build cash flow that never sleeps. Dividend Income Pro is a complete spreadsheet system that turns dividend investing into a clear, trackable plan. Five named engines work together so you can avoid yield traps, project 30 years of compound returns, optimize taxes through smart account placement, and build your holdings in the right order. Works for any portfolio size, in both Excel and Google Sheets, with instant download.

Dividend Income Score (0–100)

An auto-calculated score from five weighted components that updates as you log holdings, track risk, and check tax efficiency. Above 85 means your income engine is fully on track; below 70 means it is time to tighten the plan or check for yield traps.

What you get

• Excel file with 9 tabs and 1,017 live formulas
• Google Sheets compatible
• Quick Start Guide PDF (6 pages)
• Strategy Guide PDF (6 pages)
• CSV export for non-Excel users
• Free lifetime updates

Five named engines

• Dividend Income Score Engine — a weighted score out of 100 across Yield Quality (25%), Income Stability (20%), Growth Rate (20%), Tax Efficiency (20%) and Diversification (15%).
• Portfolio Tracker Engine — 25 holdings with a full color-coded breakdown across 13 sectors, using the Wall Street CFA / analyst color standard.
• Income Forecast Engine — a 12-month rolling payout calendar with auto-detected monthly and quarterly payers.
• Growth & Compound Engine — a 30-year compound projection with a DRIP toggle.
• Risk & Quality Engine — a Yield Trap Detector with four-tier classification and an auto cut-risk score per holding.

Inside every tab

• Start Here — setup wizard and color code explained
• Dashboard — live score, 5 KPI cards, doughnut charts
• Portfolio Holdings — 25 holdings, 13 sector breakdown
• Income Calendar — 12-month forecast with quarterly spikes
• Growth & Compound — 30-year DRIP projection
• Risk & Quality — Yield Trap Detector with 4 tiers
• Tax Optimization — account placement matrix
• Goals & Targets — 8 milestones with auto-progress

Who it is for

• The FIRE builder, building toward financial independence
• The new dividend investor, learning to spot yield traps
• The retiring income investor in retirement transition
• The growth optimizer running a long-term compounding strategy

Instant delivery

Files arrive immediately after purchase: the Excel file (.xlsx), a CSV export, a Quick Start Guide PDF and a Strategy Guide PDF. Works on Mac, Windows, iOS and Android. No subscription, no login.

File details

• Format: .xlsx and .csv
• 9 spreadsheet tabs plus 12 PDF pages
• 1,017 live formulas
• Compatible with Excel 2016+, Google Sheets, LibreOffice and Numbers
• Free lifetime updates

Educational and personal tracking only. This is not financial advice. Tax rates referenced follow 2024 US IRS guidelines and may change; verify current rates with IRS.gov. Designed and built by SpendFlow Studio.