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!

Calculator Preferences
Internal Rate of Return Calculator Sign
Internal Rate of Return Calculator

This calculator will calculate the internal rate of return (IRR) on an investment where deposits and withdrawals occur at regular intervals, but the amounts vary. The calculator will execute up 100,000 trials and errors in order to find an annual rate that will solve for the schedule of payments and income. The results include a printable chart showing the future value of each cash flow at the calculated rate. The Learn tab includes brief answers to:

  • What is IRR?
  • What is IRR Function and how does it work?
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
Interval:Cash flow interval:Cash flow interval:Cash flow interval:

Cash flow interval:

Select the frequency at which the regular cash flows occurred or will occur.

Initial investment month & year:Initial invesment month & year:Month and year of initial investment:Month and year of initial investment:

Month and year of initial investment:

Indicate the beginning time period of the initial investment by selecting the applicable month and entering the 4-digit year.

# periods:# of periods:Number of periods to include:Number of cash flow periods to include in form:

Number of periods to include in form:

Enter the number of periods you would like included in the outflow/inflow form. Note that if you make changes to this field after creating and/or completing the cash flow entry form, the entry form will be cleared. So feel free to enter more periods than you think you might need as the calculator will simply ignore any extra blank periods.

Period entry column:

This column will be automatically populated with the time periods based on the selections/entries in the first two lines of the IRR Calculator.

Investments entry 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, without dollar signs or commas). Note that numbers entered in this column are usually entered as negative values when using an IRR spreadsheet function, however this IRR Calculator converts the values to negative for you.

Withdrawals & End Value column:

For time periods where withdrawals occurred, enter the amounts in this column. If no cash flow occurred in an interim time period you can either enter a zero or leave the field blank. You must have at least one value in this column for the IRR calculation to begin. Enter as positive values, without dollar signs or commas.

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.

# periods:# of periods:Number of regular time periods:Number of regular time periods:

Number of regular time periods:

This is the total number of time periods that were included in the calculations.

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 IRR 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.