Please show me along with excel formular. Thanks

A1 V X Vfx Accessibility tab summary: Bonds issuance by Ruiz Company, is presented in rows 4 to 8 . A statement for requirement 1 is presented in rows 10 to 14 . Table a, for student preparation is presented V A1 \begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ A } \\ \hline 10 & Required: \\ \hline 11 & 1) Given the different market interest rates below, calculate the following items. \\ \hline 12 & Calculate the bond selling price using the Excel PV function. Enter all function arguments as cell references. \\ \hline 13 & \end{tabular} (Use cells A4 to B7 from the given information to complete this question.) a) Market Interest Rate: Semiannual Interest Payment: Bond Selling Price: b) Market Interest Rate: Semiannual Interest Payment: Bond Selling Price: 2. Use the answer either "Premium" or "Discount" to the following items. The bond in (a) sold at a: The bond in (b) sold at a