calcy treasure chest of featuresLove the calculators but not the ads?

Take a sneak peek at the Ad-Free Design being enjoyed by hundreds of members for less than 25¢ a week. Full details and a bonus!

XIRR Calculator to Calculate IRR of Non-Periodic Cash Flows

Calculator Preferences
XIRR Calculator Sign
XIRR Calculator

This calculator will calculate the internal rate of return (IRR) on an investment where deposits and withdrawals occur at irregular intervals. The calculator will perform up to 100,000 iterations in order to find a rate that will solve for the schedule of deposits and payments. Also includes a printable chart showing the future value of each cash flow at the calculated rate.

Learn More

Selected Data Record:

A Data Record is a set of calculator entries that are stored in your web browser's Local Storage. If a Data Record is currently selected in the "Data" tab, this line will list the name you gave to that data record. If no data record is selected, or you have no entries stored for this calculator, the line will display "None".

DataData recordData recordSelected data record: None
Enter Cash Flows

Enter Cash Flows:

To add a cash flow, Enter/select the date, amount, and direction and then tap the + button (may also appear as "Add" or "Add Cash Flow" depending on the width of your device).

To edit a cash flow, tap the radio button in the Edit column. This will load the cash flow into the form for editing. When you're satisfied with the changes you've made, tap the S button (may also appear as "Save" or "Save Changes" depending on the width of your device).

To delete a cash flow from the list, tap the radio button in the Edit column. This will load the cash flow into the form for deleting. Tap the button (may also appear as "Delete" depending on the width of your device).

To clear the form to create a new cash flow, tap the C button (may also appear as "Clr" or "Clear" depending on the width of your device).

Important! The entered cash flows are saved in your device's random memory (temporary storage), which means that if you surf to another calculator or close this browser window you will need to re-enter your cash flows.

Cash flow date:

Cash flow date:

Select the applicable month and day and enter the 4-digit year of the date the cash flow occurred on. You can enter the cash flows in any order as the calculator will sort the list of cash flows by date, from oldest to newest, and will assume the oldest was the initial investment.

Amount:Cash flow amt:Cash flow amount:Cash flow amount:

Cash flow amount:

Enter the amount of the cash flow. Enter as a positive dollar amount, but without the dollar sign and any commas. Use the next line to indicate whether or not the cash flow was an outflow (investment) or an inflow (return).

Direction:Direction:Cash flow direction:Cash flow direction:

Cash flow direction:

Select the cash flow direction. Select "Out" if the cash flow was an investment or expense. Select "In" if the cash flow was a receipt, as in a dividend or withdrawal.

Profit (-Loss):Profit (-Loss):Profit (-Loss):Profit (-Loss):

Profit (-Loss):

The is the sum of all withdrawals and the ending value minus the sum of all invested amounts.

# flows:# cash flows:Number of cash flows:Number of cash flows:

Number of cash flows:

This is the total number of entered cash flows that were included in the calculations.

# days:# of days:Number of days:Number of days:

Number of days:

This is the number of days between the date of the beginning value and the date of the ending value.

Balance:Calculated balance:Calculated balance:Calculated balance:

Calculated balance:

The closer this result is to zero, the more accurate the Internal Rate of Return result.

Iterations:# iterations:Number of iterations:Number of iterations:

Number of iterations:

This is the number of secondary iterations (tries) it took to find a rate of return that would support the entered schedule of investments and withdrawals. If this result is equal to 100,000 it means the XIRR Calculator reached its limit of tries before finding a solution within +/- $0.05 of a zero balance.

IRR:IRR:Internal Rate of Return:Internal Rate of Return:

Internal Rate of Return:

This is the estimated average annual rate of return of the entered cash flows.

If you would like to save the current entries to the secure database, tap or click on the Data tab, select "New Data Record", give the data record a name, then tap or click the Save button. To save changes to previously saved entries, simply tap the Save button. Please select and "Clear" any data records you no longer need.

Feedback AppreciatedFeedback Greatly AppreciatedYour Feedback Would Be Greatly AppreciatedYour Feedback Is Greatly Appreciated
Heading

Tip

Help and Tools

Help and Tools:

This section, which you can Unstick or Hide in the Calculator Preferences (just above the top of the calculator), contains the following tabs (content too long to fit within bordered frame can be scrolled up and down):

About: Click this tab for an introduction to the calculator.

Instructions: Click this tab for step-by-step instructions for using the calculator.

Terms: Click this tab for a list of the descriptions that are located within each popup help button (info icons).

PCalc: Click this tab for a handy "pocket" calculator you can use when you need to calculate an entry needed for the calculator.

Data: Click this tab to save a set of entries or a note in between visits. Entries and notes will be stored to your web browser's local storage (if supported by your browser of choice), meaning they can only be recalled with the same device and web browser you were using when you saved them. If you'd like to save entries and notes between devices you can do so by subscribing to the Ad-Free Member Version.

 

Favorites

Add or remove this page to/from my favorites.

Adjust Calculator Width:

Move the slider to left and right to adjust the calculator width. Note that the Help and Tools panel will be hidden when the calculator is too wide to fit both on the screen. Moving the slider to the left will bring the instructions and tools panel back into view.

Also note that some calculators will reformat to accommodate the screen size as you make the calculator wider or narrower. If the calculator is narrow, columns of entry rows will be converted to a vertical entry form, whereas a wider calculator will display columns of entry rows, and the entry fields will be smaller in size ... since they will not need to be "thumb friendly".

Show/Hide Popup Keypads:

Select Show or Hide to show or hide the popup keypad icons located next to numeric entry fields. These are generally only needed for mobile devices that don't have decimal points in their numeric keypads. So if you are on a desktop, you may find the calculator to be more user-friendly and less cluttered without them.

Stick/Unstick Tools:

Select Stick or Unstick to stick or unstick the help and tools panel. Selecting "Stick" will keep the panel in view while scrolling the calculator vertically. If you find that annoying, select "Unstick" to keep the panel in a stationary position.

If the tools panel becomes "Unstuck" on its own, try clicking "Unstick" and then "Stick" to re-stick the panel.