Gallery
About Financial Essentials
Share
Explore
Gallery
About Financial Essentials
Sample Uses

icon picker
XIRR

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

Calculate XIRR

XIRR
1
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
1/4/2019
-$100,000
​
2
1/2/2020
$1,000
​
3
2/4/2021
$1,200
​
4
1/15/2022
$1,500
​
5
1/30/2023
$1,800
​
6
1/2/2024
$2,000
​
7
3/2/2025
$2,200
​
8
2/7/2026
$2,500
​
9
1/10/2027
$2,700
​
10
2/2/2028
$3,000
​
11
1/12/2029
$600,000
​
There are no rows in this table
⁠

Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.