Bonds Issued at a Premium (Effective Interest) Haley Industries issued $170,000 of 7%, 7-year bonds on January 1, 2024, with a $9,490 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. X 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 Premium on Bonds Premium on Bonds (Debit) Payable (Debit) Payable Balance Carrying Value At issue 12/31/24 11,900 12/31/25 11,900 12/31/26 11,900 12/31/27 11,900 12/31/28 11,900 12/31/29 12/31/30 11,900 11,900 #000000