Budgeting

Month-end projection from day 15: where will your spending land?

A month-end spending projection from day 15: a run-rate formula for variable spending plus fixed bills still due, and why plain doubling overshoots.

Editorial illustration for Month-end projection from day 15: where will your spending land?

To project where your spending will land by month-end, take your variable spending so far, divide by the days gone and multiply by the days in the month, then add the fixed bills for the whole month. Doubling everything you have spent by day 15 overshoots, because rent and EMIs paid early are counted twice.

Why does plain doubling go wrong?

Spending in a month is not even. Some of it is fixed and lands once, such as rent, an EMI or a school fee. The rest is variable and flows day by day, such as groceries, fuel and eating out. If most of your fixed bills have already gone out by day 15, then doubling the total counts them twice. If most are still to come, doubling undercounts. Either way, you need to treat the two kinds separately.

What is the correct method?

  1. Add up variable spending so far.
  2. Divide by the days gone to get a daily rate.
  3. Multiply by the total days in the month, for a projected variable total.
  4. Add all fixed bills for the month: those already paid plus those still due.
  5. Add the two for the projected month.

A worked example with hypothetical numbers

It is day 15 of a 30-day month. You have spent ₹21,000 on variable items. You have also paid ₹26,000 of fixed bills (rent ₹22,000 and an EMI of ₹4,000), and ₹14,000 of fixed bills are still due, such as electricity, school fees and insurance. So the total spent so far is 21,000 + 26,000 = ₹47,000.

MethodWorkingProjected month
Plain doubling47,000 × 2₹94,000
Variable run-rate plus fixed(21,000 ÷ 15 × 30) + 26,000 + 14,000₹82,000

The daily rate is 21,000 ÷ 15 = ₹1,400. Over 30 days, that is 1,400 × 30 = ₹42,000 of variable spending. Fixed bills for the whole month are 26,000 + 14,000 = ₹40,000. Together: 42,000 + 40,000 = ₹82,000. Plain doubling gave ₹94,000, which is ₹12,000 too high. If your monthly income is ₹85,000, the doubling method would have told you that you were heading for a loss of ₹9,000, and the better method says you will have ₹3,000 left.

How do you put a range around it?

Spending is never perfectly steady, so give yourself a margin. A ten per cent range on the variable part is a sensible start. Ten per cent of 42,000 is ₹4,200, so variable spending might land between ₹37,800 and ₹46,200. Adding the fixed ₹40,000, the month ends between ₹77,800 and ₹86,200. If the top of that range is above your income, you have time to adjust.

What does the formula look like in a sheet?

Put variable spent so far in B2, days gone in B3, days in the month in B4, fixed paid in B5 and fixed still due in B6. These work in Excel and Google Sheets.

  • Projected variable: =B2/B3*B4
  • Projected month: =B2/B3*B4+B5+B6
  • Days in the current month: =DAY(EOMONTH(TODAY(),0))
  • Days gone: =DAY(TODAY())

With the figures above, the second formula returns 82,000. Replace the numbers each time you look.

What should you do with the answer?

  • If it is below income, note the margin and leave it alone.
  • If it is above income, pick the one or two variable categories that are running highest and trim for the second half.
  • If the range is wide, check again on day 22.

If your transactions are already in SpendixAI, the dashboard and reports show spending so far by category, so splitting variable from fixed is a matter of reading the categories. The projection itself is a short sum you can do in your head.

A habit to keep

Do this check on day 15 every month and write down the projection. At month-end, compare it with what happened. After three months you will know how much to trust the rule for your own spending.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports