I will personally mail you a cookie if you can help me out

\begin{tabular}{|c|c|c|} \hline Face Value: & $ & 500,000 \\ \hline Number of Years: & & 30 \\ \hline Stated Interest Rate: & & 7% \\ \hline Interest payments per year & & 2 \\ \hline \end{tabular} (Note: the bonds pay interest semi-annually.) Required: 1) Given the different market interest rates below, calculate the following items. Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all function arguments as cell references. a) Market Interest Rate: Semiannual Interest Payment: Bond Selling Price: b) Market Interest Rate: Semiannual Interest Payment: Bond Selling Price: \begin{tabular}{|r|} \hline 9% \\ \hline \\ \hline \end{tabular} 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: \begin{tabular}{|c|} \hline \\ \hline \\ \hline \end{tabular}