Internal Rate of Return is the discount rate that makes a project’s Net Present Value equal to zero.
IRR converts a stream of cash flows into a percentage return. That makes it intuitive: if a project has an IRR of 14% and the appropriate required return is 9%, the project appears to clear the hurdle. But that simplicity hides important limits. IRR can conflict with NPV, produce multiple answers, favour small projects over larger value-creating projects, and behave strangely when cash flows change sign more than once.
IRR answers “What discount rate would make this project exactly break even in present-value terms?” It does not answer every investment question.
Educational boundary: this article explains investment-appraisal concepts. It does not recommend any project, security or investment. Return to How Finance Works for the canonical Finance map.
Contents
- The short answer
- The IRR equation
- How to interpret IRR
- IRR vs hurdle rate
- Worked example
- IRR vs NPV
- The scale problem
- The timing problem
- Multiple IRRs
- When IRR does not exist cleanly
- Reinvestment assumptions
- Modified IRR
- Practical IRR workflow
- The World Return
- Observable mastery test
- Evidence and further reading
IRR: The Short Answer
Suppose a project costs S$100,000 today and is expected to produce S$40,000 a year for three years. IRR is the discount rate r that solves:
0 = −100,000 + 40,000/(1+r) + 40,000/(1+r)² + 40,000/(1+r)³
The solution is approximately 9.7%. If the project’s risk-adjusted required return is 7%, IRR clears the hurdle. If the required return is 12%, it does not.
The IRR Equation
IRR is defined by the NPV equation:
0 = Σ [CFₜ ÷ (1 + IRR)ᵗ]
The initial outflow is included as a negative cash flow at time zero. Unlike NPV, which takes the discount rate as an input and produces a currency-value answer, IRR takes the cash flows as inputs and solves for the discount rate that produces zero NPV.
How to Interpret IRR
A positive IRR is not automatically good. It must be compared with an appropriate required return. A 6% IRR can be attractive for a very low-risk project if capital costs 3%. A 15% IRR can be unattractive if the risk requires 20%.
The useful question is:
Does the project’s internal percentage return exceed the return required by capital providers for this project’s risk?
IRR vs the Hurdle Rate
The hurdle rate is the minimum required return used to evaluate a project. It may be related to the company’s Cost of Capital, but project-specific risk can justify a different rate.
| Relationship | Interpretation under conventional cash flows |
|---|---|
| IRR > required return | NPV is positive |
| IRR = required return | NPV is zero |
| IRR < required return | NPV is negative |
This relationship works cleanly when the cash-flow pattern is conventional: one initial outflow followed by positive inflows. More complicated cash flows can break the simplicity.
Worked Example
A project requires S$250,000 today and produces S$90,000, S$100,000 and S$110,000 over the next three years. Solving the IRR equation gives a return of roughly 9–10%, depending on exact timing assumptions.
If the required return is 8%, the project’s NPV is positive. If the required return rises to 12%, NPV becomes negative. IRR therefore acts as the discount-rate boundary between positive and negative NPV for that conventional project.
IRR vs NPV
NPV measures absolute value created in currency units. IRR measures a percentage return. They can point in the same direction for independent conventional projects, but they can disagree when projects differ in scale or timing.
When projects are mutually exclusive, NPV is usually the stronger value-creation criterion because the company can choose only one project and wants to maximise the amount of value created, not merely the percentage return on a smaller base.
The Scale Problem
Project A may require S$10,000 and have an IRR of 40%, creating S$4,000 of economic gain. Project B may require S$10 million and have an IRR of 18%, creating S$1 million of NPV. If the projects are mutually exclusive, choosing A merely because 40% exceeds 18% can destroy the opportunity to create far more absolute value.
Percentages are seductive because they look comparable. Scale remains part of the economic question.
The Timing Problem
IRR can favour projects that return cash earlier, while NPV may favour a project with larger later cash flows. Which matters depends on the actual objective, capital constraints and reinvestment opportunities.
When NPV profiles cross as discount rates change, the preferred project can depend on the relevant cost of capital. This is another reason one percentage metric should not replace the full cash-flow model.
Multiple IRRs
IRR becomes problematic when project cash flows change sign more than once. Consider a mining or environmental project that requires an initial investment, produces positive operating cash flows, then requires a large closure or remediation cost at the end. The sequence may be:
negative → positive → positive → negative.
This non-conventional pattern can generate multiple mathematical IRRs. If the spreadsheet returns 8% and 27%, asking “What is the project’s IRR?” no longer has one clean answer.
NPV at the actual required return remains interpretable because the company still has one chosen discount rate and one resulting present value.
When IRR Does Not Exist Cleanly
Some cash-flow patterns may produce no economically meaningful positive IRR. Others can produce an IRR that is mathematically valid but economically absurd. This is not a spreadsheet bug. It is a reminder that IRR is a root of a polynomial-like equation, not a universal law of project quality.
Reinvestment Assumptions
Traditional discussions often say IRR implicitly assumes interim project cash flows are reinvested at the IRR. Whether one frames the issue that way or more precisely through project equivalence, the practical concern is real: a project with a 60% IRR does not mean the company can reinvest every intermediate dollar at 60% for years.
This is why extraordinary IRRs should be interpreted alongside project size, duration, reinvestment opportunities and NPV.
Modified Internal Rate of Return
Modified IRR, or MIRR, addresses some IRR weaknesses by using an explicit finance rate for negative cash flows and a reinvestment rate for positive cash flows before solving for a single equivalent return.
MIRR can be useful when analysts want a percentage-return summary with more realistic reinvestment assumptions, but it still should not replace NPV.
A Practical IRR Workflow
- Build the project’s incremental cash-flow schedule.
- Check how many times cash-flow signs change.
- Calculate IRR only after the cash-flow model is sound.
- Compare IRR with the project-specific required return.
- Calculate NPV at the same required return.
- Check project scale.
- Check timing differences against alternatives.
- Investigate multiple IRRs if signs change more than once.
- Consider MIRR when reinvestment assumptions matter.
- Run sensitivity and scenarios.
- Use payback only as a supplementary liquidity view.
- Track realised cash flows after approval.
The World Return: Did the Percentage Become Real Capability?
An IRR exists inside a model. The real world does not pay “14% IRR” into a bank account. The project produces sales, savings, maintenance needs, working-capital changes and terminal outcomes that eventually become cash—or fail to.
The World Return therefore asks whether the operating system actually generated the cash-flow pattern that made the IRR look attractive.
IRR is a useful percentage translation of a cash-flow story. It is not a substitute for the story.
Observable Mastery Test
You understand IRR if you can trace:
project cash flows → zero-NPV equation → IRR → required return → NPV comparison → scale → timing → multiple-IRR risk → realised World Return.
Evidence Base and Further Reading
- OpenStax — Principles of Finance
- NYU Stern — Corporate Finance and Valuation Resources
- ACCA — Investment Appraisal