next up previous contents index
Next: ISERR, ISERROR Up: A. Function Reference Previous: IPMT, XLIPMT   Contents   Index


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


next up previous contents index
Next: ISERR, ISERROR Up: A. Function Reference Previous: IPMT, XLIPMT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003