Bonds Issued at a Premium (Effective Interest) Haley Industries issued $100,000 of 7 %, 7-year bonds on January 1, 2024, with a $5,582 premium. Interest is paid annually on December 31. The market rate of interest is 6% This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below. Open spreadsheet Required: Prepare the amortization table using the effective interest rate method. Round interest expense to a dollar and round final year interest expense amount to complete the amortization. Haley Industries Amortization Table Period Cash Payment (Credit) Interest Expense (Debit) At issue 12/31/24 12/31/25 12/31/26 12/31/27 12/31/28 12/31/29 12/31/30 Premium on Bonds Payable (Debit) Premium on Bonds Payable Balance Carrying Value