EMI Calculation and Loan Amortisation for Bankers (JAIIB AFM)

EMI calculation and loan amortisation is the one piece of arithmetic a branch officer cannot delegate to a screen. A customer sitting across the counter wants to know what the instalment will be, how much of it is interest, what happens if he pays a lakh extra next Diwali, and why the "12% flat" scheme at the dealership is not cheaper than your 12% reducing-balance loan. JAIIB AFM tests exactly this, and it tests it numerically. This guide takes you from the annuity that the formula is built on, through rests and schedules, to prepayment, moratorium and benchmark resets.

🧮 Where the EMI Formula Actually Comes From

An equated monthly instalment is nothing more than an annuity. The lender parts with a principal today and receives a stream of equal payments; the present value of that stream, discounted at the loan rate, must equal the principal disbursed. Set the present value of the annuity equal to P and solve for the instalment, and you get the formula the examination expects you to reproduce:

E = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]

Here P is the principal, n is the number of instalments, and r is the interest rate per instalment period expressed as a decimal — not the annual percentage. A 12% per annum loan on monthly rests gives r = 12 ÷ 12 ÷ 100 = 0.01. Candidates lose marks every single session by feeding 12, or 0.12, into that slot.

Work one through. Take P = ₹10,00,000, rate 12% p.a. on monthly rests, tenor 5 years, so r = 0.01 and n = 60. (1.01)⁶⁰ works out to about 1.8167. The numerator is 10,00,000 × 0.01 × 1.8167 = 18,167 and the denominator is 0.8167, giving an EMI of roughly ₹22,244. Total outgo over 60 months is about ₹13,34,640, of which ₹3,34,640 is interest.

Notice what the formula does not contain: processing fee, insurance premium, documentation charge. Every EMI calculation and loan amortisation question in the paper is a pure interest computation unless the question explicitly adds those costs, and then it is asking you for the annual percentage rate instead.

⚖️ Flat Rate, Reducing Balance and the Effect of Rests

Under the flat rate method, interest is charged on the original principal for the whole tenor, regardless of how much you have already repaid. On our ₹10,00,000 loan at 12% flat for five years, interest is ₹1,20,000 a year for five years — ₹6,00,000 — so the instalment is ₹16,00,000 ÷ 60 = ₹26,667. Under the reducing balance method, interest each month is charged only on the balance still outstanding, and the instalment is ₹22,244.

That gap is the whole point. Reverse-engineer the flat scheme: an instalment of ₹26,667 on a ₹10,00,000 loan for 60 months corresponds to roughly 20% per annum on a reducing balance. A rate quoted flat is therefore close to double the same number quoted on reducing balance — the classic trap in both the exam and the showroom.

Rests decide how often the outstanding balance is refreshed for the interest computation. On monthly rests, every instalment is credited to principal at once and the next month's interest is charged on the lower figure. On quarterly or annual rests, the repayments you made during the period do not reduce the balance used for interest until the rest date, so the borrower pays more for the same nominal rate. This table is the one to carry into the hall for EMI calculation and loan amortisation problems.

⚠️ Common Mistake: Converting a flat rate to a reducing rate by simply doubling it. Doubling is a rule of thumb for a five-year tenor. For a one-year loan the multiple is nearer 1.8, and for a very long tenor it climbs above two. If the paper gives you the instalment, solve backwards; do not assume.

📊 Reading and Building an Amortisation Schedule

An amortisation schedule splits every instalment into its interest and principal parts and carries forward the closing balance. The routine is mechanical: interest for the month = opening balance × r; principal repaid = EMI − that interest; closing balance = opening balance − principal repaid. Repeat until the balance is nil.

Take a housing loan of ₹30,00,000 at 9% p.a. on monthly rests for 20 years. Here r = 0.0075 and n = 240, and the EMI is about ₹26,992. In month one the interest is ₹30,00,000 × 0.0075 = ₹22,500, so only ₹4,492 goes towards principal and the balance falls to ₹29,95,508. In month two the interest is ₹22,466 and the principal component ₹4,526. The instalment never changes, but its composition shifts a rupee or two every month.

This is why the interest component dominates the early years and the principal component dominates the later ones. The crossover — where principal repaid first exceeds interest charged — arrives a little past the midpoint of a long tenor, which is why a borrower who exits a 20-year loan in year seven has barely dented the principal. Explaining that curve to a customer is the practical face of EMI calculation and loan amortisation.

The outstanding balance at any point is simply the closing balance of that row, and every part prepayment is applied to it. On the books, the interest element is income recognised on accrual and the principal element merely reduces the advance — the split matters for posting, which is why you should revise basic accountancy procedures alongside this topic, and subsidiary books and ledger posting for where those entries land. The same discipline governs schedule-driven write-offs you meet in the depreciation chapter.

💰 Prepayment, Moratorium and Structured Repayments

When a borrower makes a part prepayment, the amount is applied to the outstanding principal, and the lender then offers a choice: keep the EMI and shorten the tenor, or keep the tenor and reduce the EMI. Reducing the tenor saves more interest, because you continue paying the larger instalment against a smaller balance and knock out the costliest tail-end months. Reducing the EMI helps cash flow but stretches the loan over the same period, so the interest saving is smaller. Expect a question that asks which option a customer should pick and why — prepayment is the commonest twist the examiner adds to a straight EMI calculation and loan amortisation numerical.

A moratorium is a repayment holiday, not an interest holiday. Unless the sanction says otherwise, interest continues to accrue during the moratorium and is capitalised — added to the principal — so the post-moratorium instalment or tenor is larger. In an education loan with a course-plus-grace moratorium, the borrower who services simple interest during the study period ends up materially better off than one who lets it capitalise.

Structured repayments show up in the same numericals. A step-up structure starts with a smaller instalment that rises at fixed intervals, suiting a young borrower with a rising income curve; a step-down structure front-loads repayment for someone approaching retirement. A balloon instalment keeps periodic outgo low and settles a large lump at maturity, common in commercial vehicle finance, and carries obvious refinancing risk. Affluent borrowers often weigh prepayment against investing the surplus — the ground covered in wealth management for HNI customers.

💡 Exam Tip: If a numerical says "part prepayment of ₹2,00,000 in the 25th month", first compute the outstanding at the end of month 24 using the schedule logic, deduct ₹2,00,000, and only then recompute the EMI or the residual n. Deducting from the original principal is the fastest way to lose the mark.

🔁 Benchmark Resets, APR and the Key Facts Statement

Most retail floating-rate loans are now linked to an external benchmark under the Reserve Bank's external benchmark based lending rate framework, so the rate moves with the repo or the chosen benchmark rather than at the bank's discretion. When the benchmark moves, something has to give: either the EMI rises, or the residual tenor lengthens, or both.

The Reserve Bank's circular of 18 August 2023 on the reset of floating interest rates on EMI-based personal loans requires lenders to communicate this clearly. At sanction the borrower must be told the possible impact of a rate change on the instalment and the tenor; at each reset the borrower must be given the option to switch to a fixed rate, and the choice of enhancing the EMI, elongating the tenor, or a combination, along with the ability to prepay in part or full. Elongation must not create negative amortisation, and a statement showing principal and interest recovered, the rate and the residual tenor must be shared periodically. Executing all this correctly is a back office function your branch owns. Details of the framework are on the Reserve Bank of India website.

Finally, the headline rate is not the cost. The annual percentage rate folds in the processing fee, insurance premium and other charges recovered from the borrower and expresses the whole package as one rate. Since the Reserve Bank's Key Facts Statement requirement, lenders must hand retail and MSME borrowers a standardised KFS carrying the APR and the repayment schedule. A loan at a lower headline rate with a heavy fee can easily carry the higher APR — a favourite twist in comparison questions.

📌 Remember: Three numbers answer almost every EMI calculation and loan amortisation question — r per period, n periods, and (1 + r)ⁿ. Compute the third one carefully and the rest is substitution.

🧠 Practice MCQs: EMI and Amortisation

Want chapter-wise mock tests with 100+ MCQs? Start practising free →

❓ Frequently Asked Questions

🎯 Your Next Step

Get the periodic rate right, know that flat is roughly double reducing, be able to build the first two rows of a schedule from scratch, and remember that prepayment is best taken as a tenor cut — that quartet clears most of what AFM asks. Reinforce it with branch accounting and departmental accounts for the booking side, and revise everything at speed with the JAIIB AFM marathon.

Practise numericals until the calculator is a formality. Browse the full Accounting and Financial Management for Bankers article hub, then take a timed chapter test on EMI calculation and loan amortisation inside the JAIIB course and see how many of the five you get in under six minutes.