A multi-decade, tax-aware projection across every account, income source, and expense bucket — with deterministic forecasts, Roth conversion strategy, and stochastic stress testing of sequence-of-returns risk.
§01
What this analysis answers
Three questions sit underneath every part of this report. Jane's pages were built to answer them in order.
1
Will you have enough money to last through retirement?
We project the household's income, expenses, taxes, and asset growth year by year against life expectancy. If the plan funds, you'll see how the surplus grows. If it doesn't, you'll see exactly where the gap appears and the two numbers — a lump sum today or a required return rate — that would close it.
2
What happens if one spouse passes away too early?
The survivor files single. The widow / widower’s tax brackets compress at the same income, RMDs continue, and Social Security drops to the higher of the two benefits. The survivor scenario shows how the plan looks for the remaining spouse.
3
What happens if you need long-term care?
Long-term care costs in the survivor's late years drain assets fastest. The LTC overlay re-runs the projection with $X/yr of care costs starting at age Y so you can see how much cushion the plan has against that risk.
§02
Shortfall
The plan funds through life expectancy under current assumptions. No infusion or return-rate change is required.
✓
Plan is on track. Surplus grows year by year and the projection's ending balance is positive.
§01
Executive Summary
The single page a busy client reads. Everything else in this document supports these numbers.
Total investable assets
$800,000
Across all accounts, prior to projection growth.
This plan is 0 years from retirement, projected to draw $61,632 in the first year and $96,034 by age 80 — Monte Carlo says the trajectory is tight at 14%.
Years to retirement
0
Income at retirement
$61,632
Income at 80
$96,034
Lifetime tax savings
$96,098
Vs. no optimization.
Monte Carlo success
14%
Probability the plan holds across 1,000 trials.
§02
Household
Member
Role
Current age
Life expectancy
Jane
Primary
65
95
§03
Assets
Grouped by tax treatment. Drives the withdrawal-sequencing logic in the projection.
Taxable
$100,000
13%
Account
Type
Balance
Schwab Taxable
Taxable Brokerage
$100,000
Tax-deferred
$500,000
63%
Account
Type
Balance
Vanguard IRA
Traditional IRA
$500,000
Tax-free
$200,000
25%
Account
Type
Balance
Fidelity Roth
Roth IRA
$200,000
Grand total
$800,000
§15
Net worth — 2026
Snapshot at the start of the projection. Spendable drives drawdown; protected and income assets are non-drawdown.
Net worth
$920,000
Total assets
$920,000
Spendable
$800,000
87.0%
Drives retirement drawdown.
Protected
$120,000
13.0%
Annuity income riders + non-drawdown buckets.
Income
$0
0.0%
Rental properties, business interests.
§12
Risk allocation — today vs. target
Current portfolio mix vs. the target the advisor and household agreed on.
Current
Portfolio Total
$800,000
At Risk (equities)63.7%
Low Risk (fixed)31.3%
Emergency Funds (cash)5.0%
Target
Agreed allocation
$800,000
At Risk (equities)40.0%
Low Risk (fixed)55.0%
Emergency Funds (cash)5.0%
Advisor-set target from the household profile.
§04
Tax allocation — today vs. legacy
Where the household's money sits today across tax-treatment buckets, and what remains at the end of the plan.
Current
Portfolio Total
$800,000
Qualified (Trad)62.5%
Roth25.0%
Taxable12.5%
Cash / HSA0.0%
At horizon
Remaining at horizon
$2,706,684
Qualified (Trad)23.8%
Roth45.3%
Taxable30.9%
Cash / HSA0.0%
§05
Tax classifications
A shared vocabulary for the four tax treatments referenced throughout this report. Every dollar in the household belongs to one of these buckets, and the tax it owes depends on which.
1099 / Taxable
Individual & joint brokerage accounts, bank savings, CDs, money-market funds.
Tax now
Yes — interest, dividends, and realized gains reported on Form 1099 each year.
At withdrawal
Only capital-gains tax on growth at sale; basis comes out tax-free.
Most flexible bucket — no penalty for early access — but pays an annual tax drag on the way up.
Non-Qualified
Non-qualified annuities, cash-value life insurance.
Tax now
No — growth accumulates tax-deferred inside the contract.
At withdrawal
Earnings withdrawn are taxed as ordinary income (LIFO); basis comes out tax-free.
Hybrid treatment — funded with after-tax dollars but grows tax-deferred until withdrawal.
Qualified / Pre-Tax
Traditional IRA, 401(k), 403(b), 457, SEP / SIMPLE, qualified annuity.
Tax now
No — contributions were deducted or pre-tax; growth is tax-deferred.
At withdrawal
100% of every withdrawal is taxed as ordinary income. RMDs begin at age 73.
The biggest deferred-tax bill on the household balance sheet — Roth conversions reshape this bucket.
No — contributions were after-tax (Roth) or never taxed (HSA / muni interest).
At withdrawal
Qualified withdrawals are entirely tax-free. Roth has no RMDs during the owner’s lifetime.
The most valuable retirement dollar — every $1 in this bucket spends as $1, regardless of future tax rates.
§04
Income
Source
Type
Monthly
Starts
Ends
COLA
Taxable
Social Security
Social Security
$2,500
Age 67
Lifetime
2.5%
85%
§05
Custom income paths
Stepped income trajectories — bridge years before Social Security, part-time consulting after, pension kicking in mid-retirement. Each row is a single phase. Empty when the plan doesn't use them.
One-time events the recurring income and expense models can't capture cleanly — selling a property, a business buyout, an inheritance, tuition, large gifts. Each one is keyed to the owner's age. Inflows credit the destination account after tax; outflows act as an extra expense in that year.
Event
Category
Age
Today $
Direction
Taxable %
Treatment
Sell Florida condo
Home Sale
70
$300,000
Inflow
0%
LTCG
Grandchild college tuition
Tuition
68
$25,000
Outflow
0%
Ordinary
Total inflows (today $)
$300,000
Total outflows (today $)
$25,000
§06
Deterministic Projection
Year-by-year cash flow under the base assumptions. Tax-aware withdrawal sequencing, RMD-forced distributions, inflation projection.
Final balance
$2,706,684
Lifetime federal tax
$218,054
Shortfall age
—
Funds last through end of horizon.
Total balance, year-end · ages 65 – 95
§08
Monte Carlo
Thousands of randomized return sequences run against the deterministic projection. The percentile band shows the range of plausible balance trajectories.
Success probability
14%
14 of every 100 simulated futures last to age 95. The bottom-decile case runs out at age 80.
Today (age 65)
P90$889,815
P50$779,403
P10$682,176
Age 80
P90$1,336,103
P50$474,159
P10$0
Horizon (age 95)
P90$415,539
P50$0
P10$0
P10 / P50 / P90 ending balance · by age
1,000 iterationsparametric lognormal
§09
Roth Conversion Strategy
Multi-year ladder. Fills ordinary income to the target bracket each year; gates against IRMAA tier crossings unless lifetime savings justify the surcharge.
Lifetime tax savings
$96,098
Conversions
3
IRMAA tier crossings
2
Justified by lifetime savings.
Year
Amount
Bracket
2026
$196,750
24%
2027
$201,650
24%
2028
$101,600
24%
§10
Healthcare
Year-by-year cost schedule. Pre-65 is ACA marketplace pricing (post-PTC). At 65 the household switches to Medicare A/B/D plus optional Medigap and IRMAA-tier surcharge based on MAGI two years prior.
Year
Age
Coverage
Premium
Part D
Medigap
IRMAA
OOP
Total
2026
65
medicare
$2,331
$586
—
—
$8,000
$10,917
2030
69
medicare
$2,833
$712
—
—
$9,724
$13,270
2034
73
medicare
$3,444
$866
—
—
$11,820
$16,129
2038
77
medicare
$4,186
$1,052
—
—
$14,367
$19,605
2042
81
medicare
$5,088
$1,279
—
—
$17,463
$23,830
2046
85
medicare
$6,185
$1,555
—
—
$21,226
$28,966
2050
89
medicare
$7,518
$1,890
—
—
$25,801
$35,208
2054
93
medicare
$9,138
$2,297
—
—
$31,361
$42,796
2056
95
medicare
$10,074
$2,532
—
—
$34,576
$47,182
Lifetime healthcare cost (31 yrs)
$779,588
Showing 9 of 31 years. Lifetime total is computed across all years, not just the rows shown.
Methodology
Pre-65 years use ACA marketplace pricing with a national-average benchmark silver premium ($800/mo). Pricing varies materially by state and rating area; advisors should refine for the household.
Medicare years use CMS-published Part B and Part D averages. Part D in particular varies plan-to-plan; the published average is a reasonable planning anchor.
Medigap premium is $0 — advisor has not specified a supplement. Common Plan G runs $150–$250/mo depending on age and state.
Out-of-pocket is derived from the plan's "healthcare" expense row if present, inflated year-over-year. Includes deductibles, coinsurance, vision, dental — not separated.
§11
Social Security
Optimizer searches all claim-age combinations and recommends the pair that maximizes joint lifetime expected benefit.
Primary claim age
70
Lifetime expected benefit
$1,270,669
§12
Advisor Recommendations
The action items and personal commentary your advisor wants you focused on before the next conversation.
DEMO — Replace with advisor-specific recommendations during the client meeting. The Federal Retirement Planner's existing advisorNotes pipeline will surface here in production.
§13
Continuous Stewardship
A retirement plan is a living document. Tax law, capital market expectations, life expectancy data, and the client’s goals all evolve. We recommend reviewing this plan annually and after any material life change — retirement, inheritance, health event, or sustained market move.
The engine re-runs in seconds, so updating assumptions and refreshing this report between meetings is low-effort.