(I need answer for part 4 and 5 only)

The Simpsons, owners of a spa on the island of Montreal, have been hard-hit by the pandemic.Before they were forced to close their spa, their take home income, after taxes but before living expenses, was $7,000 a month.The Simpsons spent all of their take-home cash flow and even more, by borrowing on a line of credit (LOC).The day their spa was closed the balance on their LOC was $8,520.Normally they use the LOC to clear the balance on their several credit cards each month.Terms of the LOC include a repayment of 3% of principal every month plus interest charged at a rate of 0.5% per month.

Three years ago the Simpsons took out a $532,000 mortgage to purchase a home in Beaconsfield.Payments are monthly at a rate of 3.6%, compounded semi-annually.The original amortization period was 20 years and they have made 34 payments to date.

The Simpson's mortgagor has offered them the possibility of suspending payments for the next 4 months.Nevertheless, they will still owe the interest they would have paid on each payment.Furthermore, the future value of the unpaid interest after 4 months will mean that they will have to pay interest on the outstanding interest should they take up this offer.

Part 1 (1 mark)

Excluding the balance on their LOC, what minimum emergency fund should the Simpsons have held to meet unforeseen events?What type of investment would be suitable for such a fund?

Calculation of Minimum Emergency Fund

$7,000 * 12 = $84,000

Suitable Investment

They will need this amount to expense for every month, so they need to invest this amount in saving bank or liquid fund.

Part 2 (1 mark)

How much would the couple have to pay on the LOC for the month following closure of their spa?What impact would not making the payment have on their credit rating?Please explain.

LOC Payment Calculation

LOC balance = $8,520

Total interest rate = 3% + 0.5%

= 3.5%

LOC balance after a month = Amount * (1 + Interest rate) ^1

= $8,520 * (1 + 3.5%) ^1

= $8,818

Impact of Non-Payment

If they are unable to pay their LOC payment, the amount will increase at a very high rate because these rates are very high when compared to other loans, other than that, the penalty may also be charged for the late payment, and this can decrease their credit rating or credit score.

Part 3 (1 mark)

What is the monthly payment on the Simpson's mortgage?What is the balance after 34 months?Round to the nearest dollar.

Calculation of Mortgage Payment and Balance after 34 Months (rounded)

PMT = $3,105

Outstanding balance = $477,652

Even If the loan is delayed it will not cost any penalty, but it will increase the PMT because its interest will accumulate along with principal.

4) Draw up the Simpson's mortgage amortization table for the next four months (i.e. for payments 35-38).Their monthly mortgage rate is 0.2978%.Round to the nearest dollar. (The mortgage amortization table includes a table with a horizontal row of 5 components( Beginning Balance, PMT, Interest, Principal and Ending Balance) and a vertical row with the years from 35 to 38).

5) How much interest will the Simpsons owe at the end of the 4-month period?(Mortgage payments are made at the end of the month.)Round to the nearest dollar.Remember, they will be obliged to pay interest on their interest.

If they are given the choice of adding this to their mortgage balance or paying it immediately in cash, what would you recommend, and why?

Calculation of Total Interest Owed at the end of 4 months:

Repay or add to the mortgage balance?