Candies issued of

$\%,-$year bonds on January$1,,$ when the market interest rate was

$\%.$ The company pays interest annually at$$ year$-$end. The issue price of the bonds was $$$$.$

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.

Question content area bottom

Part $1$

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

A

B

C

D

E

F

Date

Interest Payment $(8$@DIV$\{3$;$8\}\%$ of Maturity Value$)$

Interest Expense $(9$@DIV$\{1$;$2\}\%$ of Preceding Bond Carrying Amount$)$

Discount Amortization $($C $-$ B$)$

Discount Balance $($Preceding E $-$ D$)$

Bond Carrying Amount $($$$300,000-$ E$)$

$1-1-2020$

$12-31-2020$

$$25,125$

$12-31-2021$

$25,125$

$12-31-2022$

$25,125$

$12-31-2023$

$25,125$

$12-31-2024$

$25,125$