Description
The Excel Mduration function calculates the modified Macaulay Duration of a security that pays periodic interest, assuming a par value of $100.
The syntax of the function is :
MDURATION( settlement, maturity, coupon, yld, frequency, [basis] )
Where the arguments are as follows:
The following spreadsheet uses the Excel Mduration function to calculate the modified Macaulay Duration of a security that with a settlement date 01-Apr-2010, a maturity date 31-Mar-2020 and a yield of 8%. The coupon rate is 10% and payments are made quarterly.
Mduration Function Errors
If you get an error from the Mduration function, this is likely to be one of the following:
Common Errors
No comments:
Post a Comment