IRR

**Syntax:** **IRR( G, F)**

*G* = a numeric value

*F* = cash flow, represented by a range

**IRR** returns the internal rate of return on an investment
given a set cash flows contained in range *F*, and an
initial ``guess'' *G* (usually 0). *F* must contain at least
two cash flow values. Negative cash flows represent
expenditures, and positive cash flows represent income.
Blanks and text are treated as zeros.

**Examples:**

**IRR**(0, L2..L6) = -0.32606171, where L2..L6 = -80, 90, 67,
72, and -90

**IRR**(0, I5..I9) = 1.0462142, where I5..I9 = -700, 750,
900, 600 and 850

**IRR**(0, -200, 100, 300) = ERROR: too many arguments to
function

**Excel function:** *N/A*

Grey Trout Software

02 March 2003