can you please include the functions used to get the answers :) thank you

AutoSave A885 C Calculating payments using PMT 10162018 (1) No Label Home Insert Draw Page Layout Formulas Data Review View >> Tell me Comments : A- %- Conditional Formatting Format as Table Paste Font Alignment Number Cells Editing Sensitivity Analyze Cell Styles Date D20 fx C D L Name: Group 5 Your score 41% On January 1, 2023 the Group 5 Company borrows $110,000 cash by signing a 5-year, 12%, installment note, with semiannual interest payments. 1) Calculate the amount of each payment using the PMT function. 2) Prepare the amortization schedule for the loan. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cell address(es) Entering a value will be marked as incorrect. Loan amount 10 Term (years) Annual interest % $110,000 5 12% 11 Payments per year 12 13 14 1) What is the amount of each semiannual loan payment?. The PMT function must be used, and formula must return a positive value $14,945 15 16 2) Complete the amortization schedule for this note. All formulas must return a positive value 17 18 Semiannual Interest Period Beginning Balance Debit interest Expense Debit Notes Payable Credit Cash Ending Balance $110,000.00 2 3 4 5 6 7 8 9 10 Ready Loans PMT Mortgage PMT Car PMT Instructions Accessibility: Investigate AV AW AX