Question

In: Finance

Joan Messineo borrowed $10,000 at a 17% annual rate of interest to be repaid over 3...

Joan Messineo borrowed $10,000 at a 17% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments.

a. Calculate the annual, end-of-year loan payment

b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments.

c. Explain why the interest portion of each payment declines with the passage of time.

Solutions

Expert Solution

If the loan amount is P, rate on interest (monthly is r, and loan term is n the EMI will be

EMI = P*r[(1 +r)^n]/ [(1+ r)^n- 1]

Where,

              Loan amount (P) = $10000

                Time (n) = 3

               Interest rate [r] = 17% /period

Let's put all the values in the formula to calculate EMI

EMI = 10000*0.17[(1 +0.17)^3]/ [(1+ 0.17)^3- 1]

        = 1700[(1.17)^3]/ [(1.17)^3- 1]

        = 1700[1.601613]/ [1.601613- 1]

        = 1700[1.601613]/ [0.601613]

        = 1700[2.6621981240432]

        = 4525.74

So EMI will be $4525.74

--------------------------------------------------------------------------------------------------------------------------

EMI

Loan balance

EMI

Interest (Loan balance* interest rate)

Principle (EMI - Interest)

Loan balance (Loan - principle)

1

10000

4525.74

1700.00

2825.74

7174.26

2

7174.26

4525.74

1219.62

3306.12

3868.14

3

3868.14

4525.74

657.58

3868.16

0.0

--------------------------------------------------------------------------------------------------------------------------

Interest in dependent on Loan balance, and each EMI has some portion of principle, so principle is reducing after every EMI, so interest expense is also decreasing.

--------------------------------------------------------------------------------------------------------------------------

Feel free to comment if you need further assistance J

Pls rate this answer if you found it useful.


Related Solutions

  Joan Messineo borrowed 42,000 at a 5​% annual rate of interest to be repaid over 3...
  Joan Messineo borrowed 42,000 at a 5​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3...
Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. (i) Calculate the annual, end-of-year loan payment. (ii) Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. (iii) Explain why the interest portion of each payment declines with the passage of time.
Joan Messineo borrowed ?$19,000 at a 9?% annual rate of interest to be repaid over 3...
Joan Messineo borrowed ?$19,000 at a 9?% annual rate of interest to be repaid over 3 years. The loan is amortized into three? equal, annual,? end-of-year payments. a.Calculate the? annual, end-of-year loan payment. b.Prepare a loan amortization schedule showing the interest and principal breadown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
Loan amortization schedule    Joan Messineo borrowed ​$40,000 at a 4​% annual rate of interest to be...
Loan amortization schedule    Joan Messineo borrowed ​$40,000 at a 4​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments a. Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of the​ equal, annual,​ end-of-year loan...
You have borrowed $33,000 to be repaid with five equal annual installments. The interest rate is...
You have borrowed $33,000 to be repaid with five equal annual installments. The interest rate is 9% per year. What is the annual payment? What is the total interest payment for year 4 of the loan? What is the total interest payment over the life of the loan?
Joan borrowed ​$17 comma 000.00 to buy a car. She repaid ​$4100.00 four months later and...
Joan borrowed ​$17 comma 000.00 to buy a car. She repaid ​$4100.00 four months later and ​$7900.00 six months later. After twelve​ months, she borrowed an additional ​$6200.00​, and repaid ​$5100.00 after 20 months. She paid the entire​ balance, including the​ interest, after 24 months. Interest was 9​% compounded monthly for the first year and 9.6​% compounded monthly for the remaining time. What was the size of the final​ payment?
Assume Sam borrowed $120,000 for a home mortgage, to be repaid at 8% interest over 3...
Assume Sam borrowed $120,000 for a home mortgage, to be repaid at 8% interest over 3 years with monthly payments. How many monthly payments does Sam has to pay for 3 year? How much is the monthly payment? How much is the interest payment for the third month? How much interest is paid over the life of the loan? Hint: Annual percentage rate (APR) = ?? Monthly discount rate (rate) = ?? Number of payment (Nper) = ?? Monthly payment...
Bob borrowed $10,000 at an effective annual rate of interest of 7%. Bob’s plan was to...
Bob borrowed $10,000 at an effective annual rate of interest of 7%. Bob’s plan was to repay the loan with equal principal repayments plus interest at the end of each year for 20 years. After the 10th payment, Bob decides to change his payment scheme and pay the outstanding balance with equal annual payments. The loan will still be repaid in 20 years. Calculate the difference between the 10th and 11th payment. Less than 174 At least 174, but less...
You borrowed $45,000 at 4% annual interest rate that you must repay over 3 years. The...
You borrowed $45,000 at 4% annual interest rate that you must repay over 3 years. The loan is amortized into three-equal end-of-year payments.         (a) Calculate annual payment amount         (b) Prepare a loan amortization schedule         (c) If you make equal monthly payment for 36 months, calculate monthly payment amount and prepare a monthly loan amortization schedule        (d) How much is total interest charge for 3 years, if you make annual payment? How much is total interest charge...
$5000 is borrowed, to be repaid in three equal, annual payments with 10% interest. Approximately how...
$5000 is borrowed, to be repaid in three equal, annual payments with 10% interest. Approximately how much principal is amortized with the second payment? $2,010.57 $1,510.57 $900.68 $1,661.63 include calculations please
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT