Do all your work on this spreadsheet using appropriate 2 X Co. sells $1,000,000 of 10% bonds on January 1, 2019. The bonds pay interest on July 1 and January 1. The due date of the bonds is January 1, 2022. The bonds yield 12%. On January 1, 2020, Co. buys back $200,000 worth of bonds for $206,000 Required: 1. Calculate the issue price of the bond. Show all inputs and calculations. Use an excel formula to calculate issue price. 2. Company X uses the effective interest rate method to determine interest expense. Prepare an amorization table for the life of the bond. 3. Show calculations for the reacquisition gain/loss on January 1, 2020 4. Record all journal entries from August 1 2019 through January 1, 2020. X Co. has a calendar year end. Label each step above and show all supporting calculations in formula form as appropriate. 10 21 22 23 24 25 26 27 28 29