XL: Use of the IRR Function in Excel (59616)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
This article was previously published under Q59616 SUMMARY
If you want to calculate the interest rate you would pay (or receive) for money borrowed (or invested), and the payments are made in either equal or unequal amounts at regular intervals, use the IRR (internal rate
of return) function in Microsoft Excel.
The IRR function is commonly used to compare one investment opportunity with another to determine the best rate of return.
REFERENCESFor more information about the IRR worksheet function, click Microsoft Excel Help on the Help menu, type irr worksheet function in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | kbhowto KB59616 |
---|
|