When income varies, work out the EMI ratio twice: once against your average month over the last twelve months, and once against your weakest quarter. The average tells you the normal picture and the weak quarter tells you whether you could still pay EMIs in a bad season.
First decide which figure is your income
For a business or freelance work, deposits are not the same as income. A shopkeeper's account receives customer money that must go back out for stock, rent and wages. For this exercise, use the amount that is actually left for the household each month. If you only have raw deposits, subtract business costs first, then follow the same steps.
A small shop owner's twelve months
All figures are invented. Say the amount left for the household was as follows, month by month and grouped by the financial-year quarter.
| Quarter | Amounts left, month by month | Quarter total | Monthly average |
|---|---|---|---|
| April to June | ₹62,000, ₹58,000, ₹45,000 | ₹1,65,000 | ₹55,000 |
| July to September | ₹40,000, ₹52,000, ₹70,000 | ₹1,62,000 | ₹54,000 |
| October to December | ₹95,000, ₹88,000, ₹66,000 | ₹2,49,000 | ₹83,000 |
| January to March | ₹50,000, ₹48,000, ₹56,000 | ₹1,54,000 | ₹51,333 |
The yearly total is 1,65,000 + 1,62,000 + 2,49,000 + 1,54,000, which is ₹7,30,000. Divided by twelve, the average month is about ₹60,833. The weakest quarter is January to March at ₹1,54,000, which is about ₹51,333 a month.
Which ratio should I trust?
Say the shop owner pays EMIs of ₹18,000 a month. The ratio against the average month is 18,000 divided by 60,833, about 29.6 percent. Against the weakest quarter it is 18,000 divided by 51,333, about 35.1 percent. In the single weakest month, July at ₹40,000, it is 45.0 percent.
- Average ratio: your normal year.
- Weakest-quarter ratio: the one to plan around.
- Weakest-month ratio: shows the cash-flow dip you must bridge from a buffer.
In rupees, what remains after EMIs is ₹42,833 in an average month and ₹33,333 in the weakest quarter. That is ₹9,500 less each month, or ₹28,500 over the three months. A buffer of about that size is what absorbs the dip. If the weakest-quarter ratio makes you uneasy, that is the number to focus on, not the comfortable average.
What if my clients pay late?
Freelancers often work in one month and get paid in another. Count the month the money reached your account, not the month you did the work, because EMIs are debited on fixed dates regardless of when invoices clear. If your gaps between work and payment are long, your real weak months will look weaker than your project calendar suggests.
How do I set this up in a sheet?
- List twelve months of the household-available amount in cells B2 to B13.
- For the yearly average, use =AVERAGE(B2:B13).
- Put the four quarter totals in C2 to C5 with =SUM(B2:B4), =SUM(B5:B7), =SUM(B8:B10) and =SUM(B11:B13).
- For the weakest quarter's monthly figure, use =MIN(C2:C5)/3.
- Divide your total monthly EMI by each figure to get the ratios.
What if my income grows each year?
Use the latest twelve months, not an older year, but do not assume next year's growth. When your records show a clear step up for two or three quarters, update the figures. Until then, the cautious view stays the working number.
A closing check
Keep the twelve months of figures somewhere you can update monthly. If you upload statements into SpendixAI, the deposit and expense rows live with each account, so you can total them for each month, though you will still need to separate business money from household money yourself.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


