C

IRR Calculator

Last updated: February 28, 2026
Reviewed by: LumoCalculator Team

Estimate return quality for business and investment projects using Internal Rate of Return (IRR), Modified IRR (MIRR), Net Present Value (NPV), and payback timing in one workflow. Use this page to compare competing cash-flow paths, test hurdle-rate sensitivity, and frame capital-allocation discussions with consistent assumptions.

Related Calculators

Editorial & Review Information

Reviewed on: 2026-02-28

Published on: 2025-10-12

Author: LumoCalculator Editorial Team

What we checked: We re-checked IRR root-solving behavior, MIRR consistency, payback timeline crossing logic, and scenario interpretation outputs against the listed public references.

Purpose and scope: This page is an educational planning calculator for screening projects and comparing modeled return paths. It is not investment advice, underwriting approval, accounting certification, or tax/legal guidance.

How to use this review: Compare base and downside cash-flow paths, confirm whether IRR and NPV stay acceptable at your hurdle rate, then validate final assumptions through full diligence before capital commitment.

Financial Disclaimer

Results are assumption-dependent and may differ from realized outcomes because of execution variance, financing terms, macro rate shifts, tax treatment, contract timing, and residual-value uncertainty. Use outputs as a scenario framework and validate material decisions with full due diligence, governance review, and qualified professional input.

Use Scenarios

Capital project screening

Compare automation, product, or expansion proposals before budget committee review by checking whether IRR and NPV remain acceptable across base and downside assumptions.

Private transaction modeling

Evaluate acquisition, redevelopment, or refinancing cash-flow timelines with MIRR and discounted payback to understand timing risk and reinvestment realism.

Portfolio scenario governance

Standardize review templates by combining percentage-return metrics with dollar-value and liquidity-speed signals when prioritizing projects under constrained capital.

Formula Explanation

IRR equation (root of NPV)

0 = -I0 + sum(CF_t / (1 + r)^t), t = 1...n

The calculator solves for r where discounted inflows and outflows net to zero. IRR is a rate metric, not a direct dollar-value metric, so it is interpreted alongside NPV.

NPV and hurdle-rate check

NPV = -I0 + sum(CF_t / (1 + k)^t)

k is your selected hurdle rate (often WACC adjusted for risk). Positive NPV means the project creates value at that required return level; negative NPV means value shortfall under current assumptions.

MIRR and payback perspective

MIRR = (FV_positive / PV_negative)^(1/n) - 1

MIRR separates financing and reinvestment assumptions. Payback is then used as a timing lens: simple payback tracks nominal recovery, while discounted payback applies time value of money to each year cash flow.

Example Cases

Case 1: SaaS platform launch

Inputs

  • Initial investment: $500,000
  • Cash flows: 120k, 140k, 170k, 210k, 250k
  • Hurdle / finance / reinvest: 10% / 10% / 10%

Computed Results

  • IRR: 19.79%, MIRR: 15.97%
  • NPV @ 10%: $151,180, PI: 1.302
  • Simple payback: 3.33 years
  • Discounted payback: 4.03 years
  • Net cash outcome: $390,000

Interpretation

Return quality and value creation are both strong, and recovery timing remains within a typical growth-stage capital window.

Decision Hint

Prioritize execution-risk controls so forecasted mid-to-late cash flows are preserved.

Case 2: Logistics facility upgrade

Inputs

  • Initial investment: $2,000,000
  • Cash flows: 350k, 420k, 500k, 580k, 640k, 720k
  • Hurdle / finance / reinvest: 9% / 8% / 9%

Computed Results

  • IRR: 13.54%, MIRR: 11.70%
  • NPV @ 9%: $316,853, PI: 1.158
  • Simple payback: 4.23 years
  • Discounted payback: 5.26 years
  • Net cash outcome: $1,210,000

Interpretation

This is a value-accretive project with moderate return intensity and a longer discounted recovery profile.

Decision Hint

Stage capex deployment and track post-implementation savings to protect payback assumptions.

Case 3: Property repositioning

Inputs

  • Initial investment: $850,000
  • Cash flows: 65k, 72k, 80k, 88k, 94k, 930k
  • Hurdle / finance / reinvest: 11% / 9% / 10%

Computed Results

  • IRR: 9.26%, MIRR: 9.39%
  • NPV @ 11%: -$63,541, PI: 0.925
  • Simple payback: 5.49 years
  • Discounted payback: Not reached
  • Net cash outcome: $479,000

Interpretation

Nominal cash outcome is positive, but return quality misses the 11% hurdle and value creation is negative on a discounted basis.

Decision Hint

Re-test entry price, timing, or exit assumptions before approval under current capital policy.

Boundary Conditions

Initial investment is treated as a positive upfront amount and modeled as a time-zero outflow.
At least one positive annual cash flow is required for meaningful return screening.
Rates are constrained to 0%-100% in this tool for practical planning and numeric stability.
The model assumes annual period-end cash-flow timing and does not capture intra-year seasonality.
Unconventional sign changes can produce unstable or non-unique IRR behavior; use NPV and MIRR in parallel when that occurs.
Outputs are educational and should not be used as the sole basis for financing, investment, or fiduciary decisions.

Sources & References

Frequently Asked Questions

What does IRR tell me that simple ROI does not?
ROI reports a total return ratio, while IRR annualizes return and reflects when cash flows arrive. Two projects can show similar ROI but very different IRR if one returns cash much earlier. IRR is usually more useful for comparing timing-sensitive projects and for screening against a hurdle rate.
When should I trust MIRR more than IRR?
MIRR is often preferred when interim cash flows are large or irregular because it uses explicit finance and reinvestment rates. Traditional IRR assumes reinvestment at the IRR itself, which may be too optimistic for high-return cases. MIRR gives a single, more policy-aligned estimate in many practical workflows.
Can a project have positive NPV but a lower IRR than another project?
Yes. A larger project can create more total dollar value (higher NPV) even with a lower percentage return (lower IRR). That is why project ranking should not rely on one metric alone. Use NPV for value scale, IRR/MIRR for rate quality, and payback for liquidity timing.
Why can IRR be unavailable for some cash-flow patterns?
IRR requires at least one negative and one positive cash flow, and some unconventional patterns can create no stable single root. In those cases, NPV at decision rates plus MIRR and discounted payback often provides clearer guidance for screening and committee discussion.
How should I choose the hurdle rate in this calculator?
Teams often start with company WACC and then adjust for project-specific risk, execution complexity, and capital lock-up duration. Running low/base/high hurdle scenarios is generally better than relying on one fixed number, especially for long-cycle or uncertain cash-flow forecasts.
Does this tool provide investment advice?
No. This calculator is for educational planning and internal scenario analysis. It does not replace professional diligence, accounting review, legal/tax advice, financing terms analysis, or portfolio suitability assessment.