Question

In: Finance

A loan of $100,000 is made today. The borrower will make equal repayments of $898 per...

A loan of $100,000 is made today. The borrower will make equal repayments of $898 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places.

(a) The loan is fully repaid exactly after 180 monthly repayments, i.e., the loan outstanding immediately after 180 repayments is exactly 0.

(b) The term of the loan is unknown but it is known that the loan outstanding 2 years later equals to $86091.

please show working out. Thank you

Solutions

Expert Solution

a) Let the interest rate per month be i

898/(1+i)+ 898/(1+i)^2+...+898/(1+i)^180 = 100000

=> 898/i* (1-1/(1+i)^180) = 100000........................(1)

Using hit and trial method on the above equation

Putting i= 0.02 , the Left hand side of the equation becomes =43628.80

Putting i= 0.01 , the Left hand side of the equation becomes =74822.85

Putting i= 0.005 , the Left hand side of the equation becomes =106416.156

Putting i= 0.006 , the Left hand side of the equation becomes =98676.25

The actual value of i lies between 0.005 and 0.006

So, Using linear approximation method

i = 0.005+ (106416.156-100000)/(106416.156-98676.25)*(0.006-0.005) = 0.005829

Putting i= 0.005829 , the Left hand side of the equation becomes =99940.172

The actual value of i lies between 0.005 and 0.005829

So, Using linear approximation method

i = 0.005+ (106416.156-100000)/(106416.156-99940.172)*(0.005829-0.005) = 0.005821

Putting i= 0.005829 , the Left hand side of the equation becomes =99999.88

So, this is almost correct value of i

Annual Interest rate = i*12 = 0.06985 or 6.985% or 6.99% (rounded to two decimals)

b) Outstanding loan = Future value of loan - FV of 24 payments = 86091

=> 100000*(1+i)^24- 898/i*(1-1/(1+i)^24) = 86091.................(2)

Using hit and trial method on the above equation

Putting i= 0.01 , the Left hand side of the equation becomes =107896.9

Putting i= 0.005 , the Left hand side of the equation becomes =92454.52

Putting i= 0.003 , the Left hand side of the equation becomes =86689.56

Putting i= 0.0025 , the Left hand side of the equation becomes =85282.85

The actual value of i lies between 0.0025 and 0.003

So, Using linear approximation method

i = 0.0025+ (86091-85282.85)/(86689.56-85282.85)*(0.003-0.0025) = 0.002787

Putting i= 0.002787 , the Left hand side of the equation becomes =86088.64

The actual value of i lies between 0.002787 and 0.003

So, Using linear approximation method

i = 0.002787+ (86091-86088.64)/(86689.56-86088.64)*(0.003-0.002787) = 0.002788

Putting i= 0.00788 , the Left hand side of the equation becomes =86091.46

So, this is almost correct value of i

Annual Interest rate = i*12 = 0.033456 or 3.3456% or 3.35% (rounded to two decimals)


Related Solutions

A loan of $100,000 is made today. The borrower will make equal repayments of $918 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $918 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios (EXCEL HIGHLY REGARDED), calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places. (a) The loan is fully repaid exactly...
A loan of $100,000 is made today. The borrower will make equal repayments of $2791.92 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $2791.92 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate in percentage: (b) The term of the loan is unknown but it is known that the loan outstanding 2 years later equals...
A loan of $100,000 is made today. The borrower will make equal repayments of $975 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $975 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places. (a) The loan is fully repaid exactly after 180 monthly...
A loan of $100,000 is made today. The borrower will make equal repayments of $1357 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $1357 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate in percentage. Give your answer as a percentage to 2 decimal places. (b) The term of the loan is unknown but it...
A loan of $100,000 is made today. The borrower will make equal repayments of $3070.83 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $3070.83 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate in percentage: (b) The term of the loan is unknown but it is known that the loan outstanding 2 years later equals...
A loan of $100,000 is made today. The borrower will make equal repayments of $3418.16 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $3418.16 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios, calculate the interest rate being charged on this loan, expressed as a nominal annual rate in percentage: (a) The loan is fully repaid exactly after 33 monthly repayments, i.e., the loan outstanding immediately after 33 repayments is...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments,...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments, followed by a final smaller repayment, i.e., there are 11 repayments in total. The first of the level repayments will occur exactly 2 years from today, and each subsequent repayment (including the final smaller repayment) will occur exactly 1 year after the previous repayment. Explicitly, the final repayment will occur exactly 12 years from today. If the interest being charged on this loan is...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments,...
A loan of $100,000 is made today. This loan will be repaid by 10 level repayments, followed by a final smaller repayment, i.e., there are 11 repayments in total. The first of the level repayments will occur exactly 2 years from today, and each subsequent repayment (including the final smaller repayment) will occur exactly 1 year after the previous repayment. Explicitly, the final repayment will occur exactly 12 years from today. If the interest being charged on this loan is...
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment...
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment is due at the end of 2 years, the second repayment is due at the end of 6 years. The interest rate is at 4% p.a. compounded quarterly for the first 3 years and then 4.4% p.a. compounded quarterly thereafter. What is the size of each repayment? Select one: a. $58,762.97 b. $58,222.14 c. $57,989.46 d. $56,779.19
$100,000 loan is made monthly interest-only repayments for 12 years, with the first repayment occurring one...
$100,000 loan is made monthly interest-only repayments for 12 years, with the first repayment occurring one month from today. Then the level annual repayments of $9,456 are made for as long as needed to pay off the remaining balance of the loan, where the first annual repayment is made at the end of year 13. The Annual repayment is made at the end of year 13. The annual effective interest rate is 9.2%. Calculate the total number of repayments to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT