use given data to fill out bond discount and bond premium, please be clear and use similar format.

B C D E 1 2 Given Data: 3 4 Aurora Fire District 5 On Jan. 1, 2021, Aurora Fire District issued bonds. 6 Interest is payable semiannually on June 30 and Dec. 31 of each year. 7 8 Bond Discount Problem Data: 9 Face amount $ 20,000,000.00 10 Stated interest rate 6.0% 11 Market interest rate 7.0% 12 Length of bonds, in years 10 13 14 Bond Premium Problem Data: 15 Face amount $ 20,000,000.00 16 Stated interest rate 6.0% 17 Market interest rate 5.0% 18 Length of bonds, in years 10 19 20 21 Bond Discount Problem - Use cell linking when possible and Excel formulas for all calculated amounts. 5 You must use Excel's PV function to receive credit for this assignment. 3 0 1 Company name: Aurora Fire District Face amount Cash interest payment Market interest rate per period Number of periods Issue price: Display as positive number Increase in Date Cash Paid for Interest Interest Expense Carrying Value 2 3 Carrying Value (End of Period) 5 8 7 8 9 0 1 2 3 -1 5 8 7 8 0 1 2 3 -4 5 8 38 In the space below, enter the journal entry for Jan 1, 2021 to record the issuance of the bonds. 39 Then make the journal entries to record the first two semiannual interest payments. 40 (TYPE IN THE ACCOUNT NAMES and use cell linking for amounts. No descriptions are required.) Account Debit Credit 42 Jan 1, 2021 41 43 44 45 47 June 30, 2021 48 49 50 52 Dec 31, 2021 53 54 55 20 57 58 Bond Premium Problem - Use cell linking when possible and Excel formulas for all calculated amounts. You must use Excel's PV function to receive credit for this assignment. 5 3 0 Company name: Aurora Fire District Face amount Cash interest payment Market interest rate per period Number of periods Issue price: Display as positive number 1 2 3 Date Cash Paid for Interest Interest Expense Decrease in Carrying Value Carrying Value (End of Period) 5 6 7 8 9 0 1 2 4 5 6 7 8 9 0 1 2 3 4 5 6 38 In the space below, enter the journal entry for Jan 1, 2021 to record the issuance of the bonds. 39 Then make the journal entries to record the first two semiannual interest payments. 40 (TYPE IN THE ACCOUNT NAMES and use cell linking for amounts. No descriptions are required.) Account Debit Credit 42 Jan 1, 2021 41 43 44 45 47 June 30, 2021 48 49 50 31 52 Dec 31, 2021 53 54 55 J0 57