Question

In: Finance

4)Mario Morales borrowed $ 15,000 at an interest rate of 14% to be paid in 3...

4)Mario Morales borrowed $ 15,000 at an interest rate of 14% to be paid in 3 years. The loan must be repaid in three equal payments at the end of each year.

a)Calculate the annual payment to be made.

b)Prepare an amortization table that shows the principal and interest payment, as well as the loan balance for each year.

c)Explain why the interest portion of each payment decreases over time.

Solutions

Expert Solution

(a)-Annual end of year loan payment

Loan Amount (P) = $15,000

Annual Interest Rate (r) = 14% per year

Loan Period = 3 Years

Annual Loan Payment = [P x {r (1+r) n}] / (1 + r) n – 1

= [$15,000 x {0.14 x (1 + 0.14)3}] / (1 + 0.14)3 - 1

= [$15,000 x {0.14 x 1.48154}] / [1.48154 – 1]

= [$15,000 0.207416] / 0.48154

= $6,460.97 per year

“Annual end of year loan payment = $6,460.97 per year”

(b)-Loan Amortization Schedule

Months

Beginning Loan Amount ($)

Annual Payments ($)

Interest Paid at 14% ($)

Principal Paid ($)

Principal balance remaining ($)

1

15,000.00

6,460.97

2,100.00

4,360.97

10,639.03

2

10,639.03

6,460.97

1,489.46

4,971.51

5,667.52

3

5,667.52

6,460.97

793.45

5,667.52

0.00

(c)- Decline in the interest portion of loan over time

YES. The interest portion of the loan will decrease over time, since the more payments will be made over the life of the loan towards the principal portion. It will result in the reduction of the interest portion of the loan.


Related Solutions

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.
Jennifer borrowed $ 7111 at a 7.00% interest rate. I paid $ 2,063 small interest for...
Jennifer borrowed $ 7111 at a 7.00% interest rate. I paid $ 2,063 small interest for this loan. How long (period) is her loan?
An auto repair shop borrowed $15,000 to be repaid by quarterly payments over 4 years. Interest...
An auto repair shop borrowed $15,000 to be repaid by quarterly payments over 4 years. Interest on the loan is 3% compounded quarterly. (a) What is the size of the periodic payment? (b) What is the outstanding principal after payment 10? (c) What is the interest paid on payment 11? (d) How much principal is repaid in payment 11? Could you please show full steps as i want to use this as a learning tool.
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...
Recently you borrowed money for a new car. The loan amount is $15,000 to be paid...
Recently you borrowed money for a new car. The loan amount is $15,000 to be paid back in equal annual payments which begin today, and will continue to be payable at the beginning of each year for a total of five years. Interest on the loan is 8%. What is the amount of the loan payment? a $4,193.34 b $4528.81 c $3,478.31 d $4,891.12
4. An economist would recommend that the Bank of Canada change the interest rate for borrowed...
4. An economist would recommend that the Bank of Canada change the interest rate for borrowed money if the average annual inflation rate is less than 2.15%. Based on a sample from the past 21 years, the average annual inflation rate was 1.87%, with a standard deviation of 0.67%. Assume the population is approximately normally distributed. (a) [1 mark] Define the parameter you are testing. (b) [1 mark] State the null hypothesis and alternative hypothesis you would use to test...
The treasurer of a small bank has borrowed funds for 3 months at an interest rate...
The treasurer of a small bank has borrowed funds for 3 months at an interest rate of 6.73% and has lent funds for 6 months at 7.87%. a. Represent the exposure on cash flow diagrams. b. To cover his exposure created by the mismatch of maturities, the dealer signs a forward loan. Calculate this treasurer’s break - even forward rate on interest, assuming no other costs. c. Assume that instead, the treasurer decides to wait 3 months and take a...
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...
Matt and Lindsay borrowed $220,000 at 4% interest using a fixed rate mortgage with a maturity...
Matt and Lindsay borrowed $220,000 at 4% interest using a fixed rate mortgage with a maturity of 20 years.  Answer the following questions about their loan. What is the monthly payment necessary to amortize this loan? If the loan required annual payments instead of monthly, what would the annual payment be? Multiply the answer in part (a) by 12.  Why does this amount not equal the answer in part b?
  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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT