In: Accounting
Daniel Richards and his wife Amy have just moved to Canada from Australia and want to buy a house that costs $1 million. They have a down payment of $200,000 plus enough to pay the other costs like legal fees and moving cost. They go to Canada’s newest bank, the Bank of Northern Ontario (BNO) to get a mortgage. They negotiated a fixed rate of 3.0% p.a. with a 25-year amortization and a 5-year term - but then the loan officer tells them they will have to make sure they can qualify for the mortgage under the new rules just brought in by the Prince of Northern Ontario, which has just declared independence from Canada. The new rule is to prevent borrowers getting in too deep: they must meet a standard of GDS of 30% and TDS of 35% and qualify at a mortgage rate that is two percentage points higher than they are actually paying. Daniel and Amy go back to Yingqi Zhang the real estate agent to get some more numbers. The estimated utilities expense (electricity, water, waste management) is $300 per month and gas for heating is approximately $125 per month. The property tax for the next year is $350 per month. The house is in good shape and Yingqi estimates they would need no more than $300 over the next year for maintenance. Amy’s new job in Canada will pay her $160,000 p.a. as a consulting neurologist, while Daniel will be working as a teacher for $60,000 p.a. They are still repaying Amy’s students loans from her degree in the UK at a rate of $300 per month. They had to buy a car when they came to Canada and the car loan payments are $400 per month.
Q1: Calculate the monthly mortgage payment they need to be approved of to purchase the home
Q2: Calculate GDS ratio:
Q3: Calculate TDS ratio:
Q4: Will BNO approve the mortgage? Explain your answer
Please show your steps.
1..They need mortagage loan whose Present value is 1000000-200000= $ 800000 |
We can use the PV of annuity formula, to find the monthly payment towards this loan, as follows: |
PV of loan=Pmt.*(1-(1+r)^-n)/r |
where, |
PV of loan= $ 800000 |
Pmt.= the monthly pmt.---to be found out--?? |
r= rate of interest, ie. 3% +2%=5% p.a. ie. 0.4167% or 0.004167 |
n= 25 yrs.*12 mths= 300 |
Plugging in the values, in the formula, |
800000=Pmt.*(1-(1+0.004167)^-300)/0.004167 |
Pmt.=800000/((1-(1+0.004167)^-300)/0.004167) |
4677 |
So, the Answer to Ques-1 will be |
The monthly mortgage payment they need, to be approved of to purchase the home= |
$4,677 |
2& 3 | For GDS | For TDS |
Utilities expense (electricity, water, waste management) | 300 | 300 |
Gas for heating | 125 | 125 |
Property tax | 350 | 350 |
House maintenance | 300 | 300 |
Student loans | 300 | |
Car loan | 400 | |
Mortgage pmt. As calculated in 1. | 4677 | 4677 |
Housing -related costs | 5752 | |
Total debt costs | 6452 | |
Gross monthly Income | ||
(160000+60000)/12= | 18333 | 18333 |
GDS ratio= | ||
Housing -related costs/Gross monthly income | 5752/18333= | |
(ANSWER-2) | 31.38% | |
TDS Ratio= | ||
Total debt commitments/Gross monthly income | 6452/18333= | |
(ANSWER-3) | 35.19% |
Answer-4 |
As, the new rule expects borrowers to meet a standard of GDS of 30% and TDS of 35% |
Daniel Richards and his wife Amy |
have both their ratios above the BNO-approved threshold |
ie. GDS ratio 31.38% > 30% & |
TDS ratio 35.19% > 35% |
SO, BNO WILL NOT approve the mortgage |