1. ABC Company decides to use bonds as a method of debt financing. They issue 4.8% bonds on October 1, 2021 with a face amount of $750,000 and a maturity date of September 30, 2024. The bonds pay interest semiannually March 31 and September 30. The market rate of interest is 4% Prepare an amortization table using the effective interest method related to the above. I would suggest inserting a table or Excel object into a Word document to prepare this.

In addition, what should ABC record related to these bonds at its fiscal year-end of December 31, 2022?

please attach excel sheet if possible