Question

Mortgage ProblemConsider a 20-year mortgage for $350,000 is taken out in Jan. 2019 at a 5.40% annual interest rate.

a.What is the Payment Amount for this mortgage? (2)

b.What total amount will be paid by the borrower over the 20-year payback period? (2)

c.What is the Interest / Principle breakdown for payment #5? (2)

d.If a $250 per month prepay is made starting with payment #1 and continuing to the end of the payment period, how much interest is saved? (3)

e.After 18 payments, what is the outstanding loan balance? (2)(Note: This question can be determined computationally by hand using the same method to determine the answer to the previous question. The “AMORT” key on a financial calculator can also be used, as well as the CUMPRINC function in Excel. For details, see the instructor.)

f.If a $30,000 lump sum prepay is made after payment #18, what is the new terminal month of the mortgage in this case? (3)

g.How much total interest will be saved over the life of the mortgage with the lump-sum prepay? (3)

h.Determine the new payment amount if the mortgage is refinanced at 3.60%, after 18 payments were made according to the original terms of the mortgage. (2)

i.What is the new terminal date if the mortgage is refinanced in this case? (2)

j.How much is saved in total interest with the refinancing? (3)

Answer 1

As per rules I am answering the first 4 subparts of the question

a	Payment amount	$2,387.88
b	Total payment in 20 years	$573,091.34
c	Opening balance for payment 5	$346,726.46
	Interest payment in payment 5	$1,560.27
	Principal	$827.61
d	Newamount with prepayment	$2,637.88
	Total period of payment	202.45261
	Total payment	$534,045.81
	Interest saved	$39,045.53

Workings