NPV Calculator

Calculate the Net Present Value and IRR of any investment to make data-driven capital allocation decisions.

Your required rate of return or WACC

Cash Flows by Period (Year 1, 2, 3...)

Year 1
Year 2
Year 3
Year 4
Year 5

Net Present Value: The Gold Standard of Investment Analysis

Net Present Value (NPV) is the most rigorous and theoretically sound method for evaluating capital investments. It answers the fundamental question: does this investment create or destroy value? By discounting all future cash flows back to today's dollars, NPV accounts for the time value of money — the principle that a dollar today is worth more than a dollar in the future.

The Time Value of Money: Why Future Cash Flows Are Worth Less

A dollar received today can be invested to earn a return. A dollar received in 5 years cannot be invested today. This opportunity cost is captured by the discount rate — the rate of return you could earn on an alternative investment of similar risk.

Example: At a 10% discount rate, $1,000 received in 3 years is worth only $751 today ($1,000 / 1.1^3). The NPV calculation applies this discounting to every future cash flow.

Interpreting NPV Results

Positive NPV: The investment returns more than the discount rate. It creates value and should be accepted (assuming the discount rate reflects your true opportunity cost). Zero NPV: The investment exactly meets your required return. You're indifferent. Negative NPV: The investment returns less than your discount rate. It destroys value relative to your alternatives.

NPV vs. IRR: Which to Use?

The Internal Rate of Return (IRR) is the discount rate at which NPV equals zero. It's the investment's implied rate of return. Both metrics are useful, but NPV is generally preferred for several reasons:

NPV accounts for the scale of the investment. A $1M investment with NPV of $100K is better than a $10K investment with NPV of $50K — even though the smaller investment has a higher IRR. NPV also handles unconventional cash flow patterns (multiple sign changes) more reliably than IRR.

Frequently Asked Questions

What is Net Present Value (NPV)?

NPV is the difference between the present value of future cash inflows and the present value of cash outflows over a period. A positive NPV means the investment creates value (returns more than the discount rate). A negative NPV means it destroys value.

What discount rate should I use for NPV?

The discount rate should reflect the opportunity cost of capital — what you could earn on an alternative investment of similar risk. Common choices: your cost of capital (WACC), your required rate of return, or a risk-adjusted rate. Many small businesses use 8–15%.

What is the NPV formula?

NPV = Σ [Cash Flow_t / (1 + r)^t] − Initial Investment. Where r = discount rate, t = time period. Each future cash flow is discounted back to present value, then summed. The initial investment is subtracted.

What is the difference between NPV and IRR?

NPV gives you the dollar value of an investment's worth above your required return. IRR gives you the rate of return at which NPV equals zero. Both are used for capital budgeting. NPV is generally preferred because it accounts for the scale of the investment.

When should I use NPV vs. payback period?

Use NPV for major capital investments where you need to account for the time value of money. Use payback period for quick screening of projects or when liquidity is a primary concern. NPV is more theoretically sound; payback period is simpler and more intuitive.

Can NPV be negative for a good investment?

A negative NPV means the investment returns less than your discount rate — it doesn't meet your required return. However, investments with negative NPV might still be pursued for strategic reasons (market entry, competitive defense, regulatory compliance) that aren't captured in cash flows.

How do I estimate future cash flows for NPV?

Base cash flow estimates on market research, historical data, and conservative assumptions. Build three scenarios: optimistic, base, and pessimistic. Calculate NPV for each. If NPV is positive even in the pessimistic scenario, the investment is robust.