Loan Repayment

A person borrows A 0 = $ 500 A_0 = \$500 on the 1st day of October, and agrees to pay back the loan in 6 equal monthly installments, each equal to B B dollars beginning November 1st, at a monthly interest rate of 20 % 20\% . Find B B , the amount of the monthly installment, rounded to the nearest cent.

Details and Assumptions:

  • On October 1st, and after receiving the loan, the amount outstanding A 0 = $ 500 A_0 = \$500
  • The next month, an interest of 20% is applied, then the monthly installment is deducted, making the outstanding amount equal to A 1 = 1.2 A 0 B A_1 = 1.2 A_0 - B
  • The same process is repeated for the following months, resulting in an outstanding balance A n = 1.2 A n 1 B , n = 1 , 2 , . . , 6 A_{n} = 1.2 A_{n-1} - B ,\space n = 1,2, .., 6
  • The outstanding balance after payment of the 6th installment is A 6 = $ 0.00 A_6 = \$0.00


The answer is 150.35.

This section requires Javascript.
You are seeing this because something didn't load right. We suggest you, (a) try refreshing the page, (b) enabling javascript if it is disabled on your browser and, finally, (c) loading the non-javascript version of this page . We're sorry about the hassle.

2 solutions

Relevant wiki: Time value of money

Let the interest rate be i i and the number of period or payments be n n . Then the future value A 0 A_0 after the n n periods is FV A 0 = A 0 ( 1 + i ) n \text{FV}_{A_0} = A_0(1+i)^n . We note that payment instalment B B has a periof n 1 n-1 , n 2 n-2 , n 3 n-3 , \cdots , 2, 1, 0. Therefore, the future value of all B B 's is FV B = B k = 0 n 1 ( 1 + i ) k \displaystyle \text{FV}_B = B\sum_{k=0}^{n-1}(1+i)^k . Since the payments with interest pay for the principal with interest,

FV B = FV A B k = 0 n 1 ( 1 + i ) k = A 0 ( 1 + i ) n B ( ( 1 + i ) n 1 ) i = A 0 ( 1 + i ) n B = A 0 i ( 1 + i ) n ( 1 + i ) n 1 Putting the values = 500 0.2 1. 2 6 1. 2 6 1 150.35 \begin{aligned} \text{FV}_B & = \text{FV}_A \\ B\sum_{k=0}^{n-1}(1+i)^k & = A_0(1+i)^n \\ \frac {B\left((1+i)^n-1\right)}i & = A_0(1+i)^n \\ \implies B & = \frac {A_0i(1+i)^n}{(1+i)^n-1} & \small \color{#3D99F6} \text{Putting the values} \\ & = \frac {500\cdot 0.2 \cdot 1.2^6}{1.2^6-1} \\ & \approx \boxed{150.35} \end{aligned}

Hosam Hajjir
Feb 8, 2018

The dynamics of the outstanding balance are governed by the first-order difference equation:

A k = ( 1 + i ) A k 1 B A_{k} = (1 + i) A_{k-1} - B

where i i is the interest rate (as a fraction) and B is constant. The solution of the difference equation is

A k = c 1 ( 1 + i ) k + c 2 A_{k} = c_1 (1+i)^k + c_2

Using the method of undetermined coefficients, we simply plug in this solution into the difference equation to determine c 1 c_1 and c 2 c_2

c 1 ( 1 + i ) k + c 2 = ( 1 + i ) ( c 1 ( 1 + i ) k 1 + c 2 ) B c_1 (1+i)^k + c_2 = (1 + i) ( c_1 (1+i)^{k-1} + c_2 ) - B

the terms containing c 1 c_1 cancel out , and we get

i c 2 = B i c_2 = B

So that,

A k = c 1 ( 1 + i ) k + B i A_{k} = c_1 (1 + i)^k + \dfrac{B}{i}

The initial condition is A 0 = A A_0 = A the loan amount, hence,

A = c 1 + B i A = c_1 + \dfrac{B}{i}

leading to,

c 1 = A B i c_1 = A - \dfrac{B}{i}

Thus we have the dynamics now fully specified, namely,

A k = ( A B i ) ( 1 + i ) k + B i A_{k} = (A - \dfrac{B}{i} ) (1 + i)^k + \dfrac{B}{i}

Now we can apply the boundary condition, that A n = 0 A_{n} = 0 where n n is the number of months of the loan agreement.

Hence,

A n = 0 = ( A B i ) ( 1 + i ) n + B i A_{n} = 0 = (A - \dfrac{B}{i} ) (1 + i)^n + \dfrac{B}{i}

Solving for B B , we obtain,

B = A i ( 1 + i ) n ( 1 + i ) n 1 \large B = A \dfrac{i (1 + i)^n}{ (1 + i)^n - 1 }

Pluggin in the given values of A = $ 500 A = \$500 and i = 20 % = 0.2 i = 20\% = 0.2 and n = 6 n = 6 , we obtain,

B = 500 ( 0.2 ) ( 1.2 ) 6 ( 1.2 ) 6 1 = $ 150.35 \large B = 500 \dfrac{ (0.2)(1.2)^6 }{ (1.2)^6 - 1 } = \$150.35

@Hosam Hajjir , this should be a Quantitative Finance problem. I have amended the catagory.

Chew-Seong Cheong - 3 years, 4 months ago

0 pending reports

×

Problem Loading...

Note Loading...

Set Loading...