Next question Dellaca Candies issued $330,000 of 6%, five-year bonds on January 1, 2020, when the market interest rate was 10%. The compan Requirement Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization Round to the nearest Requirement. Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization (Roum balance, enter a 0 where appropriate.) A B Interest Payment (6% of Maturity Value) D E Interest Expense (10% of Discount Preceding Bond Carrying Amortization Discount Balance Amount) (C-B) (Preceding E-D) F Bond Carrying Amount ($330,000 - E) Date 1-1-2020 12-31-2020 $ 19,800 12-31-2021 19,800 19,800 12-31-2022 12-31-2023 12-31-2024 19,800 19,800 Next question Delaca Candes issued $330.000 of 6% tve-year bords on January 1 2020, when the market interest rate was 10%. The compare Jually at year end The issue price of the bonds was $279,902 Requirement Create a spreadsheet model to prepare a schedule to amortize the bonds Use the effective interest method of amortization Round to the newest dollar 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 balance, enter a where appropriate) D E Interest Payment Interest Expense (10% of Discount 10% of Maturity Preceding Bond Carrying Amortization Discount Balance Value Amount) IC.) Preceding ) Bond Carrying Amount (6330.000 Date $ 1-1-2020 12-31-2020 12-31-2021 12-31-2022 12-31-2023 12-31-2024 10 000 19 300 19.000 19.000 19.300 Next question Delaca Candes issued $330.000 of 6% tive-year bonds on January 2020, when the market interest rate was 10% The compare Jually all year end The issue price of the bonds was $279,902 Requirement Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective interest method of amortization Round to the newest dollar 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 balance, enter a where appropriate D E Interest Payment Interest Expense (10% of Discount Bond Carrying 10% of Maturity Preceding Bond Carrying Amortisation Discount Balance Amount Date Value) Amount) IC.) Preceding E.) (6330.000 1-1-2020 12-31-2020 5 19,800 12-31-2021 19 300 12-31-2022 19 000 12-31-2023 19,800 12-31-2024 19.000