Project NPV Comparison Calculator

A fixed five-year forecast is the working format of most corporate capital-approval papers, and this model follows that convention: one outlay at time zero, then five end-of-year net cash flows discounted at a single rate. The discount rate should be the weighted average cost of capital for a project of ordinary risk, blending the after-tax cost of debt with a cost of equity usually derived from the capital asset pricing model. Most mature non-financial corporates operate with a WACC between 7 and 12 percent, and many add two to five percentage points as a hurdle premium for new-market or new-technology proposals. The cash flows entered should be incremental and after tax - the difference the project makes to company cash - and should include the depreciation tax shield and any change in working capital, but never interest, since financing cost is already carried in the discount rate. The supporting outputs exist because NPV alone does not answer every approval question. Payback and discounted payback measure how long the firm is exposed before recovering its outlay, which matters when cash is tight regardless of what NPV says. The profitability index normalizes value created per dollar committed and is the correct ranking rule under a hard capital budget. IRR gives a percentage that compares easily to the hurdle rate but can rank mutually exclusive projects incorrectly when they differ in scale or timing; where IRR and NPV disagree on such a pair, NPV governs. The central caveat with a five-year window is truncation: if the asset still has economic life in year six, ending the model there sets its continuing value to zero. Practitioners either extend the horizon or fold a terminal value, often a perpetuity or an exit multiple, into the year-five figure.

Formal capital budgeting emerged as American corporations grew too large for investment decisions to be made by an owner's judgment. Joel Dean's Capital Budgeting, published by Columbia University Press in 1951, is the usual marker for the shift from payback and accounting rate of return toward discounting, and it argued that firms should rank proposals by their contribution to value rather than by how quickly cash came back. The missing piece was a defensible discount rate, supplied by Franco Modigliani and Merton Miller in their 1958 American Economic Review paper on the cost of capital, which established the link between a firm's financing mix and the return its investments must clear. Harold Bierman and Seymour Smidt's textbook The Capital Budgeting Decision, first published in 1960 and revised over many later editions, turned the theory into a procedural manual and helped standardize the multi-year cash flow table that this calculator reproduces. Risk handling advanced in parallel: David Hertz's 1964 Harvard Business Review article on risk analysis in capital investment introduced simulation of probability distributions rather than single point estimates, an approach only fully practical once computing became cheap. The five-year forecast horizon itself is a convention of postwar corporate planning rather than a theoretical requirement, retained because it matches typical business-plan periods and because forecast reliability degrades sharply beyond it.