The NPV calculator above takes an upfront cost, a series of yearly cash flows and a discount rate, and returns the net present value: the amount by which the discounted inflows exceed the outlay. A positive number means the cash flows are worth more today than the money you must commit to get them, measured against the return you said you require. A negative number means the opposite. It is the single most widely taught rule in capital budgeting, and the arithmetic behind it is a division that most people can do in their head — the difficulty is entirely in choosing the inputs honestly.
Arb Digital publishes free calculators that give a specific answer without a signup wall or a download. This one shows its working: every year's discounted value appears as its own bar, so you can see which years actually carry the project and which contribute almost nothing. That matters more than the headline figure, because a project whose value sits mostly in year seven is a different risk from one that is paid off by year two, even when both have the same NPV.
What This NPV Calculator Does
Enter the initial investment, the discount rate and the yearly cash flows. The tool discounts each flow back to today, adds them, subtracts the outlay, and reports four things: the net present value itself, the present value of the inflows before the outlay is deducted, the profitability index, and the year in which cumulative discounted cash flow first turns positive. It also solves for the discount rate at which NPV would be exactly zero, which is the internal rate of return of the same series.
Three timing conventions are available. End-of-year discounting is the textbook default and the most conservative. Mid-year discounting assumes cash arrives evenly through the year rather than in a lump on 31 December, which is closer to how an operating business actually collects, and it raises the NPV slightly. Beginning-of-year treats each flow as arriving on the first day of its period. Switching between them on the same numbers shows how much of an NPV is a modelling convention rather than an economic fact.
Two boundaries are worth stating plainly. Our present value calculator discounts a single future amount or a level annuity, which is the right tool when there is one payment to value and no uneven series. Our IRR calculator answers the mirror-image question — it holds NPV at zero and solves for the rate instead of holding the rate fixed and solving for the value. This page is for an uneven series discounted at a rate you supply.
How to Use It
- Enter the initial investment as a positive number. It is the money that leaves today, at time zero, and it is never discounted because it is already in today's money.
- Choose a discount rate. This is the return you require, not a market rate this page decides for you. Many analysts use their weighted average cost of capital; our WACC calculator builds that number from the capital structure.
- Type the yearly cash flows in order. Year one first. Separate them with commas or spaces. Enter a negative value for any year the project still consumes cash — a second factory line, a major overhaul, a working-capital build.
- Add a terminal value if the asset has one. A resale price, a salvage value or the value of everything after the forecast window. It is added to the final year before that year is discounted.
- Change the rate and watch the bars. Run it at your hurdle rate, then two points either side. If the sign of the answer flips inside that band, the decision is a rate assumption, not a finding.
The Formula and How It Is Calculated
Net present value is a sum of discounted cash flows minus the outlay:
NPV = −C₀ + Σ CFₜ ÷ (1 + r)ⁿ
where C₀ is the money committed today, CFₜ is the cash flow in year t, r is the discount rate as a decimal, and n is the exponent implied by the timing convention. End-of-year uses n = t. Mid-year uses n = t − 0.5. Beginning-of-year uses n = t − 1, so the first flow is not discounted at all.
Take the worked example loaded above. An outlay of 250,000, flows of 70,000, 80,000, 90,000, 95,000 and 100,000, discounted at 10 percent at year end. The discounted values are 63,636.36, 66,115.70, 67,618.33, 64,886.28 and 62,092.13. They add to 324,348.81, so NPV is 74,348.81. The profitability index is that total divided by 250,000, or 1.30 — every unit of capital committed buys about 1.30 units of present value. Cumulative discounted cash flow reaches 197,370.40 by the end of year three, so discounted payback falls partway through year four at roughly 3.81 years. Solve for the rate that drives NPV to zero and you get 20.34 percent, the internal rate of return.
The discount rate is the whole argument. Public reference points for the risk-free leg of that rate are published daily by the US Treasury as the Daily Treasury Par Yield Curve Rates, and the underlying present-value concept is defined plainly in the SEC's Investor.gov glossary. For the derivation and the assumptions behind discounted cash flow as a decision rule, MIT's Finance Theory I course materials are freely published.
Why NPV and IRR Sometimes Disagree
Both rules use the same cash flows, so it surprises people that they can rank two projects differently. They disagree in three specific situations, and knowing which one you are in tells you which rule to trust.
The first is scale. A small project can post a spectacular percentage return on a tiny base while a large project posts a modest percentage on a base ten times bigger. IRR ranks the small one first; NPV ranks by the absolute money created, which is what a shareholder actually receives. When the two conflict on mutually exclusive projects, NPV is the rule that maximises value.
The second is timing. A project that front-loads its cash has a higher IRR than one that back-loads the same total, because IRR implicitly assumes every interim receipt is reinvested at the IRR itself — a rate you may have no way of earning. NPV assumes reinvestment at the discount rate, which is a far more defensible assumption because it is the rate you actually said you could get elsewhere.
The third is sign changes. A series that goes negative, positive, then negative again can have two mathematically valid internal rates of return, or none. NPV always produces exactly one number for a given rate, which is why it never breaks in these cases. The break-even rate shown in the fourth result box is found by scanning across rates, so if the series has multiple sign changes it reports the lowest crossing it finds and you should treat the figure with suspicion rather than as the answer.
The Discount Rate Is a Judgement, Not a Lookup
Nothing in the mathematics tells you what rate to use, and most disagreements about an NPV are really disagreements about the rate. A rate has three components layered on top of each other: the return available on something close to risk free, a premium for the general riskiness of the business, and a premium for the specific project being riskier or safer than the business average.
Two errors are common. The first is using the company's overall cost of capital for a project that is much riskier than the company as a whole — a software firm evaluating a property purchase should not use its software hurdle rate. The second is double counting risk: building a pessimistic set of cash flows and then discounting those already-conservative numbers at a high risk rate. Pick one place to express caution. If your forecasts are already expected values with the downside weighted in, the rate should reflect the cost of capital, not your nerves.
Inflation is the third trap. Either forecast cash flows in nominal terms and discount at a nominal rate, or forecast in today's money and discount at a real rate. Mixing them understates or overstates the answer by roughly the inflation rate compounded over the project life, which over ten years is not a rounding error. Our inflation calculator is useful for converting a forecast between the two bases before you discount it.
What the Profitability Index Adds
The profitability index is the present value of inflows divided by the initial outlay. An index of 1.0 is the break-even point and matches an NPV of exactly zero. It answers a question NPV cannot: which projects should you fund when the constraint is capital rather than opportunity.
If you have a fixed budget and more positive-NPV projects than you can afford, ranking by NPV alone will tempt you into one large project when three smaller ones would together create more value for the same money. Ranking by profitability index and funding down the list until the budget runs out is the standard approximation to the right answer. It is only an approximation, because projects rarely divide neatly and the last one on the list often does not fit, but it beats ranking by size.
Discounted Payback and Why It Is Not Payback
Ordinary payback counts how long until cumulative undiscounted cash flow covers the outlay. It is popular because it is intuitive and it is a rough proxy for liquidity risk, but it ignores the time value of money entirely and it ignores everything that happens after the payback point. Our payback period calculator computes that simpler measure when that is what a lender or an internal policy asks for.
Discounted payback, shown here, fixes the first flaw by counting discounted cash flow instead. It always lands later than plain payback, and the gap widens with the discount rate. It still ignores everything beyond the crossing point, so it should never be used to rank projects — only as a cash-risk sanity check alongside the NPV. A project with a strong NPV and a discounted payback in year eight is a genuine bet on year eight arriving as forecast.
Where This Fits Alongside the Other Valuation Tools
NPV is one step inside a larger workflow. The cash flows you type here usually come from a forecast built elsewhere: our free cash flow calculator derives the cash a business actually throws off after capital spending, which is the correct series to discount for a business rather than accounting profit. Our DCF calculator extends the same discounting logic to a full company valuation with a growth-based terminal value. For a capital-intensive project, our depreciation calculator matters for the tax line inside those cash flows even though depreciation itself is never a cash outflow. The full free online tools hub lists the rest.
Arb Digital builds and measures growth programmes with the same discipline this page applies to a capital project — forecast the cash, agree the hurdle, then report against it.
See Web Growth Services Talk to Arb DigitalCommon Mistakes to Avoid
- Discounting the initial outlay — money spent today is already in today's money. Dividing it by one plus the rate understates the cost and inflates the NPV.
- Using accounting profit instead of cash flow — depreciation is subtracted from profit but never leaves the bank. Discount cash, then handle the tax effect of depreciation separately.
- Including sunk costs — a feasibility study you have already paid for does not belong in the outlay. Only cash that moves as a result of the decision counts.
- Mixing real and nominal — inflated cash flows discounted at a real rate, or today's-money cash flows discounted at a nominal rate. Pick one basis and hold it for the whole model.
- Reporting a single NPV with no sensitivity — one number implies a precision the forecast does not have. Show the answer at three rates and at least one downside cash flow case.
Related Free Tools From Arb Digital
Solve for the rate instead of the value with the IRR calculator, discount a single future amount with the present value calculator, build the hurdle rate with the WACC calculator, and check the simple cash-risk measure with the payback period calculator. For growth compounding in the other direction, the compound interest calculator is the counterpart, and the break-even calculator answers the volume question that often sits underneath the cash flow forecast.
Frequently Asked Questions
It is the amount by which the discounted future cash flows exceed the money you must commit today. A positive NPV means the project is worth more than its cost when measured against the return you said you require. A negative NPV means the same money would be better placed in whatever alternative that required return represents.
That is a judgement you make, not a number this calculator supplies. Most analysts start from their weighted average cost of capital and adjust it up or down for how risky the specific project is compared with the business as a whole. Because the answer moves with the rate, run it at several rates rather than one.
Because discounting shrinks distant cash. At 10 percent, money arriving in year ten is worth under 39 percent of its face value today. A project can return more than it cost in raw totals and still fail the test once the wait is priced in.
It is the present value of inflows divided by the outlay, so 1.30 means each unit of capital buys 1.30 units of present value. It is most useful when your budget is fixed and you have more attractive projects than money, because ranking by it approximates the best use of a limited pot.
End of year is the conservative textbook default and is fine for a comparison between projects run the same way. Mid-year is closer to a business that collects revenue evenly through the year, and it produces a slightly higher NPV. What matters is that you use the same convention for every option you compare.
Yes. Type a minus sign in front of any year that still consumes cash, such as a second phase of construction or a mid-life overhaul. Be aware that a series which changes sign more than once can have more than one internal rate of return, which is one reason NPV is the more reliable rule.
It is the point at which cumulative discounted cash flow first covers the initial outlay. It always falls later than ordinary payback because the cash is shrunk before it is counted. Treat it as a liquidity risk check rather than a ranking measure, since it ignores everything that happens after the crossing point.
Only if you make it. Either forecast cash flows in nominal terms and use a nominal discount rate, or forecast in today's purchasing power and use a real rate. Mixing the two bases is one of the most common modelling errors and it can shift the answer substantially over a long project life.
This calculator is provided for general education and reference. It explains how a net present value is computed and is not investment, tax or financial advice; talk to a qualified professional before committing capital.
