please show the exel formulas

On January 1, Ruiz Company issued bonds as follows: Face Value: $ Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest annually.) 500,000 30 7% 1 Required: 1) Calculate the bond selling price given the two market interest rates below. Use formulas that reference data from this worksheet and from the appropriate future or 2 present value tables (found by dicking the tabs at the bottom of this worksheet). Note: Rounding is not required. 4.a) Market Interest Rate: 9% 35,000.00 5 6 7 8 9 Annual Interest Payment: PV of Face Value: + PV of Interest Payments: Bond Selling Price: 0 1 b) Market Interest Rate: 5.5% 22 3 Annual Interest Payment: Iowania ty of $1 Present Value of Annuity of $1 Sheet1 READY 100% Font Styles