Question

In: Finance

Jane wishes to buy a house for 150,000 and arrange for the maximum possible conventional loan...

Jane wishes to buy a house for 150,000 and arrange for the maximum possible conventional loan (hint: what is the LVR?). The lending value assessed by the lender is the same as the purchase price. Jane wants the loan to be amortized over 25 years with monthly payments. Mortgage contract rate j2=4.56% and Bank of Canada 5-year posted fixed rate j2 =8%. Property taxes for the house are 1200/year and heating costs are estimated 60/month. Jane and her husband make a combined income of 60,000 a year. For the couple, they have to make a car loan payment of 350/month and credit card loan payment of 250/month.

(a) For qualification purpose, what mortgage rate to use? Why?

(b) What are the GDS and TDS ratios for the couple?

(c) Based on (a), will the couple qualify for the mortgage?

(d) What is the maximum size of the loan they qualify for using GDS? and using TDS?

(e) Suppose they’ve saved 60,000 for down payment, what is their affordable house purchase price using GDS? and using TD

Solutions

Expert Solution

(a) For qualification purpose, what mortgage rate to use? Why?

For the qualification purpose, the bank uses "Benchmark Qualifying Rate" which is the posted 5-year fixed rate, published by the Bank of Canada. In this question, for qualification purpose, the mortgage rate to use = Bank of Canada 5-year posted fixed rate = 8%

(b) What are the GDS and TDS ratios for the couple?

For debt service ratios, we will have to first estimate the house mortgage servicing amount at the qualifying rate.

For the purpose of debt ratios calculations,

Assessed value = Purchase price = $ 150,000

Maximum LVR under conventional mortgage = 80%

Hence, loan amount = 80% x $ 150,000 = $ 120,000

Frequency = monthly

Interest rate per annum = Qualifying rate = 8%

Interest rate per period = interest rate per month = 8%/12 = 0.667%

Period of loan = nos. of month in 25 years = 12 x 25 = 300

Hence, monthly house mortgage payment required: We will calculate this using the PMT function of excel. Inputs for PMT function are : PMT(Rate, Period, PV) = PMT(0.667%, 300, -120000) = $926.18

GDS ratio = the percentage of income needed to pay monthly housing costs (this includes principal, interest, taxes, and heat)

Combined annual income =  $ 60,000

Hence, combined monthly income = 60,000 / 12 = $ 5,000

Property tax = 1,200 / year = 1,200 / 12 = $ 100 / month

Heat expenses = $ 60 / month

Hence, total expenses towards monthly housing cost = monthly house mortgage expense + property tax + heat = 926.18 + 100 + 60 = $1,086.18

GDS ratio = the percentage of income needed to pay monthly housing costs (this includes principal, interest, taxes, and heat) = 1,086.18 / combined monthly income = 1,086.18 / 5,000 = 21.72%

TDS ratio = percentage of income needed to cover all debts = (Monthly payment towards house + Credit card + car loan) / combined monthly income = (1,086.18 + 250 + 350) / 5,000 = 33.72%

(c) Based on (a), will the couple qualify for the mortgage?

Standard criteria for qualification:

GDS < 35% and TDS < 42%

Since both the criteria are met, the couple do qualify for the loan upto 80% of assessed value.

(d) What is the maximum size of the loan they qualify for using GDS? and using TDS?

Maximum housing expenses per month permissible under GDS of 35% = Monthly income x 35% = 5,000 x 35% =  1,750.00

Maximum house mortgage amount per month permissible = 1,750 - property tax - heat expenses= 1,750 - 100 - 60 = $ 1,590

Maximum size of loan they qualify for using GDS = PV of an annuity of $ 1,590 = PV(rate, period, payment) = PV(0.667%, 300, 1590) = $ 206,008

Using TDS, maximum debt expense permissible = 42% x monthly income = 42% x 5,000 = $ 2,100

Maximum house mortgage payment per month permissible = $ 2,100 - property tax of 100 - heat expense of 60 - credit card loan of 250 - car loan of 350 = $ 1,340

Maximum size of loan they qualify for using TDS = PV of an annuity of $ 1,340 = PV(rate, period, payment) = PV(0.667%, 300, 1340) = $  173,616

(e) Suppose they’ve saved 60,000 for down payment, what is their affordable house purchase price using GDS? and using TDS

Using GDS, maximum loan permissible = $ 206,008

Down payment = $ 60,000

Affordable house price= down payment + loan permissible = 60,000 + 206,008 = $ 266,008

Using TDS, maximum loan permissible = $ 173,616

Down payment = $ 60,000

Affordable house price= down payment + loan permissible = 60,000 + 173,616 = $  233,616


Related Solutions

(Loan amortization​) To buy a new​ house, you must borrow $150,000. To do​ this, you take...
(Loan amortization​) To buy a new​ house, you must borrow $150,000. To do​ this, you take out a $150,000​, 20​-year, percent mortgage. Your mortgage​ payments, which are made at the end of each year​ (one payment each​ year), include both principal and 9 percent interest on the declining balance. How large will your annual payments​ be? The amount of your annual payments will be ​$ ​(Round to the nearest​ cent.)
Jane plans to buy a house in 10 years. The house she dreams about costs about...
Jane plans to buy a house in 10 years. The house she dreams about costs about $150,000 today. The cost of houses increases at 2.5% per year. Jane will accumulate $100793.72 from her investment of 75,000 in 10 years. In addition, Jane needs to borrow $91218.96 additional money to purchase her house in 10 years. a) Prepare an amortization table to pay off Jane’s mortgage, if she can borrow at an annual rate of 6.5% to pay off the mortgage...
Jane plans to buy a house in 10 years. The house she dreams about costs about...
Jane plans to buy a house in 10 years. The house she dreams about costs about $150,000 today. The cost of houses increases at 2.5% per year. Jane will accumulate $100793.72 from her investment of 75,000 in 10 years. In addition, Jane needs to borrow $91218.96 additional money to purchase her house in 10 years. a) Prepare an amortization table to pay off Jane’s mortgage, if she can borrow at an annual rate of 6.5% to pay off the mortgage...
If you a buy a house for $150,000, live in it for more than two years,...
If you a buy a house for $150,000, live in it for more than two years, and sell it for $350,000 you pay NO TAX on this $200,000 realized gain. By contrast, if you invest $150,000 in a stock and sell the stock for $350,00 after more than one year, you must pay long term capital gains taxes of 15% on the $200,000 realized net long term capital gain. Why is this different treatment, which favors real estate over stock...
oy decides to buy a personal residence and goes to the bank for a $150,000 loan....
oy decides to buy a personal residence and goes to the bank for a $150,000 loan. The bank tells him that he can borrow the funds at 4% if his father will guarantee the debt. Roy's father, Hal, owns a $150,000 CD currently yielding 3.5%. The Federal rate is 3%. Hal agrees to either of the following: Roy borrows from the bank with Hal's guarantee to the bank. Cash in the CD (with no penalty), and lend Roy the funds...
a) Kenny wishes to buy a house for $3,500,000 in 10 years and decides to deposit...
a) Kenny wishes to buy a house for $3,500,000 in 10 years and decides to deposit a fixed amount in an investment account at the end of each year of the coming 10 years. Assume that his investment account earns an average yearly return of 16% over the next 10 years. How much should he deposit every year so that he will have enough money in his investment account to purchase the house at the end of 10 years? b)...
The Johnsons will buy a house for $348,000.00. They will get a 30 year loan for...
The Johnsons will buy a house for $348,000.00. They will get a 30 year loan for 4.63% annual interest rate compounded monthly. Calculate the payment needed for this loan and put your answer in F6. Then fill out the amortization schedule for the first year. After the table is done find the total interest paid in the first year and the total paid to principle for the first year. ON EXCELL!!
Youu want to buy a house that costs $150,000. You have $15,000 for a down payment,...
Youu want to buy a house that costs $150,000. You have $15,000 for a down payment, but your credit is such that mortgage companies will not lend you the required $135,000. However, the realtor persuades the seller to take a $135,000 mortgage (called a seller take-back mortgage) at a rate of 9%, provided the loan is paid off in full in 3 years. You expect to inherit $150,000 in 3 years; but right now all you have is $15,000, and...
Tom wishes to buy another boat in five years that presently costs $150,000. He expects the...
Tom wishes to buy another boat in five years that presently costs $150,000. He expects the cost of the boat to increase due to inflation by 3% per year for the next two years and 5% per year the following three years. He also wants to spend $75,000 per year for 6 years beginning at the end of 12 years from today. How much must he save each year for the next 5 years if he can earn 6% on...
You decide to buy a house for a total of $305,469. To get amortgage loan,...
You decide to buy a house for a total of $305,469. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 4% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage?Enter your answer in dollars, rounded to the nearest cent (2 decimals).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT