How to Calculate Retirement Savings Balance in Excel: Free Calculator Tool
=FV(annual_return/12, years*12, -monthly_contribution, -current_savings, 0) to estimate how much you’ll have at retirement.
POINTS
-
Project savings: Use FV to estimate your retirement balance.
-
Match timing: Use monthly rates for monthly contributions.
-
Include current savings: Add your existing retirement balance.
-
Count employer contributions: Include employer contributions.
-
Adjust for inflation: Account for future purchasing power.
-
Set your target: Use PMT to calculate required savings.
Excel’s FV function calculates the future value of an investment using a fixed interest rate and periodic payments.
For retirement savings, the function can incorporate the current account balance and regular contributions to estimate the balance at a future date.
How to Calculate Retirement Savings Balance in Excel
Set up current savings, a monthly contribution, and an expected return — Excel’s FV() function does the rest. Adjust the sheet below and every number updates live.
The one-line version
For a constant monthly contribution, one cell gets you the whole answer.
=FV(AnnualRate/12, Years*12, -MonthlyContribution, -CurrentSavings, 0)
Example: =FV(8%/12, 25*12, -500, -10000, 0)
Your retirement projection
Edit the input cells on the left — the output cells on the right, the chart, and the year-by-year table all recalculate instantly.
Balance growth over time
Snapshots across your timeline to retirement. Hover any bar for the exact figures.
If the return is lower or higher
Year-by-year projection
Starting balance → this year’s contribution → growth → ending balance. Scroll sideways on small screens.
| Age | Year | Start | Monthly | Contribution | Growth | End balance | Today’s value |
|---|
Excel formula cheat sheet
| Calculation | Formula |
|---|---|
| Years to retirement | =RetirementAge-CurrentAge |
| Future value (constant contribution) | =FV(rate,nper,pmt,pv,type) |
| This calculator’s formula | =FV(Return/12,Years*12,-Monthly,-Savings,0) |
| Required monthly contribution | =PMT(rate,nper,pv,fv,type) |
| Present value | =PV(rate,nper,pmt,fv,type) |
| Today’s value (inflation-adjusted) | =Balance/(1+Inflation)^Years |
Build it yourself in six steps
=RetirementAge-CurrentAge=FV(Return/12,Years*12,-Monthly,-Savings,0)=Balance/(1+Inflation)^YearsFrequently asked questions
How do I calculate retirement savings in Excel?
Use =FV(rate,nper,pmt,pv,type), entering current savings and contribution as negative numbers.
What return rate should I use?
There’s no single right number — enter an assumption you’re comfortable with, then compare it against a lower and higher case.
What if my contribution increases every year?
Don’t force it into one FV() cell — build a year-by-year table where each row’s contribution can differ from the last.
FV() vs PMT()?
FV() solves for the future balance given a contribution; PMT() works backwards, solving for the contribution needed to hit a target.
Disclaimer
- Educational only — not financial, investment, tax, or retirement advice.
- All figures are illustrative projections based on the assumptions you enter, not guarantees of actual performance.
- A fixed annual-return assumption ignores real-world volatility and sequence-of-returns risk.
- Calculations use simplified monthly compounding and exclude taxes, employer matching, and fees.
- Consult a qualified, licensed financial advisor before making retirement decisions.
How Long Will Your Savings Last?
Find out how long your savings could last in retirement based on your spending, income, inflation, and investment returns. Get a personalized estimate before you run out of money.
Calculate Your Savings RunwayWhat You Need to Calculate Retirement Savings?
You gather the basic inputs for your retirement projection.
- Current Age: Your age today (years).
- Retirement Age: The age you plan to retire (years).
- Current Savings: The total you have saved so far.
- Contribution (annual or monthly): How much you will save each period (include any employer match).
- Expected Rate of Return: Annual investment return (e.g. 5–7%).
- Inflation Rate (optional): Average annual inflation (e.g. 2–3%).
For monthly contributions, you will use the same inputs but divide the annual rate by 12 and multiply the number of years by 12 when using Excel’s formulas.
Set Up Your Retirement Savings Spreadsheet
Next, organize your assumptions in a clear input table so you can easily change values later.
For example, use column A for labels and column B for values. This makes the model transparent and editable:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Retirement Savings Calculator | |||
| 2 | Current Age | |||
| 3 | Planned Retirement Age | |||
| 4 | Current Savings |
£
|
||
| 5 | Annual Contribution |
£
|
||
| 6 | Annual Rate of Return |
%
|
||
| 7 | ||||
| 8 | Estimated Savings at Retirement | £0 | ||
| 9 | ||||
| 10 | ||||
Keeping all assumptions in one place lets you tweak them and immediately see how the outcome changes.
Calculate Years Until Retirement
As a simple helper metric, compute the time remaining until retirement.
In a new cell, subtract Current Age from Retirement Age.
For example, if B2 is current age and B3 is retirement age, enter =B3 - B2.
In the example above, this would give 35 years. This Years Until Retirement value (e.g., in cell B7) is useful for the FV formula inputs.
Calculate Future Retirement Savings Using Excel’s FV Function
Excel’s FV (Future Value) function computes the future value of an investment with regular contributions and compounding. Its syntax is:
bashCopy=FV(rate, nper, pmt, [pv], [type])
where:
- rate is the interest rate per period. (Use the annual return if your contributions are yearly.)
- nper is the total number of periods (years until retirement).
- pmt is the contribution each period (entered as a negative number, since it’s an outflow).
- pv (present value, optional) is your current retirement savings (also negative).
- type is 0 (contributions at period end) or 1 (beginning). Usually use 0 (the default) for end-of-period contributions.
For example, if B6 contains the annual return (e.g. 7%), B7 the years until retirement, B5 the annual contribution, and B4 the current savings, you could enter:
textCopy=FV(B6, B7, -B5, -B4)
This formula will return the projected nest egg.
Using the example values (7% return, 35 years, £50,000 present, £10,000 yearly), it yields about £1,983,734.
How to Calculate Retirement Savings With Monthly Contributions?
To use monthly contributions, adjust the rate and periods to months.
Divide the annual rate by 12 and multiply years by 12.
For instance, the formula =FV(5%/12, 10*12, -100, -1000, 0) uses a 5% annual rate (0.4167% per month), 120 months (10 years × 12), a monthly payment of £100, and £1,000 initial savings.
This yields about £17,175.24. So, using rate/12 and years*12 allows FV to handle monthly compounding and monthly contributions correctly.
How to Include Your Current Retirement Balance
To include your existing balance, use it as the PV argument in FV.
In Excel, cash outflows are negative, so enter your current savings as a negative number.
How to Adjust Retirement Savings for Inflation
To account for inflation, you can compute a “real” rate of return.
The real rate is given by (1 + nominal rate)/(1 + inflation rate) - 1.
For instance, if your expected return is 7% and inflation is 3%, the real return is (1.07/1.03) - 1 ≈ 3.88%. Use this lower real rate in your FV formula instead of the nominal rate.
This yields the future value in today’s purchasing power.
Alternatively, you could first calculate the future savings with the nominal rate and then divide by (1+inflation)^years to adjust back to present value.
How to Calculate Retirement Savings Growth Year by Year
To visualize the growth, build a year-by-year table.
For example, set up columns:
- Year: 1.
- Age: reference current age (e.g.
=B2). - Starting Balance: your current savings (e.g.
=B4). - Annual Contribution: reference your contribution (e.g.
=B5). - Interest Earned: calculate on the balance plus contribution. For example
=(C2+D2)*$B$6if C2 is starting balance, D2 is contribution, and B6 is rate. - Ending Balance: sum of starting balance, contribution, and interest (e.g.
=C2+D2+E2).
For the next year, copy these formulas and adjust references:
- Year: add 1 to the previous year (e.g.
=A2+1). - Age: add 1 to the previous age (
=B2+1). - Starting Balance: use the prior year’s Ending Balance (e.g.
=F2). - Annual Contribution: usually the same (or apply any raise; see next section).
- Interest and Ending Balance: use the same formulas as above.
Then select the second row and drag the fill handle down for as many years as needed (e.g., 35 rows for 35 years).
Excel will fill each row, projecting your savings growth yearly. You can also graph the Age vs Ending Balance columns to visualize the compound growth over time.
Excel FV/PMT Formula FAQs
Excel treats payments and contributions as cash outflows, so FV or PMT may return a negative value. Use =-FV(...) or =ABS(FV(...)) to display it as positive.
The type argument determines when payments are made. Use 0 (or leave it blank) for end-of-period payments and 1 for beginning-of-period payments.
Yes, if you want your result in today's money. You can use an inflation-adjusted rate or divide the future value by (1 + inflation)^years.
Yes. Just make sure the rate and number of periods match your payment frequency. For monthly calculations, use rate/12 and years*12.
