XIRR
Returns internal rate for irregular cash flows.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=XIRR(K1:K3, L1:L3) | K | L | |
|---|---|---|
| 1 | -100000 | 2026-01-01 |
| 2 | 30000 | 2026-06-01 |
| 3 | 40000 | 2026-12-01 |
Result -0.3926316839764362
Syntax
XIRR(values, dates, [guess])values- range required
dates- range required
guess- number optional
Errors
#VALUE!=XIRR(A1:A3, DATE(2026,1,15))
Related
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.