Internal Rate of Return (IRR) Calculator

Please note that this is a simple calculation and the author will not be held responsible for any claims that result out of the use

of the calculator. Contact a financial advisor if you need assistance.

You can get a full working copy in Excel with additional features from

IRR Calculator

Fill in all the blue cells and then look at/ print the summary at the bottom

Guess an IRR (helps the process)

We have left some sample numbers in the cells to show you what to do. Delete them and put in your own dates and cash flows

Resultant IRR=

Name=

Date of Cash Flow

Outflow (negative number)

Inflow (positive number)

Net Cash Flow

Cumulative IRR

Cumulative Cash Flows

Calendar

END

Cash Outflows

Cash Inlows

Net Cash Position

Start Date

End Date

Number of years

Resultant IRR

Please fill all required fields