Calculator explainer

    NPV Calculator Explained: Formula, Worked Example & Free Tool

    Net present value (NPV) measures whether an investment creates value after you translate all future cash flows into today's dollars using a discount rate. Positive NPV usually means accept the project; negative NPV means the return does not cover your required hurdle rate.

    Formula in plain language

    Add up each future cash flow divided by (1 + discount rate) raised to the year number, then subtract the upfront investment.

    NPV = Σ [ CFₜ ÷ (1 + r)ᵗ ] − Initial investment

    Worked example

    Equipment upgrade with five-year cash flows

    • Initial cost (Year 0): $250,000 outflow.
    • Annual net cash savings: $80,000 in Years 1–5.
    • Discount rate (WACC / hurdle): 12% (r = 0.12).
    • Year 1 PV: $80,000 ÷ 1.12 = $71,429; Year 2: $63,776; Year 3: $56,943; Year 4: $50,842; Year 5: $45,395.
    • Sum of discounted inflows ≈ $288,385. Subtract $250,000 initial investment.

    NPV ≈ $38,385 — the upgrade clears a 12% hurdle and generally should be accepted if assumptions hold.

    Try the calculator

    Open full tool

    Net Present Value (NPV) Calculator

    Templates

    Save and load common input configurations

    No templates saved yet

    Save your current inputs as a template to reuse later

    NPV Calculator

    Calculate the net present value of an investment to determine its profitability

    Year 1
    Year 2
    Year 3

    Compare Calculations

    Save at least 2 calculations to use the comparison feature

    Need shareable exports for lenders?

    Pro saves scenarios and exports PDF and Excel built for bankers and buyers.

    MBACalc Pro from $19/mo

    Frequently asked questions

    What does a positive NPV mean?

    A positive NPV means discounted cash inflows exceed the initial investment at your chosen discount rate. The project is expected to add economic value relative to your required return.

    What discount rate should I use for NPV?

    Use WACC for firm-wide projects, a risk-adjusted equity hurdle for acquisitions (often 15–25% for small businesses), or the opportunity cost if capital is scarce.

    Can NPV and IRR disagree?

    Yes, when cash flows are non-conventional or projects differ in scale. NPV is generally the tie-breaker because it reflects absolute dollar value created.

    Is the MBACalc NPV calculator free?

    You can run calculations free in the browser. MBACalc Pro adds saved scenarios and shareable PDF and Excel exports for lender conversations.