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
| Row | What to write | Example for ₹1,00,000 |
|---|---|---|
| 1. Date | Today's date | 15 November |
| 2. Amount | Rupees available after fixed bills | ₹1,00,000 |
| 3. Source | Bonus, refund, savings, gift | Festival bonus |
| 4. Goal for this money | One line | Reduce the loan and top up the buffer |
| 5. Date the goal needs it | Month and year, or none | None for the loan; buffer wanted by March |
| 6. Certainty needed | High, medium or low | High for the buffer part |
| 7. Cash buffer today | Months of essential expenses | 3 months |
| 8. Cash need in 12 months | Known big costs in rupees | ₹30,000 insurance premium in June |
| 9. Loan details | Outstanding, rate type, prepayment charge | ₹12,00,000, floating, no charge noted |
| 10. Interest avoided | Approximate rupees a year | About ₹9,000 a year on ₹1,00,000 at an assumed 9% |
| 11. Investment range | Low, middle, high in rupees | Minus ₹5,000, plus ₹7,000, plus ₹12,000 for a year (invented) |
| 12. Next review date | A fixed date | 1 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
| Use | Amount | Reason in the example |
|---|---|---|
| Cash buffer top-up | ₹30,000 | Covers the June premium and builds the buffer |
| Loan prepayment | ₹40,000 | Avoids about ₹3,600 interest a year at the assumed rate |
| Invest | ₹30,000 | Longer-term goal with no near date |
| Total | ₹1,00,000 | Matches 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?
- Read the sheet aloud, or show it to a partner who shares the money.
- Ask yourself whether you would still be comfortable if the investment low case happened.
- Confirm the loan details with your lender if any are guessed.
- Make the transfers and keep the bank references.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

