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