How to Forecast Your Dividend Income for the Next 12 Months

Most portfolio tools answer the wrong question. They tell you what your holdings are worth today — a number that bounces with the market and tells you almost nothing about the thing you actually built the portfolio for.

If you're a dividend-growth or FIRE investor, the question that matters is different: what will this portfolio pay me over the next 12 months — and what does that look like month by month?

That's a forecast you can build yourself. Here's how to do it, where the math quietly breaks, and why the honest number is usually higher than a flat estimate suggests.

Why forward income beats portfolio value

Price tells you what someone would pay you to sell. Forward income tells you what your portfolio produces while you hold it. For anyone planning toward financial independence, the second number is the one that pays the bills.

A 12-month forward view does three things a balance figure can't:

• It turns an abstract goal ("I want to live off dividends") into a running monthly total you can watch grow.
• It surfaces lumpy income — most portfolios pay heavily in March, June, September, and December, and a forward view shows you the gaps.
• It lets you see the effect of a single decision (a new position, a reinvested payment, a dividend hike) on actual income, not just on a price chart.

The manual method: four steps

You can build a rough forecast in a spreadsheet today. Here's the sequence.

Step 1 — List every holding and share count, by account. Not just the ticker — the actual share count in each account. The same company can sit in your Roth, your Traditional IRA, and a taxable account, and those lots may behave differently (more on that below).

Step 2 — Find each holding's forward annual dividend rate. Use the most recently declared per-share dividend, annualized by its pay frequency (a $0.50 quarterly payment is a $2.00 forward annual rate). Use the declared rate, not last year's trailing total — trailing numbers lag every hike and cut.

Step 3 — Map the pay schedule month by month. Most US dividend payers run on a quarterly cycle, but the months differ by company. Lay out a 12-column grid (one per month) and drop each expected payment into the month it lands. This is what reveals your income's real shape.

Step 4 — Total each column. Sum the grid down each month and you have a 12-month forward income curve — your baseline.

That baseline is genuinely useful. It's also, for most real portfolios, too low — and the reasons are exactly the things a static spreadsheet can't keep up with.

Where the manual forecast breaks

If you've ever watched your tracking spreadsheet keep breaking, these are the culprits.

1. Reinvested dividends (DRIP) compound — a flat estimate ignores this. When you reinvest a payment, it buys more shares, and those shares pay their own dividends next cycle, which buy more shares again. A flat annual projection freezes your share count on day one. A per-payment, DRIP-aware forecast recalculates after every reinvested payment. Over 12 months that gap is small; over a FIRE timeline it's the whole point. We break the mechanics down in flat projection vs a DRIP-aware one.

Illustrative example: take a hypothetical holding paying a quarterly dividend that you reinvest. A flat model counts four identical payments. A DRIP-aware model counts four payments where each one is slightly larger than the last, because the share count grew along the way. Same inputs, different method, higher honest total. (Illustrative only — not a projection of your results.)

2. Dividend hikes land mid-year. Dividend-growth companies often raise payouts annually. Your hand-built grid uses today's rate for all 12 months and silently undercounts every quarter after a raise.

3. The same ticker behaves differently across accounts. You might reinvest in your Roth (let it compound tax-free) but take the cash in your taxable account (to spend or redeploy). A single-line-per-ticker spreadsheet can't model "reinvest here, pay cash there" — but that split materially changes your forward income.

4. NAV-priced 401(k) funds have no public ticker. Many institutional 401(k) funds aren't listed anywhere you can look up a dividend. If you can't price them, they fall out of your forecast entirely — and for a lot of investors that's the largest account.

5. Tiered employer match. "100% of the first 3%, 50% of the next 2%, up to an annual cap" is a formula, not a flat percentage. Forecasting future contributions (and the income they'll eventually produce) means modeling that structure correctly.

The point of all this

You can absolutely forecast your dividend income by hand — and doing it once teaches you more about your portfolio than any net-worth dashboard. But the manual version is a snapshot that goes stale the moment a company raises its dividend, a DRIP purchase clears, or you add a holding. Keeping it accurate becomes a second job.

That's the gap Lensfolio was built to close: a DRIP-aware, 12-month forward income forecast that compounds reinvested payments at the per-payment level, handles the same ticker across Roth / Traditional / Taxable with different reinvest rules, and tracks NAV-priced 401(k) funds that don't have a public ticker.

You can run your own forecast on the free tier — one portfolio, up to 10 holdings, no credit card, no brokerage login, no ads, and your data is never sold.