Irr

The Irr function returns the internal rate of return for a series of periodic cash flows.

Usage:

	= Irr(<ranges_and_values>[,<guess>])

Ranges_and_values are a series of ordered cash flows.

Guess is your guess at what the rate will be. Guess is optional and assumed to be 10% if omitted with ranges. Using ranges is recommended when specifying a guess. The last argument will be the guess with values.

Example:

	/* returns 0.0866 */
	= Fixed(Irr(-70000, 12000, 15000, 18000, 21000, 26000, 10%), 4)