Yancy Capital needs help pricing the following bonds in potential market conditions:

Please use EXCEL FUNCTIONS. Thank you.

Required: Fill out the worksheet below to price the bonds with the following market rates: \begin{tabular}{|l|r|} \hline 1. Market Rate & 6% \\ \hline 2. Market Rate & 12% \\ \hline 3. Market Rate & 8% \\ \hline \end{tabular}