Interest is paid annually on December 31 . The market rate of interest is 5%. 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. Note: Round interest expense to a dollar and round final year interest expense amount to complete the amortization