Profession Calculators
Finance & Accounting

Net Present Value (NPV) Calculator

Evaluate project investments by discounting future cash flows to their present value and comparing against the initial outlay.

Share:

Upfront cost at Year 0.

Required rate of return or WACC.

Enter projected cash flows for each future year, separated by commas. Year 1, Year 2, Year 3, etc.

Your Results

$

Enter investment details and click calculate.

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

A project that returns $200,000 over five years on a $100,000 investment looks profitable on the surface. But if those returns trickle in at $40,000 per year and your cost of capital is 12%, the net present value of that investment is actually negative. You are not making money; you are losing ground relative to what that $100,000 could earn elsewhere. Net Present Value is the capital budgeting tool that corrects for this. It discounts every future cash flow back to today's value and tells you whether the project creates or destroys value in dollar terms, after accounting for the time cost of money. The CFA Institute's corporate finance curriculum identifies NPV as the primary decision criterion for capital allocation precisely because it measures wealth creation directly.

What This Calculator Does

This Net Present Value calculator discounts a series of projected future cash flows back to their present value using your specified discount rate, then subtracts the initial investment to produce the NPV. A positive NPV indicates the project is expected to create value above your required rate of return. A negative NPV indicates the project falls short. The calculator supports up to 10 years of individual cash flow entries and displays the discounted value of each year alongside the cumulative NPV.

The Formula

NPV = -Initial Investment + Sum of [Cash Flow(t) / (1 + r)^t] for t = 1 to n

The initial investment is a cash outflow at time zero, so it is subtracted. Each future cash flow is divided by (1 + r) raised to the power of the year number. This discounting reflects the time value of money: a dollar received two years from now is worth less than a dollar received today, because the dollar today could be invested for two years. The discount rate r represents your required minimum return, typically the weighted average cost of capital (WACC) or a project-specific hurdle rate.

Step-by-Step Example

1

Enter the initial investment

The upfront capital outlay at Year 0. This is always a negative cash flow. Example: $150,000.

2

Set the discount rate

Use your WACC, required rate of return, or opportunity cost. Example: 10%. For riskier projects, use a higher rate (12-15%) to build in a risk premium.

3

Enter annual cash flows

Projected net cash inflows for each year. Example: Year 1: $30,000. Year 2: $40,000. Year 3: $50,000. Year 4: $55,000. Year 5: $60,000.

4

Interpret the result

At 10% discount rate: PV of Year 1-5 cash flows = $177,170. NPV = $177,170 - $150,000 = $27,170 (positive). The project creates $27,170 in value above the 10% required return. Accept.

Real-World Use Cases

Equipment Purchase Decision

A manufacturer evaluating a $400,000 CNC machine projects $95,000 in annual labor savings over 6 years with a $40,000 salvage value. At a 9% WACC, the NPV is approximately $32,000, justifying the purchase. At 12% WACC, the NPV drops to -$18,000, making the case marginal.

Business Acquisition Valuation

An acquirer projects a target company's free cash flows for 7 years, adds a terminal value using the Gordon Growth Model, and discounts everything at 11% WACC. The result is a maximum offer price that compensates for the required return. Any offer above the NPV-derived price destroys acquirer value.

Technology Infrastructure Investment

A CFO evaluating a $2.1M ERP system implementation models $420,000/year in efficiency savings and cost reductions over 8 years. At a 10% discount rate, the NPV is $140,000. The project clears the hurdle, but barely, so the CFO runs sensitivity analysis on the savings assumptions before approving.

Comparison

Discount RateYear 1-5 Cash FlowsTotal UndiscountedNPVDecision
8%$40K / $45K / $50K / $55K / $60K$250,000$50,832Accept
10%$40K / $45K / $50K / $55K / $60K$250,000$38,944Accept
12%$40K / $45K / $50K / $55K / $60K$250,000$27,788Accept
15%$40K / $45K / $50K / $55K / $60K$250,000$11,418Accept (marginal)
18%$40K / $45K / $50K / $55K / $60K$250,000-$3,916Reject

Common Mistakes to Avoid

  • Using an artificially low discount rate to make the NPV look positive. Every percentage point reduction in discount rate inflates NPV. A 6% discount rate on a project you would normally evaluate at 12% doubles the present value of far-future cash flows. Always use your actual cost of capital.

  • Projecting overly optimistic cash flows without a conservative scenario. Most capital projects underperform initial projections. Run a downside case where cash flows are 20-30% below base case and verify the NPV still meets your threshold.

  • Omitting working capital requirements and terminal value. Many projects require upfront working capital investment and have salvage or terminal value at the end. Both significantly affect NPV and are commonly excluded in initial analyses.

  • Comparing NPV across projects of different scales and calling the higher percentage return the winner. A project with $8,000 NPV on a $10,000 investment (80% gain) may create less absolute wealth than a project with $500,000 NPV on a $2,000,000 investment (25% gain). When capital is not constrained, maximize total NPV.

Frequently Asked Questions

Accuracy and Disclaimer

NPV calculations depend entirely on the projected cash flows and discount rate you provide. Small changes in either input can materially change the result. Projected cash flows are uncertain and subject to execution risk, market changes, and unforeseen costs. This tool is for financial planning and educational purposes. Consult a qualified financial analyst or investment banker for formal valuation work.

Conclusion

NPV is the most rigorous single-number summary of whether an investment is worth pursuing. When comparing multiple competing projects, rank by NPV in dollar terms, not percentage return, because scale matters. A $50,000 NPV project creates more absolute wealth than a $15,000 NPV project even if the latter has a higher IRR. Use this calculator alongside the IRR Calculator for a complete picture: NPV tells you the dollar value created, IRR tells you the percentage return. For real estate or acquisition scenarios, the Compound Interest Calculator can model the opportunity cost of the capital you are deploying.