Home Health Surgical Supply issued \(\$ 600,000\) of \(83 / 8\)-percent ( 0.08375\()\), 5 -year bonds payable when the market interest rate was \(91 / 2\) percent \((0.095)\). Home Health pays interest annually at year end. The issue price of the bonds was \(\$ 574,082\).

\section*{Required}

Create a spreadsheet model to prepare a schedule to amortize the discount on these bonds. Use the effective-interest method of amortization. Round to the nearest dollar, and format your answer as follows:

Transcribed Image Text:

1 B C D E F 2 Bond 3 Interest Interest 4 Date Payment Expense Discount Amortization Discount Carrying Balance Amount S 1-1-XI $574,082 6 12-31-XI 7 12-31-X2 8 12-31-X3 9 12-31-X4 10 12-31-XS 600000".08375 +F5*.095 +C6-B6 600000-F5 +F5+D6