Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel VB Language Reference > Methods Reference for Siebel VB > Financial Methods > Calculate Internal Rate of Return MethodThe Calculate Internal Rate of Return method calculates, and then returns the internal rate of return for a stream of periodic cash flows. This method is iterative. It improves a guess over multiple iterations until the result is within 0.00001 percent. If it does not converge to a result in 20 iterations, then it displays a failure message. FormatFor more information, see Arguments You Can Use with Financial Methods. ExampleThe following example calculates an internal rate of return for a series of income and cost business transactions. It expresses this rate of return as an interest rate percentage. If the first value entered is a positive amount, then the IRR statement creates an Illegal Function Call error: Sub Button_Click |
![]() ![]() |
Siebel VB Language Reference | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |