Purchasing and Financing a House I. Finding the House (1)

1. You will need to find a home located in the City of Edmonton. Once you have found your home, you MUST submit, along with this assignment, a sheet detailing the important information about your home (square feet, number of bedrooms, etc.).

NOTE: Condominiums, townhouses, duplexes, and homes not located in the City of Edmonton are not acceptable for this case.

Now that you have found your home, please indicate the list price in the box below.

II. Down Payment and Mortgage Amount (2)

Assuming that you will be paying the list price for the house, what is the minimum down payment, in dollars, that you will have to put down? Assume that you will make a minimum down payment of 5%. Show your calculations. (1 mark)

Once you make your down payment, the remaining amount is yourmortgage amount. What is your mortgage amount? Show your calculations. (1 mark)

2

III. 4.

CMHC Premium (2)

IV. 5.

Mortgage Rate (1)

V. 6.

Financial Institution Mortgage Rate (5-year fixed)

Since your down payment is less than 20%, you will incur a CMHC premium. Based on your answer for Question 3, calculate your CMHC premium. Once you calculate your premium, you will need to recalculate your mortgage amount. What will be your new mortgage amount? Use the current CMHC premium figures found on the CMHC website at http://www.cmhc- schl.gc.ca/en/co/moloin/moloin_005.cfm. (2 marks)

In order to complete the following chart, you will need to go out and research current mortgage rates for a five (5) year fixed rate mortgage term. The mortgage rates you select must be from a major bank and/or credit union not a mortgage company. Once you have found your two rates, you must submit a paper or digital copy of the resource you relied on for your information and submit it as part of your assignment. (1 mark)

Prepayment Privileges (2) Describe the prepayment privileges offered by EACH financial institution listed

in question 5. (2 marks) 3

VI. Calculating Your Monthly Mortgage Payment (3)

7. Based on your answers for questions 5 and 6, select which financial institutions mortgage rate (I/Y) you will use to complete the table below. You will also need your mortgage amount from question 4 to complete the followingtable. (3 marks)

Calculator 15 year amortization 20 year amortization 25 year amortization P/Y = 12 12 12 C/Y = 2 2 2 N= I/Y = PV = PMT = FV= 0 0 0 Analysis of what

happened over the

first five (5) years

VII. Payment Frequencies (5)

P1 = P1 = P1 =

P2 = P2 = P2 = BAL Outstanding = BAL Outstanding = BAL Outstanding =

Total PRN = Total PRN = Total PRN = Total INT = Total INT = Total INT =

8. Select a mortgage payment (PMT) from question 6 (i.e. the one you think you would be comfortable in making if you were truly financing this home), and complete the following chart by calculating the new mortgage payment and the newamortization if you change the payment frequency. Use the formulas in Exhibit 7.4 on page 213 of your text . (5 marks)

Semi- monthly

Accelerated bi- Weekly Accelerated

Mortgage Payment Frequency

Calculator

Bi-weekly

P/Y C/Y N I/Y PV PMT FV AMORT (t)

4

weekly

Weekly

VIII. Calculating Annual Property Tax (3)

Go to the City of Edmonton website and determine the City of Edmontons assessed value for your home for 2018 and write it in the space below. You must also print off the information you found on the website and submit it along with this assignment. (1)

Using your value from Question 9, use the City of Edmontons property tax estimator to determine your approximate annual and monthly property tax bill and write these numbers in the space below. You must also submit the information you found on the website by including it as part of your submission in drop box. (1)

11. Assuming you took possession of this home on October 1st, what will the property tax adjustment be (assume that the seller of the home pays their property taxes annually)? (1)

5

IX. Qualification (3)

NOTE: After completing the questions below, if you do not qualify for a mortgage based on a GDS of 32% and TDS of 40%, you MUST make the necessary adjustments to get under these numbers.

12. Using the monthly figures you have already determined (mortgage payment, property tax) calculate your gross debt service ratio? Assume that the average monthly cost of heating a home $250 and that your annual household income is $120,000 (2 marks)

13. Using the monthly figures you have already determined (mortgage payment, property tax) and the figures provided in Question 12, calculate your total debt service ratio? Assume that your monthly consumer debt is $500. (1 mark)

X. Closing Costs (3)

14. Based on the house you have decided to purchase and what you have read in chapter 7 and otherwise in the course, explain which closing costs you anticipate you will need to incur and why?

6

XI. Mortgage Structure (5)

15. If you were truly financing this home, how would you structure yourmortgage payment (i.e. term, amortization, payment frequency, fixed/variable, open/closed)? Explain and support why you would structure your mortgage this way.

Term:

Amortization:

Payment Frequency:

Fixed or Variable:

Closed or Open:

7

XII. Reflection (2) 16. After completing this assignment, what have you learned about purchasing and

financing a house? Marks will be awarded based on the clarity, logic, detail and relevance of your answer to the case you just completed (i.e. simply stating that buying a house is expensive will result in a minimal mark explain why you think it is expensive). NOTE: Take this as an opportunity to reflect on what you truly learned and what you will be able to apply when you actually look for ahouse.

(4 marks)

Lessons Learned

1

2

3

4