ACTIVITY: TIME VALUE MONEY MORTGAGE #4

BACKGROUND

Jay and Lynn are considering whether or not to buy a particular property valued at $850,000. They have $250,000 of their own funds to commit towards the purchase and they expect to incur an additional $40,000 in fees and stamp duty on the purchase itself. They are able to borrow at an interest rate of 5.4% per annum with interest compounded monthly.

Loan repayments would be monthly with the first payment due at the end of the first month after purchasing the property. The term of the home loan is 20 years. They both work full-time earning a combined after-tax salary of $13,000 per month

Question 1: How much is the monthly mortgage payment Jay and Lynn will be required to pay for their loan?

You may use Formula 3 in the time value money spreadsheet provided with the course material.

Hint: because the interest is compounded monthly, we need to use the number of months for the mortgage loan, not the number of years, when determining the regular payments to be made.We also need to use the monthly interest rate (5.4% /12 = 0.45%)if we use the spreadsheet formula.

If you prefer to use an online mortgage calculator, be careful here as they may have slight differences. This one would suit this exercise:

http://www.nab.com.au/personal/loans/home-loans/loan-calculators/loan-repayments-calculator

Provide your answer here$

Question 2:Will Jay and Lynn face mortgage stress at current interest rates?

A loan affordability ratio is equal to the monthly home loan repayment divided by a couple's household

after-tax monthly income. A key threshold for 'mortgage stress' is when the loan affordability ratio reaches 35%.

Provide your answer here

Loan affordability ratio is : %(2 decimal places)

Complete question from the below three options - Jay and Lynn

A) will

B) will not

C) experience mortgage stress.

Question 3: After 1 year, the bank informs Jay and Lynn that $621714.92is still owing on their loan. How much in totalhave Jay and Lynn paid in mortgage payments during the first year?

Provide your answer here$

Question 4: How much of the amount repaid in the first year has gone towards reducing the principal amount borrowed?

Provide your answer here$

Question 5: How much interest have Jay and Lynn paid in year 1?

Provide your answer here$

Question 6:If the bank now increases interest rates from 5.4% to 6.6%, what will Jay and Lynn's new monthly mortgage repayments be?

Hint: remember to use monthly interest rates. And, remember that there are only 19 years left on the loan (usemonths not years).

Provide your answer here$

Question 7: How will this new monthly mortgage repayment affect their loan affordability ratio?That is, will they befacing mortgage stress?

Provide your answer here

Loan affordability ratio is: % (2 decimal places)

Choose from the below three options to complete question

Jay and Lynn......

A) will

B) will not

C)experience mortgage stress.

TIP: Before you submit, check over your answers to see if they look logical and check your arithmetic.

Please answer all parts of the question.