XIRR Calculator to Calculate
IRR of Non-Periodic Cash Flows

[ Skip to Calculator ] Calcy pointing down

The XIRR Calculator on this page will instantly calculate the internal rate of return for up to 20 cash flows with different dates.

Do you have an investment that has the following characteristics?

- Fluctuating interest rate

- Irregular investment intervals

- Irregular withdrawal intervals

If you do, my next question is, do you know how to determine the average annual return on your investment so you can compare the rate of return to other investments?

If you answered, "yes, by using the XIRR Function in a spreadsheet", then to you I say congratulations!

On the other hand, if the mere thought of trying to determine the rate of return on this type of an investment gives you an instant headache, then you're going to love the calculator on this page.

The XIRR Calculator on this page makes determining the rate of return a snap.

Simply enter the date and amount of the initial investment, then the dates and amounts of all subsequent investments and withdrawals, then click the "Calculate XIRR" button.

How the XIRR Calculator Works

The XIRR Calculator uses a trial and error method of determining the rate of return for a non-periodic schedule of investments and withdrawals -- which is similar to the XIRR function used in spreadsheet applications such as Excel™, OpenOffice Calc, GoogleDocs, etc.

Specifically, this calculator begins by assuming the annual rate of return is -100%, and then increases the rate of return by 1% until the combined future value of the cash flows is greater than zero.

From there the calculator keeps subtracting .0001% from the "guess" until the combined cash flows is within +/- $0.50 of zero.

Up To 100,000 Tries!

Each time the calculator adjusts the guess and recalculates the combined future values of all cash flows, this is referred to as one iteration or one try. Believe it or not, the calculator will perform up to 100,000 of these iterations before it stops trying to find an acceptable solution.

Plus, unlike other online XIRR calculators, this calculator will even display a printable chart showing the future value of each cash flow -- which will help confirm or deny the validity of the calculated internal rate of return.

Finally, if you're not sure what is meant by "Internal Rate of Return" (IRR), please visit the IRR Calculator for an explanation.

With that, let's use the XIRR Calculator to calculate the average annual rate of return for cash flows occurring at irregular intervals.

XIRR Calculator
Calcy sign introducing XIRR Calculator

Instructions: Enter the month, day, year, and amount of the initial investment. All subsequent cash flows must be dated later than the beginning date entered on the first line, but they need not be entered in the order they occurred.

Next, for each cash flow, enter the month, day, year, and either an additional investment amount or a withdrawal amount. Note that the beginning value and at least one withdrawal or ending value must exist before the calculator will begin the IRR calculation.

Once you have all cash flows entered, click the "Calculate XIRR" button. If the Number of iterations result is equal to 100,000, this means the iteration limit was reached before the calculator found a solution within +/- $0.50 of the ending value. The Calculated balance result will indicate how close the calculations got to zero before reaching the limit.

Mouse over the blue question marks for a further explanation of each entry field. More in-depth explanations can be found in the glossary of terms located beneath the XIRR Calculator.

& End Value
<< Begin Value
Help Profit (-Loss):
Help Number of cash flows:
Help Number of days:
Help Calculated balance:
Help Number of iterations:
Help Internal Rate of Return:
Please grade my work and help me improve:
If you liked this page, please share it, or give it a Like, +1, Tweet, or Pin.
calcy image pointing right

XIRR Calculator Glossary of Terms

Calcy magnifying glass

Check Out My Other Super
Investment Calculators
To Help You To
Calculate Your ...
Super Calcy

Month column: Enter the month of the year (1-12) the cash flow took place (no leading zero required for single digits). The Month field of the first line, plus at least one other line, must be completed.

Day column: Enter the day of the month (1-31) the cash flow took place (no leading zero required for single digits). The Day field of the first line, plus at least one other line, must be filled in.

Year column: Enter the 4-digit year (YYYY) the cash flow took place. The Year field of the first line, plus at least one other line, must be filled in.

Investments column: Enter the starting investment amount on the first line and then on any subsequent lines where additional amounts were invested (enter as positive values). Note that numbers entered in this column are usually entered as negative values when using an XIRR spreadsheet function, however this calculator converts the values to negative for you.

Withdrawals & End Value column: For cash flow dates where withdrawals occurred, enter the amounts in this column. Once you have entered all cash flows, use the next available line to enter the ending value (the amount you withdrew -- or could withdraw -- at the end of the investment period) along with the corresponding month, day, and year. You must have at least one value in this column for the IRR calculation to begin.

Profit (-Loss): The is the sum of all withdrawals and the ending value minus the sum of all invested amounts.

Number of cash flows: This is the total number of entered cash flows that were included in the calculations. If this number is less than the actual, check to see if all entered cash flows have the month, day, and year filled in, along with a value in one of the two right-hand columns.

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

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

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

Internal Rate of Return: This is the estimated average annual rate of return of the entered cash flows.

[ Return to Top of Calculator ] [ Return to Top of Page ] Calcy pointing up

> > XIRR Calculator

+1 Free-Online-Calculator-Use.com
+1 Page Site

Protected by Copyscape Online Plagiarism Detection
Calcy with money image
Top Ten Home
Money Calculators

Follow me on any of the social media sites below and be among the first to get a sneak peek at the newest and coolest calculators that are being added or updated each month.

Monthly What's New Email Update!

Who knows if I will show up in your next search. This will insure you'll always know what I've been up to and where you can find me!

* indicates required
Online Pocket Calc