Question

Cathy Cortez-Ochoa borrowed $4,000 from her uncle who amortized the loan at 4.5% over 3 months....

Cathy Cortez-Ochoa borrowed $4,000 from her uncle who amortized the loan at 4.5% over 3 months. Use the table below: the first two monthly payments are $1,343.35 each. (The last payment may be slightly different). Complete the amortization schedule and solve the effective rate problem.

Amortization Payment Factors per $1,000 Borrowed

Amount of Monthly Payment per $1,000 Borrowed

Term of Loan

Annual Interest Rate

4.5%

6%

7.5%

9%

10.5%

12%

1

month

1003.75000

1005.00000

1006.25000

1007.50000

1008.75000

1010.00000

2

months

502.81425

503.75312

504.69237

505.63200

506.57203

507.51244

3

months

335.83645

336.67221

337.50865

338.34579

339.18361

340.02211

4

months

252.34814

253.13279

253.91842

254.70501

255.49257

256.28109

5

months

202.25561

203.00997

203.76558

204.52242

205.28049

206.03980

6

months

168.86099

169.59546

170.33143

171.06891

171.80789

172.54837

1

year

85.37852

86.06643

86.75742

87.45148

88.14860

88.84879

2

years

43.64781

44.32061

44.99959

45.68474

46.37604

47.07347

3

years

29.74692

30.42194

31.10622

31.79973

32.50244

33.21431

4

years

22.80349

23.48503

24.17890

24.88504

25.60338

26.33384

5

years

18.64302

19.33280

20.03795

20.75836

21.49390

22.24445

10

years

10.36384

11.10205

11.87018

12.66758

13.49350

14.34709

15

years

7.64993

8.43857

9.27012

10.14267

11.05399

12.00168

20

years

6.32649

7.16431

8.05593

8.99726

9.98380

11.01086

25

years

5.55832

6.44301

7.38991

8.39196

9.44182

10.53224

30

years

5.06685

5.99551

6.99215

8.04623

9.14739

10.28613

Month

Unpaid Balance

Interest Payment

Total Payment

Principal Payment

New Balance

a.

1

b.

2

c.

3

d.

Use the amortization schedule to compute the effective annual interest rate where P is the average principal over the 3-months and I is the total interest charged.

Principal

Interest

Rate

Homework Answers

Answer #1

Yearly interest rate = 4.5%

Monthly interest rate = 4.5/12

= 0.375%

Monthly installment = 4000/PVIFA(0.375%,3)

=4000/2.97764

= 1343.35

Amortization table of the loan will be as follows -

Unpaid balance Interest payment (Unpaid bal.*monthly int. rate) Total Payment Principal Payment (Total payment - Int. amt) New balance
1 4000.00 15.00 1343.35 1328.35 2671.65
2 2671.65 10.02 1343.35 1333.33 1338.32
3 1338.32 5.02 1343.34 1338.32 0.00

(d) Effective annual interet rate = (1+nominal monthly interest rate)^12 - 1

nominal monthly interest rate = 4.5/12 = 0.375%

so Effective monthly interest rate = (1+0.00375)^12 - 1

= (1.00375)^12 - 1

= 1.04594 - 1

= 0.04594 or 4.594%

Effective yearly interest rate = 4.594%

Please check with your answer and let me know.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
?Joan Messineo borrowed $16,000at a15%annual rate of interest to be repaid over 3 years. The loan...
?Joan Messineo borrowed $16,000at a15%annual rate of interest to be repaid over 3 years. The loan is amortized into three? equal, annual,? end-of-year paymen 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. ?Show calculations
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49,000 at a 3% annual rate of...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49,000 at a 3% 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,...
Paulo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years....
Paulo 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. 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.
Loan amortization schedule  Personal Finance Problem Joan Messineo borrowed 41,000 at a 4​% annual rate of...
Loan amortization schedule  Personal Finance Problem Joan Messineo borrowed 41,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.
You borrow ​$300,000 to buy a house over a 15​-year term. The loan is structured as...
You borrow ​$300,000 to buy a house over a 15​-year term. The loan is structured as an amortized loan with annual payments and an interest rate of 10​%. Find the information for the amortization schedule for years 1 and 2. Payment​ ($) Interest in Payment​ ($) Principal Repaid​ ($) Principal Owing at End of Year​ ($)
Find the amortization table for a $8,000 loan amortized over 3 years with semiannual payments if...
Find the amortization table for a $8,000 loan amortized over 3 years with semiannual payments if the interest rate is 8.3% per year compounded semiannually. (Round your answers to the nearest cent.) End of Period Payment Made Payment Toward Interest Payment Toward Principal Outstanding Principle 0 8000 1 2 3 4 5 6
Find the amortization table for a $23,000 loan amortized over 3 years with semiannual payments if...
Find the amortization table for a $23,000 loan amortized over 3 years with semiannual payments if the interest rate is 6.1% per year compounded semiannually. (Round your answers to the nearest cent.) End of Period Payment Made Payment Toward Interest Payment Toward Principal Outstanding Principle 0 23000 1 2 3 4 5 6
Janet wanted to buy a car so she borrowed a $10,000 from HSBC Bank at a...
Janet wanted to buy a car so she borrowed a $10,000 from HSBC Bank at a 10% annual rate of interest to be repaid quarterly over 2 years. The loan is amortized into eight equal quarterly payments. a. Calculate the quarterly loan payment (A). b. Prepare the loan amortization schedule.
On 1st January 2020, a loan was issued and it was amortized over 20 years with...
On 1st January 2020, a loan was issued and it was amortized over 20 years with monthly payments at a nominal interest rate of 8.4% compounded monthly. The first payment was paid on 1st February 2020. The loan is structured in such a way that the first 120 installments will be paid in equal installments of N$6000 and the next 120 installments will be paid in such a way that each succeeding monthly payment will be 3% lower than the...
You take out a 20-year loan in the amount of $450,000 at a 4 percent annual...
You take out a 20-year loan in the amount of $450,000 at a 4 percent annual rate. The loan is to be paid off by equal monthly installments over 20 years. Draw an amortization table showing the beginning balance, total payment, principal repayment, interest payment and ending balance for each month. How much is the total interest payment for the first four months? (show only four months on the table).
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT