Hi i am having trouble calculating this pracrice problem.

please show me how to go about calculating this problem! thank you

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.

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

Suitable Investment

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

Impact of Non-Payment

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)

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.

Write in the Simpson's mortgage amortization for the next four months (i.e. for payments 35-38). Their monthly mortgage rate is 0.2978%. Round to the nearest dollar.

Month 35:

$ Beg Balance:

$ PMT:

$ interest:

$ principle:

$ end balance:

Month 36:

$ Beg Balance:

$ PMT:

$ interest:

$ principle:

$ end balance:

Month 37:

$ Beg Balance:

$ PMT:

$ interest:

$ principle:

$ end balance:

Month 38:

$ Beg Balance:

$ PMT:

$ interest:

$ principle:

$ end balance:

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?