Excel Function : MDURATION

Download now!

Excel Function : MDURATION

Category

Financial

Description

Returns the Macauley modified duration for a security with an assumed par value of $100

Microsoft Excel Reference Page

https://support.office.com/en-us/article/MDURATION-function-b3786a69-4f20-469a-94ad-33e5b90a763c

Syntax and Description of the MDURATION Excel Function

The syntax for the MDURATION function in Microsoft Excel is: MDURATION( rate, yield, frequency, [basis] ) rate is the interest rate per period. yield is the yield per period. frequency is the number of compounding periods per year. [basis] is the type of day count basis to use.

About MDURATION Excel Function

The MDURATION function returns the modified duration of a security with semiannual coupon payments. MDURATION(settlement, maturity, rate, yld, freq, basis) The MDURATION function syntax has the following arguments: Settlement Required. The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. Maturity Required. The security's maturity date. The maturity date is the date when the principal amount of a security is due to be paid. Rate Required. The security's annual coupon rate. Yld Required. The security's annual yield. Freq Required.