i need your help to solve the whole problem with formulas in excel format i want all the answer that go in the excel cells they are asking for. and the formulas of how you got them

On January 1, Ruiz Company issued bonds as follows: Required: 1) Calculate the bond selline price given the two market interest rates below. Uie formulas that reference data from this worksheet and from the oppropriate future or present value tables (found by clickine the tabs at the bottom of this workheet). Note: founding is not required 17 fx=B4/(1+C15/B7)(B5B7) A B C D 13 Note: Rounding is not required. C D 27 2. Use the answer either "Premium" or "Discount" to the following items. 28 Annual Market Rate Semiannual Interest Payment: PV of Face Value: PV of Interest Payments: Bond Selling Price: > Le of Annuity of \$1 A Present Value of Annuity of \$1 B Graded Wo Calculation Mode, Automatic Workbook Statistics Bond Pricing 2, Using Present Value Tables Ruiz Company issued bonds on January 1 and has provided the relevant information.The Controller has asked you to calculate the bond selling price given two different market interest rates, using Present Value calculations. Here are some tips for using Excel: - Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. - Multi-Tab Cell Reference:Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multitab cell reference, type the equal sign first, then click on the other tab and then click on the cell you