Emergency Fund Calculator Excel | How Many Months Could You Survive? | Savings Runway Planner, Budget Spreadsheet

The Emergency Fund Runway Calculator by Kollaz answers one question: how many months could you survive if your income stopped today? Type in your emergency savings and monthly essentials, and it gives your runway in months, a plain-English verdict, funded-by dates for your 3, 6, and 9-month targets, and two what-if stress tests. Excel spreadsheet, instant download.

Picture a father hearing at work that hours are being cut next month, and doing scared math in his head all the way home. The panic he feels is real, but it is not coming from a number. Nobody has given him one. The real culprit is Not Knowing: it turns a problem with a size into a threat with no size at all. Leave it in charge and the first hard month gets decided blind: the wrong bill skipped, the costly credit reached for first, choices made in a rush that take months to undo. So he does one calm thing first. He lines his savings up against what his family truly spends to live, and reads his runway: this many months, with dates for building it longer. Bad news still hurts, but now it arrives with a clock he can read and time to plan his next move. He learned his fear was never the size of the problem. It was facing it without a number.

This is for someone building an emergency fund who needs to know how many months their savings actually cover.

**How many months could you survive if your income stopped today?**

One number answers it: your runway. This Excel calculator turns your emergency savings and your essential monthly spending into that number, then shows you exactly when you'll hit 3, 6, and 9 months of coverage at your current savings pace.

**What you get (instant download, Excel .xlsx, no macros):**

- **Inputs tab**: your emergency savings, monthly essentials broken down by category (housing, food, transport, insurance, minimum debt payments, other), and your optional monthly contribution. Type into the cream cells; everything else calculates itself.
- **Runway Dashboard**: your runway in months ("You can survive X.X months"), a plain-English verdict (Critical / Starter / Solid / Fortress), funded-by dates for your 3, 6, and 9-month targets, a 24-month survival countdown, and a projection chart.
- **What-If tab**: two stress tests side by side with your baseline. (1) job loss today: your runway is banked cash, so it doesn't shrink, but unfunded target dates go on hold. (2) cut spending 20%: see exactly how many extra months of breathing room that buys you.

**Honest math, not a promise.** Your runway is savings divided by essentials. The calculator assumes spending stays flat and ignores interest, inflation, taxes, and surprises. It's a planning number (a clear one), not a guarantee. If that's the kind of straight answer you want, this is your tool.

**Details:**
- Excel .xlsx spreadsheet, no macros: works in Excel for Windows/Mac and Excel for the web
- 4 tabs: Cover, Inputs, Runway Dashboard, What-If
- All formulas included and verified; input cells unlocked, everything else protected so nothing breaks
- Sample numbers pre-loaded so you can see it work before typing your own

Created with AI assistance.

Try the live demo (view-only sample): https://docs.google.com/spreadsheets/d/1vgh_UPuvLdrzy7ZS1CSR9IRwF1fcjRKW/edit?usp=sharing

How many months of expenses should I keep in an emergency fund?
Track your progress toward 3, 6, and 9 months of coverage. The calculator shows your runway today and projects your funded-by dates at your current savings pace, so you always know how far you have left to go.

What does the verdict mean?
Critical, Starter, Solid, or Fortress: a plain-English read on your current runway, based on your months of essential expenses covered.

What do the what-if tests show?
Two stress tests sit side by side with your baseline: job loss today (your runway is banked cash, so it holds, but unfunded target dates go on hold) and cutting spending 20% (see exactly how many extra months of breathing room that buys you).

Does it work in Google Sheets?
Yes. Google Sheets import was verified live on 2026-09-29 with all formulas, verdict bands, and charts intact. Excel for Windows, Mac, and Excel for the web are verified clean with no repair warning.

Is this a guarantee I can survive a set number of months?
No. Your runway is your savings divided by your essentials: a clear planning number, not a promise. It assumes spending stays flat and ignores interest, inflation, taxes, and surprises.

Do I need spreadsheet skills?
No. Type your numbers into the cream cells and everything else calculates itself.

Is there a demo I can look at before buying?
A live view-only demo is staged for the listing description (paste on publish), and a watermarked PREVIEW file shows the format. The preview has zero formulas: it cannot substitute for the product.

Format: Excel .xlsx spreadsheet, no macros
Tabs: 4: Cover, Inputs, Runway Dashboard, What-If
Inputs: emergency savings, monthly essentials by category (housing, food, transport, insurance, minimum debt payments, other), optional monthly contribution
Outputs: runway in months, plain-English verdict (Critical / Starter / Solid / Fortress), funded-by dates for 3, 6, 9-month targets, 24-month survival countdown, projection chart
Input cells: unlocked cream cells; all other cells protected so nothing breaks
Sample data: pre-loaded so you can see it work before typing your own
Compatibility: Excel for Windows, Mac, and Excel for the web (verified 2026-09-29); Google Sheets import verified 2026-09-29
Maker: Kollaz: Smart financial tools for modern money
Honest math note: runway is savings divided by essentials. The calculator assumes flat spending and ignores interest, inflation, taxes, and surprises. It is a planning number, not a guarantee.