EMI – Equated Monthly Installment

For the loan amount you have got, you need to pay back the principal as well as the interest. But altogether you can’t repay the same. So you are splitting your debt (Principal + interest) to the financial institution in an equal way so that you can set aside a fixed amount every month for repayment.

Assume the loan amount (L) is Rs.1,00,000/- @ rate (R%) 12 for term (N) of 12 months.

Before calculating EMI, you need to convert rate percent per annum as rate per month – i.e., divide R% by (12 x 100)

Divide by 100 to convert to absolute number from percentage and 12 to get monthly rate value.

So let us recalculate as r = R/(12*100)

In our case, r = 12/(12*100) = 0.01

EMI = (P * r) * {[(1+r)^N] / [((1+r)^N) – 1]}

Principal - 100000

Rate per annum - 12 = 0.01

Term (in months) - 12

EMI = 8885

Month No | Outstanding | Int Paid | Principal Paid | EMI | Balance | Rate |
---|---|---|---|---|---|---|

1 | 100000 | 1000 | 7885 | 8885 | 92115 | 0.01 |

2 | 92115 | 921 | 7964 | 8885 | 84151 | 0.01 |

3 | 84151 | 842 | 8043 | 8885 | 76108 | 0.01 |

4 | 76108 | 761 | 8124 | 8885 | 67984 | 0.01 |

5 | 67984 | 680 | 8205 | 8885 | 59779 | 0.01 |

6 | 59779 | 598 | 8287 | 8885 | 51492 | 0.01 |

7 | 51492 | 515 | 8370 | 8885 | 43122 | 0.01 |

8 | 43122 | 431 | 8454 | 8885 | 34668 | 0.01 |

9 | 34668 | 347 | 8538 | 8885 | 26130 | 0.01 |

10 | 26130 | 261 | 8624 | 8885 | 17507 | 0.01 |

11 | 17507 | 175 | 8710 | 8885 | 8797 | 0.01 |

12 | 8797 | 88 | 8797 | 8885 | 0 | 0.01 |

How to generate the table?

1. EMI and rate has been fixed now.

2. Now write numbers against the month column equal to the loan term that is already known to us.

3. For month 1, outstanding = loan amount (i.e. Principal)

4. Int Paid = outstanding * r [in this case r = 0.01]

5. Principal Paid = EMI – Int Paid

6. Balance = Outstanding – Principal Paid

7. Outstanding for next month is the balance of the previous month

Thus keep going for the rest of the months. You can also prepare an excel in the same format and copy formulae and generate the EMI and the table.

If you see, EMI = Principal + Interest and thus you are paying both interest and principal every month. If you observe, the interest you pay will keep decreasing with the progress of time and the principal keeps on increasing with the progress of time.

## No comments:

Post a Comment