Dividend Portfolio Tracker Spreadsheet

Dividend investing has a measurement problem. Most brokerage platforms show you your portfolio value and your recent dividends received, but they do not show you the metrics that dividend investors actually care about: total annual dividend income across all accounts, yield on cost (what your dividends represent relative to what you paid, not what the stock is worth today), dividend growth rate per holding, projected income at 5, 10, and 20 years based on current growth rates, and how close you are to covering your essential expenses with dividend income alone.

These are the numbers that define progress for a dividend investor. A portfolio that grows 8% in market value but delivers flat dividend income is not progressing toward income independence. A portfolio that is flat in market value but has grown dividend income by 7% is getting measurably closer to the goal every year.

This spreadsheet tracks all of it. You enter your holdings once and update dividend payments as they arrive. The tool calculates every income metric and projects your future dividend income based on historical growth rates — showing you exactly when your portfolio reaches meaningful income milestones.

Disclaimer: This tracker is provided for informational and educational purposes only. It does not constitute investment or financial advice. Past dividend performance does not guarantee future payments. Companies can reduce or eliminate dividends at any time. Consult a qualified financial advisor before making investment decisions. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Why Dividend Investors Need a Dedicated Tracker#

Standard portfolio tracking focuses on total return — price appreciation plus dividends. That is the right measure for growth investors, but it conflates two distinct value streams for dividend investors. A stock that drops 10% in price but increases its dividend by 5% looks like a loser in total-return tracking but is actually a better income producer than it was before the price drop. Yield on cost increased, income increased, and the only thing that decreased was the unrealised capital gain — which a buy-and-hold dividend investor never intended to harvest anyway.

The dedicated tracker separates these streams, putting income at the centre of the analysis where it belongs for income-focused strategies.

What the Spreadsheet Tracks#

Per-Holding Detail#

For each stock, ETF, or fund in your portfolio, you enter the ticker symbol, number of shares held, purchase price per share (or average cost basis if you accumulated over time), current market price, annual dividend per share, and most recent dividend payment date. From these inputs, the spreadsheet calculates annual dividend income for that holding (shares × annual dividend per share), current yield (annual dividend ÷ current price), yield on cost (annual dividend ÷ purchase price — the metric that matters most for long-term holders), percentage of total portfolio dividend income, and total return (price change + dividends received since purchase).

Portfolio-Level Summary#

The top-level dashboard shows total portfolio market value, total annual dividend income (the sum across all holdings), portfolio weighted average yield, portfolio weighted yield on cost, monthly average dividend income (total annual ÷ 12), and dividend income by quarter (many dividend stocks pay quarterly; the spreadsheet maps payment months to show income distribution across the year).

The quarterly income view is particularly useful for planning. Dividend payments are not evenly distributed — many US stocks pay in March/June/September/December, creating income concentration in certain months. The tracker reveals this pattern and helps you identify whether your income stream is lumpy or smooth.

Dividend Growth Tracking#

For each holding, you can enter the historical dividend growth rate (the annualised percentage increase in the dividend per share over the past 5–10 years). The spreadsheet uses this to project future dividend income at three horizons: 5 years, 10 years, and 20 years.

The power of dividend growth becomes visible in these projections. A holding paying $500/year in dividends today with a 7% growth rate will pay $701 in 5 years, $984 in 10 years, and $1,935 in 20 years — nearly quadrupling the income without buying a single additional share. This is the compounding engine that makes dividend growth investing a viable path to financial independence.

Income Coverage Ratio#

The spreadsheet includes an optional section where you enter your annual essential expenses (housing, food, utilities, insurance, transportation — the baseline costs you must cover regardless of employment). The income coverage ratio is: Total Annual Dividend Income ÷ Annual Essential Expenses. When this ratio reaches 1.0 (100%), your dividends cover your essential costs. At 1.5, they cover essentials plus discretionary spending. At 2.0, you have a significant buffer.

Tracking this ratio over time — watching it climb from 15% to 25% to 40% — provides concrete evidence of progress toward financial independence that total portfolio value alone cannot convey.

How to Use the Spreadsheet#

Step 1: Enter your current holdings. Every dividend-paying stock, ETF, REIT, or fund across all accounts (brokerage, IRA, Roth IRA). Include both qualified and non-qualified dividend payers.

Step 2: Record dividend payments as received. Update the spreadsheet quarterly (at minimum) or after each dividend payment. Over time, this builds a historical record that improves the accuracy of growth rate calculations.

Step 3: Review the portfolio summary monthly. Check total annual income, yield on cost progression, and the income coverage ratio. Monthly reviews keep you engaged with the income trajectory rather than fixated on daily price movements — which is precisely the mindset shift that successful dividend investing requires.

Step 4: Run the projections annually. At year-end, review the 5/10/20-year income projections. Are the growth rates sustainable? Are any holdings showing slowing dividend growth that might warrant reallocation? Are you on track for your target income coverage ratio?

Download: Dividend Portfolio Tracker — Excel (.xlsx)

Key Dividend Metrics Explained#

Yield on cost is the metric that separates dividend veterans from beginners. It measures your personal yield based on what you paid for the stock, not its current price. If you bought a stock at $50 that now pays a $3 annual dividend, your yield on cost is 6% — regardless of whether the stock currently trades at $40 or $80. Yield on cost rises naturally as companies increase dividends, which is why long-held positions in dividend growers often show yields of 8%, 10%, or even 15%+ on the original investment.

Dividend growth rate is the annual percentage increase in the dividend per share. The Dividend Aristocrats (S&P 500 companies that have increased dividends for 25+ consecutive years) average roughly 6–8% annual dividend growth. Higher growth rates are possible in younger companies or strong performers, while mature companies may grow at 2–4%.

Payout ratio is the percentage of earnings paid out as dividends. A payout ratio under 60% generally indicates the dividend is sustainable and has room to grow. A payout ratio above 80% suggests the company is paying out most of its earnings, leaving little room for increases and raising the risk of a cut if earnings decline.

Building and Diversifying a Dividend Portfolio#

The tracker is most useful when it monitors a well-constructed portfolio. A few principles guide dividend portfolio construction.

Diversify across sectors. Dividend-heavy sectors include utilities, consumer staples, healthcare, financials, and REITs. Concentrating in one or two sectors exposes you to sector-specific risks — a banking crisis, a regulatory change in utilities, or a real estate downturn can cut dividends across an entire sector simultaneously. The spreadsheet’s income-by-holding breakdown makes concentration visible.

Balance yield and growth. A portfolio split between high-yield holdings (4–6% current yield, slow growth — utilities, REITs, mature companies) and dividend growth holdings (1.5–3% yield, 8–12% annual growth — technology leaders, industrials, consumer brands) produces both immediate income and a rising income stream over time. The projection feature shows how the growth holdings compound to eventually dominate the income picture.

Watch for yield traps. A stock yielding 8% or more often signals trouble: the price has declined (inflating the yield percentage), the payout ratio is unsustainable, or the company is in a declining industry. The spreadsheet’s payout ratio column helps identify holdings where the dividend may be at risk. If the payout ratio is above 80% and the dividend growth rate has slowed or stalled, that yield may not be sustainable.

Consider dividend ETFs for simplicity. Vanguard’s VIG (dividend growth), SCHD (high-quality dividend), and VYM (high yield) offer diversified dividend exposure in a single holding. For smaller portfolios, these provide instant diversification that would take 20–30 individual stock positions to replicate. The spreadsheet tracks ETF dividends the same way as individual stocks.

For tracking your overall portfolio allocation (not just dividend holdings), see our portfolio allocation spreadsheet. For the broader financial picture including non-investment assets and liabilities, see our net worth tracker. And for modelling how dividend income fits into your retirement plan, see our retirement savings tracker.

Frequently Asked Questions#

How much dividend income do I need for financial independence?

Enough to cover your annual spending, plus a margin for safety. If your annual expenses are $50,000, you need $50,000 in dividend income (or more, to account for taxes on non-qualified dividends and for dividend cuts during recessions). This typically requires a portfolio of $1,000,000–$1,250,000 yielding 4–5%. The income coverage ratio in the spreadsheet tracks your progress toward this target.

Should I reinvest dividends or take the cash?

During the accumulation phase (before you need the income), reinvesting dividends — either through DRIP programmes or by manually investing the cash — accelerates compounding by buying more shares that generate more dividends. Once you are drawing income, take the cash. The spreadsheet tracks income projection both ways so you can see the compounding impact of reinvestment versus cash collection.

What is a good dividend yield to target?

A yield of 2.5–4% is the sweet spot for most dividend growth investors. Below 2%, the income contribution is minimal. Above 5%, the high yield often signals a declining stock price, an unsustainable payout ratio, or a company in distress. Exceptions exist (REITs, utilities, and certain MLPs legitimately yield 5–8%), but chasing yield above 5% without understanding the fundamentals is one of the most common dividend investing mistakes.

How do I handle dividend cuts in the tracker?

Update the annual dividend per share to the new (lower) amount. The spreadsheet will automatically adjust all income calculations and projections. A dividend cut is also a signal to re-evaluate the holding — companies that cut dividends often face fundamental problems that may worsen. The tracker’s historical data helps you identify holdings that have cut or frozen dividends, informing your reallocation decisions.

Do dividends from REITs and ETFs work the same in this tracker?

Yes, with one tax nuance. REIT dividends are typically taxed as ordinary income (not at the lower qualified dividend rate), and some ETF distributions include return of capital that is not taxable in the year received but reduces your cost basis. The tracker treats all dividends as income for projection purposes. For tax impact modelling, see our capital gains tax calculator.

How often should I update the tracker?

Quarterly is the minimum effective frequency, as most US dividend stocks pay quarterly. Monthly is ideal if you want real-time income tracking. The year-end review is the most important update — it provides the complete annual income figure and the basis for next year’s growth rate calculations.

Is dividend investing better than index fund investing?

This is one of the most debated topics in personal finance, and the honest answer is: total return from broad index funds has historically exceeded the total return from dividend-focused strategies. However, dividend investing provides a psychological advantage (visible, growing income regardless of price volatility) and a structural advantage for income-phase investors (you do not need to sell shares to generate cash flow). The best approach for many investors is a core index fund position supplemented by a dividend income portfolio — the spreadsheet supports this by tracking dividend-specific metrics alongside total return.