Financial
IRR
Internal rate of return.
Syntax
IRR(values, [guess])Example: =IRR(B3:B8)
Available in: All versions
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =IRR(B2:B6)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Year | Cash flow | Result | |
| 2 | 0 | -10000 | 0.151064041897 | |
| 3 | 1 | 3000 | ||
| 4 | 2 | 4000 | ||
| 5 | 3 | 4500 | ||
| 6 | 4 | 2500 |
Result in D2: 0.151064041897