Interest is paid semiannuslly on fune 30 snd December 31 of esch year. Hequired: 1. Use an Excel fonmula to calculabe the issue price of the bonds. 2. Complete the first four rows of the amortization schedule. 2. Prepare the journal etery for istuante of the bond. 4. Prepare the joumal entry for the fint interest payment on June 30. 2024 5. Prepare the joumal eatry for the second interest poyment on December 31,2024 , Requirement 1: 1sses Price of the Bonds Qse cells A2 to 87 from the given infocmation above to complete this question. Hint: Use the PV function to calculste the issue pric in your formula, be sure to use cell references to the given information foelt .4 to 877 . Since intesest is puid semiannuely, multiply divide by a factor of 2 in your formuls a aporopriate. Show the lasue price as a positive amount by including a necutive aymbol C."7 before the PV Lanction.) Aecuirement 2: Amortiation 5chedule fUse tellt A2 to B7 frun the tiven information above to complete this cuestion. All vaives thould be shown at postive amounts.) Repuirement 3: jourtal Entry for issuance of Bonds on Janiary 1, 2024 (Use cells A2 to B7 from the given information above to complete this question. Hint A "dscoust" or "pprnmium" accoust will auto-populate based on your answer to fecuirement 1. Show all valuet as positive amounts) Hequigament 4. bounal Entry for First interest Payment on hune 3n, 2024 Quse cells A2 to B7 from the given informaton above to complete this question. Hint-A "dicount" or "premium" acsount will auto-populate based on your answets to Requirements 1 and 2 . Show al values as positive amounts ) Fequirement 5. doumal tntry for 3econd intereat Payment on December 11, 2024 (Qse tells A2 to B7 from the even information above to complete this question. Mint: A "ditcount" or "premium" actourt will auto-populate based on your answers to Requirements 1 and 2 . Show all values as positive amounts )