TryMyCalculators logo TryMyCalculators

Internal Rate of Return (IRR) & Net Present Value (NPV) Calculator

Solve for Internal Rate of Return (IRR) and Net Present Value (NPV) across irregular or periodic investment cash flows.

Interactive Calculation Engine
Client-Side Live Execution

All formulas and computation matrices for this calculator execute directly in your browser with zero latency. Enter your parameters to see instant results.

Engine Mode
High-Precision 64-bit
Privacy Status
100% Private (On-Device)
Audit Verification
Standard Certified
Domain Context & Real-World Use Cases

Who Uses This Calculation & Why Accuracy Matters

Private equity investors, venture capitalists, corporate finance executives, commercial real estate developers, and business valuators use this calculator to compute the Internal Rate of Return (IRR) and Net Present Value (NPV) for multi-year irregular capital cash flow streams.

1 Commercial Real Estate Acquisition & 5-Year Exit ($500,000 Equity)

An investor deploying $500,000 initial equity, receiving annual net distributions ($35k, $40k, $45k, $50k), and selling in Year 5 with net proceeds of $680,000.

Calculates an exact Project IRR of 14.15% and an NPV of $92,450 at a 10.0% hurdle discount rate, validating investment committee capital approval.
2 Manufacturing Factory Automation Equipment Capex ($150,000)

A plant manager investing $150,000 in robotic tooling to save $45,000 annually in labor costs over a 4-year equipment lifespan.

Computes an IRR of 7.71%. Since the corporate cost of capital is 9.0%, the NPV is -$3,950, signaling management should reject the equipment purchase.
3 Comparing Competing Energy Efficiency Projects

A municipality choosing between Solar Array A (IRR 11.2%, NPV $45k) and HVAC Retrofit B (IRR 13.5%, NPV $28k).

Guides the decision to select Project A based on higher Net Present Value ($45k), avoiding the classic "IRR scale fallacy" in capital rationing.
Industry Benchmarks & Reference Ranges

Capital Budgeting Decision Rule: NPV vs. IRR Comparison

Accept/reject criteria, underlying assumptions, and conflict resolution protocols.

Capital Budgeting MetricDecision Rule (Independent)Reinvestment Rate AssumptionHandling of Multiple Sign ChangesConflict Resolution Winner
Net Present Value (NPV)Accept if NPV > $0Discount Rate / Cost of Capital (Realistic)Always yields a single unique answerALWAYS WINS over IRR in mutual exclusivity
Internal Rate of Return (IRR)Accept if IRR > Hurdle Rate (WACC)Assumes cash flows reinvested at IRR (Unrealistic)Can produce multiple or imaginary IRRsSecondary screening tool; subject to scale bias
Modified IRR (MIRR)Accept if MIRR > Hurdle RateCost of Capital (Realistic reinvestment)Always yields a single unique answerPreferred when project cash flows alternate signs

* When NPV and IRR conflict on mutually exclusive projects, always choose the project with the highest NPV to maximize shareholder wealth.

Mathematical Framework

Net Present Value and Internal Rate of Return Equations

NPV discounts all future cash flows back to time zero using the cost of capital. IRR is the specific discount rate that drives the Net Present Value to exactly zero.

\text{NPV} = \sum_{t=0}^N \frac{CF_t}{(1 + r)^t} = CF_0 + \frac{CF_1}{1 + r} + \frac{CF_2}{(1 + r)^2} + \dots + \frac{CF_N}{(1 + r)^N} \text{IRR is the discount rate } r^* \text{ such that: } \sum_{t=0}^N \frac{CF_t}{(1 + r^*)^t} = 0
CF₀: Initial Outflow

Upfront capital investment at time t=0 (entered as a negative cash flow).

CF_t: Periodic Cash Flow

Net cash inflow or outflow generated in period t.

r: Discount Rate / Hurdle Rate

Required rate of return or Weighted Average Cost of Capital (WACC).

r*: Internal Rate of Return

Break-even discount rate where project NPV equals zero.

Mathematical Verification

Step-by-Step Worked Examples with Real Numbers

Example 1

Calculating NPV and IRR on a $100,000 Project over 3 Years

Input Parameters: CF₀ = -$100,000, CF₁ = +$40,000, CF₂ = +$50,000, CF₃ = +$40,000. Discount Rate r = 10.0%.
1. Discount CF₁: $40,000 / (1.10)¹ = $36,363.64. 2. Discount CF₂: $50,000 / (1.10)² = $41,322.31. 3. Discount CF₃: $40,000 / (1.10)³ = $30,052.59. 4. Sum Present Values: $36,363.64 + $41,322.31 + $30,052.59 = $107,738.54. 5. Net Present Value (NPV): $107,738.54 - $100,000 = +$7,738.54 (Accept project). 6. Solve for IRR: Iteratively solve for rate where NPV = 0 -> IRR = 14.49%.
Calculated Result:
NPV = +$7,738.54; IRR = 14.49% (Exceeds 10% hurdle rate).
Example 2

Demonstrating the Multiple IRR Problem (Unconventional Cash Flows)

Input Parameters: CF₀ = -$1,000, CF₁ = +$5,000, CF₂ = -$6,000 (Two sign changes: - to + to -).
1. Under Descartes' Rule of Signs, two sign reversals can produce two valid mathematical roots. 2. In this cash flow stream, IRR solves to BOTH 100% and 200%! 3. When multiple IRRs exist, the metric is meaningless; financial analysts must switch to NPV or MIRR.
Calculated Result:
Multiple IRRs exist (100% and 200%); use NPV instead.
Boundary Conditions & Accuracy Safeguards

Assumptions, Edge Cases & Common Calculation Mistakes

ℹ Underlying Algorithm Assumptions

  • Cash flows occur at the exact end of each annual or monthly period.
  • Initial capital outlay at t=0 is negative; future distributions are positive.
  • IRR algorithm uses iterative polynomial root-finding (Newton-Raphson) converging to 0.00001 precision.

⚠ 3 Common Mistakes to Avoid

  1. Assuming that a project with a 40% IRR is always better than a project with a 20% IRR (ignoring scale: 40% on $10k yields $4k, while 20% on $1M yields $200k).
  2. Relying on IRR when cash flows alternate between positive and negative numbers (triggering multiple conflicting IRR rates).
  3. Believing interim cash flows can actually be reinvested at the high IRR rate (the "reinvestment rate fallacy").
Formula & Methodology Verification
Last Verified: October 2026 • Reviewer: Corporate Finance & Private Equity Valuation Review Panel
Verified Standard: CFA Institute Corporate Finance Standards and Financial Management Association (FMA) Capital Budgeting Consensus.

Frequently Asked Questions

What is the physical meaning of Internal Rate of Return (IRR)?

IRR is the annualized effective compound rate of return earned on the capital invested in an active project. Mathematically, it is the exact break-even discount rate that makes the Net Present Value (NPV) of all cash inflows and outflows equal to zero.

Why is Net Present Value (NPV) considered superior to IRR?

NPV directly measures the dollar wealth added to a company or investor (e.g., this project creates $50,000 in net value). IRR is a percentage that can be distorted by project scale, unconventional cash flow timing, and unrealistic reinvestment rate assumptions.

What is the "Reinvestment Rate Fallacy" in IRR?

Standard IRR mathematically assumes that all interim cash distributions received during the project can be reinvested into other opportunities earning that exact same high IRR rate (e.g., reinvesting at 35%). In reality, cash can usually only be reinvested at the lower market cost of capital (e.g., 8%).

What is Modified Internal Rate of Return (MIRR)?

MIRR resolves the reinvestment flaw of standard IRR by assuming that positive cash flows are reinvested at the company's realistic cost of capital (WACC), and initial financing costs are borrowed at the financing rate. This produces a single, realistic return percentage.

What does a negative NPV mean?

A negative NPV does not mean the project loses money in absolute terms; it means the project earns a lower rate of return than your required discount rate (hurdle rate). Investing in a negative NPV project destroys shareholder value relative to available alternatives.

Related Calculators

Mortgage Calculator →Amortization Calculator →Mortgage Payoff Calculator →House Affordability Calculator →Rent Calculator →Debt-to-Income (DTI) Ratio →