Dividend Income Tracker: Yield-on-Cost & DRIP Spreadsheet

See exactly how close you are to living on dividends. The Dividend Income Command Center is an all-in-one Google Sheets & Excel dashboard that tracks every dividend you collect, calculates your yield-on-cost for each holding, projects your DRIP snowball for 25 years, and estimates your dividend tax — so your passive income has a plan, not just a hope.

🌱 Built for Dividend & Income Investors who want their money to pay them.

Dividend investing is a long game — and the investors who win are the ones who can actually see it working. This workbook turns a pile of brokerage statements into one clean, color-coded command center that shows your income growing, dividend by dividend, year by year. Type in your holdings and log your payouts — the dashboard, yields, charts, tax estimate and 25-year projection update themselves. That's it.

✅ WHAT IT DOES FOR YOU

• See your real yield-on-cost. Enter shares, cost and price once — every holding's yield-on-cost, current yield, market value, gain/loss and portfolio weight calculate automatically.

• Watch your income snowball. The 25-year DRIP projection shows how reinvested dividends, annual raises and new contributions compound your annual income over time.

• Know your "living on dividends" number. Set a target annual income and instantly see the gap — and the exact capital you still need at your current yield.

• Never miss a payout. The Dividend Calendar maps each holding's pay frequency and estimated payment so you can plan monthly income.

• Estimate your dividend tax. Splits qualified vs non-qualified dividends and applies the 2026 US brackets (0/15/20% + NIIT) so you know what you actually keep.

• Stay diversified. Allocation views by sector and account flag over-concentration before it becomes a risk.

📚 WHAT'S INCLUDED — 13 tabs

Start Here guide · Interactive Dashboard · Setup · Holdings & Yield-on-Cost ·Dividend Log · Income Summary · Dividend Calendar · Income Goals · DRIP Snowball (25-yr) · Dividend Tax Estimator · Allocation & Diversification · Portfolio Value Tracker · Watchlist — plus a separate interactive HTML dashboard.

IDEAL BUYER

✓ Dividend growth & income investors

✓ DRIP & "living off dividends" / FIRE savers

✓ Retirees & near-retirees building income

✓ Anyone tracking a dividend portfolio by hand

🖥️WORKS WITH

Google Sheets (free) and Microsoft Excel. Fully fillable, all formulas built in. Color-coded so you always know which cells to type in.

⚡ INSTANT DIGITAL DOWNLOAD

Get it immediately after purchase. No physical item is shipped. Make your own copy and use it for years.

⚠️ Educational planning tool — not financial, investment or tax advice, and not are commendation to buy or sell any security. Yields, projections and tax figures are simplified