Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: MDURATION function

MDURATION function: Description, Usage, Syntax, Examples and Explanation

What is MDURATION function in Excel? MDURATION function is one of the Financial functions in Microsoft Excel that returns the modified Macauley duration for a security with an assumed par value of $100. Syntax of¬†MDURATION function MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) The MDURATION function syntax has the following arguments: Settlement:¬† The security’s settlement date. The security settlement date is…