Help Save & E Ira Bates Corp entered into a 9-year finance lease on a warehouse on December 2021 Le parts of 2000, which includes manance service of S a re due annually beginning on December 2012 and every December 31 thereafter. The wterest rate implicat in the basis . The rounded present value of an ordinary annuity for me years at 576. What amount should Bates record as the lease payable December 31, 2021 O 042 09:40 Loooo O 7.000 O 300 DELL ers 13, 14, 15 6 Jane Wright Company is preparing an Excel spreadsheet for a 6-year finance lease. The implicit interest rate in the lease is 4%. The beginning of the lease is December 31, 2021. Lease payments are made each December 31 starting at December 31, 2021. A portion of the spreadsheet appears as follows: Required: 1. Using the format followed in cell D7. provide the appropriate formula for cell B6. 2. Using the format followed in cell D7, provide the appropriate formula for cell C8. 3. Using the format followed in cell D7, provide the appropriate formula for cell E8. E BC Effective rate: Lease payments: 300.000 Term to maturity in years: T L Cash Payment Interest Expense Change in Balance Outstanding Balance 1.635 546 Date 6 12/31/21 7 12/31/21 8 12/31/22 C7-87