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
Year
Age
Income
Expenses
Tax
Ending balance
2026
65
$61,632
$58,000
$3,632
$833,068
2027
66
$63,276
$59,650
$3,626
$866,398
2028
67
$64,383
$61,351
$3,032
$900,539
2029
68
$96,410
$90,028
$6,382
$905,724
2030
69
$68,081
$64,915
$3,166
$940,585
2031
70
$390,831
$66,781
$3,230
$1,334,696
2032
71
$72,003
$68,705
$3,298
$1,393,612
2033
72
$74,059
$70,691
$3,368
$1,455,119
2034
73
$73,822
$72,740
$1,082
$1,501,417
2035
74
$75,965
$74,854
$1,111
$1,549,097
2036
75
$82,595
$77,035
$5,560
$1,593,770
2037
76
$85,116
$79,287
$5,829
$1,639,490
2038
77
$87,689
$81,611
$6,078
$1,686,294
2039
78
$90,379
$84,011
$6,368
$1,734,159
2040
79
$93,161
$86,488
$6,673
$1,783,085
2041
80
$96,034
$89,046
$6,988
$1,833,074
2042
81
$98,975
$91,688
$7,287
$1,884,155
2043
82
$102,043
$94,417
$7,626
$1,936,297
2044
83
$105,180
$97,236
$7,944
$1,989,531
2045
84
$108,463
$100,148
$8,315
$2,043,808
2046
85
$111,815
$103,157
$8,657
$2,099,161
2047
86
$115,279
$106,267
$9,012
$2,155,579
2048
87
$118,851
$109,481
$9,371
$2,213,056
2049
88
$122,530
$112,803
$9,727
$2,271,591
2050
89
$126,476
$116,237
$10,239
$2,331,018
2051
90
$130,495
$119,788
$10,708
$2,391,363
2052
91
$134,648
$123,460
$11,188
$2,452,589
2053
92
$138,899
$127,258
$11,642
$2,514,694
2054
93
$143,269
$131,186
$12,083
$2,577,659
2055
94
$147,533
$135,249
$12,284
$2,641,688
2056
95
$152,001
$139,454
$12,547
$2,706,684
§16
Finishing strong
The last few years of the projection. Balances stay positive through horizon end.
Year
Age
Income
Expenses
Ending balance
2053
92
$138,899
$127,258
$2,514,694
2054
93
$143,269
$131,186
$2,577,659
2055
94
$147,533
$135,249
$2,641,688
2056
95
$152,001
$139,454
$2,706,684
§07
Scenarios
Scenario
Description
Last run
Retire at 70
Five extra working years; SS claimed at 70; baseline spending unchanged.
May 8, 2026
Conservative returns (4% / 3%)
Equity 4%, fixed 3% — stress test for a low-return decade.
May 8, 2026
No Roth conversions
Withdraw straight from traditional balances per RMD; no preemptive ladder.
May 8, 2026
§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
Notes
2026
$196,750
24%
Conversion crosses 3 IRMAA tiers (tier 0 → 3). Annual surcharge increases by $4,561 in 2028.
2027
$201,650
24%
Conversion crosses 3 IRMAA tiers (tier 0 → 3). Annual surcharge increases by $4,674 in 2029.
2028
$101,600
24%
—
§10
What if you need long-term care?
Assisted living facility at $90,000/yr starting age 80, lasting 3 years.
LTC cost (today's $)
$270,000
LTC cost (inflated)
$589,844
5%/yr LTC inflation.
Plan impact
−$1,646,669
Ending balance falls by this amount.
Base plan vs. plan with LTC overlay · ages 65–95
Methodology
LTC overlay: Assisted living facility at $90,000/yr (today's $), starting age 80, lasting 3 years.
5.0% annual LTC-cost inflation applied (healthcare-grade, higher than general CPI).
Single-event overlay only — does not model recurring LTC episodes or LTC insurance offsets in v1.
Tax-on-tax convergence iterates a maximum of 8 times per year ($1 tolerance).
Cost basis on taxable brokerage assumed to be $0 unless explicitly provided.
RMD-driven cash overflow accumulates in a virtual cash sweep earning 0%.
AMT calculation excludes ISO exercise and private-activity bond preference items.
§11
Market Comparison
Deterministic projection at a flat assumed return vs. the median Monte Carlo path. Same average; the delta is the cost of volatility. The MC Return column shows the realized year-over-year rate the median path implies.
Year
Age
Det. ROR
Deterministic
MC return
Monte Carlo (median)
Δ
2026
65
7.00%
$833,068
—
$779,403
−$53,665
2027
66
7.00%
$866,398
−1.42%
$754,926
−$111,473
2028
67
7.00%
$900,539
−0.45%
$736,345
−$164,194
2029
68
7.00%
$905,724
−6.51%
$673,080
−$232,644
2030
69
7.00%
$940,585
+1.49%
$635,080
−$305,505
2031
70
7.00%
$1,334,696
+48.02%
$913,615
−$421,081
2032
71
7.00%
$1,393,612
−2.28%
$892,763
−$500,849
2033
72
7.00%
$1,455,119
−0.10%
$872,456
−$582,662
2034
73
7.00%
$1,501,417
−2.74%
$828,891
−$672,526
2035
74
7.00%
$1,549,097
+0.04%
$790,207
−$758,890
2036
75
7.00%
$1,593,770
+0.80%
$755,930
−$837,840
2037
76
7.00%
$1,639,490
+0.29%
$711,974
−$927,516
2038
77
7.00%
$1,686,294
−0.33%
$662,133
−$1,024,161
2039
78
7.00%
$1,734,159
−0.93%
$607,176
−$1,126,983
2040
79
7.00%
$1,783,085
−2.13%
$544,337
−$1,238,747
2041
80
7.00%
$1,833,074
−3.53%
$474,159
−$1,358,915
2042
81
7.00%
$1,884,155
−5.63%
$395,876
−$1,488,278
2043
82
7.00%
$1,936,297
−10.05%
$305,207
−$1,631,090
2044
83
7.00%
$1,989,531
−10.62%
$220,426
−$1,769,105
2045
84
7.00%
$2,043,808
−19.03%
$129,380
−$1,914,427
2046
85
7.00%
$2,099,161
−63.93%
$24,008
−$2,075,153
2047
86
7.00%
$2,155,579
—
$0
−$2,155,579
2048
87
7.00%
$2,213,056
—
$0
−$2,213,056
2049
88
7.00%
$2,271,591
—
$0
−$2,271,591
2050
89
7.00%
$2,331,018
—
$0
−$2,331,018
2051
90
7.00%
$2,391,363
—
$0
−$2,391,363
2052
91
7.00%
$2,452,589
—
$0
−$2,452,589
2053
92
7.00%
$2,514,694
—
$0
−$2,514,694
2054
93
7.00%
$2,577,659
—
$0
−$2,577,659
2055
94
7.00%
$2,641,688
—
$0
−$2,641,688
2056
95
7.00%
$2,706,684
—
$0
−$2,706,684
Average ROR
7.00%
§13
Return-rate sensitivity
How the ending balance moves if returns come in 7.00% ± 1%.
6.00%
$1,835,101
−$871,584
6.50%
$2,242,640
−$464,044
7.00%baseline
$2,706,684
—
7.50%
$3,213,559
+$506,874
8.00%
$3,685,970
+$979,286
Methodology
Increment analysis re-runs the projection at five expected-stocks-return assumptions: baseline ±0.5% and ±1.0%. Bonds + cash scale proportionally with stocks.
Holds withdrawal sequencing, Social Security claiming, and spending constant — isolates the effect of returns alone.
§14
7-year quick view
Spendable assets at every-7-year checkpoints. Projected vs Monte Carlo median where available.
Year
Age
Projected
Monte Carlo (median)
Δ
2032
71
$1,393,612
$892,763
−$500,849
2039
78
$1,734,159
$607,176
−$1,126,983
2046
85
$2,099,161
$24,008
−$2,075,153
2053
92
$2,514,694
$0
−$2,514,694
2056
95
$2,706,684
$0
−$2,706,684
§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.
§14
Methodology
Every assumption and simplification baked into the numbers above. We surface these here so they are visible, not buried.
01DEMO REPORT — synthetic data. The "Jane Anderson" plan is a textbook 65-year-old single retiree per FOUNDATION §10 Sprint 2 acceptance.
02Tax-on-tax convergence iterates a maximum of 8 times per year ($1 tolerance).
03Cost basis on taxable brokerage assumed to be $0 unless explicitly provided.
04RMD-driven cash overflow accumulates in a virtual cash sweep earning 0%.
05AMT calculation excludes ISO exercise and private-activity bond preference items.
06Optimizer fills to top of 24% bracket and gates against IRMAA crossings.
07Window: 2026 – 2035 (10 years).
08IRMAA crossing approved only if savings exceed 1.5× the surcharge cost.
09Lifetime savings is estimated analytically (current marginal vs. assumed RMD-era marginal); not a full re-projection.
10Cost basis on traditional IRA / 401(k) assumed $0 — full conversion amount taxed as ordinary income.
11Ignores 5-year aging rule for converted Roth principal — conversions after age 59½ avoid the 10% penalty.
12Year 2029: no traditional balance left to convert; stopped.
13Recommended 3 conversions totaling $500,000.
Disclaimer
This report is for educational and discussion purposes only. Projections are based on user-supplied inputs and assumptions. Actual results will differ. Tax law cited reflects published guidance as of the plan date; consult IRS and SSA primary sources for definitive treatment. Not investment, tax, or legal advice.