PLE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ADD-INS QuickBooks 614 X f r --PMT(4010/12,011*09,08) HT Name: kelly gamer Your score On January 1, 2020 the Kelly Gamer Company borrows $150,000 cash by signing a 5-year, 10%, 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 $150.000 Your PMT formula is incorrect Loan amount Term (years) Annual interest Payments per year 1) What is the amount of each semiannual loan payment? The PMT function must be used, and formula must return a positive value. 2) Complete the amortization schedule for this note. Al formulas must return a positive value Semiannual Interest Period Beginning Balance $150,000.00 Credit Cash Debit interest Expense Debt Notes Pavable Ending Balance tucions Loans PMT Mortgage Car PMT Limited - 00140 - $74.20 Periode 20120 - $5300 C