MDURATION
Returns the Macauley modified duration for a security with an assumed par value of $100.
FinancialFinance & Accounting
What it does
Calculates modified Macaulay duration.
Syntax
MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.
Examples
Modified Duration
Calculate duration.
FORMULA
=MDURATION(A2, B2, 0.08, 0.09, 2)
RESULT
5.6
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 2023-01-01 | 2030-01-01 |