i need a step by step showing calculations. As well as how to input into excel using the fuctions cells of excel. like =pv(D8,D9...)

Bond X is a premium bond making semiannual payments. The bond pays a 9 percent coupon, has a YTM of 7 percent, and has 13 years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a 7 percent coupon, has a YTM of 9 percent, and also has 13 years to maturity. What is the dollar price of each bond today? If interest rates remain unchanged, what do you expect the price of these bonds to be one year from now? In three years? In elght years? In 12 years? Complete the following analysis. Do not hard code values in your answers. Complete the following analysis. Do not hard code values in your answers. \begin{tabular}{c} Price of Bond X \\ \hline Maturity (years) \\ 13 \\ 12 \\ 10 \\ 5 \\ 1 \end{tabular} \begin{tabular}{|c|} \hline Price of Bond Y \\ Maturity (years) \\ 13 \\ 12 \\ 10 \\ 10 \\ 5 \\ 1 \end{tabular}