Internal rate of return for a series of periodic cash flows
The function IRR returns a value specifying the internal rate of return for a series of periodic cash flows (payments and receipts).
IRR (ValueArray)
IRR (ValueArray, Guess)
ValueArray
Array of specifying cash flow values. The array must contain at least one negative value (a payment) and one positive value (a receipt).
Guess
Object specifying value you estimate will be returned by IRR. If omitted, Guess is 0.1 (10 percent).