Dracut issued 100 000 of 8% 10 yr bonds payable on January 1 20x0 when the market interest rate was 10%. The company pays interest annually at year end.

1. Create spreadsheet model to prepare schedule to amortize the bond. Use effective interest method of amortization. (round to nearest dollar)