What's inside
- Plan: starting age and savings, spending in today's dollars, Social Security or pension and when it starts, return, inflation, tax on withdrawals and the age to plan to
- Results: the age savings run out, what's left at your plan age, the most you can spend each year to last, and your first-year withdrawal rate
- Year by year: 60 years of balances, spending, income, withdrawals grossed up for tax and any shortfall, with a chart
- Sample file: $800,000 at 62, spending $60,000 with $28,000 of Social Security from 67: savings run out at 86; $54,427 a year lasts to 95
Checked, not just designed: all 486 formulas recalculate with zero errors, and every result was checked against an independent year-by-year calculation and a bisection search in 7 scenarios.
Works in Excel and Google Sheets. Not financial advice.
Try the free version first
The free online calculator uses the same model for a quick answer. The spreadsheet adds tracking, history and the full views.