Manuals/calci/IRR
IRR(V, E)
Where 'V' is an array or a reference to cells and 'E' is a number that you guess is close to the result of IRR.
This function returns the internal rate of return for a series of cash flows represented by the numbers.
- The following formula demonstrates how NPV and IRR are related:NPV(IRR(B1:B6),B1:B6) equals 3.60E-08
IRR
Lets see an example,
IRR(V, E)
B
-25000
10000
11000
14000
18000
20000
=IRR(B2:B7) is 0.4259
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | -25000 | 0.4259 | ||
| Row2 | 10000 | |||
| Row3 | 11000 | |||
| Row4 | 14000 | |||
| Row5 | 18000 | |||
| Row6 | 20000 |
