Foley Co. is preparing the electronic spreadsheet below to amortize the discount on its 10-year, 6%, $100,000 bonds payable. Bonds were issued on December 31 to yield 8%. Interest is paid annually. Foley uses the effective interest method to amortize bond discounts. B C E Cash Interest Discount Carrying Year paid expense amortization amount $86,580 $6,000 D 2 2 which formula should Foley use in cell E3 to calculate the bonds' carrying amount at the end of Year 27