- Practice
- About 17 min
- 5 practice questions
Loan schedules: outstanding balance and prepayment
Build the first rows of a repayment schedule, find the balance outstanding after some EMIs, and compare cutting the EMI with cutting the tenure after a prepayment.
If something looks wrong, please tell us.
Once the EMI is known, a second family of questions follows: how much is still owed after some months, how the EMI splits into interest and principal in a given month, and what happens if the borrower pays a lump sum early. This lesson works through all three using one loan, so you can see how the pieces fit. Rates are invented ('suppose').
The repayment schedule
Take the loan from earlier lessons: ₹1,00,000 at 1% a month for 12 months, EMI ₹8,884.88. Each month: interest = 1% of the opening balance; principal repaid = EMI − interest; closing balance = opening balance − principal repaid.
| Month | Opening balance (₹) | Interest (₹) | Principal (₹) | Closing balance (₹) |
|---|---|---|---|---|
| 1 | 1,00,000.00 | 1,000.00 | 7,884.88 | 92,115.12 |
| 2 | 92,115.12 | 921.15 | 7,963.73 | 84,151.39 |
| 3 | 84,151.39 | 841.51 | 8,043.37 | 76,108.02 |
Notice that the principal repaid grows each month and the interest shrinks, as lesson 4 of the foundation course explained. In a schedule question, work row by row and round each figure to the paisa.
Outstanding balance after k EMIs
Going row by row is slow for, say, the balance after 6 months. There is a direct way. The balance still owed equals the value today of the EMIs that remain. Equivalently, grow the original loan for k months and subtract what the k EMIs have grown to:
Balance after k EMIs = P(1 + r)ᵏ − EMI × [(1 + r)ᵏ − 1] ÷ r
Worked example 1: balance after six months
For the same loan, find the balance after 6 EMIs, given (1.01)⁶ = 1.061520. Working: P(1 + r)⁶ = 1,00,000 × 1.061520 = 1,06,152.02 (using the unrounded factor 1.0615201506). (1.01)⁶ − 1 = 0.0615202, and ÷ 0.01 = 6.15202. EMI × 6.15202 = 8,884.88 × 6.15202 = 54,659.92. Balance = 1,06,152.02 − 54,659.92 = ₹51,492.10, about ₹51,492. Check: six of the twelve EMIs are paid, but more than half the principal is still owed (₹51,492 out of ₹1,00,000), because the early EMIs were mostly interest. Answer: about ₹51,492.
Worked example 2: a prepayment
After paying those 6 EMIs, the borrower prepays ₹20,000. The new balance is 51,492.10 − 20,000 = ₹31,492.10. Compare (a) keeping 6 months but lowering the EMI, and (b) keeping the EMI of ₹8,884.88 and finishing early. (a) Using the formula for P = 31,492.10, r = 0.01, n = 6: new EMI = 314.921 × 1.061520 ÷ 0.061520 = ₹5,433.91. Interest over the 6 months = 6 × 5,433.91 − 31,492.10 = ₹1,111.36. (b) Month by month: interest 314.92, balance falls to 22,922.14; interest 229.22, balance 14,266.48; interest 142.66, balance 5,524.26; interest 55.24, and a final payment of ₹5,579.50 clears it. Total interest = 314.92 + 229.22 + 142.66 + 55.24 = ₹742.04, and the loan ends in 4 months instead of 6. Answer: reducing the tenure saves more interest (₹742.04 against ₹1,111.36); reducing the EMI eases the monthly budget.
Rules worth remembering
- The interest part in any month = r × the balance at the start of that month.
- Halfway through the tenure, more than half the principal is still owed.
- A prepayment saves interest because the balance falls earlier.
- Keeping the EMI and shortening the tenure saves more interest than keeping the tenure and cutting the EMI.
- Any prepayment charges are set by the loan terms and the rules that apply; questions will state them if they matter.
Why does the formula work? If the borrower paid nothing, the loan would grow to P(1 + r)ᵏ after k months. Each EMI paid along the way also grows, because it reduces a balance that would otherwise have attracted interest; together the k EMIs are worth EMI × [(1 + r)ᵏ − 1] ÷ r at month k. The difference between the two is what is still owed. You can confirm the formula against the schedule above: for k = 3 it gives the same ₹76,108.02. In a question, if the factor (1 + r)ᵏ is given, the whole calculation is two multiplications and a subtraction, far quicker than six rows of a table.
Key takeaways: build schedules row by row with interest on the opening balance; use the balance formula for a jump of several months; expect more than half the principal to remain at the half-way point; and after a prepayment, a shorter tenure saves more interest than a smaller EMI.
Check your understanding
-
1. Suppose a loan has an opening balance of ₹84,151.39 in a month and the rate is 1% a month with an EMI of ₹8,884.88. How much principal does that EMI repay?
- ₹841.51
- ₹8,884.88
- ₹7,884.88
- ₹8,043.37
Show answer
Answer: D. Interest = 1% of 84,151.39 = ₹841.51. Principal = 8,884.88 − 841.51 = ₹8,043.37.
-
2. Halfway through the tenure of an EMI loan, the principal still owed is
- exactly half the original principal
- more than half the original principal
- less than half the original principal
- always zero
Show answer
Answer: B. Early EMIs are mostly interest, so less than half the principal has been repaid by the half-way point.
-
3. Suppose a loan balance is ₹50,000, the rate is 1.5% a month and the EMI is ₹10,000. What is the balance after the next EMI?
- ₹40,750
- ₹40,000
- ₹39,250
- ₹40,075
Show answer
Answer: A. Interest = 1.5% of 50,000 = ₹750. Principal repaid = 10,000 − 750 = ₹9,250. Balance = 50,000 − 9,250 = ₹40,750.
-
4. After a prepayment, which choice usually saves the most interest?
- Keeping the same tenure and lowering the EMI
- Stopping EMIs for a few months
- Keeping the same EMI and shortening the tenure
- Converting to flat-rate interest
Show answer
Answer: C. Keeping the EMI repays the balance faster, so interest is charged on a smaller balance for fewer months.
-
5. Suppose P = ₹1,00,000, r = 0.01, EMI = ₹8,884.88 and (1.01)³ = 1.030301. Using the balance formula, what is the balance after 3 EMIs, to the nearest rupee?
- ₹73,345
- ₹75,000
- ₹78,500
- ₹76,108
Show answer
Answer: D. P(1.01)³ = 1,03,030.10. EMI × (0.030301 ÷ 0.01) = 8,884.88 × 3.0301 = 26,922.08. Balance = 1,03,030.10 − 26,922.08 = ₹76,108.02, matching the schedule.
Sign in to keep track of the lessons you finish.