IRR NPV Calculator

Evaluate investment opportunities using Net Present Value (NPV) and Internal Rate of Return (IRR).

Status: Algorithmic Audit (CPA Review Pending)
Jurisdiction: United States (IRS & SSA Standards)
Tax Year / Constants: 2026 Statutory Limits
Data Privacy: 100% Client-Side In-Browser

The Mathematical Formula

NPV = ∑ [ CF_t / (1 + r)^t ] - C₀ ; IRR is the discount rate r where NPV = 0

Variable & Parameter Definitions

  • NPV Net Present Value of all future discounted cash flows minus initial capital cost.
  • CF_t Expected net cash inflow or outflow in time period t.
  • r The hurdle discount rate or cost of capital used to discount future cash flows.
  • C₀ Initial upfront capital expenditure or investment outlay at period zero.
  • IRR The Internal Rate of Return: the exact breakeven discount rate that forces NPV to zero.

Real-World Worked Scenario: Commercial Equipment / Business Project

A company invests $100,000 into automated fulfillment equipment expected to generate $35,000 in net cash flows annually for 4 years with a 10% cost of capital.

  1. Year 1 Discounted Cash Flow: $35,000 ÷ (1.10)¹ = $31,818.
  2. Year 2 Discounted Cash Flow: $35,000 ÷ (1.10)² = $28,926.
  3. Year 3 Discounted Cash Flow: $35,000 ÷ (1.10)³ = $26,296.
  4. Year 4 Discounted Cash Flow: $35,000 ÷ (1.10)⁴ = $23,905.
  5. Sum of Discounted Cash Flows: $110,945.
  6. NPV Calculation: $110,945 - $100,000 = +$10,945 Net Value Added.
  7. IRR Solution: The discount rate where discounted cash flows equal $100,000 is approximately 14.96%.
Key Financial Takeaway: Because NPV > 0 and the IRR of 14.96% exceeds the 10% cost of capital hurdle rate, the investment adds positive economic shareholder value.

Strategic Insights & Pitfalls to Avoid

  • ✓ When choosing between mutually exclusive projects with different scales, prioritize highest absolute positive NPV over highest IRR.
  • ✓ IRR implicitly assumes intermediate cash flows can be reinvested at the IRR rate, which can overstate profitability compared to MIRR.
  • ✓ Always run sensitivity testing by adjusting the discount rate upward by 2% to 3% to evaluate margin of safety.

Frequently Asked Questions

What does a positive NPV mean?

A positive NPV indicates that projected earnings (discounted for time and risk) exceed initial costs, adding net financial value.

How does IRR relate to the hurdle rate?

If a project IRR exceeds the required hurdle rate or cost of capital, the project is financially acceptable.

Why might NPV and IRR give conflicting project rankings?

IRR can favor smaller high-percentage projects over larger investments that generate greater total dollar wealth (the scale problem).

Related Decision Calculators

Return On Investment (ROI) Calculator Calculate the return on investment (ROI) and annualized rate of r... Weighted Average Cost of Capital Calculator Calculate the Weighted Average Cost of Capital (WACC) for a compa... Commercial Loan Calculator Calculate payments, amortization schedules, and balloon payments ... Rental Property Calculator Evaluate real estate investment properties, calculating cash flow...