Paste BIU To Fo 2-29- 2% 8% Numbe 2 Style Format as Table- - format Analyze Cate Analy Setty A B Function: PMT, SUM; Formula: Subtract, Multiply, Divide, Cell Referencing D EF G H. 3 BE10.9 Using Excel to Calculate Mortgage Payment, 4 Amortization Schedule, and Entries 5 PROBLEM 6 Eyre Inc. signed a mortgage payable on November 30, 7 2020, with a bank to obtain financing for a new building 8 Installment payments are to be made at the end of each 9 month. Information for the mortgage follows 10 11 Mortgage loan amount $3,00,000 12 Mortgage term in years 10 13 Interest rate 4% 14 15 16 17 18 19 20 21 K M Student Work Area N O P Q Required: Provide input into cells shaded in yellow in this template. Use the PMT function to calculate the payment and mathematical formulas with cell references to the Problem area and work area as indicated a Use Excel's PMT function to calculate the amount of each installme Mortgage payment calculation b. Prepare a partial amortization table through January 31, 2021 Monthly Interest Cash Payment Payment Interest Expense Reduction of Principal Principal Balance Nov 30, 2020 Dec. 31, 2020 Jan. 31, 2020 c. Prepare the entries to record the mortgage on November 30, 2020, and thei Enter Answer My Ambly Investig . Q 0 144 04-04-2022