Retirement Calculator
Plan your retirement with realistic projections
Retirement Summary
Year-by-Year Projection
| Year | Age | Contributions | Growth | Balance | % of Target |
|---|
Excel Formulas for Retirement Planning
Copy these formulas into Excel or Google Sheets. Replace cell references with your values.
FIRE Number (Retirement Target)
Calculate how much you need to retire based on the 4% rule
=B1/B2
B1 = Annual Expenses
B2 = Withdrawal Rate (decimal, e.g., 0.04)
Future Value of Savings
Calculate portfolio value at retirement with monthly contributions
=FV(B3/12, B4*12, -B2, -B1)
B1 = Current Savings
B2 = Monthly Contribution
B3 = Annual Return (decimal, e.g., 0.07)
B4 = Years to Retirement
Years to FIRE
Calculate how many years until you reach your FIRE number
=NPER(B3/12, -B2, -B1, B4)/12
B1 = Current Savings
B2 = Monthly Contribution
B3 = Annual Return (decimal)
B4 = FIRE Number (target)
Savings Rate
Calculate your savings rate as a percentage of income
=(B1*12)/B2
B1 = Monthly Contribution
B2 = Annual Income
Safe Withdrawal Amount (Annual)
Calculate how much you can withdraw annually in retirement
=B1*B2
B1 = Portfolio Value
B2 = Withdrawal Rate (decimal, e.g., 0.04)