Debt

A bonus: prepay, invest or split it? A three-column worked example

A bonus: prepay, invest or split it? A worked example with three columns, months saved and a comfort score so you can choose transparently.

Editorial illustration for A bonus: prepay, invest or split it? A three-column worked example

When a bonus arrives, three simple options sit on the table: put all of it towards a loan, put all of it into investments, or split it. A three-column sheet showing months saved, money you can still reach and how comfortable each option feels makes the choice visible instead of a guess. Here is one with invented numbers.

The hypothetical situation

  • Bonus after deductions: ₹1,50,000.
  • Loan: ₹20,00,000 outstanding, 180 months left, an assumed 9% a year, EMI about ₹20,285.
  • You keep paying the same EMI after any part-payment, so the tenure shortens.
  • Investment assumption: a steady 8% a year for five years on the invested part. This is only an assumption; real results vary.

The three-column sheet

RowPrepay allInvest allSplit half and half
Amount to loan₹1,50,000₹0₹75,000
Amount invested₹0₹1,50,000₹75,000
Months of loan saved25 (155 left)0 (180 left)13 (167 left)
Loan interest saved over the loan's lifeAbout ₹3,73,887NoneAbout ₹1,99,548
Assumed value of invested part after 5 yearsNoneAbout ₹2,20,399About ₹1,10,200
Cash you can still reach₹0₹1,50,000, value varies₹75,000, value varies
Comfort score, 1 to 5 (invented)435

The loan rows come from the hypothetical schedule: with the EMI unchanged, ₹1,50,000 shortens the loan from 180 to 155 months, and ₹75,000 shortens it to 167. The investment rows come from compounding at the assumed 8%: 1,50,000 x 1.08 five times over is about ₹2,20,399.

Why can't you read the rows straight across?

The two kinds of row cover different periods. Loan interest saved is spread over the remaining fifteen years of the loan, while the investment value is a five-year assumption. A fair comparison needs the same horizon and the same level of certainty on both sides. Use the table to see the shape of each option, not to crown a winner.

What does the comfort score add?

It admits something spreadsheets hide. Give each option a score from 1 to 5 for how you would feel about it in a bad year: if your income fell, if the investment dropped, if you needed cash urgently. In this made-up example the split scores highest because it leaves some cash and still shortens the loan. Your scores will be different, and so they should be.

What should you decide first?

  1. Is your cash buffer already where you want it? If not, fund that before any column.
  2. Are there costs in the next twelve months that this bonus should cover, such as school fees or insurance premiums?
  3. Is there any prepayment charge that changes the loan rows?
  4. Which column would you still be happy with if the investment fell for two years?

What if the bonus is not fully yours to allocate?

Bonuses often arrive with claims on them: an annual insurance premium, a festival trip, school fees due in June or a family obligation. Subtract those first, and treat only the remaining amount as free to allocate. In the example, a ₹30,000 premium would leave ₹1,20,000 to split, and every row of the sheet would need to be recalculated from that smaller figure rather than from ₹1,50,000.

How do you track what you chose?

Record the loan part as extra principal in its own category, separate from your EMI, and note the date and the lender's reference. If you invest part of it, keep that record in your own investments sheet or statement. Prepaid and invested money are different in your records, even when they came from the same bonus.

A short closing list

  • Buffer checked before the bonus is allocated.
  • Months saved and interest saved read from your own lender schedule, not from this example.
  • Investment assumptions written as a low, middle and high case.
  • Comfort scores filled in honestly.
  • Review date set.

This is a thinking tool, not advice on any product. Tax treatment of bonuses, loans and investments changes, so confirm the current position with your CA.

SPENDIXAI JOURNAL

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

Explore your reports