Reference no: EM132538584
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.
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.
Month $ Beg. Bal. $ Pmt. $ Interest $ Principal $ End. Bal.
35
36
37
38