Gallery
About Financial Essentials
Share
Explore
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

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.