Internal Rate of Return (IRR) Calculator

What is internal rate of return?

Internal rate of return, usually shortened to IRR, is the rate of return that makes the net present value of an investment’s cash flows equal to zero. It is called “internal” because the rate is calculated from the cash flows of the investment itself. It does not require an external market rate to calculate the IRR, although an external required return is still needed to interpret whether the IRR is attractive.

IRR is commonly used for investment projects, private equity deals, real estate investments, business expansion decisions, startup investments, capital budgeting, equipment purchases, and any situation where money is invested now in exchange for expected future cash flows. The calculation begins with an initial outflow, such as \( -AED\ 100{,}000 \), followed by inflows such as \( AED\ 28{,}000 \) per year. The IRR is the discount rate that makes the present value of those future inflows exactly equal to the initial outflow.

For example, if a project costs \( AED\ 100{,}000 \) today and returns \( AED\ 28{,}000 \) at the end of each year for five years, the IRR is the annual rate that makes those five future payments worth exactly \( AED\ 100{,}000 \) today. If the calculated IRR is \( 12.38\% \), and the investor’s required return is \( 10\% \), the project may appear acceptable because the internal return is higher than the required return.

IRR is useful because it converts a stream of cash flows into one percentage rate. Percentages are easy to compare, which is why IRR is popular in business and finance. However, IRR should not be used alone. A project with a high IRR may be very small, while a project with a lower IRR may create more total value. This is why IRR should be reviewed together with net present value, cash-flow size, risk, and project duration.

The most important limitation is that IRR can be misleading when cash flows change signs more than once. A normal project usually has one negative cash flow at the beginning and positive cash flows later. An unusual project might have negative, positive, and negative cash flows. In that case, there may be multiple IRRs or no meaningful IRR. The calculator is designed for educational use and will give a best-effort result when a valid root can be found.

IRR formula

The internal rate of return is found by setting net present value equal to zero. The general formula is:

Where:

• \( C_0 \) = initial cash flow, usually negative because it is the initial investment.
• \( C_t \) = cash flow received or paid at period \( t \).
• \( N \) = total number of periods.
• \( r \) = discount rate used for NPV.
• \( IRR \) = the discount rate that makes NPV equal to zero.

Unlike simple interest or compound interest problems, the IRR formula usually cannot be rearranged neatly for all cash-flow patterns. When there are multiple future cash flows, IRR is normally found using numerical methods such as trial and error, bisection, or Newton’s method. That is what the calculator does in the background.

The calculator also calculates annualized IRR when cash flows are not yearly. If the IRR per period is \( r_p \), and there are \( q \) cash-flow periods per year, the annualized IRR is:

For example, if a monthly IRR is \( 1\% \), the annualized IRR is not simply \( 12\% \). It is:

The calculator also shows NPV at your required return. The NPV formula is:

Here, \( k \) is the required return per cash-flow period. If your required return is annual and your cash flows are monthly, the calculator converts the annual rate into a matching period rate.

How to calculate IRR

To calculate IRR, list every cash flow in order. The first cash flow is usually the initial investment and is written as a negative number. Future cash inflows are written as positive numbers. Then find the discount rate that makes the present value of all cash flows equal to zero.

1. Enter the initial investment. This is usually the first cash flow, written as a negative amount in the IRR equation.
2. Enter the periodic cash inflow. In structured mode, this is the same amount received each period.
3. Enter the number of periods. This tells the calculator how many future cash flows to include.
4. Enter a terminal value if applicable. This is a final exit value, sale value, resale value, or salvage value added to the last period.
5. Choose cash-flow frequency. Yearly, quarterly, and monthly cash flows need different annualization.
6. Enter a required return. This is used to calculate NPV for comparison with IRR.
7. Calculate IRR. The calculator searches for the rate that makes \( NPV = 0 \).
8. Compare IRR with required return. If IRR is higher than the required return, the project may pass the IRR rule.

However, the IRR rule is not always enough. A project can have a high IRR but a small total profit. Another project can have a lower IRR but a much larger NPV. If two projects are mutually exclusive, meaning you can choose only one, NPV is often the more reliable decision tool because it measures value in currency terms.

Worked examples

Example 1: Basic IRR with equal yearly cash flows

Suppose a project requires an initial investment of \( AED\ 100{,}000 \). It is expected to produce \( AED\ 28{,}000 \) per year for \( 5 \) years. The cash-flow series is:

The IRR is the rate that solves:

This equation is normally solved numerically. The approximate IRR is about \( 12.38\% \). If the required return is \( 10\% \), the project’s IRR is higher than the required return, so the project may be acceptable under the IRR rule.

Example 2: IRR with terminal value

Suppose an investor pays \( AED\ 200{,}000 \) for a property investment. The property produces \( AED\ 18{,}000 \) of net cash flow each year for \( 5 \) years and is sold for \( AED\ 240{,}000 \) at the end of year \( 5 \). The final period cash flow includes both the annual income and the sale value:

The cash-flow series is:

This example shows why terminal value is important. For real estate, private business investments, and asset purchases, the final resale or exit value can be a major part of the total return.

Example 3: Monthly IRR and annualized IRR

If cash flows occur monthly, the first result is a monthly IRR. To compare it with annual required returns, it should be annualized. If the monthly IRR is \( 1\% \), the annualized IRR is:

This is higher than \( 12\% \) because monthly compounding is included. The calculator shows both the IRR per cash-flow period and the annualized IRR.

Example 4: NPV at required return

Suppose a project has an IRR of \( 12.38\% \), and the required return is \( 10\% \). The NPV at \( 10\% \) may be positive. A positive NPV means the discounted value of inflows is greater than the initial investment at the required return.

This is why IRR and NPV are often reviewed together. IRR gives the break-even discount rate. NPV shows the value created at the investor’s required return.

IRR vs NPV

IRR and NPV are closely related, but they answer different questions. IRR gives a percentage return. NPV gives a currency value. IRR asks, “What discount rate makes this project break even in present value terms?” NPV asks, “How much value does this project create at my required return?”

If a project has a positive NPV at the required return, it is expected to create value above the investor’s required return. If a project has a negative NPV, it does not meet the required return. IRR is useful, but NPV is often better for choosing between mutually exclusive projects because it measures the size of value created.

How to interpret IRR

IRR should be interpreted as a break-even discount rate. If the required return is below the IRR, the investment usually has a positive NPV. If the required return is above the IRR, the investment usually has a negative NPV. This makes IRR useful for quickly checking whether a project clears a hurdle rate.

A high IRR is not automatically better in every decision. A small project can have a high IRR but create little total value. A larger project can have a lower IRR but generate a much larger NPV. For serious investment decisions, review both rate-based and value-based metrics.

Common mistakes

• Entering the initial investment as positive in custom mode. In custom mode, the initial investment should usually be negative, such as \( -100000 \).
• Forgetting the terminal value. Real estate, business, and asset investments often have a resale or exit value in the final period.
• Comparing monthly IRR with annual required return. Convert period IRR into annualized IRR before comparing.
• Using IRR alone. IRR should be reviewed with NPV, payback, risk, project size, and cash-flow reliability.
• Ignoring multiple IRR problems. Cash flows that change sign more than once can create more than one possible IRR.
• Assuming IRR is the reinvestment rate. IRR can imply a reinvestment assumption that may not be realistic.
• Ignoring taxes, fees, and inflation. Real investor returns can be lower than project-level IRR.

A good habit is to create a cash-flow table before calculating. Put each period in order, use negative numbers for outflows, positive numbers for inflows, and include all sale proceeds or final costs in the correct period.

Related calculators and guides

Use these related Num8ers tools to continue working with investment return, future value, and financial decision-making:

FAQs