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.

What This Calculator Does

This Net Present Value calculator helps analysts, CFOs, and business owners evaluate whether a proposed investment or project creates value. It discounts projected future cash flows back to their present value using a specified discount rate and compares the total against the initial investment. A positive NPV indicates the project is expected to generate more value than it costs, while a negative NPV suggests the investment should be reconsidered.

The Formula

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

The initial investment is subtracted because it is a cash outflow at time zero. Each future cash flow is divided by (1 + r) raised to the power of the year number, where r is the discount rate. This discounting reflects the time value of money: a dollar received in the future is worth less than a dollar today. The sum of all discounted cash flows minus the initial investment gives the NPV.

Step-by-Step Example

1

Enter the initial investment

This is the upfront capital required at Year 0. Example: $100,000.

2

Set the discount rate

Use your required rate of return, cost of capital, or WACC. Example: 10%.

3

Enter projected cash flows

Enter expected annual cash inflows as comma-separated values. Example: $25,000, $30,000, $35,000, $40,000, $45,000 over 5 years.

4

Interpret the result

With these inputs, the NPV is approximately $32,297. Since it is positive, the project is expected to create value above the 10% required return.

Real-World Use Cases

Capital Budgeting

Evaluate whether to invest in new equipment, facilities, or technology by comparing the NPV of each option.

Project Selection

When choosing between multiple projects with limited capital, rank them by NPV to allocate resources to the highest-value opportunities.

Acquisition Analysis

Determine a fair price for acquiring a business or asset by calculating the NPV of its projected cash flows.

Common Mistakes to Avoid

  • Using an unrealistically low discount rate, which inflates the NPV and makes poor investments look attractive.

  • Projecting overly optimistic cash flows without accounting for risk, competition, or market changes.

  • Forgetting to include all relevant cash flows such as working capital requirements, salvage value, or tax effects.

  • Comparing NPV of projects with different time horizons without adjusting for equivalent annual annuity.

Frequently Asked Questions

Accuracy and Disclaimer

NPV calculations are based on projected cash flows and an assumed discount rate. Actual results may differ significantly due to market conditions, execution risk, and unforeseen costs. This tool is for educational and planning purposes only. Consult a qualified financial professional for investment decisions.