Ohlson co. is preparing an excel spreadsheet for its 20-year, 4.5%, $500,000 bonds payable. the bonds were issued on january 1 to yield 5% annually. interest is paid semi-annually. a portion of the spreadsheet appears as follows: a b c d e 1 stated rate: 0.045 2 effective rate: 0.05 3 face amount: 500,000 4 term to maturity in years: 20 5 6 period cash payment interest expense change in discount outstanding balance 7 0 8 1 9 2 what formula should ohlson use in cell c8 to calculate interest expense for the first interest payment? multiple choice =e7*b3/2 =e7*b3 =b8 – d8 =e7*c2/2