IRR
Returns the internal rate of return for a series of cash flows
Syntax
IRR(values, [guess])
Parameters
- values: Required. An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return
- guess: Optional. A number that you guess is close to the result of IRR (default 0.1)
Example
=IRR({-70000, 12000, 15000, 18000, 21000, 26000})