Free IRR Calculator

What Is the Internal Rate of Return (IRR)?

The internal rate of return (IRR) is a discount rate at which the net present value (NPV) of a project's cash flows equals zero. When investors or businesses undertake a project, they typically pay an initial cost and receive a series of returns over time. Because money today is worth more than the same amount in the future, future cash flows need to be discounted back to their present value. The IRR is the specific discount rate that makes the project's net present value exactly zero.

In other words, IRR is the "break-even" rate of return for an investment when considering the time value of money. If the IRR of a project is higher than the company's required rate of return or the cost of capital, the project is generally considered worthwhile. Our free IRR calculator supports both fixed recurring cash flows and varying annual amounts at equal year-end intervals, making it suitable for a wide range of investment analysis scenarios.

How Is IRR Calculated?

The IRR formula is derived from the net present value equation. For a series of cash flows CF₀, CF₁, CF₂, ..., CFₙ, the IRR is the rate r that satisfies:

The calculator brackets a root in log(1 + r) and uses bisection, checking the discounted-cash-flow residual before returning a rate. It accepts investment streams with one negative-to-positive sign change. Multiple sign changes are rejected because selecting a single root could be misleading. The numeric search uses log(1 + r) between -20 and 20; a failure to find a root does not prove that no mathematical IRR exists.

How to Use This IRR Calculator

1. 1

   Choose a Calculation Mode

   Select "Fixed Cash Flow" for investments with regular periodic deposits or withdrawals, or "Irregular Cash Flow" for projects with varying annual returns.

2. 2

   Enter Your Investment Details

   For fixed cash flow, enter the initial investment, holding period, ending balance, and any periodic deposits or withdrawals. For varying annual cash flow, enter the initial investment and each year's cash flow amount.

3. 3

   Click Calculate

   The calculator will compute the IRR along with total investment, total returns, and net profit. Compare the IRR against your hurdle rate or cost of capital to evaluate the investment.

What Is IRR Used For?

IRR helps translate complicated patterns of cash inflows and outflows into a single number that can be compared directly to alternatives or required benchmarks. Whether you are deciding whether to purchase new equipment, evaluating real estate deals, or considering a long-term business expansion, IRR can bring clarity and structure to the evaluation process.

IRR Calculation Examples

Example 1: A Simple Investment Project

A small manufacturing firm is evaluating the purchase of a machine that costs $40,000 upfront. The machine is expected to generate the following cash inflows: $10,000 at the end of Year 1, $20,000 at the end of Year 2, and $30,000 at the end of Year 3. Using the "IRR based on varying annual cash flow" calculator, enter $40,000 as the initial investment and $10,000, $20,000, and $30,000 in the Year 1, 2, 3 fields respectively. The calculator returns an IRR of approximately 19.438%.

If the firm's cost of capital is 12%, then a 19.438% IRR is comfortably above the hurdle rate, suggesting the project is financially appealing. Conversely, if the cost of capital were 20%, the project may not be viable.

Example 2: Comparing Multiple Projects

Imagine two real estate investments, both requiring $100,000 upfront. Investment A generates cash flows of $5,000, $20,000, $25,000, $40,000, and $60,000 over five years. Investment B generates $0, $10,000, $30,000, $30,000, and $80,000. Both total $150,000 in cash flows for a simple ROI of 50%. However, when you factor in the time value of money using IRR, Investment A yields 11.290% while Investment B yields 10.259%. A has the higher IRR in these hypothetical cash flows. The decision still depends on risk, scale and NPV at an appropriate discount rate.

Limitations of IRR

While IRR is a powerful financial metric, it has some important limitations to consider:

• Scale of projects: IRR does not account for the overall scale of the project. A smaller project with a high IRR might generate less total profit than a larger project with a slightly lower IRR.
• Risk of projects: IRR does not explicitly factor in risk or uncertainty. A project with a lower IRR but low uncertainty may be preferred over a higher-IRR project with significant risk.
• Reinvestment: Solving the IRR equation does not simulate reinvestment. Turning interim receipts into a terminal wealth estimate requires a separate reinvestment-rate assumption.
• Multiple IRRs: Projects with alternating signs of cash flows can yield more than one IRR. This page declines those streams instead of selecting a root from an arbitrary starting guess.

For a more comprehensive analysis, consider using IRR alongside other metrics like NPV, modified internal rate of return (MIRR), or payback period. Decision-makers typically look at multiple measures to arrive at the most informed decision.

Timing references: Microsoft IRR documentation and XIRR documentation. Varying amounts do not make dates irregular. Beginning-of-period recurring payments include a payment at time zero; end-of-period payments include the final period. No partial periods are silently rounded.