How To Calculate Macaulay Duration In Excel?
The formula used to calculate a bond’s modified duration is the Macaulay duration of the bond divided by 1 plus the bond’s yield to maturity divided by the number of coupon periods per year. In Excel, the formula used to calculate a bond’s modified duration is built into the MDURATION function. How do I calculate […]