DURATION
Returns the annual duration of a security with periodic interest payments
Syntax
DURATION(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
=DURATION("01/01/2024", "01/01/2034", 0.08, 0.09, 2, 1)