Free IRR Internal Rate of Return Calculator Tool

This IRR Calculator allows the user to measure the IRR of 3 separate projects. The internal rate of return (IRR) is a capital budgeting metric used by people to decide whether they should make an investment in the project. It is an indicator of the efficiency or quality of an investment.

Examples of IRR’s can be found on our financial projections, investor business plans and bank business plans. Let us know if you are looking for a business plan writer and business plan consultants.

The IRR tool calculator (just like the one on this page) can be purchased and downloaded in Microsoft Excel for only $6. Please follow the link below to purchase this tool. Following your payment, you will be emailed the tool in Excel.

Inputs:

Investment: This number must always be negative. It is the amount of investment required to do the project.
Year 1 to 24: These are the inputs for the cash flows seen from the original investment.

Samples:
Project 1: This project shows an investment of $12 million. Cash flows are scattered from year 1 to year 7. This project creates an IRR of 13.76%. This means that the project created on average 13.76% return per year for 7 years.

Project 2: This project has an investment of $8 million. Years 1 to 9 provide $0 in cash flow then $4 million comes in years 10. Years 11 to 19 have $0 for cash flow followed by a large lump sum of $50 million in year 20. This means that the project created on average 10.70% return per year for 20 years.

Project 3: This project has an investment of $8 million. Similar to Project 2, there are years where the investment provides $0 for cash flow. This project created on average 11.51% return per year for 24 years.

Project 1 Project 2 Project 3
Investment Investment Investment
Year 1 Year 1 Year 1
Year 2 Year 2 Year 2
Year 3 Year 3 Year 3
Year 4 Year 4 Year 4
Year 5 Year 5 Year 5
Year 6 Year 6 Year 6
Year 7 Year 7 Year 7
Year 8 Year 8 Year 8
Year 9 Year 9 Year 9
Year 10 Year 10 Year 10
Year 11 Year 11 Year 11
Year 12 Year 12 Year 12
Year 13 Year 13 Year 13
Year 14 Year 14 Year 14
Year 15 Year 15 Year 15
Year 16 Year 16 Year 16
Year 17 Year 17 Year 17
Year 18 Year 18 Year 18
Year 19 Year 19 Year 19
Year 20 Year 20 Year 20
Year 21 Year 21 Year 21
Year 22 Year 22 Year 22
Year 23 Year 23 Year 23
Year 24 Year 24 Year 24
           
IRR IRR IRR