Emily, Bev, and Doug had originally thought that the computer equipment upgrade that ABC decided to undertake could be paid for with cash in the bank. As at June 25, 2021, the balance of the 5% mortgage payable after making the payment on that day was $47,196. Monthly principal and interest instalment payments are $659, paid on the 25th of each month. The mortgage is up for renewal on November 25, 2021. Because interest rates have fallen since the original mortgage was signed, it can be renewed at an interest rate of 4%. In addition, Emily has decided to reduce the mortgage term to five years, instead of the seven years remaining. Unfortunately, there was not enough cash to pay for the computer equipment as originally planned, and $20,000 of the operating line of credit had to be used to finance this upgrade. Emily would like to transfer the balance of the line of credit onto the mortgage payable balance outstanding instead of trying to pay the balance pwed on the line of credit from cash generated from operations. The bank has agreed to accommodate both of these requests and has advised that the monthly instalment payments will be $1,195 for the combined amounts and revised term, with payments starting on December 25, 2021. Monthly Interest Period 25. Nov. Balance 2021 25, Dec. 2021 25, Jan. 2022 25. Feb. 2022 25. Mar. 2022 25, Apr. 2022 May 25, 2022 (A) Cash Payment (B) Interest Expense (C) Reduction of Principal $ $ June July Aug 25. 2022 25, 2022 25. 2022 25, Sept. 2022 Oct. 25, 2022 25, Nov. 2022 25, Dec. 2022 25, Jan. 2023 25. Feb. 2023 25, Mar 2023 2022 25, Oct. 2022 25, Nov. 2022 25, Dec. Jan. 2022 25, 2023 [ 25, Feb. 2023 25, Mar. 2023 25. Apr. 2023 25. May 2023 25, June 2023 Balance $ (A) Cash Payment (B) Interest Expense (C) Reduction of Principal (D) Principal Balance $