ONLY ANSWER QUESTION E , F and justify

Securing a Mortgage

Claude and Mike are a young couple of working professionals living in Thunder Bay, Ontario. Together, they have a combined gross monthly income of $6,200. They currently pay $260 per month towards a lease on their car and Claude makes a payment of $200 per month towards her school debt. They have also developed a high credit score, by keeping their credit card balances low and paying off all bills and debts on time.

Claude and Mike have been putting money aside from each of their paycheques to save up for a down payment of 20% on a $175,000 condo. Once they saved up enough money, they began researching different mortgage options online.

Through their research, Claude and Mike discovered that in addition to big banks, there are mortgage brokers who can assist them with their mortgage. A mortgage broker will negotiate terms with multiple different potential lenders, and as such, can often find the lowest interest rate offered by a financial lending institution. In addition to this, a mortgage broker is paid commission by the lender, and therefore, the service would not be of cost to Claude and Mike.

Intrigued by this, the couple contacted a Canadian mortgage broker company, that has access to over 30 of the top mortgage lenders in Canada.

a. What size of mortgage do the couple require? 140.000

b. If the mortgage broker is able to secure them with a ten-year mortgage with a fixed rate of 2.35% compounded semi-anually for a term of five years, what would be the size of their monthly payment? 1309.53

c. Claude and Mike are informed that the utilities and taxes on their condo will be approximately $195 per month. Assuming the mortgage terms outlined in (b), calculate the GDS and TDS. GDS = 24.27

%

Round to 2 decimal places.

TDS = 31.69

%

Round to 2 decimal places.

Based on the calculations, is it advisable for the lender to qualify the couple for their mortgage?

Yes

The couple accepted the mortgage terms, and made monthly payments for five years. At the end of the term, a new term of five years with a fixed rate of 2.22% compounded semi-anually was negotiated.

d. What is the new monthly payment that Claude and Mike must make?

1,305.33

Round to the nearest cent.

e. Instead of making monthly payments, the mortgage broker presented an option of accelerated bi-weekly payments, in which the couple must make a payment of half the amount calculated in (d) every two weeks. Claude and Mike opted for the accelerated bi-weekly payment schedule. By how many weeks did they shorten their amortization period?

20 weeks

Round up to the next payment and week.

f. Construct a partial mortgage schedule the mortgage broker can present to the couple, showing:

1. the first two payments of the first term,
2. the last two payments of the first term,
3. the first two payments of the second term,
4. the last two payments of the second term, and the total payment made and interest paid.

\begin{tabular}{|c|c|c|c|c|} \hline \begin{tabular}{l} Payment \\ Number \end{tabular} & \begin{tabular}{l} Amount Paid \\ (Periodic \\ Payment) \\ PMT (\$) \end{tabular} & \begin{tabular}{c} Interest Portion \\ (Previous \\ Balance i ) \\ INT (\$) \end{tabular} & \begin{tabular}{l} Principal \\ Portion \\ (PMT - INT) \\ PRN (\$) \end{tabular} & \begin{tabular}{c} Principal \\ Balance \\ (Previous \\ Balance - PRN) \\ BAL (\$) \end{tabular} \\ \hline 0 & - & - & - & $0.00 \\ \hline 1 & $0.00 & $0.00 & so. 00 & $0.00 \\ \hline 2 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline & & & & \\ \hline 58 & & & & $0.00 \\ \hline 59 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline 60 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline 61 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline 62 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline & & & & \\ \hline 0 & & & & $0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline 0 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline 0 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Total & $0.00 & $0.00 & $0.00 & \\ \hline \end{tabular}