WallStSmart

NPV Calculator

Calculate Net Present Value, Internal Rate of Return, payback period, and profitability index. For project evaluation, real estate analysis, and capital budgeting decisions. Supports uniform and variable per-year cash flows.

Net Present Value

$21,710

At 10% discount rate

Accept Project

IRR: 16.33%

Above hurdle rate

IRR

16.33%

Above hurdle

Payback Period

4.00 yr

Initial recovered

Profitability Index

1.22

Creates value

Total Cash Flow

$75K

Undiscounted sum

Cash Flow Timeline

Annual Cash FlowCumulative Cash Position

The cumulative line crosses zero at the payback point. The chart shows undiscounted cash flows. NPV in the headline above is fully discounted.

Year-by-Year Breakdown

YearCash FlowDiscount FactorPresent ValueCumulative PV
0-$100,0001.0000-$100,000-$100,000
1$25,0000.9091$22,727-$77,273
2$25,0000.8264$20,661-$56,612
3$25,0000.7513$18,783-$37,829
4$25,0000.6830$17,075-$20,753
5$25,0000.6209$15,523-$5,230
6$25,0000.5645$14,112$8,882
7$25,0000.5132$12,829$21,710
Total NPV$21,710

How NPV Works

Net Present Value is the bedrock of financial decision-making. It answers a simple question: does this investment create or destroy value, given the cost of capital and the time horizon? Every other corporate finance technique extends from this one idea. If the discounted future cash flows exceed what you put in, the project clears the hurdle. If not, the money is better used elsewhere.

The math is direct. For each year of the project, take that year's expected cash flow and discount it back to today using your required rate of return. Sum up all the discounted cash flows. Subtract the initial investment. The result is NPV. A positive NPV means the project beats your hurdle rate. A negative NPV means it does not. Zero means it earns exactly the hurdle rate.

This calculator computes NPV plus three other essential metrics: IRR (the implied return), payback period (how long until you recover the investment), and profitability index (value created per dollar invested). Together they give you a complete picture of any project's financial profile.

NPV vs IRR vs Payback

These three metrics answer different questions. NPV tells you how much value the project creates in today's dollars. IRR tells you the implied annual return rate. Payback tells you how quickly you get your money back. Each has a use case.

For accept and reject decisions on a single project, NPV is the gold standard. It directly measures value creation in dollars. IRR is intuitive and works for most projects, but it can mislead when comparing mutually exclusive projects of different sizes, or when cash flows change sign multiple times (the multiple IRR problem). Payback is the simplest of the three but ignores the time value of money entirely and does not consider cash flows beyond the recovery date.

The right approach for serious analysis is to run all three and look at them together. A project with strong NPV, IRR above hurdle rate, and reasonable payback is a clear accept. Disagreement among the three is information: it usually means the project has unusual cash flow timing that deserves closer examination.

How to Use This Calculator

  1. Enter the initial investment. The upfront cost of the project, treated as a year-zero outflow.
  2. Set the discount rate. Your required rate of return or weighted average cost of capital. 8 to 12 percent is common for corporate projects.
  3. Choose project duration. Number of years the project generates cash flows. 5 to 10 years is typical.
  4. Enter the cash flow. Either a uniform annual amount, or toggle on per-year customization to enter different amounts each year.
  5. Read the verdict. Positive NPV plus IRR above your discount rate means the project clears the hurdle. Negative NPV means reject.
  6. Stress test. Lower your assumed cash flows by 20 to 30 percent and see if the project still works. Real projects almost always underperform initial forecasts.

Frequently Asked Questions

What is Net Present Value (NPV)?+

Net Present Value is the present value of all future cash flows from an investment, minus the initial investment cost. A positive NPV means the project is expected to generate more value than it costs in today's dollars. A negative NPV means the project destroys value relative to the discount rate. NPV is the foundation of corporate finance decision-making and is used to evaluate everything from factory expansions to real estate purchases to acquisitions.

How is NPV calculated?+

NPV equals the sum of (cash flow at time t divided by one plus discount rate raised to power t) for all periods, minus the initial investment. In plain terms: take every future cash flow, discount it back to today using your required rate of return, add them all together, then subtract what you put in. If the result is positive, the project clears your hurdle rate.

What discount rate should I use?+

The discount rate represents your opportunity cost or required rate of return. For corporate projects, it is typically the company's weighted average cost of capital (WACC). For personal investments, use the return you could earn on comparable risk elsewhere. For evaluating a stock, use the equity discount rate (10 to 12 percent is common). For very safe projects, treasury yields plus a small premium work. Higher risk demands higher discount rates.

What is the difference between NPV and IRR?+

NPV gives a dollar value at a given discount rate. IRR is the discount rate that makes NPV equal to zero. If IRR is higher than your required rate of return, NPV is positive at your required rate. Both should agree on accept and reject decisions for simple projects. They can disagree when comparing mutually exclusive projects of different sizes or when cash flows change signs multiple times. NPV is generally more reliable because it scales with project size.

What does a negative NPV mean?+

A negative NPV means the project does not earn its required rate of return. The discounted future cash flows do not cover the initial investment. Reject the project, or revisit your assumptions on cash flows, discount rate, or duration. Sometimes projects with negative NPV are still pursued for strategic, regulatory, or non-financial reasons, but that is an explicit override of the financial logic, not a contradiction of it.

What is the Profitability Index?+

The Profitability Index (PI) equals the present value of future cash inflows divided by the initial investment. PI greater than 1 means the project creates value (equivalent to positive NPV). PI of 1.25 means every dollar invested generates 1.25 dollars in present value terms. PI is useful for ranking projects when you have a fixed budget and need to choose between multiple positive-NPV options.

What is payback period and how is it different from NPV?+

Payback period is the time it takes to recover your initial investment from cash flows, ignoring the time value of money. It is a quick liquidity check, not a full evaluation. NPV considers time value of money and all cash flows over the project's life. Use payback as a sanity check (how exposed am I to bad early outcomes?) but rely on NPV for the actual accept and reject decision.

When does NPV fail or mislead?+

NPV is sensitive to the discount rate. Small changes can swing the answer significantly for long-dated projects. It also requires reliable cash flow forecasts, which are hard for long horizons. NPV does not capture optionality (the ability to expand, abandon, or delay), so for projects with significant flexibility, real options analysis can be a better tool. Finally, NPV does not consider strategic value, brand impact, or other non-financial benefits.

About WallStSmart's NPV Calculator

This calculator computes Net Present Value plus three complementary metrics (IRR, payback period, profitability index) for any cash flow stream. Supports both uniform and variable per-year cash flows. All calculations run in your browser. Nothing is stored or sent anywhere.