# FNCE1125 Introduction to Finance- Mortgage Case- Finance assignment Help

1. Finding the House (1)
1. You will need to find a home located in the City of Edmonton from

https://www.realtor.ca/ab/edmonton/real-estate Website.
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 and the MLS Number in the box below. (1 mark)

 List Price:                                                   MLS Number:
1. Down Payment and Mortgage Amount (2)
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)

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

1. Mortgage Rate (1)

1. 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. (1 mark)

 Financial Institution Mortgage Rate (5-year fixed)

1. Prepayment Privileges (2)

1. Describe the prepayment privileges offered by EACH financial institution listed in question 5. (2 marks)

1. Calculating Your Monthly Mortgage Payment (3)
2. Based on your answers for questions 5 and 6, select which financial institution’s 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 following table.

(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 P1 = P1 = P1 = P2 = P2 = P2 = BAL Outstanding = BAL Outstanding = BAL Outstanding = Total  PRN = Total  PRN = Total  PRN = Total INT = Total INT = Total INT =

• Payment Frequencies (5)

1. Select a mortgage payment (PMT) from question 7 (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 new amortization if you change the payment frequency. Use the formulas in Exhibit 7.4 on page 213 of your text. (5 marks)

 Mortgage Payment Frequency Calculator Semi-monthly Bi-weekly Accelerated bi-weekly Weekly Accelerated Weekly P/Y C/Y N I/Y PV PMT FV AMORT (t)

• Calculating Annual Property Tax (3)

1. Go to the City of Edmonton website and determine the City of Edmonton’s assessed value for your home for 2020 and write it in the space below. (1 mark)

1. Using your value from Question 9, use the City of Edmonton’s property tax estimator to determine your approximate annual and monthly property tax bill and write these numbers in the space below. (1 mark)

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

1. Qualification (3)

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

1. 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)

1. 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)

1. Closing Costs (3)

1. Based on the house you have decided to purchase and what you have read in chapter 7, explain which closing costs you anticipate you will need to incur, and the approximate amount for each cost and total closing cost? (3 marks)

1. Mortgage Structure (5)

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

 Term: Amortization: Payment Frequency: Fixed or Variable: Closed or Open:
• Reflection (3)
1. 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 a house.

(3 marks)

 Lessons Learned 1 2 3