Debt

Prepay vs invest: a worked example with assumed returns

A prepay vs invest worked example on a hypothetical ₹3 lakh over five years, showing how the answer flips as assumed returns change.

Editorial illustration for Prepay vs invest: a worked example with assumed returns

Here is a prepay vs invest worked example using made-up numbers: ₹3,00,000 of spare cash, five years, and three assumed investment returns set against an assumed loan rate. The result flips depending on the assumption, which is exactly the lesson. None of these figures are forecasts or typical rates; swap in your own.

The setup, with every assumption labelled

  • Spare money: ₹3,00,000, available today.
  • Assumed loan rate: 9% a year (hypothetical, reducing balance).
  • Horizon: five years.
  • Simplification: we treat the interest avoided as growing at the loan rate, compounded yearly. A real loan schedule is monthly and moves a little, so use this as a reasoning tool, not a quote.
  • Ignored on purpose: tax on gains, investment charges, prepayment fees, and any change in the loan rate.

What does ₹3 lakh become if you prepay?

Each rupee prepaid stops earning the lender interest at 9%. Treating that avoided interest as compounding for five years: 3,00,000 x 1.09 x 1.09 x 1.09 x 1.09 x 1.09 comes to about ₹4,61,587. The gain is about ₹1,61,587, and in the example it does not depend on any market.

What if you invest it instead?

Now assume the investment grows at a steady yearly rate. Real investments do not grow steadily, but a steady rate keeps the arithmetic clear.

Assumed yearly returnValue after 5 yearsGainVersus prepaying
0% (money just sits)₹3,00,000₹0₹1,61,587 behind
7%₹4,20,766₹1,20,766₹40,821 behind
9% (equals loan rate)₹4,61,587₹1,61,587Level
11%₹5,05,517₹2,05,517₹43,930 ahead

Notice that the break-even is exactly the loan rate in this simplified setup. Anything below it loses to prepaying; anything above it wins. But each row has a single outcome only because we froze the return. In real life you get one bumpy path, not a tidy average.

Why does range testing matter more than the answer?

Change one assumption and the winner changes. A person who assumed 11% would invest, and a person who assumed 7% would prepay, from the same facts. That is why the useful habit is to test a low, middle and high case, and to ask how bad the low case can get while you still sleep fine and still meet your commitments.

Three things the table hides

  • Sequence: a fall in year four hurts more than a fall in year one if you need the money in year five.
  • Liquidity: the prepaid ₹3 lakh cannot be spent; the invested sum usually can, subject to the product's terms.
  • Rate resets: if your loan floats, the 9% might be 8% or 10% for part of the five years.

How would you run this on your own numbers?

  1. Enter your outstanding principal, your current loan rate and the months left.
  2. Use your lender's schedule or a simple loan calculator to see interest saved by the extra amount.
  3. Pick three return assumptions you would not be shocked by: a low one, a middle one and a high one.
  4. Compare the five-year values side by side, as in the table.
  5. Add what the table ignores: charges, tax and your need for cash.

What would change the table?

Try a few edits to the same example. If the loan rate were 10% instead of 9%, the prepay side would grow to about ₹4,83,153 (3,00,000 x 1.1 five times over), and the 9% investment row would fall behind by about ₹21,566. If you only had three years, every gap would be smaller, because there is less time for the difference between the two rates to compound. Each variation is a quick way to see how sensitive your choice is, and sensitivity is the thing worth knowing before you act.

When the maths is a tie

If your low, middle and high cases straddle the loan rate, as they do here, the numbers alone will not decide. Then the non-numerical points do: how much buffer you hold, how soon you need the money, and whether being debt-free sooner has a value to you that does not show up in a spreadsheet. Write your choice and a review date down, and revisit it when your income, your loan rate or your goals change.

SPENDIXAI JOURNAL

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

Explore your reports