IRR
Returns the internal rate of return for a series of cash flows.
FinancialFinance & Accounting
What it does
Calculates the Internal Rate of Return for cash flows.
Syntax
IRR(values, [guess])
Arguments
values(range) — Range of cash flows (must contain at least one negative and one positive).
Examples
Internal Rate of Return
Calculate IRR for cash flows.
FORMULA
=IRR(A2:A5)
RESULT
0.1
SAMPLE DATA
| A | |
|---|---|
| 1 | Cash Flow |
| 2 | -1000 |
| 3 | 200 |
| 4 | 400 |
| 5 | 600 |