Question

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 $39,246. Monthly principal and interest instalment payments are $548, 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 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,055 for the combined amounts and revised term, with payments starting on December 25, 2021. (a) Your answer is correct. If the amount of mortgage owing was $39,246 on June 25, and instalment payments are $548 per month as indicated above, what is the amount of the mortgage owing at November 25, 2021, after making the payment on that date, immediately before it is renegotiated? (Round answer to 0 decimal places, e.g. 5,275.) Amount of the mortgage owing at November 25, 2021 $ 37307.54 Your answer is correct. Assume that ABC increases the mortgage payable amount you determined in part (a) by $20,000, the amount of the line of credit outstanding at November 25, 2021. What is the revised amount of the mortgage payable at November 25? Revised amount of the mortgage payable $ 57307.54 Record the increase in the mortgage payable on November 25, 2021. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit entries before credit entries.) Debit Credit Date Account Titles and Explanation Nov. 25, cash 2021 20000 mortgage payable 20000 Your answer is partially correct. Prepare an instalment payment schedule using the revised instalment payments of $1,055, from December 25, 2021, to June 25, 2023.(Round answers to 0 decimal places, e.g. 5,275.) Monthly Interest Period 25, Nov. 2021 (A) Cash Payment (B) Interest Expense (C) Reduction of Balance Dec. $ 1055 $ Jan. 25, 2021 25, 2022 25, 2022 1055 Feb. 1055 Mar. 25, 2022 1055 25, Apr. 1055 2022 May 1055 25, 2022 25, 2022 une 1055 July 25, 2022 1055 25, Aug. 1055 2022 ept. 25, 2022 1055 Oct. 1055 25, 2022 25, Nov. 1055 2022 Dec. 25, 2022 1055 Jan. 1055 Feb. 1055 Mar. 25, 2023 25, 2023 25, 2023 25, 2023 25, 2023 1055 Apr. 1055 May 1055 une 25, 2023 1055

Answer 1

The adjusted mortgage amount after including the line of credit immediately before the renegotiation of the mortgage is $57,307.54. A new payment schedule is then required for the revised terms with a lower interest rate and an increased balance due to the line of credit transfer into the mortgage.

Step-by-step explanation:

To calculate the monthly payment of a mortgage, one must consider the loan amount, interest rate, and the term of the loan. For instance, a $1,000,000 house loan over 30 years with a 6% nominal interest rate will require a monthly payment that results in paying more than twice the original loan amount over the period. Conversely, with increased monthly payments, the loan term can be reduced, saving a substantial amount in interest over time.

In the scenario provided in the question, the student needs to find out the amount of mortgage owing at November 25, 2021, and then prepare a new instalment payment schedule with the revised rates and terms. The assumption made is that the mortgage amount will increase by $20,000 due to the line of credit before the new payment schedule begins.