Excel: Incorrect Example for MDURATION Function

 Last reviewed: November 30, 1994
Article ID: Q93253
The information in this article applies to:
  • 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)
Where 31413 is the serial number for January 1, 1986, and 34335 is the serial number for January 1, 1994.

REFERENCES

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

KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 4.0 4.00 wrong

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.