Question

Find the duration of a bond with settlement date June 10, 2016, and maturity date December 13, 2025. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.