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.$)$