Bonds Issued at a Premium (Effective Interest) Haley thdustres issued \$110,000 of 134,7 year bonds on January 1, 2024, wht a $5,020 promum. Interest is pald annoally on Deceanber 31 . The market rate of interest is 12%. Thie information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the cuestlon below. Open soreadsheet Required: Prepart 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 amertizabion. Haley industriet asued bonds on January 1,20e4 that are due in 7 years. Interest is pald annualy on December 3ist. The following information pertains to the bond issuance: FEEQURED: Prepare the amortitation table through using the eftectve intevest rale method (Note: Rounding sffereoces may occur in spreadsheet sohware) Uling formulat and celt relerences from the problem dala, perform the requed andyis. Formulas entered in the green cells Nhow in the crange ceds. Trans/er amounts to CNOWV2 for grading. This speeadsheet has been formatted to found numbers to the nearest cent. For example, 17.651.5=26.475. The amount wit disclay and hold 26.44 , not 26.475 . There is no nesd to use fiscelfe rounding function. Haw do you feel look? Wrid lone to hear vo \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & c & 0 & E & F \\ \hline2423 & & & & Formulas: & & \\ \hline 25 & Period & \begin{tabular}{c} Cash Payment \\ (Credi) \end{tabular} & \begin{tabular}{l} Interest Expense \\ (Dobit) \end{tabular} & \begin{tabular}{c} Premium on Bonds \\ Payoble (Debili) \end{tabular} & \begin{tabular}{l} Premilum on Bonds. \\ Payable Balance : \end{tabular} & Carnying Value \\ \hline 26 & At issue & & & & & \\ \hline 27 & 1231124 & & & & & \\ \hline 28 & 12311/25 & & & & & \\ \hline 29 & 12311/26 & & & & & 4 \\ \hline 39 & 1231/27 & & & & & \\ \hline 31 & 12/31/28 & & & & & \\ \hline 32 & 12/31/29 & & & & & \\ \hline 33 & 12/31/30 & & & & & \\ \hline \end{tabular}