In relation to the bonds listed above, please calculate the PVBP, Duration, and Convexity while also showing the excel formulas to do so

\begin{tabular}{|l|r|r|r|l|l|} \hline & Coupon & Date of Maturity & Type of Coupon & Currency & Credit Rating \\ \hline Emera US Finance LP (Bond A) & 0.83% & 06-Jun-24 & Semi-Annual & USD & BBB- \\ \hline Emera US Finance LP (Bond B) & 4.00% & 15 -Jun-29 & Semi-Annual & USD & A- \\ \hline Emera US Finance LP (Bond C) & 2.64% & 01-Jun-31 & Semi-Annual & USD & BBB- \\ \hline Emera US Finance LP (Bond D) & 4.75% & 01-Jun-46 & Semi-Annual & USD & BBB- \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|r|r|} \hline & Price (Feb 1) & Par & YTM & PVBP & Duration & Convexity \\ \hline Emera US Finance LP (Bond A) & 98.522 & $100.00 & 2.33% & & & \\ \hline Emera US Finance LP (Bond B) & 99.981 & $100.00 & 4.00% & & & \\ \hline Emera US Finance LP (Bond C) & 99.054$100.00 & 2.77% & & \\ \hline Emera US Finance LP (Bond D) & 78.417 & $100.00 & 6.59% & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|l|l|} \hline & Coupon & Date of Maturity & Type of Coupon & Currency & Credit Rating \\ \hline Emera US Finance LP (Bond A) & 0.83% & 06-Jun-24 & Semi-Annual & USD & BBB- \\ \hline Emera US Finance LP (Bond B) & 4.00% & 15 -Jun-29 & Semi-Annual & USD & A- \\ \hline Emera US Finance LP (Bond C) & 2.64% & 01-Jun-31 & Semi-Annual & USD & BBB- \\ \hline Emera US Finance LP (Bond D) & 4.75% & 01-Jun-46 & Semi-Annual & USD & BBB- \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|r|r|} \hline & Price (Feb 1) & Par & YTM & PVBP & Duration & Convexity \\ \hline Emera US Finance LP (Bond A) & 98.522 & $100.00 & 2.33% & & & \\ \hline Emera US Finance LP (Bond B) & 99.981 & $100.00 & 4.00% & & & \\ \hline Emera US Finance LP (Bond C) & 99.054$100.00 & 2.77% & & \\ \hline Emera US Finance LP (Bond D) & 78.417 & $100.00 & 6.59% & & & \\ \hline \end{tabular}