IRR Explained: The Discount Rate That Sets NPV to Zero
IRR is the yield-like number that solves NPV = 0 for a cash-flow stream. It is popular on spreadsheets because it summarizes a project in one percentage.
IRR Explained: The Discount Rate That Sets NPV to Zero
Updated May 2026 · ~8 min read
IRR is a discount-rate root that sets modeled NPV to zero. It can summarize a conventional cash-flow stream, but multiple sign changes can create multiple roots, no root, or misleading rankings. IRR does not inherently guarantee reinvestment at the IRR and should be considered with NPV, scale, timing, financing, and scenario risk.
When IRR is useful
- Private investments: compare IRR to a required return after fees, not to headline public-market averages blindly.
- Capital projects: communicate a single summary statistic to stakeholders alongside NPV at the corporate hurdle rate.
- Loan-like structures: IRR on borrower cash flows relates to the effective borrowing cost.
The formula
Find IRR such that: 0 = Σ_t ( CF_t / (1 + IRR)^t ) (No closed form in general—numerical root finding.)
The solver period must match cash-flow timing. Irregular dates require an XIRR-style method, and the numerical algorithm can converge to different roots depending on guesses and cash-flow shape.
A root, not a promised project return
For one initial outflow followed by positive inflows, a single IRR may exist. The realized investor return can still differ because cash flows, timing, financing, and reinvestment outcomes differ from the model.
Common mistakes
- Ranking mutually exclusive projects only by the highest IRR.
- Assuming IRR always exists uniquely.
- Claiming IRR inherently assumes all cash flows are reinvested at IRR.
- Mixing monthly and annual periods.
- Ignoring project scale, NPV, financing, and multiple roots.
Try the calculator
Use the interactive calculator to plug in your numbers and see results instantly—without redoing the math by hand.
Open IRR calculator →FAQ
Does IRR assume reinvestment at IRR?
IRR is a root calculation; reinvestment interpretations depend on how the metric is used. MIRR can impose explicit rates.
Can there be multiple IRRs?
Yes. Multiple sign changes can create multiple roots or no economically useful root.
Why can NPV and IRR rankings conflict?
Scale, timing, cash-flow shape, and the selected discount rate can produce different rankings.
Is IRR the realized return?
Not necessarily. Actual cash flows and timing can differ from the model.
Related calculators
Continue learning this topic
Move from this guide into a complete calculator path with related tools and glossary terms.
Open the Risk & Portfolio hub →Educational Disclaimer
This article is for educational and informational purposes only and should not be considered investment, financial, tax, or legal advice. Market information may change over time, and readers should verify important details independently before making financial decisions.