XIRR
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
FinancialFinance & Accounting
What it does
Calculates IRR for irregular intervals.
Syntax
XIRR(values, dates, [guess])
Arguments
values(range) — Cash flows.dates(range) — Dates of flows.
Examples
Irregular IRR
Calculate return.
FORMULA
=XIRR(B2:B4, A2:A4)
RESULT
0.38
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Date | Flow |
| 2 | 2023-01-01 | -1000 |
| 3 | 2023-06-01 | 500 |
| 4 | 2024-01-01 | 800 |