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,046. Monthly principal and interest instalment payments are $657. 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 $21,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 owed 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,210 for the combined amounts and revised term, with payments starting on December 25, 2021. Prepare an instalment payment schedule using the revised instalment payments of $1,210, from December 25, 2021, to June 25, 2023. (Round answers to O decimal places, e.g. 5,275.) Monthly Interest Period (A) Cash Payment (B) Interest Expense (C) Reduction of Principal Nov. 25, 2021 Balance $ | Dec. 25. 2021 $ 47046 $ $ Jan. 25, 2022 Feb. 25, 2022 Mar. 25, 2022 Apr. 25. 2022 May 25, 2022 25. June 2022 July 25, 2022 25, July Aug. Dec 1000000 ANOS TODO Jan. Mar. Anr 10000 May 25, June