Please answer using all excel formulas.

ard OM 3. Compute the PVBP, McCauley's Duration and Modified Duration for the following bonds. Settlement date is September 29, 2017. Explain why the duration differs (if any) for bonds with the same maturity date. Maturity Coupon Bid Asked 11/15/2017 11/15/2017 11/30/2017 11/30/2017 11/30/2017 1/31/2018 1/31/2018 1/31/2018 6/30/2018 6/30/2018 6/30/2018 7/15/2018 0.875 99.9922 100.0078 4.25 100.375 100.3906 0.625 99.9219 99.9375 0.875 99.9609 99.9766 2.25 100.1797 100.1953 0.75 99.8828 99.8984 0.875 99.9297 99.9453 2.625 100.4922 100.5078 0.625 99.5156 99.5313 1.375 100.0547 100.0703 2.375 100.7734 100.7891 0.875 99.6563 99.6719 Asked yield 0.6595 1.6316 0.5213 0.6799 1.2822 0.6716 0.7675 1.8212 0.6143 1.2712 2.0302 0.8451