solve the given question accurately

Chilliwack Candies issued $300,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 $256,743 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.)