MDURATION
Returns the Macauley modified duration for a security with an assumed par value of $100
Syntax
MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- coupon: Required. The security's annual coupon rate
- yld: Required. The security's annual yield
- frequency: Required. The number of coupon payments per year
- basis: Optional. The type of day count basis
Example
=MDURATION("01/01/2024", "01/01/2034", 0.08, 0.09, 2, 1)