Carlson Candies issued $310,000 of 8%, five-year bonds on January 1, 2020, when the market interest rate was 12%. The company pays interest annually at year end. The issue price of the bonds was $265301 Requirement Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization. Round to the nearest dollar 2. Requirement. Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization (Round your final answer to the nearest dollar. For amounts with a zero balance enter a 0 where appropriate.) A B Interest Payment (8% of Maturity Value) D E Interest Expense (12% of Discount Preceding Bond Carrying Amortization Discount Balance Amount) (C-B) (Preceding E-D) 44699 F Bond Carrying Amount ($310,000 - E) 265301 Date 1-1-2020 318361 37663 7036 s 12-31-2020 272337 280218 7880 29782 12-31-2021 24,800 24.800 24,800 32680 33626 8826 20956 289044 12-31-2022 34685 9885 11071 298929 12-31-2023 24,800 11071 35871 0 310000 12-31-2024 24.800