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.
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.
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, colour key, method, sources, limits, disclaimer |
| Dashboard | Pick Example or My plan | Key figures and a native line chart: balance vs FIRE number vs Coast FIRE number |
| Plan | 8 inputs: age, invested assets, yearly investment, retirement spending, return, inflation, withdrawal rate, coast age | Real 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 |
| Projection | Nothing (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 projection | Already filled | The fictional case shown on this page |
How to use it
- Open Plan and fill the 8 yellow cells. "Inputs complete?" turns to Yes.
- Type retirement spending in today's money. Count only invested assets (brokerage, retirement accounts, index funds), not your home.
- Enter your expected return before inflation and your inflation assumption. The sheet turns them into a real return for you.
- Pick a withdrawal rate. 4% is the classic starting point; 3%–3.5% leaves more room for a long retirement.
- Read your FIRE number, years to FIRE and Coast FIRE age. Then check the sensitivity grid to the right.
- On Dashboard, switch cell B3 to My plan to chart your own numbers.
- 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.
| Result | Formula |
|---|---|
| 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
- Real return: (1 + 7%) ÷ (1 + 2.5%) − 1 = 4.390%. Everything after this is in today's dollars.
- FIRE number: $40,000 ÷ 4% = $1,000,000. Today's $85,000 is 8.5% of it.
- 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).
- In future dollars: at 2.5% inflation, the same buying power needs $1,673,039 at that point.
- Coast FIRE number today: $1,000,000 ÷ (1 + 4.390%)^33 = $242,227. The example has $85,000, so not yet.
- 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)
| Year | Age | Start | Invested | Growth | End balance | % of FIRE | Coast number |
|---|---|---|---|---|---|---|---|
| 0 | 32 | – | – | – | $85,000 | 8.5% | $242,227 |
| 1 | 33 | $85,000 | $24,000 | $3,732 | $112,732 | 11.3% | $252,862 |
| 2 | 34 | $112,732 | $24,000 | $4,949 | $141,681 | 14.2% | $263,963 |
| 5 | 37 | $203,448 | $24,000 | $8,932 | $236,380 | 23.6% | $300,277 |
| 8 | 40 | $306,644 | $24,000 | $13,462 | $344,107 | 34.4% | $341,588 |
| 10 | 42 | $383,214 | $24,000 | $16,824 | $424,038 | 42.4% | $372,239 |
| 15 | 47 | $606,061 | $24,000 | $26,608 | $656,669 | 65.7% | $461,447 |
| 20 | 52 | $882,314 | $24,000 | $38,736 | $945,050 | 94.5% | $572,033 |
| 21 | 53 | $945,050 | $24,000 | $41,490 | $1,010,540 | 101.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 rate | FIRE number | 2% real | 3% real | 4% real | 5% real | 6% real | 7% real |
|---|---|---|---|---|---|---|---|
| 3.00% | $1,333,333 | 34.3 | 29.8 | 26.5 | 23.9 | 21.9 | 20.2 |
| 3.25% | $1,230,769 | 32.2 | 28.1 | 25.1 | 22.7 | 20.8 | 19.2 |
| 3.50% | $1,142,857 | 30.3 | 26.6 | 23.8 | 21.6 | 19.9 | 18.4 |
| 3.75% | $1,066,667 | 28.7 | 25.2 | 22.7 | 20.6 | 19.0 | 17.6 |
| 4.00% | $1,000,000 | 27.2 | 24.0 | 21.6 | 19.7 | 18.2 | 16.9 |
| 4.25% | $941,176 | 25.8 | 22.9 | 20.7 | 18.9 | 17.5 | 16.2 |
| 4.50% | $888,889 | 24.5 | 21.9 | 19.8 | 18.1 | 16.8 | 15.6 |
| 4.75% | $842,105 | 23.4 | 20.9 | 19.0 | 17.4 | 16.1 | 15.1 |
| 5.00% | $800,000 | 22.3 | 20.0 | 18.2 | 16.8 | 15.5 | 14.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
- Mixing nominal returns with today's spending. In the example, 7% nominal with today's $40,000 gives 16.9 years. The consistent real-return answer is 20.8 years.
- Counting your home or car. Only assets that can fund withdrawals belong in the FIRE number.
- Leaving out taxes and health costs. If withdrawals are taxed, the spending figure must be the gross amount, not what you plan to spend after tax.
- Treating 4% as a promise. It is a historical planning figure for up to about 30 years. Retiring at 40 can mean 50 years of withdrawals.
- Forgetting sequence risk. The sheet assumes a steady return. A market fall early in retirement does more damage than the same fall later, as Bengen's 1973–74 example shows.
- Never updating. Refresh invested assets and spending once a year so the dates stay meaningful.
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
- Compound interest spreadsheetYear-by-year growth with contributions
- Coast FIRE calculatorCoast number and age online
- CAGR calculatorCheck the return you assume
- Net worth trackerTotal the assets you count
- Compound interest calculatorGrowth with regular deposits
- Inflation calculatorToday's money vs future money
- Net worth percentileCompare your net worth
- Investment policy statementWrite down your plan and rules
- All templatesFree spreadsheets
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.