Net Present Value (NPV) Calculator — Step-by-Step

Net present value expresses an investment as a single number in today currency by discounting every projected cash flow back to period zero and subtracting what must be paid up front. The discount factor for period n is 1/(1+r)^n, which falls quickly: at a 10 percent rate, a dollar arriving in year 1 is worth 0.909 today, in year 5 it is worth 0.621, and in year 10 only 0.386. This is why two projects with identical undiscounted totals can have very different NPVs depending on whether cash arrives early or late. The discount rate r represents the opportunity cost of capital - the return available on an alternative of comparable risk - and for corporate capital budgeting it is normally the weighted average cost of capital, which for most large listed firms falls in the 7 to 12 percent range. The decision rule is that a positive NPV project earns more than the required return and should be accepted, while the profitability index, present value divided by initial outlay, ranks projects by value created per dollar committed when capital is rationed. The method is only as reliable as its inputs, and its sensitivity to the discount rate is the most common source of error, which is why the sensitivity table across several rates matters more than any single figure. Other pitfalls are structural: including sunk costs that cannot be recovered, omitting working capital swings, salvage values or tax effects, double-counting risk by both haircutting cash flows and raising the discount rate, and mixing nominal cash flows with a real discount rate. Standard NPV also assumes a committed, passive project and therefore undervalues investments carrying genuine managerial flexibility to expand, defer or abandon, which real options analysis addresses separately.

Discounting is older than corporate finance. Compound interest tables were published by Simon Stevin in 1582, and the underlying logic of valuing deferred sums was familiar to merchants and actuaries long before it was applied to capital projects. Irving Fisher gave the idea rigorous economic form in The Rate of Interest in 1907 and again in The Theory of Interest in 1930, framing investment choice as a comparison between the present value of a project and its cost. John Burr Williams extended discounting to securities in The Theory of Investment Value in 1938, arguing that an asset is worth the present value of the cash it will distribute - the foundation of the dividend discount model and of discounted cash flow valuation generally. The translation into everyday corporate practice came after the Second World War. Joel Dean, an economist at Columbia, published Capital Budgeting in 1951 and argued that firms should rank projects by discounted measures rather than payback period or accounting rate of return, which were then the dominant tools. Adoption was slow through the 1950s and 1960s but accelerated as business schools built the technique into their curricula and as the cost of capital gained a theoretical basis through the work of Modigliani and Miller from 1958 onward. By the time John Graham and Campbell Harvey surveyed 392 chief financial officers for their 2001 Journal of Financial Economics study, roughly three quarters reported using net present value always or almost always, placing it alongside internal rate of return as the standard capital budgeting method.