Excel: Incorrect Example for MDURATION Function

• Microsoft Excel for Windows, version 4.0
• Microsoft Excel for the Macintosh, version 4.0

SUMMARY

The example for the MDURATION function on page 272 of the version 4.0 "Microsoft Excel Function Reference" is incorrect. The example uses incorrect serial numbers and percentages.

MORE INFORMATION

The example states that the settlement date is January 1, 1986, and that the maturity date is January 1, 1994. The serial numbers that are used in the arguments are incorrect.

The example uses 33239 which is the serial number for January 1, 1991, and it uses 36631 which is the serial number for April 15, 2000.

The listed coupon rate is 8-percent with the yield being 9-percent. However, the arguments for the coupon rate and yield are entered as "0.8" and "0.9". These numbers must be entered as either ".08" and ".09" (without the quotation marks) or as "8%" and "9%" (without the quotation marks). If the arguments in the example are entered, the MDURATION will return the value ".962958" (without the quotation marks). For Microsoft Excel to return the value 5.73567 (the value that is given in the book), the function must be entered as:

   MDURATION(31413,34335,.08,.09,2,1) 

REFERENCES

"Microsoft Excel Function Reference," version 4.0, Pages 271-272

Additional query words: wrong

Keywords :
Version :
Platform :
Issue type :