C

NPV Calculator

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

Estimate net present value from projected cash flows and a chosen discount rate. Use the result to compare capital allocation options, check value creation, and stress-test assumptions.

Related Calculators

Editorial & Review Information

Reviewed on: 2026-02-28

Published on: 2025-10-17

Author: LumoCalculator Editorial Team

What we checked: We re-checked NPV formula mapping, discount-rate sensitivity, payback handling consistency, and source-link availability against the listed public references.

Purpose and scope: This page supports educational discounted cash-flow planning and project comparison. It does not provide portfolio suitability, security selection, or institution-specific underwriting decisions.

How to use this review: Treat outputs as scenario evidence, then confirm final assumptions for discount rate, taxes, financing terms, and execution risk with your internal review process before committing capital.

Financial Disclaimer

NPV outputs depend on forecast quality, timing assumptions, and discount-rate selection. Real outcomes may vary with financing conditions, demand shifts, inflation, tax effects, and execution risk. Use this calculator for planning context and confirm major decisions with qualified professional review.

Use Scenarios

Capital budgeting decisions

Compare investment alternatives by converting projected cash flows into present-value terms under a consistent required return.

Scenario stress testing

Test sensitivity by adjusting discount rate and cash-flow path to identify conditions where a project shifts from value-creating to value-eroding.

Portfolio prioritization

Use NPV together with profitability index and payback metrics to rank projects when budget is limited.

Formula Explanation

Core NPV equation

NPV = Sum[ CF_t / (1 + r)^t ] - Initial Investment

`CF_t` is period cash flow, `r` is discount rate, and `t` is period index. Each future flow is discounted back to present value before aggregation.

Profitability index

PI = Total Present Value of Inflows / Initial Investment

`PI > 1` indicates discounted inflows exceed upfront investment, while `PI < 1` indicates value loss under current assumptions.

Payback perspectives

Simple payback uses raw cash flows; discounted payback uses present values.

Discounted payback is typically longer and provides a stricter recovery lens for risk-adjusted capital planning.

Example Cases

Case 1: Equipment investment baseline

Inputs

  • Initial investment: $100,000
  • Discount rate: 10.0%
  • Cash flows (Y1-Y5): 30k / 35k / 40k / 35k / 30k

Computed Results

  • Total undiscounted inflow: $170,000
  • Total present value: $128,784
  • NPV: +$28,784
  • Profitability index: 1.288
  • Discounted payback: 4.58 years

Interpretation

The project clears the required return and recovers discounted capital within the modeled horizon.

Decision Hint

Use this as the base case, then test downside demand and cost-overrun scenarios before approval.

Case 2: Same cash flows, higher hurdle

Inputs

  • Initial investment: $100,000
  • Discount rate: 22.0%
  • Cash flows (Y1-Y5): 30k / 35k / 40k / 35k / 30k

Computed Results

  • Total undiscounted inflow: $170,000
  • Total present value: $97,033
  • NPV: -$2,967
  • Profitability index: 0.970
  • Discounted payback: Not reached

Interpretation

Required return pressure alone can move a project from value-creating to value-eroding, even with unchanged operating cash flows.

Decision Hint

Reprice financing, reduce upfront cost, or improve early-year cash flow before committing capital.

Case 3: Back-loaded inflow timing

Inputs

  • Initial investment: $100,000
  • Discount rate: 10.0%
  • Cash flows (Y1-Y5): 5k / 10k / 20k / 45k / 90k

Computed Results

  • Total undiscounted inflow: $170,000
  • Total present value: $114,455
  • NPV: +$14,455
  • Profitability index: 1.145
  • NPV gap vs Case 1: -$14,329

Interpretation

Nominal inflows match Case 1, but delayed timing materially reduces present value and lowers NPV.

Decision Hint

Improve milestone billing and shorten cash-conversion timing to recover discounted value.

Boundary Conditions

Initial investment must be non-negative and cash-flow list must contain at least one period.
Discount-rate input is constrained to 0-100% for practical scenario analysis.
Cash flows are treated as end-of-period values and are not adjusted for intra-period timing.
Inflation, tax shields, and financing side effects are not automatically modeled unless reflected in user cash-flow inputs.
Negative and volatile cash flows are supported, but interpretation should include scenario stress testing.
Use outputs for educational planning; final decisions should be validated against project-specific due diligence.

Sources & References

Frequently Asked Questions

What does NPV mean in investment analysis?
NPV measures value created after discounting expected future cash flows and subtracting initial investment. Positive NPV indicates value creation under the chosen discount rate.
How does discount rate affect NPV?
Higher discount rates reduce present values of future cash flows and lower NPV. Lower rates increase present values and can improve NPV.
What is the difference between simple payback and discounted payback?
Simple payback ignores time value of money, while discounted payback uses present values. Discounted payback is usually longer and more conservative.
Can NPV be compared across projects of different size?
Yes, but absolute NPV should be paired with profitability index, capital constraints, and risk profile so larger projects do not dominate by scale alone.
Why might NPV be negative even when cash flows are positive?
If discounted cash inflows are not large enough to recover initial investment at the required return, NPV remains negative.
Does this calculator replace financial advice?
No. It is an educational modeling tool and not individualized investment, tax, legal, or financing advice.