Demo report. Sign up to download the PDF or send a branded copy to your client.
Sign up to enable downloads Send to client
Print Preview · Advisor copy·11 pages · 8.5 × 11 in·Web preview→ Client copy
Comprehensive Retirement PlanADVISORCAL · NO. 6183
Prepared for

Jane Anderson

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.
Prepared by
AdvisorCal Demo Firm
Demo Advisor
Plan date
May 15, 2026
§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.
AdvisorCal Demo02 / 11
§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

MemberRoleCurrent ageLife expectancy
JanePrimary6595
§03

Assets

Grouped by tax treatment. Drives the withdrawal-sequencing logic in the projection.

Taxable
$100,000
13%
AccountTypeBalance
Schwab TaxableTaxable Brokerage$100,000
Tax-deferred
$500,000
63%
AccountTypeBalance
Vanguard IRATraditional IRA$500,000
Tax-free
$200,000
25%
AccountTypeBalance
Fidelity RothRoth 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.

Tax-Free

Roth IRA, Roth 401(k), HSA (qualified medical), 529 (qualified education), municipal-bond interest.

Tax now
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

SourceTypeMonthlyStartsEndsCOLATaxable
Social SecuritySocial Security$2,500Age 67Lifetime2.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.

Bridge + part-time consultingDefault taxable: 100%
PhaseAge windowMonthly $COLATaxable %Note
165 → 66$4,000100%Bridge years — consulting before SS claim
267 → 72$1,5002.0%100%Part-time consulting (post-SS)
§05

Expenses

ExpenseCategoryAnnualStartsEndsInflation
Baseline livingBaseline$50,000Age 60Lifetime2.5%
Healthcare (out-of-pocket + Medicare premiums)Healthcare$8,000Age 65Lifetime5.0%
Year-1 total$58,000
§06

Future cash flows

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.

EventCategoryAgeToday $DirectionTaxable %Treatment
Sell Florida condoHome Sale70$300,000Inflow0%LTCG
Grandchild college tuitionTuition68$25,000Outflow0%Ordinary
Total inflows (today $)
$300,000
Total outflows (today $)
$25,000
AdvisorCal Demo03 / 11
§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 6595
YearAgeIncomeExpensesTaxEnding balance
202665$61,632$58,000$3,632$833,068
202766$63,276$59,650$3,626$866,398
202867$64,383$61,351$3,032$900,539
202968$96,410$90,028$6,382$905,724
203069$68,081$64,915$3,166$940,585
203170$390,831$66,781$3,230$1,334,696
203271$72,003$68,705$3,298$1,393,612
203372$74,059$70,691$3,368$1,455,119
203473$73,822$72,740$1,082$1,501,417
203574$75,965$74,854$1,111$1,549,097
203675$82,595$77,035$5,560$1,593,770
203776$85,116$79,287$5,829$1,639,490
203877$87,689$81,611$6,078$1,686,294
203978$90,379$84,011$6,368$1,734,159
204079$93,161$86,488$6,673$1,783,085
204180$96,034$89,046$6,988$1,833,074
204281$98,975$91,688$7,287$1,884,155
204382$102,043$94,417$7,626$1,936,297
204483$105,180$97,236$7,944$1,989,531
204584$108,463$100,148$8,315$2,043,808
204685$111,815$103,157$8,657$2,099,161
204786$115,279$106,267$9,012$2,155,579
204887$118,851$109,481$9,371$2,213,056
204988$122,530$112,803$9,727$2,271,591
205089$126,476$116,237$10,239$2,331,018
205190$130,495$119,788$10,708$2,391,363
205291$134,648$123,460$11,188$2,452,589
205392$138,899$127,258$11,642$2,514,694
205493$143,269$131,186$12,083$2,577,659
205594$147,533$135,249$12,284$2,641,688
205695$152,001$139,454$12,547$2,706,684
AdvisorCal Demo04 / 11
§16

Finishing strong

The last few years of the projection. Balances stay positive through horizon end.

YearAgeIncomeExpensesEnding balance
205392$138,899$127,258$2,514,694
205493$143,269$131,186$2,577,659
205594$147,533$135,249$2,641,688
205695$152,001$139,454$2,706,684
AdvisorCal Demo05 / 11
§07

Scenarios

ScenarioDescriptionLast run
Retire at 70Five 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 conversionsWithdraw 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.
YearAmountBracketNotes
2026$196,75024%Conversion crosses 3 IRMAA tiers (tier 0 → 3). Annual surcharge increases by $4,561 in 2028.
2027$201,65024%Conversion crosses 3 IRMAA tiers (tier 0 → 3). Annual surcharge increases by $4,674 in 2029.
2028$101,60024%
AdvisorCal Demo06 / 11
§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 6595
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.
AdvisorCal Demo07 / 11
§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.

YearAgeDet. RORDeterministicMC returnMonte Carlo (median)Δ
2026657.00%$833,068$779,403$53,665
2027667.00%$866,398−1.42%$754,926$111,473
2028677.00%$900,539−0.45%$736,345$164,194
2029687.00%$905,724−6.51%$673,080$232,644
2030697.00%$940,585+1.49%$635,080$305,505
2031707.00%$1,334,696+48.02%$913,615$421,081
2032717.00%$1,393,612−2.28%$892,763$500,849
2033727.00%$1,455,119−0.10%$872,456$582,662
2034737.00%$1,501,417−2.74%$828,891$672,526
2035747.00%$1,549,097+0.04%$790,207$758,890
2036757.00%$1,593,770+0.80%$755,930$837,840
2037767.00%$1,639,490+0.29%$711,974$927,516
2038777.00%$1,686,294−0.33%$662,133$1,024,161
2039787.00%$1,734,159−0.93%$607,176$1,126,983
2040797.00%$1,783,085−2.13%$544,337$1,238,747
2041807.00%$1,833,074−3.53%$474,159$1,358,915
2042817.00%$1,884,155−5.63%$395,876$1,488,278
2043827.00%$1,936,297−10.05%$305,207$1,631,090
2044837.00%$1,989,531−10.62%$220,426$1,769,105
2045847.00%$2,043,808−19.03%$129,380$1,914,427
2046857.00%$2,099,161−63.93%$24,008$2,075,153
2047867.00%$2,155,579$0$2,155,579
2048877.00%$2,213,056$0$2,213,056
2049887.00%$2,271,591$0$2,271,591
2050897.00%$2,331,018$0$2,331,018
2051907.00%$2,391,363$0$2,391,363
2052917.00%$2,452,589$0$2,452,589
2053927.00%$2,514,694$0$2,514,694
2054937.00%$2,577,659$0$2,577,659
2055947.00%$2,641,688$0$2,641,688
2056957.00%$2,706,684$0$2,706,684
Average ROR7.00%
AdvisorCal Demo08 / 11
§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.

YearAgeProjectedMonte Carlo (median)Δ
203271$1,393,612$892,763−$500,849
203978$1,734,159$607,176−$1,126,983
204685$2,099,161$24,008−$2,075,153
205392$2,514,694$0−$2,514,694
205695$2,706,684$0−$2,706,684
AdvisorCal Demo09 / 11
§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.

YearAgeCoveragePremiumPart DMedigapIRMAAOOPTotal
202665medicare$2,331$586$8,000$10,917
203069medicare$2,833$712$9,724$13,270
203473medicare$3,444$866$11,820$16,129
203877medicare$4,186$1,052$14,367$19,605
204281medicare$5,088$1,279$17,463$23,830
204685medicare$6,185$1,555$21,226$28,966
205089medicare$7,518$1,890$25,801$35,208
205493medicare$9,138$2,297$31,361$42,796
205695medicare$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.

AdvisorCal Demo10 / 11
§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.