The rate that makes NPV zero.
A worked example
Starting figures
- Investment
- $100,000
- Yearly cash flow
- $28,000
- Years
- 5
What it returns
- IRR
- 12.38%
- Total received
- $140,000
How to read the results
With the defaults above, irr works out at 12.38%.
The rate that makes NPV zero.
IRR
12.38%
Total received
$140,000
With these inputs, IRR comes to 12.38% over 5 years. Total received works out to $140,000.
| Input | −10% | Now | +10% |
|---|---|---|---|
| Investment | 16.80% | 12.38% | 8.62% |
| Yearly cash flow | 8.23% | 12.38% | 16.36% |
| Years | 4.69% | 12.38% | 12.38% |
Save this set of inputs, change something, then save again to compare the outcomes side by side.
The rate that makes NPV zero.
With the defaults above, irr works out at 12.38%.