Internal Rate of Return (IRR) Calculator

Use our Internal Rate of Return (IRR) Calculator to find the true return on your investment. This tool is useful for corporate finance, real estate deals, and private equity projects. It uses a smart method to work through different cash flows and find the annual return rate. You can use it to see if a project is worth the risk.

Initial Outlay



This is treated as a negative cash flow (Year 0).

Projected Cash Flows



What is the Internal Rate of Return (IRR)?

The Internal Rate of Return (IRR) measures the profitability of a potential investment. It finds the discount rate that makes the Net Present Value (NPV) of all project cash flows equal to zero.

Think of IRR as the "Break-Even Interest Rate." If you borrowed money at the IRR percentage to fund a project, the project would generate enough cash to repay the loan and interest. It would leave zero profit after that. So if the IRR exceeds your actual cost of capital, the project makes money.


The Formula and Logic

You cannot calculate IRR with a simple algebraic formula. Instead, it requires an iterative numerical method like the Newton-Raphson method or the Bisection method, which our calculator uses.

The equation solved is: 0 = CF0+ CF1/ (1+ IRR) + CF2/(1+ IRR)2 +...+ CFn/ (1 + IRR)n

Here,
CF0: Initial Investment (always a negative number).
CFn: Cash flows in period n.
n: The holding period in years.


Clarifying the Inputs

  • Initial Investment: This is the total money you need to start the project. You enter it as a positive number, but the tool counts it as an outflow.
  • Cash Flows (Years 1–10): These show the net income from the project each year. You should enter net cash flow, which means revenue minus expenses.
  • Terminal Value: This is the amount you receive when you sell the asset. If you sell in Year 5, you add the sale price to that year’s cash flow.

Global Investment Facts: IRR Usage by Region

United States (USA)

In the United States, many firms use IRR in private equity and real estate. Private equity firms often target an IRR above 20 percent. Analysts also compare IRR with MIRR for better insight. MIRR uses a more conservative reinvestment rate.

England / United Kingdom (UK)

In the United Kingdom, companies use IRR to review projects. Firms set a hurdle rate to guide decisions. They approve projects that exceed this rate. The hurdle rate often includes WACC plus a small risk premium.

Canada (CAN)

In Canada, resource sectors use IRR for long term projects. These sectors include mining, oil, and gas. Analysts test IRR under different scenarios. They check best case, base case, and worst case results.

Australia (AUS)

In Australia, investors use IRR to compare property types. They often compare residential and commercial real estate. Commercial leases often provide stable cash flow. This makes IRR a useful measure for these assets.

India (IND)

In India, many investors use XIRR for mutual funds and SIPs. SIP investments happen at different times. XIRR helps track returns with these irregular flows. Investors use it to measure performance against inflation.


Frequently Asked Questions

What is a good IRR?

A good IRR depends on the type of investment. Corporate bonds may offer about 5 percent. Real estate often targets 10 to 15 percent. Venture capital may aim for 30 percent or more. If IRR is higher than your loan rate, you earn a profit.

Can IRR be negative?

Yes, IRR can be negative. This happens when total cash inflows stay below the initial cost. It shows that the investment loses money.

Why is IRR different from ROI?

ROI shows the total return on an investment. IRR shows the yearly growth rate of that return. IRR also considers the time value of money. Money received earlier has more value.

What are the limits of IRR?

IRR assumes you reinvest cash at the same rate. This may not match real situations. Some cash flow patterns can also create more than one result.

How do I handle selling the asset?

Add the sale price to the final year cash flow. For example, you may earn rent and sell the asset. You should combine both amounts in that year.

Excel Insider
Logo