Retirement Planning Simulator (HourglassFP)

Retirement Planning Simulator

BETA

This is the basic beta version of this tool and is for informational purposes only. Please consult your financial advisor before making any important decisions based on its outputs. Note: Double-check all inputs as some are automatically populated. Projections are with inflation-indexed cash flows & taxes; results shown in today’s dollars.

General

Current Age Retirement Age Life Expectancy Annual Spending at Retirement ($/yr) Inflation (%/yr) Run Monte Carlo?

MC Runs Show P10/P50/P90

Returns & Starting Balances

Taxable Returns (%) Taxable StDev (%)

Tax-Deferred Returns (%) Tax-Deferred StDev (%)

Roth Returns (%) Roth StDev (%)

Taxable Balance ($) Tax-Deferred Balance ($) Roth Balance ($) Taxable “Tax Drag” (% of balance/yr; 0 = off)

Contributions & Match

Annual Savings Until Retirement ($)

% of Savings to 401(k)/403(b) % of Savings to IRA

% of 401(k) to Traditional (rest to Roth 401k) % of IRA to Traditional (rest to Roth IRA)

Limits auto-inflate by CPI. Catch-up after age 50 is applied automatically.

Employer Match

Salary ($) Match % of Salary

Employer Match Destination

Income & Policy

SS Start Age Annual SS at Start

Other Retirement Income ($/yr)

House Sale Age Net Proceeds ($)

Spending Reduction Age Spending Reduction (%)

Withdrawal Order (after forced RMDs)

Taxes

Filing Status

Standard Deduction ($) LTCG/Qualified Dividends Rate (%)

Ordinary brackets modeled with a simple progressive function; SS inclusion uses 0/50/85% rules by provisional income.

Monte Carlo Options

Seed (optional) Clamp annual return at −60% min?

Log-normal sampling per bucket/year with arithmetic mean & stdev converted to log space.

Summary

Age 73 RMD (Yr 1 RMD, today’s $): $0

First RMD computed from prior-year end balance.

Final Total Balance (today’s $): $0

At life expectancy.

Shortfall Begins: None

If balances hit $0 before horizon.

Deterministic Path (today’s $)

Monte Carlo (today’s $)

Age	Taxable ($, real)	Deferred ($, real)	Roth ($, real)	Total ($, real)	RMD ($, real)	SS Rec’d ($, real)	Ord. Tax ($, real)	CG Tax ($, real)	Spending ($, real)	Net Flow ($, real)

Educational tool; not tax or investment advice. Brackets/limits are simplified approximations; confirm with current IRS rules.