please show the work, show how to solve it on excel using pmt, formula subtract, multiply;cell referencing. show all work. how to solve it on excel

A B D Function: PMT; Formula: Subtract, Multiply; Cell referencing 2 Using Excel to Calculate Loan Payments PROBLEM Jenseng Inc. issues a 10-year mortgage loan on December 31 , 2022 with the following information: Mortgage loan amount Annual interest rate Loan term in years Annual installment payment $800,000 10% 10 $130,196 tract, Multiply; Cell referencing E F Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the PMT function with cell references in part a to the Problem area. Input cell references in parts b and c. In part c, use mathematical formulas with cell references to the Problem area to calculate both debit amounts, and a cell reference to the Cash amount you calculated in part a. a. Verify the annual mortgage payment amount using Excel's PMT function. Verification of payment using PMT b. Record the journal entry for mortgage loan on December 31, 2022. c. Record the journal entry for the first installment payment on December 31,2023. \begin{tabular}{ccc} Date & Debit & Credit \\ \hline 12/31/23 & InterestExpenseMortgagePayableCash & \end{tabular}