EMI calculation formula, worked by hand
The technique
Everything goes in as a monthly number
The formula is exact; the mistakes come from feeding it annual inputs. The rate enters as a monthly decimal, so 13 percent a year becomes 0.010833, and the tenure as a count of instalments, 48 rather than 4. Enter the annual rate or the tenure in years and the result is not slightly off, it is meaningless, which is why a hand check sometimes seems to prove the lender wrong when it is the check that is wrong.
The formula is E = P × r × (1+r)^n ÷ ((1+r)^n − 1). P is the principal, r the monthly rate as a decimal (the annual percentage divided by 12, then by 100), and n the number of monthly instalments. It is the reducing balance EMI formula: it assumes each month's interest is charged only on what is still owed, and solves for the one fixed payment that brings the balance to zero after exactly n months.
The only awkward step is raising 1.010833 to the 48th power. A phone calculator without a power key can still do it by squaring: square once for the 2nd power, square that for the 4th, again for the 8th, the 16th and the 32nd, then multiply the 32nd by the 16th to reach the 48th. Keep four decimal places at every step; rounding earlier drifts the answer by a few rupees. Here is the whole EMI calculation example on the loan used throughout.
- Monthly rate r = 13 ÷ 12 ÷ 100
- 0.010833
- (1+r) squared, then the 4th and 8th powers
- 1.0218, 1.044, 1.09
- 16th and 32nd powers
- 1.1882, 1.4117
- 48th power = 32nd × 16th
- 1.6773
- P × r = ₹5,00,000 × 0.010833
- ₹5,416.67
- Numerator: ₹5,416.67 × 1.6773
- ₹9,085.54
- Denominator: 1.6773 − 1
- 0.6773
- EMI: ₹9,085.54 ÷ 0.6773, rounded to the rupee
- ₹13,414
Unrounded, the EMI is ₹13,413.75. The loan and its 13 percent rate are illustrative; a sanctioned rate depends on the lender and your profile.
- ₹13,414 × 48 is ₹6,43,872, so the formula says the loan costs ₹1,43,872 in interest. The schedule below charges ₹1,43,858, because the final EMI is trimmed to ₹13,400 to land the balance exactly on zero
- P × r is the first month's interest, ₹5,417 here. If your lender's first row shows something different, it is almost certainly counting days rather than months, which the next section explains