IRR Calculator guide
IRR is the discount rate that makes net present value equal zero. It summarizes return as a percentage but can be ambiguous for unconventional cash flows.
Projects with multiple sign changes can have multiple IRRs, and some cash-flow patterns have no meaningful result.
How to use the IRR calculator
- Enter current amounts: Use current, documented values from the same relevant period.
- Enter assumptions: Use realistic rates, percentages, periods, and costs where applicable.
- Review the full result: Review the primary estimate together with its supporting measures.
- Stress-test risk: Model less favorable timing, value, cost, or rate assumptions.
Formula and variables
The estimate applies the entered values and assumptions to the stated formula.
Find rate where Σ cash flowₜ ÷ (1 + rate)ᵗ = 0- Inputs — Entered values
- The amounts, percentages, or periods supplied to the calculator.
- Result — Calculated output
- The estimate produced by applying the formula to the entered values.
Worked example: IRR calculator
A user enters a representative set of values and assumptions.
- Key inputs
- Amounts, percentages, periods, and costs
- Apply the stated formula.
- Include all relevant entered values and constraints.
- Compare the result with an alternative scenario.
Result: Estimated IRR, NPV at the hurdle rate, and the return spread.
Use the estimate as a planning input and verify important decisions with current records or qualified guidance.
Understanding your results
Primary estimate
Estimated IRR, NPV at the hurdle rate, and the return spread.
Risk measures
Use supporting payment, leverage, cost, and cash figures together.
Assumptions
- Entered rates and costs remain constant.
- Payments and cash flows occur on schedule.
Limitations
- Taxes, legal terms, accounting treatment, and transaction-specific costs may differ.
- Future values, timing, and rates are uncertain.
Common mistakes
- Reviewing only the headline result.
- Ignoring relevant costs, timing, or supporting measures.
- Using optimistic timing or value assumptions.
- Treating an estimate as a guaranteed outcome.
Practical use cases
Compare scenarios consistently
Change one assumption at a time or enter each alternative using the same basis.
Plan cash requirements
Estimate funds needed before committing.
Planning and decision guide
Stress-test the assumptions
Inspect the cash-flow pattern before interpreting IRR.
Review the important risks
Use NPV for value creation and when comparing projects of different scale.
Verify the source values
Do not assume interim cash flows can be reinvested at the IRR.
Frequently asked questions
What does IRR mean?
The modeled discount rate at which project NPV equals zero.
What is a hurdle rate?
The minimum required return used for comparison.
Can a project have multiple IRRs?
Yes, when cash-flow signs change more than once.
Why might IRR be unavailable?
The entered cash flows may not cross zero NPV within a meaningful rate range.
Sources and review
- Introduction to investing — U.S. Securities and Exchange Commission. Accessed 2026-07-10.
Reviewed 2026-07-10.