Web Trader MT5 
Can you, for a second, imagine being in a situation where your company has limited capital and two projects on the table? One promises to pay back quickly, but the returns are not great. The other one takes its time, but it looks a lot better in the long run.
Which one do you choose?
This is where the Internal Rate of Return (IRR) comes into play. IRR takes all the money that will come in and go out in the future and converts it into a single annual percentage rate. One number. Simple to compare.
This guide explains what IRR really means, how the formula works, how to figure it out step by step, when it’s useful, and most importantly, when you should be skeptical of what it says.
Quick Answer
- IRR (Internal Rate of Return) is the percentage rate at which your discounted cash coming in exactly equals your initial cash going out.
- IRR makes the NPV of an investment equal zero. You could call it the annual return that breaks even.
- It’s used to compare projects, determine how significant an investment is, and assess how well you’re using your money.
- IRR assumes you can reinvest all of those cash flows at the same IRR rate, which you usually can’t. It can also give you more than one answer, or none at all, if the cash flow patterns are unusual.
IRR Logic & Formula (NPV = 0)
The IRR is the rate at which your Net Present Value equals zero.
In discounted cash flow (DCF) analysis, you figure out how much each future cash inflow is worth by bringing it back to today at a specific rate. IRR is the exact rate at which all of your present values equal zero. This is the point at which money coming in and money going out are perfectly balanced.
This is what the formula looks like:
[0 = NPV = \sum{t=0}^{n} \frac{Ct}{(1 + r)^t}]
Where:
- C t = cash flow at time t (the negative value represents cash outflow; the positive value represents cash inflow).
- r = internal rate of return (that is what we are seeking)
- t = time interval (it may be years or months)
The equation is a (1 + r) -polynomial and thus is typically not algebraically solvable in closed form. You have to solve it by making educated guesses over and over again until you find the right answer.
And timing is essential—a lot. Your IRR can change a lot if you move a large cash flow forward or backward by even one year. That’s the value of discounted cash flow analysis.
How to Calculate IRR (Step-by-Step)
The IRR calculation identifies the discount rate that equates NPV to zero, typically using a spreadsheet function or an iterative process.
- Get your cash flows together: Make a list of your initial investment (which is usually negative) and all your future cash flows, along with the dates they occur. Be clear about dates or times.
- Check cash-flow pattern: See how your cash flows go from good to bad and back again. Most normal projects start with one big negative (the money you put in) and then move on to positives (the money you get back). Note that when cash flows go back and forth a lot, you might get more than one IRR.
- Start with a guess: Choose a trial discount rate. Most projects can start with 10%.
- Use a spreadsheet or calculator: For periods that are evenly spaced, =IRR(range) in Google Sheets or Excel. For dates that don’t follow a pattern, use =XIRR(values, dates). Financial calculators also have built-in IRR functions.
- Look for convergence: If your guessed rate doesn’t get your NPV close to zero, the function will keep running until it finds the answer.
- Cross-check with NPV: Use the NPV formula again and put your solved IRR back in. NPV should be close to zero.
- Sanity-check results: Look at your IRR and compare it to your company’s WACC (weighted average cost of capital), your hurdle rate, and other measures like NPV and MIRR.
Helpful hint: When you graph NPV against different discount rates, IRR is the point where the curve crosses the zero line. It’s a way to see what’s going on.
Example (Table)
A simple IRR example demonstrates how IRR summarizes a multi-year cash flow into one annual rate.
| Year | Cash Flow ($) |
| 0 | -100 |
| 1 | +40 |
| 2 | +45 |
| 3 | +50 |
IRR ≈ 16.0% (rounded)
What does that mean? When you take away about 16% from those cash flows, the NPV comes out to zero:
[-100 + \frac{40}{(1+0.16)} + \frac{45}{(1+0.16)^2} + \frac{50}{(1+0.16)^3} \approx 0]
That 16% is the break-even return for your project. It is the one rate that perfectly balances the money going out with the money coming back in, accounting for the time value of money.
A quick way to figure out the IRR of your cash flow series in a spreadsheet is to type `=IRR()`. If the dates are irregular, use `=XIRR()` instead.
Interpretation & Use-Cases
You can use the IRR to compare investments by looking at the annualized return percentage. But you really need to know what’s going on.
How to read it in practice:
- Check against your hurdle rate: If your IRR is higher than your WACC (or any other threshold rate you’ve set), the project usually adds value. You’re destroying value if it’s lower.
- Rank similar projects: If you have a small budget and many options, IRR can help you choose the best ones by showing which are most efficient. The IRR tells you how much more you get for your money in percentage terms.
- Investments in private companies and real estate: IRR is ubiquitous in private equity, venture capital, and real estate, where cash flows are not steady and can last several years.
- Help with quick decisions: IRR is an excellent tool for quick go/no-go checks with NPV and payback period.
But here’s the thing: IRR doesn’t tell you how much money you made. And it doesn’t care how big the project is.
Think about a project with a $10,000 budget and a 20% IRR versus one with a $10 million budget and a 12% IRR. Which one is better for your business? Most likely the latter, even though the percentage is lower. That’s why you should always use IRR and NPV together to thoroughly evaluate a project.
IRR vs NPV vs ROI (Mini Comparison Table)
You get a rate from IRR. NPV tells you how much money you have. ROI gives you a simple percentage. Each one answers a different question.
| Metric | Decision Focus | Reinvestment Assumption | Best Use |
| IRR | Rate of return (relative) | Reinvest at IRR | Rank the efficiency of similarly sized projects |
| NPV | Net dollar value created | Reinvest at the discount rate | Determine absolute value, add, and accept/reject |
| ROI | Simple % gain | No time value | Quick, surface-level comparisons |
If there’s a dispute between IRR vs. NPV on which project to choose (this is called “ranking reversal”), select NPV if you want to get the most value overall. IRR is excellent for comparing efficiency, but it’s not the best tool for ranking projects of different sizes or durations.
Note: This article is only meant to educate you, not give financial advice. Please speak with a financial advisor if you need help navigating the trading world.
IRR vs XIRR (When Dates Are Irregular)
The standard IRR assumes that cash flows occur at regular intervals. XIRR uses actual calendar dates.
When you use the standard IRR function, it assumes that cash flows occur at regular intervals, such as once a year or once a quarter. That’s fine if your project has a set schedule.
But what about real life? Not so tidy.
Payments and receipts happen at different times all the time. Private equity drawdowns, real estate rent payments, and staggered project disbursements don’t all happen at the same time every month or year.
That’s where XIRR comes in.
The XIRR function uses the actual timestamps of each cash flow to calculate your internal rate of return. It correctly annualizes your return even when cash flows are weeks or months apart rather than perfectly spaced. So, in the IRR vs XIRR comparison, XIRR is more flexible and accurate for real investment timelines.
Example: If you put $10,000 into an investment on January 1, you would get $3,000 back on July 15 and another $9,000 back on December 30. Regular IRR would treat these as evenly spaced, yielding a result that is slightly off. Using `=XIRR(values, dates)` accounts for the actual time elapsed between each flow.
Bottom line: For standard period models, use IRR. When you have cash flows that don’t occur regularly and are tied to specific dates, use XIRR. This is especially true if timing is essential for your decision.
MIRR & Common Pitfalls
MIRR fixes IRR’s unrealistic reinvestment assumption. And yes, you can get multiple IRRs from the same project (which is confusing).
Common pitfalls and fixes:
- Multiple IRR problem: If your cash flows change signs more than once (for example, -100, +250, -200), the polynomial can give you more than one IRR that works. The polynomial equation goes through zero more than once. Which one do you use? It really is hard to understand.
- Nonconventional cash flows: projects with alternating inflows/outflows aren’t IRR-friendly — use NPV or MIRR.
- Unrealistic reinvestment assumption: IRR assumes that you can reinvest all of your intermediate cash flows at the same rate. In real life? You probably can’t. MIRR (Modified IRR) uses a more realistic rate for reinvestment, like your WACC, to give you one metric that behaves better.
- Scale and timing distortion: Even if they don’t add as much value as bigger, longer projects with lower IRRs, IRR can favor short projects with high percentage returns.
When you encounter any of these problems, use MIRR and NPV alongside your IRR. You’ll see a lot more of the whole picture.
Frequently Asked Questions
A: The IRR is the rate at which an investment’s NPV becomes zero. You can find it by going through the NPV equation over and over until you get zero, or you can use `=IRR()` or `=XIRR()` in a spreadsheet, which is much easier.
A: It usually means a higher percentage return. But it only matters if it beats your hurdle rate and you’ve also checked NPV and project scale. Don’t pick projects based only on IRR.
A: When cash flows change sign more than once, IRR fails to converge. This is the classic “multiple IRR problem,” where you get more than one mathematically valid IRR. Stick with NPV or MIRR when this happens.
A: If you want to get the most value (in dollars), use NPV. IRR is a good way to compare projects of the same size and risk level based on their rates of return.
A: IRR assumes that cash flows happen at regular intervals. XIRR works better with irregular timing and uses exact dates.
A: Yes. If your IRR is negative, it means your discounted inflows never offset your initial outflow; the project loses value.
Conclusion
IRR gives you one easy-to-compare percentage that shows both when and how much money you have coming in. It’s great for sorting and ranking projects. But it has real limits, like questionable assumptions about reinvestment, inability to see scale, and strange behavior with cash flows that aren’t normal.
Always use IRR with NPV (to see how much value was really created), MIRR (for realistic reinvestment assumptions), and your WACC or hurdle rate (for context). When your dates are not regular, use XIRR. And always have a spreadsheet on hand. The “IRR()” and “XIRR()” functions make things so much easier.
Don’t let IRR be the only factor in your decision. Use it as part of a bigger set of tools.
Disclaimer: No representation is given, warranty made or responsibility taken about the accuracy, timeliness or completeness of information sourced from third parties. Because of this, we recommend you consider, with or without the assistance of a financial adviser, whether the information is appropriate having regard to your particular circumstances.
Tags
Open Live Account
Please enter a valid country
No results found
No results found
Please enter a valid email
Please enter a valid verification code
1. 8-16 characters + numbers (0-9) 2. blend of letters (A-Z, a-z) 3. special characters (e.g, !a#S%^&)
Please enter the correct format
Please tick the checkbox to proceed
Please tick the checkbox to proceed
Important Notice
STARTRADER does not accept any applications from Australian residents.
To comply with regulatory requirements, clicking the button will redirect you to the STARTRADER website operated by STARTRADER PRIME GLOBAL PTY LTD (ABN 65 156 005 668), an authorized Australian Financial Services Licence holder (AFSL no. 421210) regulated by the Australian Securities and Investments Commission.
CONTINUEImportant Notice for Residents of the United Arab Emirates
In alignment with local regulatory requirements, individuals residing in the United Arab Emirates are requested to proceed via our dedicated regional platform at startrader.ae, which is operated by STARTRADER Global Financial Consultation & Financial Analysis L.L.C.. This entity is licensed by the UAE Capital Market Authority (CMA) under License No. 20200000241, and is authorised to introduce financial services and promote financial products in the UAE.
Please click the "Continue" button below to be redirected.
CONTINUEError! Please try again.
