NPV Calculator — Cash-Flow Waterfall
Compute Net Present Value of uneven cash flows over 1-10 years, with a waterfall that draws both nominal and discounted bars side-by-side. The cyan NPV bar lands positive (accept) or negative (reject) against your discount rate. IRR estimated automatically via bisection. Backed by Fisher (1907), Modigliani-Miller (1958), and Damodaran 2026 industry WACC tables.
Quick Conversion
Formula: PV = FV ÷ (1 + r)ⁿ
Real project presets
PV of $1,000 received in year N (at r = 10.0%)
| Year (N) | PV of $1,000 | PV factor |
|---|---|---|
| 1 | $909.09 | 0.9091 |
| 2 | $826.45 | 0.8264 |
| 3 | $751.31 | 0.7513 |
| 4 | $683.01 | 0.6830 |
| 5 | $620.92 | 0.6209 |
| 7 | $513.16 | 0.5132 |
| 10 | $385.54 | 0.3855 |
| 15 | $239.39 | 0.2394 |
| 20 | $148.64 | 0.1486 |
| 30 | $57.31 | 0.0573 |
Need just the discount factor? Present Value Calculator →
Formula
NPV = −C₀ + Σ CFₜ ÷ (1+r)ᵗDFₜ = 1 ÷ (1+r)ᵗNPV > 0 → accept; NPV < 0 → rejectWorked: C₀ = $500K, CF = [100K,150K,200K,250K,300K], r = 10% → PVs ≈ [91, 124, 150, 171, 186]K sum = $722K; NPV = 722 − 500 = +$222K → accept.
Why this calculator exists — Fisher, Williams, Modigliani-Miller, and Sharpe's NPV legacy
In 2026, a corporate-development director at a mid-cap industrial firm evaluates a $95M Boeing 737 MAX 8 lease against a 9% cost of capital. Each year the aircraft is forecast to generate $12-15M in net cash flow. Should the firm sign? The answer hinges on a single number — NPV — and on whether the discounted sum of those cash flows exceeds the upfront capital. This tool turns that decision into a 30-second waterfall chart, so the analyst can hand it directly into a board memo.
Net Present Value as a concept dates to Irving Fisher's 1907 work The Rate of Interest, which formalized the idea that a dollar tomorrow is worth less than a dollar today because today's dollar can be invested. Fisher's separation theorem — that production decisions can be made independently of consumption preferences via the price signal — gave the discount rate its first rigorous foundation. Every modern NPV calculation traces back to Fisher's equation (1 + nominal) = (1 + real) × (1 + inflation).
John Burr Williams' 1938 dissertation at Harvard, The Theory of Investment Value, applied Fisher's discounting to security valuation. Williams argued that any asset's value equals the present value of its future cash flows — the dividend discount model in its primitive form. Williams was the first to publish the phrase "intrinsic value" in its modern meaning, and to recommend NPV as the decision rule for corporate capital budgeting.
Franco Modigliani and Merton Miller's 1958 American Economic Review paper cemented NPV as the discipline. They proved that in frictionless markets, firm value is the present value of operating cash flows — independent of capital structure. The Modigliani-Miller theorem implies that any NPV-positive project, financed however, increases shareholder wealth. This is the formal justification for using NPV as the primary capital-budgeting decision rule rather than payback or accounting ROI.
William Sharpe's 1964 Capital Asset Pricing Model gave NPV its discount-rate engine. CAPM: r = rf + β(rm − rf). Combined with Modigliani-Miller, this yields WACC (see /tools/calculators/financial/wacc) as the firm-wide discount rate for unlevered cash flows. Harry Markowitz's 1952 mean-variance portfolio theory (Nobel Prize 1990, shared with Sharpe and Miller) supplied the diversification logic that justifies using systematic risk only.
The SEC requires public-company 10-K filings to disclose NPV-based impairment testing under FASB ASC 360 (long-lived assets) and ASC 805 (goodwill). The discount rate and cash-flow assumptions must be disclosed in Item 7A (Quantitative and Qualitative Disclosures about Market Risk). IFRS IAS 36 mandates the same value-in-use computation for international filers. FINRA market-makers track these disclosures because changes in disclosed WACC or terminal-growth assumptions signal management's evolving view of firm risk.
By 2026 Aswath Damodaran's NYU Stern dataset (updated each January) is the de-facto industry reference for NPV inputs: betas by industry, equity risk premium, country risk premium, and terminal growth assumptions. The Federal Reserve's 5-year breakeven inflation curve sets nominal-vs-real discount choices. Together they make every NPV calculation auditable against primary sources. This tool ships four preset projects benchmarked against industry medians from Damodaran, the Bessemer Cloud Index, IATA aircraft-lease economics, and US Department of Transportation fleet-cost surveys.
How to use the NPV waterfall
- Enter the initial investment. Type the upfront cash outlay (Year 0). It draws the red bar that drops below the baseline on the waterfall.
- Set the discount rate. Use your WACC or hurdle rate. A 10-12% rate is typical for US corporate projects; emerging-market projects use 14-20%.
- Fill each year of cash flow. Add or remove years (1-10) using the +Yr / −Yr buttons. Each year draws a light nominal bar and a deeper discounted bar.
- Read the cyan NPV bar. Above baseline = positive NPV = accept; below = negative = reject. The accept/reject pill shows the verdict immediately.
- Cross-check IRR. The IRR pad shows the break-even discount; accept if IRR comfortably exceeds your hurdle. Save the scenario to localStorage for comparison.
Related financial tools
What corporate-finance specialists say
“I run NPV on every Tata Capital infra mandate. The cash-flow waterfall is the cleanest visualization I have used — clients immediately see the difference between nominal and present-value bars. Bookmarked for every IC memo.”
“The aircraft-lease NPV preset matches exactly the structure we use for fleet financing. The IRR readout from the bisection routine agrees with my Excel to two decimal places. This replaces my workbook for ad-hoc client calls.”
“Used the truck-fleet preset to model our last expansion. The cyan NPV bar landing positive at our 14% hurdle rate gave the board the confidence to approve. Beautiful, intuitive, fast.”
“I evaluate German-Mittelstand acquisitions weekly. The waterfall's split of light-vs-deep green bars to show nominal vs discounted is exactly how I want to teach junior analysts the time-value concept. Excellent didactic tool.”
Love using our calculator?
Related Articles
Dive deeper with our expert guides and tutorials related to NPV Calculator — Cash-Flow Waterfall