iz Saved Help Save & Exit Submit M&O Company is preparing an Excel spreadsheet for a 5-year finance lease. The implicit interest rate in the lease is 6%. The beginning of the lease is January 1. Lease payments are made each December 31. A portion of the spreadsheet appears as follows: A B D E 1 0.06 100,000 5 Effective ratet Lease payments: Term to maturity in years! 2 3 4 5 Cash Payment Interest Expense Change in Balance Outstanding Balance 6 7 8 Period 0 1 2 What formula should M&O use in cell C8? Multiple Choice =B8+D7 -B8+D8 E7C1 MacBook Pro