i just need help with the bottom two pv= formulas please!!!

A1 22 23 1 2 On January 1, Ruiz Company issued bonds as follows: 3 4 5 6 7 Interest payments per year 8 Face Value: Number of Years: Stated Interest Rate: 13 Note: Rounding is not required. 14 15 a) 16 17 18 19 20 21 fx Accessibility tab summary: The Future Value of $1 is presented in cells A3 to S27. The Present Value of $1 is presented in cells A3 to $27. The Future N Q b) 3.5 36 b) $500,000 Annual Market Rate Semiannual Interest Payment: PV of Face Value: + PV of Interest Payments: Bond Selling Price: 9 Required: 10 1) Calculate the bond selling price given the two market interest rates below. 11 Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottom of 12 this worksheet). Annual Market Rate Semiannual Interest Payment: PV of Face Value: + PV of Interest Payments: Bond Selling Price: 15 Annual Market Rate Bond Selling Price 7% 2 24 25 26 27 2. Use the answer either "Premium" or "Discount" to the following items. 28 29 The bond in (a) sold at a: 30 The bond in (b) sold at a: 31 32 3. Use the Excel PV function to verify the selling prices of the bonds. 33 a) Annual Market Rate 34 Bond Selling Price 9% 6.00% 9% D 6% F G + H you to any additional work you need to solve this question or can be used to show your work. M O P 37 38 39 40 41 Students: The scratchpad area is f 42 Nothing in this area will be graded, but it will be submitted with your assignment. > = Future Value of $1 Present Value of $1 Future Value of Annuity of $1 Present Value of Annuity of $1 Graded Worksheet R +

323 . Use the Excel PV function to verify the selling prices of the bonds. \begin{tabular}{|l|} \hline 33 \\ \hline 34 \\ 35 \\ 36 \\ 37 \\ 38 \end{tabular} a) Annual Market Rate Bond Selling Price b) Annual Market Rate Bond Selling Price 323 . Use the Excel PV function to verify the selling prices of the bonds. \begin{tabular}{|l|} \hline 33 \\ \hline 34 \\ 35 \\ 36 \\ 37 \\ 38 \end{tabular} a) Annual Market Rate Bond Selling Price b) Annual Market Rate Bond Selling Price