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])

0Better Sheets Tutorials

No videos yet. Stay tuned!