Net Present Value (NPV) Calculator

What the calculator does and when to use it

The same number of euro is worth different amounts at different moments. A thousand euro today can be invested and become more within a year; a thousand euro a year from now cannot be invested today. Discounting is the reverse of compounding — it converts a future amount into its present-day equivalent. Net present value applies that consistently across all the expected flows of a project and then subtracts the money you must commit at the start.

The calculator suits any decision where you pay something now and receive something later: buying equipment, hiring a team with an expected contribution, developing a product, acquiring a property to let, taking a stake in a company. It is also the natural choice when comparing projects of different size — precisely where percentage measures mislead, because they ignore scale.

The formula and what each variable means

Net present value is the sum of all future flows divided by an increasing power of one plus the discount rate, minus the initial outlay.

• CFₜ — the net cash flow in year t: receipts minus costs for that year. Work with actual movements of cash, not accounting profit.
• r — the discount rate, expressed as a decimal. This is your minimum required return for projects of that risk.
• t — the year number, counted from the start of the project.
• C₀ — the initial investment, made at time zero.
• 1/(1+r)ᵗ — the discount factor for year t. It shows what one euro received in t years is worth today.

Unlike internal rate of return, there is no iteration here. The formula computes directly once you have chosen the discount rate — and that choice is the single most important decision when working with NPV.

A worked example

You are weighing a project with an initial outlay of €120,000 and rising receipts over the next five years. You require a minimum return of 8% per year.

The discounted receipts total €156,643.43. After subtracting the €120,000 invested, the net present value is €36,643.43. The project creates value: it does not merely cover the required 8% per year, it delivers nearly thirty-seven thousand euro in present-day money on top of that hurdle.

The cumulative column also shows when the outlay is recovered in discounted terms. By the end of year three the running total is still negative at −€30,462.07. During year four it turns positive. The discounted payback period is therefore around four years, and year five is pure gain.

Now look at how heavily the choice of rate matters. On the same flows, net present value is €28,032.61 at 10%, €20,128.37 at 12% and €9,440.37 at 15%. At roughly 18% it reaches zero — which is exactly the internal rate of return of this project, 17.99%. Above that rate the project destroys value. The two measures describe the same thing from two angles: NPV measures the value created in euro at a given rate, while IRR finds the rate at which the value created is zero.

Practical guidance

The discount rate is the most important input and the most common source of error. For a debt-financed project, a sensible starting point is the loan rate plus a margin for risk. For a project funded from your own capital, the rate is the return you would earn on the best available alternative of similar risk. Do not use a deposit rate to appraise a risky business project — that makes almost anything look attractive.

Be consistent about inflation. Either forecast the flows in nominal euro and discount at a nominal rate, or forecast them in today's prices and discount at a real rate. Mixing the two distorts the result badly over long horizons.

Work with after-tax flows. Bulgaria's flat 10% personal income tax simplifies the arithmetic for an individual investor, but the structure matters: investing through a company, earning rental income, and realising gains on financial instruments traded on a regulated market in the EU or EEA — which are exempt for individuals — are treated differently. Check the current regime for your particular structure before fixing a tax rate in the forecast.

Run a robustness check as well. Recompute NPV at a discount rate three to four percentage points above the one you chose, and with receipts 20% below forecast. If the result stays positive in both cases, the project has genuine headroom.

Limitations and when to use a different calculator

NPV is only as good as the forecasts behind it. Distant years carry a low discount factor and matter less, but that is exactly where uncertainty is greatest. Beyond seven or eight years, rely on scenarios rather than a single figure.

The calculator assumes annual periods with flows at the end of each year. If receipts are monthly or fall on irregular dates, accuracy degrades.

NPV does not capture the value of flexibility. A project you can halt or expand after year two is worth more than the mechanical output of the formula, which does not price that option.

When to switch calculators: if you want the return expressed as a percentage, use IRR. If flows fall on arbitrary dates, use XIRR. If you are valuing a bond with a fixed coupon and maturity, use yield to maturity. If you are planning regular contributions towards a savings goal, use the future value of regular contributions calculator.