Template
Loan EMI Tracker
A home loan or two car loans can dominate your monthly budget, yet most people never see how much of each EMI is interest versus principal, or how a small prepayment could cut years off the loan. This tracker logs every loan with its EMI, interest rate, and tenure, shows the outstanding principal falling month by month, and lets you model prepayments to see how much interest and time you save. It keeps all your debt obligations and their progress in one clear, India-ready view.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The tracker records each loan you hold — home, car, personal, education — with its original principal, interest rate, tenure, and monthly EMI. For each loan it shows the outstanding principal, the split of the current EMI into interest and principal, and the remaining number of instalments. Crucially, it lets you enter a one-time or recurring prepayment and instantly see the impact: how many EMIs you save and how much total interest you avoid. Because most home loans are front-loaded with interest, the tracker makes the case for early prepayment visible, and keeps every loan’s payoff progress in one place.
Who it’s for
- Home loan borrowers who want to see how prepayment shortens their loan and cuts interest.
- People with multiple EMIs who want every loan and its remaining tenure in one view.
- Anyone deciding whether to prepay a loan or invest the surplus instead.
- Borrowers tracking a floating-rate loan whose EMI or tenure changes when rates move.
Fields included
How to use it
- Add each loan on its own row — home, car, personal, education — with its lender.
- Enter the original principal, annual interest rate, tenure in months, and the EMI amount.
- Record the outstanding principal from your latest statement to anchor the schedule.
- Read the interest-versus-principal split of your current EMI to see where the money goes.
- Enter any planned prepayment to see how many EMIs and how much interest it saves.
- Update the outstanding balance each month or after every prepayment.
- Compare the interest saved by prepaying against returns you could earn by investing the same amount.
Preview
| Loan | Outstanding (₹) | EMI (₹) | Interest in EMI (₹) |
|---|---|---|---|
| Home loan | 38,00,000 | 34,700 | 26,900 |
| Car loan | 4,20,000 | 9,500 | 3,100 |
| Personal loan | 1,10,000 | 5,000 | 1,300 |
| Total EMI | — | 49,200 | 31,300 |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Deepa has a ₹40L home loan at 8.5% over 20 years, with an EMI of about ₹34,700. Two years in, her outstanding principal is roughly ₹38L, and the tracker shows that nearly ₹27,000 of each EMI is still interest. She receives a ₹3L bonus and enters it as a prepayment. The tracker shows that applying it to principal — and keeping the EMI unchanged so the tenure shrinks — saves her close to ₹8L in interest and finishes the loan about two years early. Seeing that, she prepays the bonus rather than parking it in an FD earning far less.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)