81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

MDURATION()

Description

Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

How To Use in Sheets

MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])

External Links

MDURATION Financial Function with Example in MS Office Excel Spreadsheet 2016

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.