Debt

Decision worksheet: prepay, invest or hold cash

A decision worksheet to prepay, invest or hold cash: rows for amount, goal, certainty, cash need and review date, filled in for a hypothetical ₹1 lakh.

Editorial illustration for Decision worksheet: prepay, invest or hold cash

This worksheet turns a vague "what should I do with this ₹1 lakh" into twelve short rows you fill in before you act. It covers the amount, the goal, how certain you need the money to be, your cash need and a review date. Below is the template, then the same rows filled in for a hypothetical ₹1,00,000.

The template, with an example filled in

RowWhat to writeExample for ₹1,00,000
1. DateToday's date15 November
2. AmountRupees available after fixed bills₹1,00,000
3. SourceBonus, refund, savings, giftFestival bonus
4. Goal for this moneyOne lineReduce the loan and top up the buffer
5. Date the goal needs itMonth and year, or noneNone for the loan; buffer wanted by March
6. Certainty neededHigh, medium or lowHigh for the buffer part
7. Cash buffer todayMonths of essential expenses3 months
8. Cash need in 12 monthsKnown big costs in rupees₹30,000 insurance premium in June
9. Loan detailsOutstanding, rate type, prepayment charge₹12,00,000, floating, no charge noted
10. Interest avoidedApproximate rupees a yearAbout ₹9,000 a year on ₹1,00,000 at an assumed 9%
11. Investment rangeLow, middle, high in rupeesMinus ₹5,000, plus ₹7,000, plus ₹12,000 for a year (invented)
12. Next review dateA fixed date1 April

How do you fill in the tricky rows?

Row 7 asks for months, not rupees. Divide the cash you can reach within a day or two by your monthly essential outgo. Row 8 asks for costs you already know about, so look at your calendar for premiums, school fees, festival travel and annual subscriptions. Row 10 is simply the amount multiplied by the loan rate for one year: 1,00,000 x 9% = 9,000. It is an estimate, because your actual loan schedule changes the figure slightly.

Which choices does the worksheet make visible?

Once rows 6, 7 and 8 are filled, you can see whether the money has an urgent job before it has an interesting one. In the example, a three-month buffer and a ₹30,000 premium coming in June are good reasons to hold some cash before prepaying anything. That is the kind of answer a rate comparison alone never shows.

A sample split, to show the arithmetic

UseAmountReason in the example
Cash buffer top-up₹30,000Covers the June premium and builds the buffer
Loan prepayment₹40,000Avoids about ₹3,600 interest a year at the assumed rate
Invest₹30,000Longer-term goal with no near date
Total₹1,00,000Matches the amount in row 2

The split is an illustration of how to document a decision, not a suggestion that you do the same. Your numbers and your comfort will produce a different split. Check that the parts add up to the amount in row 2 before you move anything.

What should you do after filling it?

  1. Read the sheet aloud, or show it to a partner who shares the money.
  2. Ask yourself whether you would still be comfortable if the investment low case happened.
  3. Confirm the loan details with your lender if any are guessed.
  4. Make the transfers and keep the bank references.
  5. Record each transfer in your tracker, with extra loan principal in its own category.

How often should you redo it?

Redo it each time a meaningful sum arrives, and at least once a year at the start of the financial year in April. Keep the old copies. After a year or two they show how your thinking and your circumstances changed, which is more useful than any single decision.

Loan terms, tax rules and charges change, so confirm the details with your lender and, for tax questions, with your CA.

SPENDIXAI JOURNAL

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

Explore your reports