NPV Formula Calculator: How to Use It

This calculator works out the Net Present Value (NPV) of a series of future cash flows. You enter an initial investment, a discount rate, and the expected cash flows for each period, and it returns the NPV in today’s money. The result tells you whether the investment is likely to add value compared with putting the same money elsewhere at the discount rate.

Formula

The NPV formula discounts each future cash flow back to its present value using the discount rate, then subtracts the initial investment. In symbols:

NPV = –C₀ + Σ (C_t / (1 + r)^t)

• C₀ = initial investment (a negative cash flow at time 0, in your currency)
• C_t = net cash flow in period t (in your currency)
• r = discount rate per period (as a decimal, e.g., 10% = 0.10)
• t = time period number (1, 2, 3, …)

The calculator above uses the same formula. It assumes cash flows occur at the end of each period, which is the standard convention. If your cash flows occur at the beginning of the period, you would adjust the exponent (use t–1) – but that’s a less common variant.

Worked Example

Using the default values: initial investment = 1000, discount rate = 10%, cash flows = 300, 400, 500, 600.

1. Discount each cash flow: 300/(1.10)^1 = 272.73; 400/(1.10)^2 = 330.58; 500/(1.10)^3 = 375.66; 600/(1.10)^4 = 409.81.
2. Sum the present values: 272.73 + 330.58 + 375.66 + 409.81 = 1388.78.
3. Subtract the initial investment: 1388.78 – 1000 = 388.78.

The NPV is 388.78 (rounded to two decimals). The calculator’s first output shows the same result. Because the NPV is positive, the project is expected to generate more value than the 10% discount rate – it’s a financially attractive investment under this assumption.

When to Use NPV

NPV is used in capital budgeting to evaluate whether a project or investment is worthwhile. It’s applicable when you have an initial outlay and a series of expected future cash inflows (or outflows). Common uses include:

• Comparing alternative projects – the one with the higher NPV is generally preferred.
• Deciding whether to accept a single project – accept if NPV > 0.
• Evaluating business expansions, equipment purchases, or real estate investments.

The discount rate is the key input. It should reflect the opportunity cost of capital – the return you could earn elsewhere with similar risk. A common choice is the company’s weighted average cost of capital (WACC), but for a personal investment you might use your required rate of return.

How to Read the Result

NPV is expressed in the same currency as your cash flows. A positive NPV means the investment is expected to generate more value than the discount rate implies. A negative NPV means it’s expected to fall short. A zero NPV means it’s exactly on par with the discount rate.

For example, an NPV of 388.78 with a 10% discount rate means the project is expected to be worth 388.78 more today than investing the same money at 10% compounded annually. But NPV is only as good as your cash flow estimates – if those are wrong, the NPV will be off.

Common Mistakes

Several errors are easy to make when calculating NPV manually or entering data into a calculator:

• Using the wrong discount rate period. If your cash flows are monthly, use a monthly discount rate (annual rate / 12). The calculator above assumes the rate you enter matches the period of your cash flows.
• Forgetting the initial investment sign. The formula subtracts the initial outlay; if you enter it as a positive number without subtracting, you’ll overstate NPV.
• Inconsistent timing. NPV assumes end-of-period cash flows. If your first cash flow comes immediately (time 0), it should be added to the initial investment, not discounted.
• Rounding too early. If you round each discounted cash flow to two decimals before summing, you might get a slightly different result. Keep more decimals during the calculation.

Limits of the Formula

NPV is a powerful tool, but it has limitations. It assumes a constant discount rate over the entire period, which may not reflect reality – rates can change. It also assumes cash flows are reinvested at the discount rate, which might not happen. NPV doesn’t capture non-financial factors like strategic value or risk beyond the discount rate. For projects with uncertain cash flows, you might run a sensitivity analysis by changing the discount rate and cash flow estimates to see how NPV changes.

Alternatives to NPV

NPV is not the only investment appraisal method. Others include:

• Internal Rate of Return (IRR) – the discount rate that makes NPV zero. It gives a percentage return, which some find intuitive, but it can be misleading for projects with non-conventional cash flows.
• Payback Period – the time it takes to recover the initial investment. Simple but ignores the time value of money and cash flows after the payback date.
• Profitability Index – NPV divided by initial investment. Useful for ranking projects when capital is limited.

Each method has its place, but NPV is generally considered the most theoretically sound because it directly measures value added in today’s money.

Frequently Asked Questions

What discount rate should I use for NPV?

Use a rate that reflects the opportunity cost of capital – the return you could earn on a similar-risk investment. For businesses, that’s often the weighted average cost of capital (WACC). For personal investments, you might use your required rate of return or the interest rate on a comparable savings account.

What does a negative NPV mean?

A negative NPV means the investment is expected to lose value compared with investing at the discount rate. In other words, you’d be better off putting your money elsewhere. However, some projects with negative NPV are still undertaken for strategic reasons, such as regulatory compliance or market entry.

Can NPV be used for personal finance?

Yes. You can use NPV to compare a lump-sum payment versus an annuity, or to evaluate a rental property purchase. Just be realistic about cash flows and choose a discount rate that reflects your investment alternatives.

How does NPV differ from IRR?

NPV gives a dollar figure; IRR gives a percentage rate. NPV is generally preferred because it doesn’t have the multiple-IRR problem that can occur when cash flows change sign more than once. IRR is useful for comparing the return of different projects, but it can be misleading if the scale of investment differs.

What if my cash flows are uneven?

That’s fine – NPV handles uneven cash flows naturally. You just enter each period’s cash flow separately. The formula discounts each one by its own period number.

Does the calculator include the initial investment in the cash flow list?

No. The initial investment is entered separately in the “Initial investment” field. The cash flow list should contain only the net cash inflows (or outflows) for each period after the start. If you include the initial investment in the list, you’d double-count it.

Related

• JB Value Calculator Formula Explained
• GST Calculator Formula: How to Add & Remove Tax
• Increment Calculator Formula & How to Use It

in rate | Discount rate (annual) | % | 10 | 0
in inv | Initial investment | currency | 1000 | 0
list cf | Cash flows per period | 300, 400, 500, 600
out npv | Net present value | currency | -inv + sum(cf[i] / (1 + rate/100)^i) | 2