Functions

DURATION

Macaulay duration

Try it

When to use it

When should I use DURATION?

Use DURATION (Macaulay duration) to measure a bond's weighted-average time to receive cash flows — the foundation for assessing interest-rate sensitivity.

Used in

finance

Syntax

DURATION(settlement, maturity, coupon, yld, frequency, [basis])

Examples

=DURATION(DATE(2010,1,2),DATE(2039,12,31),0.03,1.2,2) // => 1.3277777784097888
=DURATION(DATE(2010,1,2),DATE(2039,12,31),0.03,1.2,2,1) // => 1.3278084720868903

DSUM

Sum of field values for rows matching criteria

DVAR

Sample variance of field values for rows matching criteria