Moreau Candies issued $$390,000$ of $9\%,$ five$-$year bonds on January $1,2020,$ when the market interest rate was $13\%.$ The company pays interest annually at year$-$end. The issue price of the bonds was $$335,131.$

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.