The project is spreadsheet problems solving. It is necessary to turn in soft copy of the excel solution. It should be well organized and easy to follow.

question) A treasury bond that settles on November 18, 2013, matures on April 30, 2032. The coupon rate is 6.3 percent and the bond has a 5.45 yield to maturity. What are the Macaulay duration and modified duration?

Note: please guide me with excel formula also so I can put with it. thank you