Skip to content
About Financial Essentials
  • Pages
    • Welcome
    • Support
    • All Formulas
    • Sample Uses
      • Loan Calculator
      • Loan Amortization Schedule
      • NPV
      • IRR
      • icon picker
        XIRR
    • Sample Docs
    • Terms of Service
About Financial Essentials
/
/
XIRR
Share
Explore

XIRR

Determine the extended internal rate of return for a series of dates and cash flows

Calculate XIRR

XIRR
20.38%
There are no rows in this table
⁠

List the dates and cash flows to be analyzed:
There must be a date for each cash flow
Use negative numbers for outflows and positive numbers for inflows
You may paste numbers into the Dates and Cash Flow columns from another source; the number of rows will expand to accommodate the number of rows pasted
Delete unused rows

⁠
Clear Cash Flow Table
⁠
Delete Empty Rows
⁠
⁠
Date
Cash Flow
Notes
1/4/2019
-$100,000
​
1/2/2020
$1,000
​
2/4/2021
$1,200
​
1/15/2022
$1,500
​
1/30/2023
$1,800
​
1/2/2024
$2,000
​
3/2/2025
$2,200
​
2/7/2026
$2,500
​
1/10/2027
$2,700
​
2/2/2028
$3,000
​
1/12/2029
$600,000
​
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.