A budget stress test asks one question: if my income fell to a fraction of today's, how many months could my savings cover the gap? Build a small tab with an income multiplier, a list of fixed costs, a list of flexible costs you could trim, and a runway formula. Then change the multiplier and the trim and watch the answer move.
How do I set up the inputs?
- B1: income multiplier. 100% is normal, 60% means income falls to 60 percent of today's.
- B2: normal monthly income, say ₹90,000.
- B3: stressed income, =B2*B1.
- B4: trim to flexible spending, such as 30% if you could cut flexible costs by that much.
- B5: savings you could draw on, say ₹2,40,000.
All figures here are invented. Use your own, and use only money you could genuinely spend without penalty.
Which costs go where?
| Group | Line | Monthly (₹) |
|---|---|---|
| Fixed | Rent | 22,000 |
| Fixed | EMI | 14,000 |
| Fixed | Utilities and internet | 4,000 |
| Fixed | Insurance premiums, yearly cost divided by 12 | 3,000 |
| Flexible | Groceries | 12,000 |
| Flexible | Eating out | 5,000 |
| Flexible | Transport | 6,000 |
| Flexible | Shopping and extras | 6,000 |
Fixed costs add up to ₹43,000 and flexible costs to ₹29,000. Put the totals in B6 and B7 with =SUMIF(A10:A17,"Fixed",C10:C17) and the same with "Flexible", assuming the table sits in A10:C17 and the group is in column A.
What formulas give the runway?
- Stressed spending in B8: =B6+B7*(1-B4).
- Monthly shortfall in B9: =B8-B3.
- Months of runway in B10: =IF(B9<=0,"Income covers spending",B5/B9).
What do the numbers say?
With the multiplier at 100 percent, income of ₹90,000 against spending of ₹72,000 leaves a surplus of ₹18,000, so there is no shortfall. Now push the multiplier down:
| Income level | Income (₹) | Trim | Spending (₹) | Shortfall (₹) | Runway |
|---|---|---|---|---|---|
| 60% | 54,000 | 0% | 72,000 | 18,000 | 13.3 months |
| 60% | 54,000 | 30% | 63,300 | 9,300 | 25.8 months |
| 40% | 36,000 | 0% | 72,000 | 36,000 | 6.7 months |
| 40% | 36,000 | 30% | 63,300 | 27,300 | 8.8 months |
Check one line: with a 30 percent trim, flexible spending becomes 29,000 times 0.7, which is 20,300. Add the 43,000 fixed and spending is 63,300. Subtract income of 54,000 and the shortfall is 9,300. Then 2,40,000 divided by 9,300 is about 25.8 months.
What do I learn from this?
- Fixed costs set the floor. Whatever you trim, the 43,000 stays until rent, EMI or premiums change.
- The same 30 percent trim does a lot at 60 percent income and much less at 40 percent. Trimming has limits.
- The runway is only as long as the savings. Counting money you could not touch quickly will flatter the result.
How often should I update it?
Twice a year is enough for most households, and again after any big change: a new loan, a move, a new child. Rebuild the flexible list from recent months of real spending, not memory.
A checklist for the first run
- List fixed costs from your last three statements, not from memory.
- Mark each flexible cost with the cut you could actually keep for three months.
- Run at least three income levels and write down the runway for each.
- Decide at what runway you would want to act, and note the first step.
Keep the first version modest: one tab, eight cost lines and three income levels. A sheet you will reopen is worth more than a detailed model abandoned after one evening, and you can always add lines once the structure proves useful.
Sorting your costs into fixed and flexible is easier with categorised history. SpendixAI lets you keep your own categories and reports spending by category from imported statements, which gives you the lines for this tab.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


