FinancialLevel: ExpertAvailable in: Excel 2007+

MDURATION estimates the percentage price change for a 1% change in yield — the number fund managers quote.

Syntax

=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])

Examples

Example 1

=MDURATION(DATE(2021,4,1), DATE(2031,4,1), 7%, 7.5%, 2)

A little below DURATION — roughly the % price drop if yields rise 1%.

Related functions

DURATION · PRICE

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.