How Much Do I Need to Retire? A 4% Rule Spreadsheet Calculator (Worked Example)

You want one number: how much do I need to retire. The 4% rule gets you there in thirty seconds, but most people stop at the shortcut and end up with a number that is far too high or dangerously low. Below is the full spreadsheet version, with a worked example you can copy cell by cell, including the Social Security step that most quick calculators skip.

All dollar figures here are illustrative assumptions I chose for the example. They are not statistics, forecasts or advice, and you should replace every input with your own.

The 4% Rule in One Paragraph

The rule traces to William Bengen’s 1994 research and the 1998 Trinity Study. It tested how long a stock-and-bond portfolio lasted when a retiree withdrew a fixed percentage in year one and then increased the dollar amount with inflation. Historically, a 4% starting withdrawal survived roughly 30-year periods in most tested scenarios. It is a benchmark built from past markets, so treat it as a planning tool rather than a promise.

The Multiply-by-25 Shortcut

Because 1 divided by 0.04 is 25, your target portfolio is annual spending times 25:

That is the whole shortcut. The rest of this guide is about feeding it the right spending figure and testing it.

Worked Example: A 4% Rule Spreadsheet in Six Steps

Meet a hypothetical household (all numbers are assumptions for the example): spending of $62,000 a year in retirement, $310,000 invested today, saving $1,500 a month, and combined Social Security of $30,000 a year starting at 67.

Step 1: Build the spending figure. Lay out your expected retirement budget by category rather than guessing a percentage of income.

Category Annual (assumed)
Housing (taxes, insurance, upkeep) $18,000
Food and household $9,600
Healthcare and insurance $9,000
Transportation $5,400
Utilities and phone $4,800
Travel and hobbies $9,600
Gifts, misc, buffer $5,600
Total $62,000

Step 2: Compute the gross target. $62,000 x 25 = $1,550,000. This is the number if your portfolio had to fund every dollar of spending.

Step 3: Net out guaranteed income. If $30,000 of the spending is covered by Social Security, the portfolio only funds the $32,000 gap: $32,000 x 25 = $800,000. Same household, nearly half the target. That single step is the biggest correction most people can make.

Step 4: Add the bridge if you retire before benefits start. Suppose they retire at 60 but claim Social Security at 67. For seven years the portfolio funds the full $62,000, which is 7 x $62,000 = $434,000 before any investment growth or inflation. That bridge is a separate amount to hold in lower-risk assets, not something the 25x multiplier covers. If you plan to stop before 65, this step matters as much as the multiplier.

Step 5: Test the withdrawal rate. Run the target at three rates against the $32,000 gap:

Withdrawal rate Multiplier Target
3.5% 28.6x $914,286
4.0% 25x $800,000
4.5% 22.2x $711,111

The spread, roughly $711,000 to $914,000, is the honest answer. Plan toward the middle, and keep the high end as your safety margin.

Step 6: Measure progress. $310,000 / $800,000 = 38.75% funded. With $1,500 a month at an assumed 6% annual return, the balance reaches about $804,000 after roughly 119 months, close to 10 years. At lower returns it takes longer, which is why you should recalculate with a few return assumptions instead of trusting one.

Copy-Ready Formulas

Put these in a block labelled Inputs and Results. Cell addresses are examples, so adjust them to your layout.

Cell Label Formula or value
B2 Annual spending 62000
B3 Guaranteed income (SS + pension) 30000
B4 Withdrawal rate 0.04
B5 Portfolio-funded gap =MAX(B2-B3,0)
B6 Retirement target =B5/B4
B7 Current invested balance 310000
B8 % funded =B7/B6
B9 Monthly saving 1500
B10 Assumed annual return 0.06
B11 Months to target =NPER(B10/12,-B9,-B7,B6)
B12 Years to target =B11/12

For the range table, copy the target formula down three rows with 0.035, 0.04 and 0.045 in the rate column. For the bridge, use =years_between_retirement_and_benefits * B2.

Year-One Income Check

Once you hit the target, test it in reverse. An $800,000 portfolio at 4% gives a first-year withdrawal of $32,000. Add $30,000 of Social Security and spending of $62,000 is covered. Under the rule’s inflation adjustment, if prices rise 3% a year (an assumption), the second-year withdrawal is about $32,960 and the third is about $33,949. Watching that line move is how you see whether the portfolio is keeping up.

Where the 4% Rule Needs Adjusting

Retirement length. The rule was tested on about 30 years. If you retire at 50 or 55, you may need a longer horizon, which is why many early retirees use 3.5% or lower. Our FIRE number guide covers that version.

Taxes. Withdrawals from traditional accounts are taxable, Roth withdrawals generally are not, and taxable brokerage accounts have their own treatment. Spending of $62,000 may require a larger gross withdrawal. The order you draw accounts matters, which is part of the safe withdrawal analysis.

Healthcare. Costs before Medicare eligibility are a common surprise for early retirees. Give healthcare its own line, as in the budget table, and stress it.

Flexibility. Real retirees trim spending after weak market years. A plan that can drop discretionary spending 10% in a bad year is sturdier than a rigid rule, which is why a range beats a single point.

Claiming age. Social Security at 62, 67 or 70 changes the guaranteed income you subtract in Step 3. The break-even guide for claiming at 62, 67 or 70 shows how to compare them.

Five Mistakes That Skew the Number

  1. Multiplying income instead of spending. Your salary is not what retirement costs. Use projected spending.
  2. Forgetting Social Security. Skipping Step 3 can nearly double the target, as the example shows ($1.55M vs $800K).
  3. Ignoring the bridge years. The multiplier says nothing about the years before benefits start.
  4. Using one return assumption. Run at least three: pessimistic, middle, optimistic.
  5. Setting it and forgetting it. Update balances and spending quarterly so the % funded line stays honest.

Track It in a Template Instead of Rebuilding It

You can build the block above in an hour. The harder part is keeping it connected to your accounts, your projection and your scenarios. The Retirement & FIRE Calculator has all of this prebuilt, and a net worth tracker is the companion piece for today’s balances. For the complete build including projections and scenarios, see the full retirement calculator walkthrough.


Frequently Asked Questions

What is the 4% rule for retirement?

The 4% rule says you can withdraw 4% of your portfolio in your first year of retirement, then raise that dollar amount with inflation each year, and have a high historical probability of the money lasting about 30 years. It was popularized by William Bengen's 1994 research and the 1998 Trinity Study. In practice your target portfolio is annual spending multiplied by 25 - $50,000 a year points to $1.25 million.

How do I calculate my retirement number using the 4% rule?

Take annual spending your portfolio must cover and multiply by 25. That is the same as dividing by 0.04. $40,000 needs $1,000,000; $60,000 needs $1,500,000; $80,000 needs $2,000,000. The key detail is to subtract guaranteed income such as Social Security or a pension first, because the portfolio only has to fund the gap.

Should I subtract Social Security before multiplying by 25?

Yes, for the retirement years when benefits are being paid. In the worked example above, $62,000 of spending with $30,000 of combined Social Security leaves a $32,000 gap, so the target falls from $1,550,000 to $800,000. Use your own estimate from your Social Security statement, and add a separate bridge amount if you will retire before benefits begin.

Is the 4% rule still accurate?

It remains a widely used planning benchmark, not a guarantee. Some planners use a lower starting rate such as 3.5% for longer retirements, and others adjust spending up or down with markets. The practical move is to calculate your target at 3.5%, 4% and 4.5% and plan around the range instead of a single number.

What is the difference between my retirement number and my FIRE number?

They use the same math, annual spending times 25, but a FIRE number usually has to last 40 to 50 years rather than 30, and Social Security is often decades away. Early retirees therefore often use 3.5% (about 28.6 times spending) and add a bridge amount for the years before benefits and penalty-free account access.

How much should I have saved by now to be on track?

Divide your current investable balance by your target. In the worked example, $310,000 against an $800,000 target is 38.75%. With $1,500 saved per month and an assumed 6% annual return (an assumption, not a promise), the model reaches about $804,000 in roughly 10 years. Change the return to 4% or 8% to see how sensitive the date is.

Can I do this in Google Sheets?

Yes. Every formula in this guide is plain arithmetic plus IF, MAX and NPER-style logic that works in both Excel and Google Sheets. Put inputs in one block, label the assumptions, and keep the withdrawal-rate table beside the target so you can see the range at a glance.

Find Out If You're Actually On Track to Retire

The Retirement & FIRE Calculator — 9 tabs and 463 working formulas — a Your Info tab that collects every input in yellow-highlighted cells; a Retirement Dashboard returning an ON TRACK / NEEDS ATTENTION readiness status; a Savings Projection tab running 40 years of compound growth with a portfolio chart; an Account Planner that optimises contributions across 401(k), Traditional IRA, Roth IRA, HSA and brokerage with a recommended funding order; a FIRE Calculator returning your financial independence number, years to FIRE, FIRE age and progress percentage with a savings-rate scenario table; a Withdrawal Strategy tab with 4% rule analysis, a Required Minimum Distribution schedule for ages 73-90 and a tax-efficient withdrawal order; an Expense Planner projecting retirement spending by category with inflation adjustments; and a Scenarios tab running best, expected and worst case side by side with a Social Security claiming comparison at ages 62, 65, 67 and 70. Dual-income support for couples. Formula cells protected. Works in Excel and Google Sheets.

View on Etsy — $17.99