Quick Summary
Emergency fund sizing starts with essential expenses, not income. This covers the calculation, where to park the money, and a spreadsheet approach for tracking progress.
An emergency fund is the foundation of any financial plan. But two questions trip people up: how much to save, and how to track progress toward that number.
The calculation is straightforward. The tracking is where a spreadsheet earns its keep.
How Much: The Calculation
The standard range is 3-6 months of essential expenses. Not income - expenses. Here’s how to figure that number:
| Monthly Expense | Amount |
|---|---|
| Housing (rent/mortgage) | $1,500 |
| Utilities | $200 |
| Groceries | $400 |
| Transportation | $300 |
| Insurance premiums | $250 |
| Minimum debt payments | $200 |
| Total essential expenses | $2,850 |
| Target | Calculation | Amount |
|---|---|---|
| 3 months | $2,850 x 3 | $8,550 |
| 4 months | $2,850 x 4 | $11,400 |
| 6 months | $2,850 x 6 | $17,100 |
Which target? Some people with stable dual incomes and low fixed costs lean toward 3 months. Those with variable income, single earners, or higher fixed obligations often aim for 6. There’s no universal right answer.
The Emergency Fund Calculator walks through this calculation interactively.
Where to Keep It
The money needs to be liquid, safe, and ideally earning something while it sits. High-yield savings accounts (HYSAs) check all three boxes.
| Account Type | Typical APY | Access Speed | FDIC Insured |
|---|---|---|---|
| Traditional savings | 0.5% | Instant | Yes |
| High-yield savings (online) | 4.0 - 4.35% | 1-2 days transfer | Yes |
| Money market account | 3.5 - 4.2% | Same day (checks/ATM) | Yes |
| Checking account | 0.01 - 0.1% | Instant | Yes |
The difference between 0.5% and 4.25% on a $10,000 balance is about $375/year. Same safety, same FDIC protection - just a different type of bank.
What matters most for an emergency fund account:
- FDIC or NCUA insured (up to $250,000)
- No withdrawal penalties
- No minimum balance requirements
- Transfer speed that works for your situation
Rates change with Federal Reserve policy. Worth checking quarterly, but chasing a 0.15% difference between banks rarely justifies the hassle.
Tracking Emergency Fund Progress in a Spreadsheet
This is where the spreadsheet approach shines. A simple progress tracker turns a vague goal into a concrete path.
Emergency Fund Tracker:
| Month | Starting Balance | Added | Interest | Ending Balance | % of Goal |
|---|---|---|---|---|---|
| Jan | $0 | $500 | $0 | $500 | 4.4% |
| Feb | $500 | $500 | $1.77 | $1,002 | 8.8% |
| Mar | $1,002 | $500 | $3.55 | $1,505 | 13.2% |
| Apr | $1,505 | $500 | $5.33 | $2,010 | 17.6% |
| … | |||||
| Dec | $5,522 | $500 | $19.56 | $6,041 | 53.0% |
Goal: $11,400 (4 months of expenses) Monthly contribution: $500 Time to goal: ~23 months
Watching the percentage climb each month makes the goal feel achievable rather than overwhelming.
Building It Faster
Some people find that redirecting irregular income accelerates the timeline:
| Source | Amount | New Balance | % of Goal |
|---|---|---|---|
| Tax refund | $1,200 | $3,210 | 28.2% |
| Sold unused items | $350 | $3,560 | 31.2% |
| Bonus at work | $800 | $4,360 | 38.2% |
Adding a column for windfalls shows how irregular money can close the gap.
Once You Hit Your Target
A fully funded emergency fund still needs occasional attention:
- Annual review. If expenses change, the target changes. A rent increase or new insurance premium means recalculating.
- After a withdrawal. If the fund gets used (that’s what it’s for), add a rebuilding plan to the tracker.
- Interest tracking. The fund earns money while it sits. Worth noting in a net worth tracker or the Financial Planning Template.
Useful to keep the emergency fund as a line item in the Net Worth Tracker so it’s visible alongside other assets.
Quick-Start Spreadsheet Setup
Three columns are enough to start:
- Essential expenses worksheet - List monthly costs, sum them, multiply by target months
- Progress tracker - Monthly balance with percentage of goal
- Contribution plan - How much per month, projected completion date
The calculation takes 15 minutes. The tracking takes 5 minutes per month. The clarity lasts as long as you maintain it.
Related
- Financial Planning Template - Comprehensive financial planning
- Net Worth Tracker - Track emergency fund
- Emergency Fund Calculator
- When to Recalculate Your Emergency Fund
- Multiple Savings Accounts Strategy