Burnaby Candies issued $360,000 of 10%, five-year bonds on January 1,2020, when the market interest rate was 14%. The company pays interest annually at year-end. The issue price of the bonds was $310,564.
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.
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.)
Bumaby Candies issued $360.000 of 10%,five-year bonds on January 1,2020, when the market interest rate was 14%. The company pays interest annually at year-end. The issue price of the bonds was $310,564 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.
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 O where appropriate.) A B c D E F Interest Payment Interest Expense(14%of Bond Carrying (10% of Maturity Preceding Bond Carrying Discount Amortization (C-Discount Balance Amount Date Value) Amount) B) Preceding E-D) $360,000-E) 1-1-2020 12-31-2020 36,000 12-31-2021 36,000 12-31-2022 36,000 12-31-2023 36,000 12-31-2024 36,000
