give an example of how to do this on excel

Bond Duration Project (Example) Macaulay Duration determines the weighted-average number of years until an investment is recovered You purchases a 5 -year Bond at face value ($1,000) with a 6 percent coupon \begin{tabular}{|r|r|r|r|l|} \hline \multicolumn{2}{|c|}{4.50%} & & \\ \hline \\ \hline \end{tabular} Duration of the Bond (D)=4,779.28/1,065.85=4.4840 years Input to calculate PV for each cash flow =(RATE,NPER,FV) For example: year 1,PV=(B5,A10,B10) NOTES 1. The PV of the the cash flows are not negative. The negative shows that the purchasing power of the cash flows from the bond decreases each year 2. Duration of the bond is determine by dividing the sum of time-weighted PV of the cash flows by the current market price tof the bond