need know the coupon pyament and present value for all. please show the formula for excel/ steps

Bond valuation: Annual interest. Calculate the value of each of the bonds shown in the following table, all of which pay interest annua Solution Bond C Par value Coupon interest rate Years to maturity Required return Coupon payment Present value \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Bond D Par value Coupon interest rate Years to maturity Required return Coupon payment Present value \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Bond E Par value Coupon interest rate Years to maturity Required return Coupon payment Present value \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular}