Question

In: Finance

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 exactly 0.

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

Solutions

Expert Solution

Part A) We are given the following information:

PMT 3418.16
no. of payments n 33
frequency 12
PV $   1,00,000.00

We need to solve the following equation to arrive at the required rate:

where r is the nominal annual rate.

Following is the amortization schedule and graph

  • Opening balance = previous year's closing balance
  • Closing balance = Opening balance+Loan-Principal repayment
  • Interest = 0.0869992273219028/12 x opening balance
  • Principal repayment = PMT - Interest

Part B) We need to solve the following equation to find the interest rate which will lead to loan amount remaining as $32254.82 at the end of 2 years or after 12 x 2 = 24 monthly payments

where r is the nominal annual rate.

Following is the schedule:.


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 $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...
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. 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