FIRE Calculator Spreadsheet — Financial Independence Retire Early Planner, 4% Rule Withdrawal & Savings Rate Planner, Excel Download

The FIRE Freedom Planner is an 11-tab Excel workbook that finds your FIRE number across five lifestyles (Lean, Standard, Fat, Coast, and Barista FIRE), solves your exact years to independence, and stress-tests the 4% rule honestly: the Trinity Study found 4% worked ~95% of the time over 30 years (never "guaranteed").

This is for someone who knows roughly what early retirement should cost but has never run their own numbers, and wants one 11-tab model that computes their FIRE number, their freedom date, and whether the 4% rule actually holds up for them.

Try it before you buy — live demo with sample data: https://docs.google.com/spreadsheets/d/19GDywuc1hNe2yr62Y-bhq6O0d1Yp2Mw9k6CZV8mwOgo/edit?usp=sharing. This preview shows the Dashboard and the Savings Engine. The full 11-tab workbook (FIRE Numbers, Accumulation Projector, Withdrawal Lab, Milestone Tracker and more) is included instantly after purchase.

**Find your FIRE number. See your freedom date. Stress-test the 4% rule: honestly.**

How much would you need invested to never work again? The answer is simpler than you think: it's your annual spending, divided by a safe withdrawal rate. This planner takes that one number and builds your complete early-retirement plan around it: your FIRE number across five lifestyles, the exact year you reach financial independence, and a no-hype stress-test of whether your money actually lasts. Everything lives in one place, and every assumption is yours to change, so it's a model you can manipulate and update yourself, not a black box.

**What this planner does**

- **Finds your FIRE number across 5 lifestyles**: Lean, Standard, Fat, Coast, and Barista FIRE, each with live progress and status. Coast FIRE shows what you need invested *today* to stop saving; Barista FIRE shows the smaller target if part-time work covers part of your spending.
- **Solves your exact years to financial independence**: from your savings, annual investing, and real return. A formula, not a guess, plus your freedom age and % of the way there.
- **Shows which change buys you the most years**: the Savings Engine re-runs your timeline under five what-if scenarios (save more, spend less, save 25% of income, stop saving) with a "years shaved off" column and an automatic biggest-lever verdict.
- **Projects your portfolio year by year**: in today's dollars, split into "what you put in" vs. "what compound growth did."
- **Puts the 4% rule under a microscope**: the honest version. The Trinity Study found 4% worked ~95% of the time over 30 years (never "guaranteed"). Simulate YOUR drawdown year by year at 3%, 3.5%, and 4%, then run a -30% crash stress-test to see sequence-of-returns risk in one glance.
- **Tracks your milestones**: progress bars toward each tier. Revisit monthly and watch the percentages climb.

**Easy to start: no spreadsheet expertise needed**

This isn't a one-page calculator: it's an 11-tab planning model that does the math for you. Sample data is pre-loaded so you see it working the moment you open it; just overwrite it with your own numbers. A 15-minute setup guide lives inside the workbook, and the included Quick-Start PDF walks you through your first session step by step. See what your potential retirement could look like, then adjust if you need to.

**What's inside (11 tabs)**

1. COVER: branded title page
2. DASHBOARD: your headline. FIRE number, years to FI, freedom age, progress, all five tiers.
3. MY INPUTS: the only tab you fill in. Age, savings, investing, 3 spending levels, 3 assumptions.
4. MY FIRE NUMBERS: Lean / Standard / Fat / Coast / Barista FIRE calculators
5. SAVINGS ENGINE: five what-if scenarios with "years shaved off" and biggest-lever verdict
6. ACCUMULATION PROJECTOR: year-by-year portfolio growth in today's dollars
7. WITHDRAWAL LAB: published Trinity success rates + your 3%/3.5%/4% simulation + -30% crash test
8. MILESTONE TRACKER: progress bars toward each FIRE tier
9. HOW-TO: 15-minute setup guide inside the workbook
10. SOURCES & HONEST MATH: the research (Bengen 1994, Trinity Study 1998, Early Retirement Now) and what the math does NOT promise
11. REF (hidden): lookup tables powering the math

**The math is independently verified**

COMPATIBILITY: Math independently verified. All calculated values matched an independent Python recalculation plus a LibreOffice recalculation sweep (67/67 checks, zero mismatches). Built for Microsoft Excel (desktop & web): opened and verified in Excel for the web with no errors or repair warnings. Imports into Google Sheets via File, Import: live import tested 2026-09-22. All 10 tabs, charts, and live formulas verified working.

Sample data is pre-loaded so you can see the planner working right away. Just overwrite it with your own numbers (the Quick-Start PDF shows you how).

**First 60 seconds:** in Google Sheets, open the file then click **File → Make a copy** to create your own editable version. In Excel, click **Enable Editing** if prompted.

One real example: a 32-year-old with $85,000 saved, investing $22,000/year at a 5% real return and $60,000/year spending reaches Standard FIRE ($1,500,000) in 26.8 years, at age 59. Cutting spending 10% buys 4.5 extra years of freedom. Your numbers will be different. This planner finds yours in seconds.

**Details**

- Instant download: Excel `.xlsx` spreadsheet + Quick-Start PDF guide
- Verified: independent math recalculation (67/67 checks, zero mismatches)
- Built from published research: Bengen (1994), Trinity Study (1998), Early Retirement Now safe-withdrawal series

**Please note**

- This is an **educational planning tool, not financial, tax, or legal advice**. Confirm major decisions with a qualified professional.
- The 4% rule figures are historical research summaries, not predictions. ~95% is not 100%, and the rule was built for 30-year retirements. Early retirees planning 40-50+ year horizons should consider lower withdrawal rates (the planner models 3% and 3.5% for exactly this reason).
- Projections assume a smooth real return; real markets are volatile. Taxes, fees, and Social Security are not modeled.
- Digital product: no physical item will be shipped.

*Built by the Kollaz studio. Smart financial tools for modern money.*

Q&A
Q: What does it do?
A: Finds your FIRE number across 5 lifestyles (Lean, Standard, Fat, Coast, Barista), solves your exact years to financial independence from your savings, investing, and real return. The Savings Engine shows which change buys you the most years.

Q: How does the 4% stress-test work?
A: The Withdrawal Lab combines published Trinity success rates with your own 3%/3.5%/4% year-by-year drawdown simulation, plus a -30% crash stress-test for sequence-of-returns risk.

Q: One real example?
A: A 32-year-old with $85,000 saved, investing $22,000/year at a 5% real return with $60,000/year spending reaches Standard FIRE ($1,500,000) in 26.8 years, at age 59. Cutting spending 10% buys 4.5 extra years of freedom.

Q: Is the math verified?
A: All calculated values matched an independent Python recalculation plus a LibreOffice sweep: 67/67 checks, zero mismatches.

MINI-FAQ
Q: Is this financial advice?
A: No: it's an educational planning tool, not financial, tax, or legal advice. Confirm major decisions with a qualified professional.

Q: Is the 4% rule guaranteed?
A: No: the figures are historical research summaries, not predictions; ~95% is not 100%.

Q: Do I need spreadsheet skills?
A: No: sample data is pre-loaded, and MY INPUTS is the only tab you fill in.

Q: Can I try it first?
A: Yes: there's a live demo with sample data at the start of this description.

SPECS
Format: 11-tab Excel .xlsx workbook + Quick-Start PDF guide
Compatibility: Microsoft Excel (desktop & web: verified in Excel for the web); Google Sheets (File, Import, live import tested)
Region: General retirement math based on published research (Bengen 1994, Trinity Study 1998); taxes, fees, and Social Security not modeled
Maker: Kollaz: Smart financial tools for modern money
Delivery: Instant digital download