Monte Climb

The Retirement Calculator Formula, and Why One Isn't Enough

Most retirement calculators chain together four simple formulas built on one average return. Here's that math, a worked example of where it breaks, and how Monte Carlo turns the same formula into a probability of success.

3.9%. Morningstar found that this starting withdrawal rate holds up in 90% of simulated futures over a 30-year retirement. Look at how it was measured. Morningstar didn't use an average return. It counted how often the money lasted. That difference explains most of what you need to know about the retirement calculator formula. Below is the math most calculators use, how to rebuild it in a spreadsheet, and the point where one formula stops giving you a reliable answer. (Source: Morningstar, The State of Retirement Income 2025, Dec 2025.)

The retirement calculator formula, in short

Nearly every basic retirement calculator does four things:

  1. Grow what you've saved, plus what you'll add.
  2. Inflate what you'll spend.
  3. Set a target nest egg that can fund that spending.
  4. Compare the two and report the gap.
Step Formula What it answers
Grow savings FV = P(1+r)^n + PMT × [((1+r)^n − 1) / r] How much will I have?
Inflate spending S_future = S_today × (1+π)^t What will I spend then?
Target (shortcut) Target = annual spending × 25 How much do I need?
Target (precise) PV = W × [1 − (1+r)^−n] / r What lump sum funds n years of withdrawals?
Gap Gap = Target − FV Am I short?

The rest of this article walks through each formula, then shows where they go wrong.

1. Future value of savings and contributions

FV = P(1+r)^n + PMT × [((1+r)^n − 1) / r]

  • P is what you have saved today
  • r is the return per period
  • n is the number of periods until retirement
  • PMT is the amount you add each period

The first term grows your current balance. The second adds up a stream of contributions, each growing for a different length of time. For monthly contributions, use r/12 and n×12. Pages like HomePage Media's formula breakdown and CalcPlanet use this same structure.

In a spreadsheet: =FV(r, n, -PMT, -P). The minus signs are there because Excel and Google Sheets count money you put in as negative.

2. Inflate your spending

S_future = S_today × (1 + π)^t

Here π is the inflation rate and t is the number of years until you retire. If you spend $5,000 a month today, that figure will be higher on the day you retire, and it keeps rising for every year after.

3. Set a target

The shortcut most people know is annual spending × 25. That's the 4% rule turned around (1 ÷ 0.04 = 25), and it goes back to Bengen's 1994 research and the 1998 Trinity Study (Compound Ladder).

The more precise version is the present value of an annuity:

PV = W × [1 − (1+r)^−n] / r

W is the yearly withdrawal and n is the number of years it needs to last. The result is the lump sum that would fund those withdrawals if your return were exactly r every single year.

4. Compare

If the target is bigger than your projected savings, you have a gap. Rearrange the future value formula to solve for PMT and you get the monthly contribution needed to close it.

That's the whole method. It's tidy and it's easy to check. It also rests on one assumption that doesn't hold up.

Why a single formula isn't enough

Every formula above uses one return, applied the same way every year. Real markets go up and down, and once you start withdrawing, the order of those ups and downs matters. This is called sequence-of-returns risk.

Here's an illustrative example. Two retirees each start with $500,000 and withdraw $40,000 at the start of every year. Over five years both get the same returns, just in opposite order. The average is 5% in both cases.

Year Retiree A return A balance Retiree B return B balance
1 −20% $368,000 +30% $598,000
2 +5% $344,400 +5% $585,900
3 +5% $319,620 +5% $573,195
4 +5% $293,601 +5% $559,855
5 +30% $329,681 −20% $415,884

Both had the same average return and the same withdrawals. Retiree B still ends with about $86,000 more.

Without withdrawals the two balances would finish at exactly the same number, roughly $601,965, because the order of multiplication doesn't change the result. Taking money out is what makes timing matter. When you withdraw during a crash, you sell shares at low prices, and those shares are gone before the recovery.

A single-return formula can't see any of this. It assumes every year is an average year.

From one formula to 1,000: what Monte Carlo actually does

"Monte Carlo" can sound technical, but it's the same formula you just read, run many times. Each run picks a random return for each year instead of one fixed average.

In plain pseudocode:

funded = 0
repeat 1,000 times:
    balance = savings
    for each year from now until age 95:
        balance = balance − spending (adjusted for inflation)
        balance = balance × (1 + a random return for this year)
        if balance < 0: this future fails, stop
    if balance never went below 0: funded = funded + 1
success rate = funded ÷ 1,000

That's it. The formula stays the same. What changes is the question. "What do I end up with at 6% a year?" becomes "How often does my money last across a wide range of possible markets?"

The free-standing calculators from Bankrate or Vertex42 are good for getting the basic arithmetic right. Monte Carlo tools such as FIRECalc answer the probability question instead. Monte Climb takes the second approach. You enter three numbers (your age, your savings, and your monthly spending), and our engine runs them through 1,000 simulated futures and returns a success rate.

What "probability of success" really means

A success rate is more honest than a single projection. It still needs reading with care.

It depends on the assumptions. In a Kitces test with a 60/40 portfolio, 6.5% of Monte Carlo scenarios came out worse than the worst case in the historical record (Kitces). Compound Ladder found that Bengen's 4% rule over 30 years succeeded 100% of the time on historical data. In Compound Ladder's own Monte Carlo model, with its own settings, it succeeded about 91% of the time (Compound Ladder). The method you choose changes the answer you get.

How badly a plan fails matters as much as how often. Kitces compares two plans. One has a 90% success rate, but when it fails it means a 10-year shortfall. The other has an 85% success rate, but its failures need only a 3-year adjustment (Kitces). The plan with the higher number isn't automatically the better plan.

It's a probability, not a promise. A 90% success rate means 1 in 10 simulated futures ran short. That's useful to know, and it gives you a reason to adjust before you retire rather than after.

The 4% rule has moved

If a formula page multiplies by 25 and stops, it's using an old rule of thumb. Morningstar revisits its safe withdrawal rate every year:

  • Morningstar's outlook for 2025 put the safe starting rate at 3.7%, down from 4.0% the year before (Morningstar).
  • Its December 2025 report put it at 3.9%, judged by a 90% chance of money left after 30 years. That works out to roughly 25.6× spending instead of 25×.
  • Stretching the horizon from 30 to 35 years lowers the safe starting rate from 3.9% to 3.5% (Morningstar).
  • Spending flexibly, which means cutting back after bad years, can raise the safe starting rate to as much as 5.7% (Morningstar).

Morningstar updates these figures regularly, so check its latest report before you put one into your spreadsheet. The bigger lesson is that the "safe" multiple depends on how long your retirement lasts and how flexible your spending is.

Where each formula breaks

The simple formulas have some quieter weaknesses too. Can I Retire Yet argues that many calculators give similar answers simply because they share the same assumptions (Can I Retire Yet). Check these before you trust any result, including your own spreadsheet:

  • Real vs. nominal returns. If you inflate your spending, use nominal returns. If you keep spending in today's dollars, subtract inflation from the return. Mixing the two quietly inflates the result.
  • Contribution timing. The FV formula assumes you contribute at the end of each period. If you contribute at the start, multiply the contribution term by (1+r).
  • Taxes and fees. Neither appears in the basic formulas. Both reduce what you actually get to spend.
  • Social Security timing. The age you claim changes how much your portfolio has to cover, and for how many years.
  • Health care. Fidelity's 2025 estimate is $172,500 in Medicare premiums, deductibles, and prescriptions over retirement for a 65-year-old retiring that year, and that excludes long-term care (Fidelity Investments, 2025 Retiree Health Care Cost Estimate, Jul 2025). A flat spending figure won't capture costs like these.
  • Longevity. About one in three 65-year-olds may live to at least 90 (Social Security Administration, Retirement Information for Medicare Beneficiaries, 2026). If your n assumes a plan that ends at 85, you're betting against a third of retirees.

Some of these show up in how we built our engine. Plans run to age 95 by default, and you can extend them further. Medicare premiums and income-based surcharges are charged year by year rather than as one flat guess.

Build it yourself, then test it

The formulas are worth knowing. They show you which inputs drive your result, and they let you check any calculator's answer against your own. Here's a practical order:

  1. Run the FV formula with a conservative return.
  2. Inflate your spending to your retirement year.
  3. Set a target using a current withdrawal rate, not an automatic 25×.
  4. Then test the plan against a range of possible markets, not just one average.

You'd be ahead of a lot of people. EBRI's 2025 Retirement Confidence Survey found that only 52% of workers have ever estimated the monthly income they'll need in retirement (EBRI/Greenwald Retirement Confidence Survey 2025, Fact Sheet 3). The other half are guessing.

You need three numbers to start: your age, your savings, and your monthly spending. Enter them and see your success rate across 1,000 futures. The calculation runs in your browser, and nothing is saved until you choose to save it. If you want to know why the number came out the way it did, you can ask William, our AI planner, and he'll show his work. It's planning software, not advice.

Show my answer →

Frequently asked questions

What is the basic retirement calculator formula?

Most calculators use the future value formula FV = P(1+r)^n + PMT × [((1+r)^n − 1) / r] to project your savings. They compare the result with a target nest egg, which is often annual spending × 25 or the present value of an annuity, PV = W × [1 − (1+r)^−n] / r.

How do I calculate retirement savings in Excel or Google Sheets?

Use =FV(rate, periods, -contribution, -current_savings). For monthly contributions, divide the annual return by 12 and multiply the number of years by 12. The minus signs are there because spreadsheets count money you put in as negative.

Is the 4% rule (25x spending) still accurate?

It's a rough starting point. Morningstar's December 2025 report put the safe starting withdrawal rate at 3.9% for a 30-year retirement with a 90% success standard. Longer retirements lower that figure, and flexible spending can raise it. Morningstar updates the number regularly, so check its latest report.

Why do retirement calculators using the same formula give different answers?

They make different assumptions about returns, inflation, how long retirement lasts, taxes, and fees. Fixed-return calculators also ignore sequence-of-returns risk: two portfolios with the same average return can end very differently once withdrawals start.

How is a Monte Carlo retirement calculator different from a formula?

It uses the same year-by-year formula but runs it many times, often 1,000 or more, with a random return for each year. The result is the share of simulated futures in which the money lasts. That's a probability of success, not a guarantee.

When can you actually retire?

Three numbers. We run your savings through 1,000 simulated futures, the same engine behind the app, and give you one clear answer.

Show my answer

Get new posts by email

We'll email you new Monte Climb posts once the newsletter starts. Nothing has been sent yet.

We keep only your email address and the post you signed up from, and delete it whenever you ask. Privacy policy

Keep reading