PV and Modified Duration of Bond A and B.

Please show excel formula if able!

\begin{tabular}{|c|c|c|c|c|c|} \hline & Face Value & Term (yrs) & Coupon \% & Frequency & Current \% \\ \hline Bond A: & 1,000 & 5 & 5.75 & Annual & 5.95% \\ \hline Bond B & 1,000 & 4 & 4.75 & Annual & 5.25% \\ \hline What is the present value of Bond A? & & & Bond B: & & \\ \hline What is the modified duration of Bond A: & & Bond B: & & & \\ \hline \end{tabular}