I need help solving for yield, shift price, DV01, shock price (100bp), and shock change(100bp). please and thank you!

THIS IS IN EXCEL.

\begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline \multicolumn{7}{|l|}{1} \\ \hline 2 & & & & & & \\ \hline 3 & Global Inputs & & & & & \\ \hline 4 & Settlement & 10/5/23 & & & & \\ \hline 5 & Shift bp & 1 & & & & \\ \hline 6 & Shock bp & 100 & & & & \\ \hline 7 & & & & & & \\ \hline 8 & Bond Inputs & & & & & \\ \hline 9 & Bond Name & 2 year & 5year & 10 year & 20year & 30 year \\ \hline 10 & Maturity & 8/15/25 & 8/15/28 & 8/15/33 & 5/15/43 & 8/15/53 \\ \hline 11 & Coupon & 5.000% & 4.625% & 3.875% & 2.000% & 4.125% \\ \hline 12 & Price & 99.00 & 99.00 & 92.50 & 62.00 & 87.00 \\ \hline 13 & & 2 year & Syear & 10 year & 20 year & 30 year \\ \hline 14 & Yield & & & & & \\ \hline 15 & ShiftPrice & & & & & \\ \hline 16 & 5 DV01 & & & & & \\ \hline \begin{tabular}{l} 17 \\ 18 \end{tabular} & \begin{tabular}{l} ShockPrice (100bp) \\ ShockChange (100bp) \end{tabular} & & & & & \\ \hline 19 & & & & & & \\ \hline \end{tabular}