Use the following problem to complete the excel worksheet:

Please help me to complete the excel worksheet with the proper inputs! Directions above

On June 30, 2020, Vaughn Company issued $3,120,000 face value of 15%, 20-year bonds at $3,824,160, a yield of 12%. Vaughn uses the effective-interest method to amortize bond premium or discount. The bonds pay semiannual interest on June 30 and December 31. (a) Your answer is correct. Prepare the journal entries to record the following transactions. (Round answer to 0 decimal places, e.g. 38,548. If no entry is required, select "No Entry" for the account titles and enter for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually.) (1) The issuance of the bonds on June 30, 2020. (2) The payment of interest and the amortization of the premium on December 31, 2020. (3) The payment of interest and the amortization of the premium on June 30, 2021. (4) The payment of interest and the amortization of the premium on December 31, 2021. Date Account Titles and Explanation Debit Credit June 30, 2020 Cash 3824160 Bonds Payable 3120000 Premium on Bonds Payable 704160 December 31, 2020 Interest Expense 229450 Premium on Bonds Payable 4550 Cash 234000 June 30, 2021 Interest Expense 229177 Premium on Bonds Payable 4823 Cash 234000 December 31, 2021 Interest Expense 228887 Premium on Bonds Payable 5113 Cash 234000 Show the proper balance sheet presentation for the liability for bonds payable on the December 31, 2021, balance sheet. (Round answers to 0 decimal places, e.g. 38,548.) Vaughn Company Balance Sheet December 31, 2021 Long-term Liabilities Bonds Payable ta 3120000 Premium on Bonds Payable 689674 Book Value of Bonds Payable tA 3809674 A B D E F G H 3 4 5 6 7 Instructions: 1. Open the Bond Bonus Problem in Wileyplus. Enter the provided items for your problem: Bond Face Value Bond Stated Rate Bond Market Rate Number of years Bond Interest Payment $ 8 9 10 11 12 13 In the boxed cell below, compute the Present Value of the bonus using the Excel PV function. Excel Computed Bond Present Value: WileyPlus Selling Price (PV): Difference due to rounding $ $ $ Note: Due to rounding in Wileyplus, the present value may be slightly off from selling price (PV) in Wileyplus. Small difference is OK. 14 15 16 17 18 19 Premium Balance 20 Bond CV 21 22 23 24 25 26 27 28 29 30 2. Complete the amortization table. Use the rounded Selling Price (PV) from WileyPlus to start the amortization table. Premium Date Interest Payment Interest Expense Amortization 6/30/20 1 12/31/20 2 6/30/21 3 12/31/21 4 6/30/22 5 12/31/22 6 6/30/23 7 12/31/23 8 6/30/24 9 12/31/24 10 6/30/25 11 12/31/25 12 6/30/26 13 12/31/26 14 6/30/27 15 12/31/27 16 6/30/28 17 12/31/28 18 6/30/29 19 12/31/29 20 6/30/30 21 12/31/30 22 6/30/31 23 12/31/31 31 32 33 34 35 36 37 38 39 40 41 42 43 44 A B D E F G H 4 22 5 6 7 8 6 7 9 8 0 9 1 2 3 10 11 12 13 4 5 14 15 6 7 16 17 18 19 20 21 22 8 9 -0 -1 -2 -3 4 -5 -6 -7 8 9 0 1 12/31/22 6/30/23 12/31/23 6/30/24 12/31/24 6/30/25 12/31/25 6/30/26 12/31/26 6/30/27 12/31/27 6/30/28 12/31/28 6/30/29 12/31/29 6/30/30 12/31/30 6/30/31 12/31/31 6/30/32 12/31/32 6/30/33 12/31/33 6/30/34 12/31/34 6/30/35 12/31/35 6/30/36 12/31/36 6/30/37 12/31/37 6/30/38 12/31/38 6/30/39 12/31/39 6/30/40 23 24 25 26 27 28 29 30 31 2 3 32 4 5 6 7 8 33 34 35 36 37 9 0 38 39 40 1 2. 3 Note: Due to rounding in original PV, ending CV may be off from face value slightly. Small difference is OK. 4 5 6 -7 8 3. Complete parts (a) and (b) in Wileyplus problem. You have 3 attempts in Wileyplus. Note: In the issuance entry, use the rounded present value provided in Wileyplus. For all other entries and parts, use amounts from the table above