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.
All formulas and computation matrices for this calculator execute directly in your browser with zero latency. Enter your parameters to see instant results.
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.
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.
A plant manager investing $150,000 in robotic tooling to save $45,000 annually in labor costs over a 4-year equipment lifespan.
A municipality choosing between Solar Array A (IRR 11.2%, NPV $45k) and HVAC Retrofit B (IRR 13.5%, NPV $28k).
Capital Budgeting Decision Rule: NPV vs. IRR Comparison
Accept/reject criteria, underlying assumptions, and conflict resolution protocols.
| Capital Budgeting Metric | Decision Rule (Independent) | Reinvestment Rate Assumption | Handling of Multiple Sign Changes | Conflict Resolution Winner |
|---|---|---|---|---|
| Net Present Value (NPV) | Accept if NPV > $0 | Discount Rate / Cost of Capital (Realistic) | Always yields a single unique answer | ALWAYS 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 IRRs | Secondary screening tool; subject to scale bias |
| Modified IRR (MIRR) | Accept if MIRR > Hurdle Rate | Cost of Capital (Realistic reinvestment) | Always yields a single unique answer | Preferred 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.
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.
Upfront capital investment at time t=0 (entered as a negative cash flow).
Net cash inflow or outflow generated in period t.
Required rate of return or Weighted Average Cost of Capital (WACC).
Break-even discount rate where project NPV equals zero.
Step-by-Step Worked Examples with Real Numbers
Calculating NPV and IRR on a $100,000 Project over 3 Years
Demonstrating the Multiple IRR Problem (Unconventional Cash Flows)
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
- 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).
- Relying on IRR when cash flows alternate between positive and negative numbers (triggering multiple conflicting IRR rates).
- Believing interim cash flows can actually be reinvested at the high IRR rate (the "reinvestment rate fallacy").
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.