Bonds Issued at a Discount (Effective Interest) Crafty Corporation recelved $758,349 of cash upon issuance of 800,$1,000 par value bonds. Each bond has a stated rate of 7% and will mature on December 31,2030,7 years after the issuance of the bonds. Interest is paid annually on December 31 . The market rate of interest is 8%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required anaiysis, and input your answer in the question below. Required: Prepare the amortization table vising the effective interest rate method. Note: Round interest expense to a dollar and round final year interest expense amount to complete the amertization. Crafty Corporation received $758,349 of cash upon issuance of 800,51,000 par value bonds. Each bond has a stated rate of 7% and will mature on December 31,2030,7 years after the issuance of the bonds. Interest is paid annually on December 31 . The market rate of interest is 8%. This information has been collected in the Microsof Excel Oniine flie. Open the spreadsheet, perform the required analysis, and input your answer in the question below. Required: Prepare the amortiration table using the effective interest rate method. Note: Round interest expense to a doliar and round final year interest expense amount to complete the amortiration. Crafty Corporation issued bonds that will mature on December 31, 2030, 7 years after the issuance of the bonds. Interest is paid annually on December 31. The following information pertains to the bond issuance: REQUIRED: Prepare the amortization table through using the effective interest rate method. (Note: Rounding differences may occur in spreadsheet software.) Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading. This spreadsheet has been formatted to round numbers to the nearest cent. For example, 17.651.5=26.475. The amount will display and hold 26.48, not 26.475 . There is no need to use Excel's rounding function