3.3 Present Value of Multiple Payments
To get the present value of future payments, we discount each of these payments at the given interest rate for the time periods they correspond to. This is an extension of the formula given in the above Section 3.2.
Let p be the principal or present value of a loan lent at r% interest rate per annum. If A, B and C are the repayments made at the end of a, b and c years, wherein the loan is fully repaid, then
p=(1+100r)aA+(1+100r)bB+(1+100r)cC
Example 11
Caishen wants to lend a certain amount to Jade at 20% per annum compound interest. Jade agrees to repay 1000 coins at the end of each of first, third and fifth years. How many coins (rounded to the nearest integer) should Caishen lend?
Solution
Let the present value or principal be p.
p=(1+10020)11000+(1+10020)31000+(1+10020)51000
=1.21000+1.231000+1.251000
Using the calculator, we get
p=1813.91∼1814
Answer: 1814
3.4 Equated Monthly Instalment (EMI)
For most retail loans (such as home loans, auto loans and personal loans), the borrowers repay by paying a fixed amount every month over the tenure of the loan. This fixed amount is called Equated Monthly Instalment or EMI. EMI includes interest and principal.
For instance, where Rs.
25,000 was lent on 1stt January 2019 and the interest is 12% per annum, which is 1% per month, and the EMI is Rs. 1250, the following table provides the impact on the principal outstanding, i.e. the principal remaining.
| Date |
EMI |
Interest |
Principal Repaid |
Principal Outstanding |
| 1st January |
|
|
|
25,000 |
| 31st January |
1,250 |
250 |
1,000 |
24,000 |
| 28th February |
1,250 |
240 |
1,010 |
22,990 |
| 31st March |
1,250 |
229.90 |
1,020.10 |
21,969.90 |
As a certain portion of the EMI is principal repayment, the principal outstanding decreases over time. As a result, interest decreases over time and principal repayment portion of the EMI increases with time.
While the above are general observations, we need to understand how EMI is calculated. The present value of all future payments should equal the loan amount. Compound interest applies for these loans.
Let the loan amount be
p, the EMI be e, interest rate per time period be r% and number of time periods be n.
p=(1+100r)1e+(1+100r)2e+...+(1+100r)ne
p is the sum of n terms in Geometric Progression. We are not going create another formula here. You simply need to remember the sum to n terms of GP formula and apply here.
Sn=(1−r)a(1−rn), where a is the first term and r is the common ratio.
[Note: r in the above formula is common ratio and not rate of interest.]
Example 12
Jessica borrows Rs. 1,00,000 from HBSC bank at 12% per annum compounded monthly. If she wishes to repay through EMI, a fixed amount every month, over 70 months, what is EMI she pays every month?
[Assume (1.01)70=2]
(1) 2000
(2) 2200
(3) 2400
(4) 2500
Solution
Let the EMI amount be e.
Rate of interest =r=1% per month
Present Value of Loan = Present value of EMIs
100000=(1+100r)1e +(1+100r)2e+...+(1+100r)70e
⇒ 100000=(1.01)1e +(1.01)2e+...+(1.01)70e
The RHS is in GP where the first term a=1.01e, the common ratio r=1.011 and n=70
Applying the sum of n terms in GP formula, i.e. (1−r)a(1−rn)
⇒ 100000=1.01e×1−1.011(1−(1.011)70) =1.01e×1.010.01(1−1.01701)
⇒ 100000=0.01e×(1−21)=0.02e ⇒ e=2000
Answer: (1) 2000