the formulas needed to solve in excel for number 1?

X 1. Determine the price of the bonds issued on February 1, 2016. Given Data: 5. On February 1, 2016, Alex Company issued 9% bonds, dated February 1, with a face amount of $80 million. 6 The bonds mature on January 31, 2020 (4 years). The market yield for bonds of similar risk and maturity was 10%. 7 Interest is paid semiannually on July 31 and January 31. 8 The fiscal years of both firms end December 31. 10 Required: 111. Determine the price of the bonds issued on February 1, 2016, 12 2. Prepare amortization schedules that the effective interest expense on the bond 13 3. Prepare the journal entries to record the issuance of the bonds by Alex Company February 1, 2016. 14 4. Prepare the journal entries to record all subsequent events related to the bonds through January 31, 2018 15 16 Alex Co. $80,000,000 20 Bond issue by Alex Co 21 Bond issue (years) 22 Bond issue interest rate 23 Market annual yold 10% Given Data Problem Template AutoSave H S Excel+Assignment_+2018 (2) - Excel File Home Insert Draw Page Layout Formulas Data Review View Help F50 : for A BLC Student Name: Class: F G Requirement 1: Alex Company Interest Principal Present value (price) of the bonds Requirement 2: Alex Company Amortization Schedule Cash Payment Effective Interest Increase in Balance Outstanding Balance