IRR Function

Internal rate of return for a series of periodic cash flows


Description

The function IRR returns a value specifying the internal rate of return for a series of periodic cash flows (payments and receipts).


Syntax

IRR (ValueArray)

IRR (ValueArray, Guess)


Required Parameter

ValueArray

Array of specifying cash flow values. The array must contain at least one negative value (a payment) and one positive value (a receipt).

Optional Parameter

Guess

Object specifying value you estimate will be returned by IRR. If omitted, Guess is 0.1 (10 percent).