PLEASE READ ALL DIRECTIONS CAREFULLY. Use cell references in your formulas in a way that if numbers would change, it would still work (debits and credits)

A B C D E F G H I 1 2 Spreadsheet 10 - Bonds payable transactions 3 5 6 7 Record the journal entries for the issuance of the bonds, the six semi-annual interest payments using the effective interest method, and the early redemption of the bonds. 1. Assume the bonds will always be issued at a discount, even if the numbers in cells D14, D15, D16, and/or D18 change. 2. Assume the term in cell D17 will always be 3 One account has been entered already in each joumal entry. Complete the other accounts and the amounts (to the nearest whole dollar.) Use only cell references and formulas. The only number that may be entered in the formulas is "2". Formulas in the last transaction should be robust enough to accommodate a gain or a loss based on changes in the amount in cell G68. On January 1, 2020, your company issued bonds to raise money. The facts are as follows: Face amount Cash received Stated rate Term Market rate $530,000 $504,736 12% 3 14% years Interest is recorded semi-annually January 1, 2020 Record the entry for the issuance of the bonds. 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Account Debit Credit Date 1/1/20 Discount on Bonds Payable June 30, 2020 Record the entry for the semi-annual interest expense. Account Debit Credit Date 6/30/20 Discount on Bonds Payable A B C D E F G H 38 39 40 41 December 31, 2020 Record the entry for the semi-annual interest expense. Date Account Debit Credit 12/31/20 Discount on Bonds Payable June 30, 2021 Record the entry for the semi-annual interest expense. Account Debit Credit Date 6/30/21 Discount on Bonds Payable 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 December 31, 2021 Record the entry for the semi-annual interest expense. Account Debit Credit Date 12/31/21 Discount on Bonds Payable December 31, 2021 Record the entry to call the bonds after two years $524,700 Account Debit Credit Date 12/31/21 Discount on Bonds Payable