Question

I. A family buys a house worth $326,000. They pay $75,000 deposit and take a mortgage for the balance at J12=9% p.a. to be amortized over 30 years with monthly payments.

A.     Find the value of the mortgage on their house? (1 mark)

B.     Find the value of the monthly payment?

C.     Find the loan outstanding after making 20 payments?

D.    Find the principal repaid in the 21^st payment?

II. Fill out the loan amortization schedule provided in the solution template for the first 5 loan payments. What do you notice about the composition of the payment amount?

III. Suppose that after making 50 payments, the interest rate changes to J2=9% p.a.:

A.     Convert the interest rate J2=9% to J12 equivalent (2 marks

B.     Assuming that the family seeks to accept the change in interest rates, what would be their new payment based on the new interest rate?

C.     Assuming that the family seeks to continue their initial monthly payment calculated in part I, how many full payments would be required to pay off the loan and what would be the final concluding smaller payment one period later?

Answer 1

I can only answer 1 question at a time, so I am solving question 1 only.
Please do rate me and mention doubts, if any, in the comments section.