Question

You are looking to purchase your first home and have picked one out. The house costs $287,000.00, and you saved up 8% in cash and you will need to get a loan/mortgage for the remainder of the purchase price. You also need to get private mortgage insurance, which will cover 25% of your loan amount in the event of default. The PMI involves a 3.5% of loan premium due at closing, which will be added to the loan balance. The loan is an Adjustable Rate mortgage with a fixed interest rate for the first 5 years, and then the rate then changes one time every 2 years thereafter on the anniversary of the loan, with a maximum interest rate increase of up to 2% per change. The underlying index for the loan is Wall Street Journal Prime and the rate is the index plus ½%. The loan 30 years amortization and a 30-year term. Under these circumstances, answer the following questions.

1. Assume that the loan rate is 3.75% for the first 5 years. What is the mortgage payment due for first month. Use Excel to make it easier and the show your work.

2. What will be the loan’s principle balance after the first 5 years?

3. If you were to default on your loan after the ninth month payment, what is the net loss of the bank if the house sold for $265,000 a month later and had closing costs of 9% of the sales price? (remember to calculate the principle balance due, the sale proceeds net closing cost and any PMI proceeds). Use Excel to make it easier and the show your work.

Answer 1

	Purchase cost	2,87,000
	Loan amount	2,64,040
	Insurance	10,045
	Total loan	2,74,085
Answer 1	EMI amount (ie mortgage payment for first 12 months each)	-1,269
	By excel formula "=PMT(RATE,NPER,PV,0)"
	Rate is interest rate, NPER is number of instalments and NPER is loan amount)
Answer 2	Loan balance after first five months (Refer repayment schedule)	2,46,888
Answer 3	Loan balance outstanding after 9 instalments (A) (Refer repayment schedule)	2,70,323
	Sale price to bank (B)	2,65,000
	Cost of sale (C)	23,850
	Net proceeds from sale (D) = (A) - (B)	2,41,150
	Proceeds from insurance ( E)	67,581
	Total proceeds (F) = (D) + ( E)	3,08,731
	Profit to bank (G) = (F) - (A)	38,408
Unable to paste repayment schedule in the answer
				0