IRR(G, F)

 

Description

This function returns the internal rate of return on an investment given a set of 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.

 

Parameters

 

G

A numeric value.

 

F

Cash flow, represented by a range.

 

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.