please solve in excel and show formulas

\begin{tabular}{|c|c|c|c|} \hline d. & A & B & C \\ \hline 1 & \multicolumn{3}{|c|}{ Given } \\ \hline 2 & Today's Date & feb-05 & \\ \hline \multicolumn{4}{|c|}{3} \\ \hline 4 & Ford Motor Co. & & \\ \hline 5 & Coupon: & \multicolumn{2}{|l|}{6.38%} \\ \hline 6 & Matuirity: & \multicolumn{2}{|l|}{02/01/2029} \\ \hline 7 & Term to Matuirity & 24 & years \\ \hline 8 & Rating: & \multicolumn{2}{|l|}{ Baa1/BBB- } \\ \hline 9 & Price: & 927.87 & \\ \hline \multicolumn{4}{|c|}{10} \\ \hline 11 & General Motors Corp. & & \\ \hline 12 & Coupon: & \multicolumn{2}{|l|}{8.38%} \\ \hline 13 & Matuirity: & 7/15/2033 & \\ \hline 14 & Term to Matuirity & \multirow[b]{2}{*}{Baa/BBB} & years \\ \hline 15 & Rating: & & \\ \hline 16 & Price: & 1,061.25 & \\ \hline 17 & & & \\ \hline 18 & \multicolumn{3}{|c|}{ Solution } \\ \hline 19 & & Ford Motor Co. & General Motors \\ \hline 20 & Semi-annual YTM & & \\ \hline 21 & Annualized YTM & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline d. & A & B & C \\ \hline 1 & \multicolumn{3}{|c|}{ Given } \\ \hline 2 & Today's Date & feb-05 & \\ \hline \multicolumn{4}{|c|}{3} \\ \hline 4 & Ford Motor Co. & & \\ \hline 5 & Coupon: & \multicolumn{2}{|l|}{6.38%} \\ \hline 6 & Matuirity: & \multicolumn{2}{|l|}{02/01/2029} \\ \hline 7 & Term to Matuirity & 24 & years \\ \hline 8 & Rating: & \multicolumn{2}{|l|}{ Baa1/BBB- } \\ \hline 9 & Price: & 927.87 & \\ \hline \multicolumn{4}{|c|}{10} \\ \hline 11 & General Motors Corp. & & \\ \hline 12 & Coupon: & \multicolumn{2}{|l|}{8.38%} \\ \hline 13 & Matuirity: & 7/15/2033 & \\ \hline 14 & Term to Matuirity & \multirow[b]{2}{*}{Baa/BBB} & years \\ \hline 15 & Rating: & & \\ \hline 16 & Price: & 1,061.25 & \\ \hline 17 & & & \\ \hline 18 & \multicolumn{3}{|c|}{ Solution } \\ \hline 19 & & Ford Motor Co. & General Motors \\ \hline 20 & Semi-annual YTM & & \\ \hline 21 & Annualized YTM & & \\ \hline \end{tabular}