please show step by step of equation of coupon payment and present value equation and how to insert into Microsoft excel and show work by hand too.

Problem 6-20 Bond valuation: Annual interest. Calculate the value of each of the bonds shown in the following table, all of which pay interest mnexgly. Important: Do not use cell references to cells in rows 6 to 10. For all required answers, use cell references to values starting in row 15. \begin{tabular}{|c|r|r|r|r|} \hline Bond & Parvalue & Couponinterest & Yearstomaturity & \multicolumn{1}{|c|}{Requiredreturn} \\ \hline A & 1,000 & 11% & 20 & 12% \\ \hline B & 1,000 & 8 & 16 & 8 \\ \hline C & 100 & 9 & 8 & 7 \\ \hline D & 500 & 6 & 13 & 8 \\ \hline E & 1,000 & 7 & 10 & 5 \\ \hline \end{tabular} Solution Bond A Parvalue Couponinterestrate Years to maturity Required return Coupon payment Present value Bond B Par value Couponinterest rate Years to maturity Required return Coupon payment Present value \begin{tabular}{|r|} \hline 1,000 \\ \hline 11% \\ \hline 20 \\ \hline 12% \\ \hline \\ \hline \end{tabular} Bond C Par value Coupon interestrate Yearstomaturity Required return Coupon payment Present value Bond D Par value Coupon interestrate Years to maturity Required return Coupon payment Present value Bond E Parvalue Couponinterest rate Years tomaturity Required return Coupon payment Present value \begin{tabular}{|r|} \hline \multirow{2}{*}{100} \\ \hline 9% \\ \hline 8 \\ \hline 7% \\ \hline \\ \hline \end{tabular} \begin{tabular}{|r|} \hline$500 \\ \hline 6% \\ \hline 13 \\ \hline 8% \\ \hline \\ \hline \end{tabular}