Home › Templates › FIRE calculator spreadsheet

FIRE Calculator Spreadsheet

Your FIRE number is your yearly spending divided by your withdrawal rate: at 4% that is 25 times spending. This free spreadsheet works it out, then shows how many years it takes to get there, your Coast FIRE number and age, a year-by-year projection and how the answer moves between a 3% and 5% withdrawal rate.

Download Excel template (.xlsx) 43 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 27 Oct 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no email, no add-on. The formulas are plain NPER, INDEX, MATCH and IF.

Preview: the Example plan tab. Fictional saver: age 32, $85,000 invested, invests $24,000 a year, wants to spend $40,000 a year, assumes 7% return and 2.5% inflation.
$1,000,000FIRE number ($40,000 ÷ 4%)
20.8 yearsYears to FIRE (age 52.8)
$242,227Coast FIRE number today
Age 40Coast FIRE age
Example projection in today's dollars, fictional data: the balance starts at $85,000 at age 32, crosses the $1,000,000 FIRE number in year 21 (age 53) and crosses the Coast FIRE line at age 40.$0$750k$1.5M$2.25M$3M323742475257626772AgeBalanceFIRE numberCoast FIRE number

Chart: the Example projection tab, first 40 years, in today's dollars. The dashed line is the balance you would need at each age to coast to the FIRE number by age 65 with no new money.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, colour key, method, sources, limits, disclaimer
DashboardPick Example or My planKey figures and a native line chart: balance vs FIRE number vs Coast FIRE number
Plan8 inputs: age, invested assets, yearly investment, retirement spending, return, inflation, withdrawal rate, coast ageReal return, FIRE number, progress, gap, years and age to FIRE (NPER), FIRE number in future dollars, Coast FIRE number and age, plus a 9 × 6 sensitivity grid
ProjectionNothing (formulas)Years 0–60: start balance, money invested, growth, end balance in today's and future dollars, % of FIRE number, Coast FIRE number at each age
Example plan / Example projectionAlready filledThe fictional case shown on this page

How to use it

  1. Open Plan and fill the 8 yellow cells. "Inputs complete?" turns to Yes.
  2. Type retirement spending in today's money. Count only invested assets (brokerage, retirement accounts, index funds), not your home.
  3. Enter your expected return before inflation and your inflation assumption. The sheet turns them into a real return for you.
  4. Pick a withdrawal rate. 4% is the classic starting point; 3%–3.5% leaves more room for a long retirement.
  5. Read your FIRE number, years to FIRE and Coast FIRE age. Then check the sensitivity grid to the right.
  6. On Dashboard, switch cell B3 to My plan to chart your own numbers.
  7. Update the invested assets cell once or twice a year. For the asset total, the net worth tracker template helps.

Where the 4% rule comes from, and its limits

The 4% figure goes back to William P. Bengen, "Determining Withdrawal Rates Using Historical Data", published in the Journal of Financial Planning in October 1994 (reprinted by the FPA in 2004). He tested a first-year withdrawal, raised each year with inflation, on US stock and bond returns since 1926. For a 4% start he wrote: "In no past case has it caused a portfolio to be exhausted before 33 years, and in most cases it will lead to portfolio lives of 50 years or longer." He also warned: “An initial five-percent withdrawal rate is risky; six percent or more is ‘gambling.’”

The "Trinity study" by Philip Cooley, Carl Hubbard and Daniel Walz of Trinity University (AAII Journal, February 1998) tested withdrawal rates of 3% to 12% over 15, 20, 25 and 30-year payouts with 1926–1995 data, using the S&P 500 and long-term high-grade corporate bonds. With inflation-adjusted withdrawals, it found that "withdrawal rates of 3% to 4% continue to produce high portfolio success rates for stock-dominated portfolios."

Limits for early retirees. Both studies used past US data. The Trinity study tested payouts of up to 30 years; Bengen required at least 30 years and his charts stop at 50. The Trinity authors note: "The study did not adjust for taxes or transaction costs", and that "young retirees who anticipate long payout periods should plan on lower withdrawal rates than their older counterparts." They also stress that a withdrawal rate "is not a matter of contract but rather a matter of planning." Past results do not guarantee future ones.

The formulas, explained

Exact formulas from the Plan tab (each is wrapped in IF($B$13<>"Yes","",…) so the sheet stays blank until all inputs are in). B5 = age, B6 = assets, B7 = yearly investment, B8 = spending, B9 = return, B10 = inflation, B11 = withdrawal rate, B12 = coast age.

ResultFormula
Real return (B16)=(1+B9)/(1+B10)-1
FIRE number (B17)=B8/B11
Years to FIRE (B20)=IF(B6>=B17,0,IFERROR(IF(NPER(B16,-B7,-B6,B17)<0,"Not reached",NPER(B16,-B7,-B6,B17)),"Not reached"))
Age at FIRE (B21)=B5+B20
FIRE number in future dollars (B23)=B17*(1+B10)^B20
Coast FIRE number today (B24)=B17/(1+B16)^MAX(0,B12-B5)
Coast FIRE age (B26)=INDEX(Projection!$B$6:$B$66,MATCH(1,Projection!$J$6:$J$66,0))
Projection end balance (F)=C7+E7+D7 where growth E7=C7*Plan!$B$16 and invested D7=Plan!$B$7
Coast number at each age (I)=G7/(1+Plan!$B$16)^MAX(0,Plan!$B$12-B7); flag J7=IF(F7>=I7,1,0)
Sensitivity cell=NPER(G$5,-$B$7,-$B$6,$F6) with FIRE number F6=$B$8/E6

NPER returns the number of periods for "periodic, constant payments and a constant interest rate" (Microsoft Support). Money you put in is negative, the target is positive. The projection adds each year's investment at the end of the year, the same timing NPER assumes.

Worked example from the sample data

Step by step

  1. Real return: (1 + 7%) ÷ (1 + 2.5%) − 1 = 4.390%. Everything after this is in today's dollars.
  2. FIRE number: $40,000 ÷ 4% = $1,000,000. Today's $85,000 is 8.5% of it.
  3. Years to FIRE: NPER(4.390%, −24,000, −85,000, 1,000,000) = 20.84 years, around age 52.8. The projection first passes the target at the end of year 21 ($1,010,540).
  4. In future dollars: at 2.5% inflation, the same buying power needs $1,673,039 at that point.
  5. Coast FIRE number today: $1,000,000 ÷ (1 + 4.390%)^33 = $242,227. The example has $85,000, so not yet.
  6. Coast FIRE age: at age 40 the balance ($344,107) first beats that age's coast number ($341,588). From then on, growth alone would reach $1,000,000 by 65.

Projection excerpt (Example projection tab, today's dollars)

YearAgeStartInvestedGrowthEnd balance% of FIRECoast number
032–––$85,0008.5%$242,227
133$85,000$24,000$3,732$112,73211.3%$252,862
234$112,732$24,000$4,949$141,68114.2%$263,963
537$203,448$24,000$8,932$236,38023.6%$300,277
840$306,644$24,000$13,462$344,10734.4%$341,588
1042$383,214$24,000$16,824$424,03842.4%$372,239
1547$606,061$24,000$26,608$656,66965.7%$461,447
2052$882,314$24,000$38,736$945,05094.5%$572,033
2153$945,050$24,000$41,490$1,010,540101.1%$597,147

Year 1: $85,000 × 4.390% = $3,731.71 growth, plus $24,000 invested, ends at $112,731.71.

Sensitivity: years to FIRE

Same saver, different withdrawal rates (rows) and real returns (columns). Values are years from today.

Withdrawal rateFIRE number2% real3% real4% real5% real6% real7% real
3.00%$1,333,33334.329.826.523.921.920.2
3.25%$1,230,76932.228.125.122.720.819.2
3.50%$1,142,85730.326.623.821.619.918.4
3.75%$1,066,66728.725.222.720.619.017.6
4.00%$1,000,00027.224.021.619.718.216.9
4.25%$941,17625.822.920.718.917.516.2
4.50%$888,88924.521.919.818.116.815.6
4.75%$842,10523.420.919.017.416.115.1
5.00%$800,00022.320.018.216.815.514.5

Moving from 4% to 3.5% raises the target to $1,142,857 and, at a 4% real return, adds 2.2 years (21.6 → 23.8). A 3% rate needs $1,333,333 and 26.5 years. The return you assume moves the date as much as the withdrawal rate does, which is why it is worth testing a range rather than a single number.

Common mistakes

FAQ

How do you calculate your FIRE number?

Divide the yearly spending you want in retirement by your withdrawal rate. At 4% that is spending × 25; at 3.5% it is about 28.6 times. In the example, $40,000 ÷ 4% = $1,000,000. Use spending in today's money and count only invested assets toward it.

How do I calculate years to FIRE in Excel or Google Sheets?

Use NPER with a real (after-inflation) return: =NPER(real_return, -yearly_investment, -assets_today, FIRE_number). With $85,000 invested, $24,000 a year and a 4.39% real return, it gives 20.8 years to $1,000,000. NPER works the same way in Excel, Google Sheets and LibreOffice.

What is Coast FIRE?

Coast FIRE means you have enough invested that, with no new money, growth alone would reach your FIRE number by a chosen retirement age. The Coast FIRE number is FIRE number ÷ (1 + real return)^(years until that age). In the example it is $242,227 today, reached at age 40.

Is the 4% rule still safe for early retirement?

It is a planning rule of thumb from US historical data, not a guarantee. Bengen (1994) found 4% lasted at least 33 years in every past case he tested, and the Trinity study tested payouts of up to 30 years. Early retirees may need 40 years or more, which is why many plan with 3% to 3.5%. The sensitivity grid shows the cost in extra years.

Should I use a nominal or real return in a FIRE calculator?

Use a real return if your spending is in today's money. Mixing a nominal return with today's spending makes the date look too early: in the example, 7% nominal gives 16.9 years, while the matching 4.39% real return gives 20.8 years.

Can I use this FIRE spreadsheet in Google Sheets?

Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Drive and open it with Google Sheets. It uses only NPER, INDEX, MATCH, IF and basic maths, with no macros or add-ons.

Related tools and templates

Educational template only, not financial, tax or investment advice. Example data is fictional: the saver, balances and return assumptions are made up. The 4% rule and other withdrawal rates are planning assumptions based on past US market data and do not guarantee that money will last. Quotes from Bengen (Journal of Financial Planning) and Cooley, Hubbard and Walz (AAII Journal) were retrieved on 27 October 2026.