Skip to main content

ROI / NPV / IRR Calculator

Calculate return on investment, net present value, and internal rate of return for projects and investments. Compare capital budgeting metrics, analyze cash flows, and make data-driven financial decisions.

Last updated:
Reviewed by Bilal Khan, Mathematician
Cash Flows

Financial Analysis Tools

Calculate ROI, NPV, IRR, WACC, and more for investment analysis

Master Financial Analysis & Investment Planning

Build essential skills in capital budgeting, project evaluation, and data-driven investment decision-making

Explore more data science and operations calculators →

Related: money and taxes calculators.

What ROI, NPV, and IRR Each Answer About an Investment

The CFO asks whether a $200k equipment purchase is worth it. You can answer three different ways, and each tells a different story. ROI gives the simplest ratio — total gain divided by total cost — but ignores when the money arrives. NPV fixes that: it discounts every future cash flow back to today at a chosen discount rate, then subtracts the upfront cost. A positive NPV means the investment creates value after accounting for the time value of money. IRR flips the question: at what discount rate does NPV equal zero? The common mistake is using ROI alone for multi-year projects — a 40% ROI spread over eight years looks very different from 40% in one year.

Use ROI for quick back-of-napkin comparisons. Use NPV when you need a dollar figure for how much value the project adds. Use IRR when you want a rate you can compare against your cost of capital or a competing project’s IRR. All three assume your cash-flow estimates are correct — garbage in, garbage out.

Inputs That Swing the Result: Discount Rate and Cash-Flow Timing

NPV is extremely sensitive to the discount rate. At 8%, a $50k annual cash flow for five years is worth $199k today. At 15%, the same stream is worth $168k. A seven-point change in the rate swings NPV by $31k — enough to flip a borderline project from “go” to “no-go.” If you are unsure which rate to use, run the analysis at your company’s weighted average cost of capital (WACC) as the base case, then stress-test at WACC ± 3 points.

Cash-flow timing matters almost as much. Front-loaded projects (big returns in years 1–2) have higher NPV than back-loaded ones (returns in years 4–5) at the same total. IRR amplifies this: it rewards early cash flows heavily because reinvestment happens sooner. If your project has lumpy, uneven cash flows, IRR can produce misleading results — sometimes even multiple IRRs when cash flows change sign more than once. In those cases, MIRR (modified IRR) is more reliable.

ROI, NPV, IRR, and Payback at a Glance

Each metric answers a different question. Here is when to reach for which:

ROI — “How much do I get back per dollar spent?”
Best for: quick comparisons, single-period investments. Weakness: ignores timing.
NPV — “How many dollars of value does this create today?”
Best for: go/no-go decisions with known discount rate. Weakness: requires choosing a rate.
IRR — “What annualised return does this project earn?”
Best for: comparing projects of different sizes. Weakness: assumes reinvestment at IRR, can have multiple solutions.
Payback — “When do I get my money back?”
Best for: liquidity-constrained decisions. Weakness: ignores everything after the payback point.

Common Misreads That Lead to Bad Investment Decisions

Comparing IRRs across projects of different sizes. Project A has a $10k investment and 50% IRR ($5k gain). Project B has a $500k investment and 20% IRR ($100k gain). IRR says pick A, but NPV says B creates twenty times more value. IRR ranks efficiency; NPV ranks magnitude. For capital allocation, you usually care about magnitude.

Using ROI without a time dimension. “ROI is 120%” means nothing without knowing the period. 120% over one year is stellar; 120% over ten years is about 8% annualised — barely beating a savings account. Always annualise ROI or state the holding period explicitly.

Ignoring opportunity cost. A project with a positive NPV at 10% discount rate is still a bad investment if you have an alternative project with a higher NPV using the same capital. NPV tells you whether a project clears the hurdle, not whether it is the best use of limited funds. Compare NPVs across the set of mutually exclusive options.

Edge Cases: Negative Cash Flows, Multiple IRRs, and Zero NPV

Non-conventional cash flows. If a project requires a large decommissioning cost in the final year (positive flows, then negative), the cash-flow series changes sign twice. The IRR equation can produce two valid solutions — say 8% and 35%. Neither is “the” IRR. Use MIRR instead, which assumes a separate reinvestment rate and finance rate, giving one clean answer.

NPV exactly zero. This means the project earns exactly the discount rate — no more, no less. It does not mean the project is worthless; it means you are indifferent between doing it and investing at the discount rate. In practice, a zero-NPV project might still be worth doing if it has strategic value the model does not capture.

Very long horizons. A 20-year NPV is heavily dependent on cash-flow estimates for years 10–20, which are usually guesses. Discount rates compress distant cash flows, but if the rate is low (3–5%), those distant years still carry significant weight. Sensitivity-test the terminal value or cap the projection at a conservative horizon.

NPV, IRR, and ROI Equations

The core formulas behind each investment metric:

Net Present Value
NPV = Σt=0..T CFt / (1 + r)t
CF0 is typically negative (initial investment)
Internal Rate of Return
Find r such that Σt=0..T CFt / (1 + r)t = 0
Solved iteratively (Newton’s method or bisection)
Return on Investment
ROI = (Total gains − Total cost) / Total cost × 100%
Annualised: ROIann = (1 + ROI)1/n − 1
Payback period
Payback = smallest t where Σi=0..t CFi ≥ 0

Equipment Purchase Decision: Full Worked Example

Scenario: A manufacturing firm considers buying a $150k CNC machine. Expected cash flows: Year 1 = $40k, Year 2 = $50k, Year 3 = $55k, Year 4 = $45k, Year 5 = $30k. The firm’s WACC is 10%.

ROI: Total gains = $220k. ROI = ($220k − $150k) / $150k = 46.7% over five years. Annualised ≈ 8.0%. Useful as a headline but does not account for timing.

NPV at 10%: $40k/1.10 + $50k/1.21 + $55k/1.331 + $45k/1.4641 + $30k/1.6105 − $150k = $36.4k + $41.3k + $41.3k + $30.7k + $18.6k − $150k = +$18.3k. Positive NPV — the project clears the hurdle and creates $18.3k in present-value terms.

IRR: Solving iteratively, NPV hits zero at r ≈ 16.2%. Since 16.2% > 10% WACC, the project earns more than the cost of capital. Payback: Cumulative cash flow turns positive partway through Year 3 ($40k + $50k + $55k = $145k at end of Y3, full payback early in Y4 after $5k more flows in).

Sources

Frequently Asked Questions about ROI, NPV, and IRR

What is the difference between ROI, NPV, and IRR?

ROI (Return on Investment) is a simple percentage showing total return relative to initial investment, ignoring timing. NPV (Net Present Value) sums all discounted cash flows to measure value added in dollars, accounting for the time value of money. IRR (Internal Rate of Return) is the discount rate that makes NPV = 0, representing an annualized rate of return. Use ROI for quick comparisons, NPV for rigorous value assessment, and IRR for intuitive rate-of-return communication.

When should I use NPV instead of ROI?

Use NPV whenever timing matters and you have a meaningful discount rate. ROI is useful for simple, single-period investments, but for multi-year projects with varying cash flows, NPV is far more accurate because it accounts for the time value of money. NPV tells you how much value a project adds (or destroys) at your required rate of return, making it the preferred metric in corporate finance and rigorous investment analysis.

How do I choose an appropriate discount rate for NPV?

The discount rate should reflect your required rate of return, opportunity cost, and risk level. For corporate projects, many firms use WACC (Weighted Average Cost of Capital), which blends the cost of equity, debt, and preferred stock. For personal investments, consider what return you could earn on a similar-risk alternative. Riskier projects warrant higher discount rates (to compensate for uncertainty); safer projects use lower rates. The calculator's WACC mode can help you compute a blended rate.

What does it mean if NPV is positive but ROI looks modest?

A positive NPV means the project adds value above your discount rate, which is good. A modest ROI might mean the project takes a long time or has large upfront costs relative to total returns. ROI doesn't account for timing, so a 20% ROI over 10 years looks the same as 20% over 1 year. NPV is the more reliable indicator—if NPV is positive, the project is conceptually attractive, even if ROI seems low. Compare NPV across alternatives to make the best choice.

What does it mean if my IRR is higher than my required return?

If IRR > required return (or hurdle rate), the project is expected to earn more than your minimum acceptable rate, which is a good sign. Combined with a positive NPV, this suggests the project is attractive. However, always check NPV too—IRR can be misleading for projects with unusual cash-flow patterns or when comparing projects of different scales. Think of IRR as a screening tool and NPV as the decision-maker.

Can a project have more than one IRR?

Yes. If cash flows change sign more than once (e.g., negative, then positive, then negative again), the IRR equation can have multiple solutions. This is called the multiple IRR problem. In such cases, IRR becomes ambiguous and less useful. The calculator will attempt to find an IRR, but may return a warning or no solution. When this happens, rely on NPV for your decision—NPV is always well-defined and unambiguous.

What if the calculator says it cannot find an IRR?

Some cash-flow patterns have no real or positive IRR—for example, if all cash flows are negative, or if the pattern doesn't allow the NPV to cross zero. The calculator will display a warning or leave IRR blank. This isn't a problem with the tool; it's a mathematical property of your cash flows. In such cases, focus on NPV and ROI to evaluate the project. IRR simply isn't applicable or meaningful for every cash-flow pattern.

How is this calculator different from a full financial planning tool?

This calculator focuses on capital budgeting metrics (ROI, NPV, IRR, payback, MIRR, WACC, depreciation) for educational and conceptual analysis. It doesn't handle portfolio optimization, tax planning, retirement income streams, insurance, estate planning, or personalized financial advice. It's a learning tool for capital-budgeting concepts and high-level project evaluation, not a substitute for a financial planner or full investment management software.

Can I use this tool for personal investments or only business projects?

You can use it for both. The math is the same whether you're evaluating a corporate equipment purchase, a rental property, a side hustle, or a personal investment. Just enter your cash flows and an appropriate discount rate (your opportunity cost or required return), and the calculator will compute ROI, NPV, and IRR. The key is to define cash flows realistically and choose a discount rate that reflects your alternatives and risk tolerance.

When does IRR mislead, and when should I use MIRR or NPV instead?

IRR's two big traps are the reinvestment-rate assumption and project scale. The reinvestment trap: standard IRR implicitly assumes you can reinvest interim cash flows at the IRR itself, which is unrealistic for projects with very high IRRs. A 60% IRR doesn't mean the project actually earns 60% per year unless you can find another 60% IRR opportunity to park the cash in. MIRR fixes this by letting you specify a separate, realistic reinvestment rate (usually your WACC or a market return). The scale trap: a $10K investment with 50% IRR and a $500K investment with 20% IRR rank in the wrong order under IRR alone. The smaller project wins on rate. The larger project creates twenty times more dollar value. Use MIRR when you need a percentage return that doesn't lie about reinvestment. Use NPV directly when you need to choose between projects of different sizes, or compare against a hurdle rate. Skip IRR entirely when cash flows change sign more than once, since the equation can have multiple solutions and none of them mean what people assume IRR means.

What is MIRR and when should I use it instead of IRR?

MIRR (Modified Internal Rate of Return) addresses IRR's unrealistic reinvestment assumption by letting you specify separate rates for financing negative cash flows and reinvesting positive cash flows. Use MIRR when you want a single percentage return but with more realistic assumptions than IRR. MIRR is often lower than IRR and closer to actual achievable returns. It's particularly useful for communication with stakeholders who prefer a rate-of-return metric but want fewer distortions.

What is Profitability Index (PI) and how do I use it?

Profitability Index (PI) is the ratio of the present value of future cash inflows to the initial investment. PI = (PV of inflows) / (Initial investment). A PI > 1 means the project adds value (positive NPV). PI is especially useful when you have limited capital and need to rank multiple positive-NPV projects—choose the ones with the highest PI to maximize total NPV per dollar invested.

How do I interpret the payback period?

The payback period is the time it takes to recover your initial investment from cumulative cash inflows. A shorter payback is generally better (faster recovery, less risk exposure). However, payback ignores cash flows after the cutoff and (in simple payback) ignores time value of money. Use it as a rough screening tool, but rely on NPV and IRR for final decisions.

Why does the NPV change so much when I adjust the discount rate slightly?

NPV is highly sensitive to the discount rate because each cash flow is divided by (1 + r)^t. Small changes in r compound over time, especially for long-term projects. This sensitivity is why choosing the right discount rate is so important. Use the NPV vs Discount Rate curve to visualize this sensitivity and understand how robust your decision is across a range of rates.

Can I use this calculator to compare projects with different time horizons?

Yes, but be careful. NPV and IRR can compare projects of different lengths, but interpretation requires thought. A 3-year project and a 10-year project might both have positive NPV, but the 10-year one ties up capital longer. Consider the Profitability Index to normalize for scale, and think about what you'll do with capital after the shorter project ends. In many cases, NPV still provides the clearest answer—accept all positive-NPV projects if capital isn't constrained, or rank by PI if it is.

Was this calculator helpful?

Your rating helps us improve every EverydayBudd tool.

Need More Data Science & Operations Tools?

Explore our other calculators for data science, operations, and more

View All Tools