I need to understand what formulas to use on excel. not just the answers.

1 On January 1, Ruiz Company issued bonds as follows: Face Value: beroen Stated interest Rate: Note: the bonds pay interest 11 Use formules that reference data from this worksheet and from the appropriate future 12 prevent value tables found by clicking the tabs at the bottom of this worksheet 35,000.00 -3 Note: Rounding is not required. 14 a) Market Interest Rate: 15 Annual Interest Payment: PV of Face Value: + PV of Interest Payments: = Bond Selling Price: $ 35,000.00 Market Interest Rate: 22 Market Interest Rate Annual Interest Payment: PV of Face Value: + PV of Interest Payments: = Bond Selling Price: 28 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. The bond in (a) sold at a: The bond in (b) sold at a: of 1 Present Value of Any of $ Sht