Excel’s MDURATION function returns the modifiedMacauley durationfor an assumed par value of $100.
Thesettlementdate is 15-Dec-2017, thematuritydate is 15-Sep-2027, and the day countbasisis US (NASD) 30/360.
The formula in F5 is:
and returns 7.55 years.
Entering dates
In Excel,dates are serial numbers.
To enter valid dates directly inside a function, you’re able to use theDATE function.
The DISC function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.
Thisarticle on Wikipediaprovides a detailed explanation of available conventions.
