Excel: INTRATE() Function Uses Simple InterestLast reviewed: August 20, 1995Article ID: Q89942 |
The information in this article applies to:
SUMMARYIn Microsoft Excel, the INTRATE() function returns the interest rate for a fully invested security. This function uses simple interest rather than compound interest to compute the interest rate.
MORE INFORMATIONThe INTRATE() function has a special use for fully invested securities. The interest rate returned is prorated (or inversely prorated) to the number of days between redemption and settlement. This function cannot be modified to take into account compounding interest. To compute compound interest we have to know the settlement, the redemption, the first payment day and the frequency of payments. Compounding between two dates does not make sense without this additional information. INTRATE() estimates an average rate over the period of time. You can use NOMINAL() to approximate the rate without knowing the number of periods between the two dates.
REFERENCESOnline Help, version 5.0, INTRATE function "Function Reference," version 4.0, pages 245-246, 286-287 For more information about the INTRATE function, choose the Search button in Microsoft Excel Help and type:
INTRATE function |
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |