Carlson Candies issued $300,000 of 83„8%, five-year bonds on January 1, 2017, when the market interest rate was 9½%. The company pays interest annually at year-end. The issue price of the bonds was $287,041.
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, and format your answer as shown here.

Transcribed Image Text:

li Bond InterestInterest Bond Discount Bond Discount Carrying Date PaymentExpense Amortization Balance Amount 287,041 5 1-1-2017 6 12-31-2017 7 12-31-2018 8 12-31-2019 9 12-31-2020 10 12-31-2021 300,000 × 0.08375 + F5 × 0.095 + C6-B6 300,000-F5 + F5 + D6