Household Financial Summary

Retirement Sustainability

Whole portfolio — every number below is the actual net worth and spending, not a hypothetical
● Demo data

Is current spending sustainable?

Not financial advice — a model to react to, not a plan. Tests the WHOLE portfolio (current net worth) against lifestyle spending (guaranteed income + portfolio draw combined) — same Layer 1 figure as the Financial Summary page. Proceeds from a home sale are NOT included here — see the separate Downsize Model page for that, deliberately kept as its own isolated pot.

At 90% confidence over 25 years, our portfolio could sustainably support about $13,590/mo in total household spending — more than the $12,523/mo actually being spent today, suggesting headroom of roughly $1,067/mo. Today's actual spending succeeds in 96% of simulated paths over 25 years.

Current net worth
$1.97M
the whole simulated pot
Guaranteed income (net)
$6,666/mo
SS + pensions, after the tax caveat
Current total spending
$12,523/mo
lifestyle only — see note on taxes below
Capital-gains tax is deliberately excluded from spending here rather than added, unlike an earlier version of this page. Calendar-year 2025 taxes were $33,617 (see the Financial Summary page) — a real, lumpy figure driven by that year's actual realized gains, which has no relationship to the smoothed 5%/yr return assumption below. Adding it to every simulated year, including bad ones with little real gain and little real tax owed, overstated how much this model draws down our portfolio. "Expected real return (after-tax)" is assumed to already absorb ongoing capital-gains tax drag inside that one number instead.

How much could we sustainably spend?

Monte Carlo, 3,000 trials, real terms (already inflation-adjusted — expected return 5%/yr, volatility 12%/yr). General inflation is assumed at 3.0%/yr. Lifestyle spending is assumed to track general inflation exactly (flat in real terms). Guaranteed income (Social Security + pensions) is assumed to track general inflation exactly (flat in real terms). Ruin is permanent — once a path hits zero it stays there. Each cell is our largest monthly total spending that still succeeds in at least that fraction of the 1,000 simulated paths; the last column is the success probability of TODAY'S actual spending level specifically. 50 years stands in for "indefinitely." Figures are shown per month; the model simulates in annual terms.

Horizon75% confidence /mo90% confidence /mo95% confidence /moToday's spending succeeds
20$16,726$14,635$13,93899%
25$14,983$13,590$12,54496%
30$14,287$12,544$11,84792%
50 (indefinite proxy)$12,544$11,150$10,45478%

Assumptions (edit these on the "Portfolio Model" sheet tab)

Current net worth$1.97M
Guaranteed income (net of tax caveat)$79,992/yr
Current total spending (lifestyle only, tax excluded — see note above)$150,274/yr
Expected real return / volatility5% / 12%
General inflation3.0%/yr
Lifestyle spending real growth+0.0%/yr
Guaranteed income real growth+0.0%/yr

Not a CFP/CPA figure. Assumes the SAME 5%/12% real return/volatility as the Downsize Model page as a starting point — confirm against the portfolio's actual allocation when known, since the real portfolio may have a different risk posture than a hypothetical newly-invested pot. Guaranteed income is assumed fully COLA'd (flat in real terms); if either pension is known not to have COLA, set "Guaranteed income real growth" negative on the sheet to model its real value eroding over time. Proceeds-only downsizing and whole-portfolio sustainability are DIFFERENT questions — this page never assumes our house gets sold.