Can someone help explain what numbers go where and what the journal entries would be and amount of interest payments for the first two interest payments.

File Edit View Insert Format Data Tools Extensions Hop ACCI 100 . ES - - . $ Calibri 11 6 D. 123- E LI.00 fx D G H M . 3 A Lerend PRINCIPAL Title Principal Annual interest Rate Compounding Periods per Year Years Draw Date(Beg 1, End-o) Premium $300,000 14% 2 10 Manual Input Calculated Problem: Formular PV of Cash $77,525.70 On May 1 2020 a $300,000, 10 year bond with stated interest rate of 14% was sold with an effective interest rate of 12%, plus accrued interest. The bond was dated January 1.2020 and interest is paid semiannually each January 1 and July 1. Interest Title Principal Annual Interest Rate Compounding Periods per Year Years Payment Amount Draw Date(Beg-1, Endeo) Formular PV of Cash Par $300,000 14% 2 10 1) Calculate the PV of the principal and interest of the bond using correct Excel Formula Show data inputs and related work 2) Prepare the journal entry on May 1,2020 to record sale, including accrued interest 3) Using the effective interest method calculate the 1st two interest payments. $77,525.70 Total Principal & Interest $155,051.40 Par Value Problem 21 - Problem w2 Problem Problem w Problem #5 Problem 6 Problem #7