What Is an IRR Calculator?
The Internal Rate of Return (IRR) is the discount rate that makes the net present value (NPV) of a series of cash flows equal to zero. In practical terms, it is the annualized rate of return you can expect to earn on an investment that produces irregular cash flows over time, such as a business investment, real estate project, or private equity deal.
This calculator also computes NPV at your chosen discount rate, giving you two complementary tools to evaluate whether a project or investment is financially worthwhile.
What This Calculator Does
Inputs Required
- Year 0 Cash Flow: The initial investment, entered as a negative number (money going out)
- Subsequent Years: Expected cash inflows (positive) or outflows (negative) for each future period
- Discount Rate: Your required rate of return or cost of capital, used to calculate NPV
Outputs Provided
- IRR: The annualized return on the investment
- NPV: The present value of all future cash flows minus the initial investment at your chosen discount rate
- Decision Signal: Accept or reject based on whether IRR exceeds your discount rate
- Cash Flow Chart: A timeline showing all cash flows colored by inflow or outflow
How the Calculation Works
IRR is found by solving for the rate r that makes this equation equal to zero:
0 = CF0 + CF1/(1+r)^1 + CF2/(1+r)^2 + ... + CFn/(1+r)^n
There is no closed form algebraic solution, so this calculator uses a binary search algorithm that iterates hundreds of times to find the rate with high precision. NPV is calculated using the standard discounted cash flow formula at the discount rate you specify:
NPV = Sum of [ CFt / (1 + r)^t ] for t = 0 to n
The decision rule is straightforward: if IRR exceeds your required rate of return (hurdle rate), the project adds value and should be accepted. If NPV is positive at your discount rate, the same conclusion applies. Both metrics should point in the same direction for a standard investment.
How to Use the Calculator
- Enter Year 0 as a negative number representing your initial investment
- Enter expected cash flows for each subsequent year as positive numbers
- Add or remove years using the plus and minus buttons
- Set your discount rate (cost of capital or required return) for the NPV calculation
- Review IRR, NPV, and the accept or reject recommendation
- Adjust cash flows to model optimistic and pessimistic scenarios
Example Calculation
A business invests $50,000 today and expects cash inflows of $12,000, $15,000, $18,000, $20,000, and $22,000 over the next five years:
- Total cash inflows: $87,000
- Net undiscounted cash flow: +$37,000
- IRR: approximately 18.6%
- NPV at 10% discount rate: approximately +$14,500
If the company's cost of capital is 10%, this project's IRR of 18.6% significantly exceeds the hurdle rate and the positive NPV confirms the investment adds value in present value terms. Both signals indicate the project should be accepted.
Real World Scenarios
Evaluating a Business Acquisition
A private equity firm considers acquiring a business for $500,000. They project annual cash flows from operations over 7 years, ending with a projected sale. The IRR calculator helps them determine whether the projected return exceeds their typical 20% hurdle rate.
Real Estate Development
A developer spends $1.2 million to buy and renovate a commercial property, then collects rent for 5 years before selling. Entering the construction costs, rental income, and projected sale price produces an IRR that can be compared against borrowing costs and alternative investment returns.
Capital Equipment Purchase
A manufacturer considers purchasing new equipment for $200,000 that will reduce operating costs by $45,000 per year for 6 years. The IRR on those cost savings, compared against the company's cost of borrowing, determines whether the purchase makes financial sense.
Why This Calculation Matters
IRR is one of the most widely used capital budgeting metrics in finance and business. It translates a complex series of cash flows spread over many years into a single percentage that can be directly compared against a cost of capital, lending rate, or alternative investment return. This makes it extremely practical for decision making.
Combined with NPV, IRR gives a complete picture of an investment's attractiveness. NPV tells you the absolute dollar value added, while IRR tells you the efficiency of that return as a percentage rate.
Common Mistakes to Avoid
- Multiple IRRs: If cash flows change sign more than once (positive to negative to positive), multiple IRR solutions may exist. In such cases, rely on NPV instead
- Ignoring the time value of money: Simply summing cash flows without discounting ignores the fact that money received sooner is worth more. IRR and NPV both correct for this
- Overly optimistic cash flow projections: IRR is only as reliable as the cash flows entered. Model conservative, base case, and optimistic scenarios to understand the range of outcomes
- Using IRR alone for mutually exclusive projects: When choosing between two projects of different scale, a smaller project can have a higher IRR but lower NPV. Always use NPV as the primary metric for project selection when scale differs