Bookshelf Home | Contents | Index | PDF |
Siebel VB Language Reference > VB Language Reference > IRR FunctionThis standard VB function returns the internal rate of return for a stream of periodic cash flows. SyntaxReturnsThe internal rate of return for a stream of periodic cash flows. UsageValuearray( ) must have at least one positive value (representing a receipt) and one negative value (representing a payment). Payments and receipts must be represented in the exact sequence. The value returned by IRR varies with the change in the sequence of cash flows. In general, a guess value of between 0.1 (10 percent) and 0.15 (15 percent) is a reasonable estimate. IRR is an iterative function. It improves a given guess over several iterations until the result is within 0.00001 percent. If it does not converge to a result within 20 iterations, it signals failure. ExampleThis example calculates an internal rate of return (expressed as an interest rate percentage) for a series of business transactions (income and costs). The first value entered must be a negative amount, or IRR generates an "Illegal Function Call" error. Sub Button_Click See AlsoFV Function |
Siebel VB Language Reference |