Installments in Compound Interest

Do you know, If someone wants to buy a Motor Cycle, or a costly mobile or if your father wants to purchase a new flat, they generally take loan from a bank or from a financier.  They need to pay monthly installments.  Today, across the world, all the EMI's (Equated monthly Installments) are being calculated on compound interest.  So after reading this article, you must be in a position to calculate the EMI you are going to pay for your new scooter purchase!!

Before that, let us try to understand the meaning of compounding and discounting. We know that daily prices of the goods increase at a rate. Assume, A product which costs Rs.100 costs Rs.110 next year and Rs.121 that next year.  Suppose, You lend Rs.100 to your friend and he promised to give you Rs.100 after 1 year.  Do you accept it? Out of friendship we accept.  But think like a financier. If you receive Rs.100 after 1 year the value of this 100 rupee may not buy the same amount of goods it would have purchased today as the prices went up to Rs.100.  So we need to charge some interest. So how much is the interest?
We use the formula of compound interest.
$P\left( {1 + \displaystyle\frac{R}{{100}}} \right) = A \Rightarrow 100\left( {1 + \displaystyle\frac{R}{{100}}} \right) = 110$
It is clear that interest rate is 10%
That means, if the interest rate is 10%, Rs.100 today is equal to Rs.110 earned after 1 year and Rs.121 after 2 years.


Formula for installments in Compound Interest:

If a buyer sells a product to you at full payment get some interest on your amount for n periods. This total amount should equal to sum of all EMI's and the interests accrued on each EMI  for the remaining period. Then only the seller did not get any loss.
Assume we have taken a loan at period 0 and have to pay installments at the end of 1, 2, 3, 4th periods of x each. 
Now  loan amount plus the interest on the total loan amount P at R% rate for 4 periods is equal to all the EMI's and interests earned for the remaining period.  That is the EMI in the period 2 earns 2 periods interest and EMI in the 3rd period earns only 1 period interest. 
$P\left( {1 + \displaystyle\frac{R}{{100}}} \right)^4$  = $x\left( {1 + \displaystyle\frac{R}{{100}}} \right)^3$  + $x\left( {1 + \displaystyle\frac{R}{{100}}} \right)^2$  + $x\left( {1 + \displaystyle\frac{R}{{100}}} \right)^1$  + $x$


Present Value method:

We should also solve this problem by Present Value (PV method).  You learn this concept in any finance text book!!
We already learnt that Rs.110 earned after 1 year is equal to Rs.100 earned today if the interest rate is 10%
So Rs.110 discounted at 10% gives you Rs.100.  Don't worry how to do this. This is quite simple. You have to calculate P from the compound interest formula. 
$P = \displaystyle\frac{A}{{\left( {1 + \displaystyle\frac{R}{{100}}} \right)^n }}$
Here A = Rs.110, R = 10%, n = 1. 
From the above diagram, if we have taken loan for 4 periods, the last installment should discount for 4 periods and so on. 
So $P$ = $\displaystyle\frac{x}{{\left( {1 + \displaystyle\frac{R}{{100}}} \right)^1 }}$ + $\displaystyle\frac{x}{{\left( {1 + \displaystyle\frac{R}{{100}}} \right)^2 }}$ + $\displaystyle\frac{x}{{\left( {1 + \displaystyle\frac{R}{{100}}} \right)^3 }}$ + $\dfrac{x}{{\left( {1 + \displaystyle\frac{R}{{100}}} \right)^4 }}$


General Discussion On EMI's: 
Suppose you have taken a loan of Rs.100000 to buy a house at 12% rate to be paid EMI's for 60 months.
They use this formula EMI = $\displaystyle\frac{{P \times r \times (1 + r)^n }}{{\left( {1 + r} \right)^n  - 1}}$

Here r = Rate / 1200
n = periods (5 years = 60 periods)

Sample Loan Schedule: 
CarWale EMI Schedule
Following  Schedule Is For : 100000 to repay in 60 months.
All calculations are based on EMI in Arrears(i.e. Rear Ended EMI's).
EMI Number
EMI Amount
Interest Amount
Principal Reduction
Balance Due
1.
Rs.2224
Rs.1000
Rs.1224
Rs.98776
2.
Rs.2224
Rs.988
Rs.1237
Rs.97539
3.
Rs.2224
Rs.975
Rs.1249
Rs.96290
4.
Rs.2224
Rs.963
Rs.1262
Rs.95028
5.
Rs.2224
Rs.950
Rs.1274
Rs.93754

Monthly interest is 1% per month. Now after 1 month, interest accrued is 1000.  Of the total EMI of Rs.2224, Rs.1000 used for interest and the remaining Rs.1224 for principal reduction.  Now Balance of Rs.98776 becomes the principal for next month. So interest is 987.7 or Rs.988.