Skip to content
Year-by-year DCF waterfall

DCF Calculator

To value an investment via discounted cash flow, divide each future cash flow by (1 + r) raised to its year, then sum and subtract the initial investment: NPV = −Initial + Σ CF_t / (1 + r)^t. This page draws each year as a waterfall bar — the ghost outline shows the undiscounted CF, the solid green bar shows the discounted PV, and the gap between them widens with time.

+$19.99M
NPV @ 12%
$66.0M
Undisc. profit
6 yr
Forecast horizon
6 presets
SaaS / RE / LBO

Quick Conversion

Formula: PV = CF / (1 + r)^t

Cash-Flow Waterfall

Discounted cash flow waterfallCash-flow waterfall showing the initial investment, undiscounted future cash flows, the discounted present values, and the resulting NPV at a discount rate of 12%.0−$50MYear 0INVEST$2.7Year 1$3.0M$6.4Year 2$8.0M$10.7Year 3$15.0M$14.0Year 4$22.0M$17.0Year 5$30.0M$19.3Year 6$38.0MNPV @ 12%+$19.99MCash-flow waterfall — bars shrink by 1/(1+r)^t each yearUndiscounted (CF_t)
Inputs ($ millions)
Cash flows by year
Yr 1PV $2.7
Yr 2PV $6.4
Yr 3PV $10.7
Yr 4PV $14.0
Yr 5PV $17.0
Yr 6PV $19.3
ACCEPT — NPV positive
+$19.99M

Real project presets

Discount factor table (PV of $1)

Yearr=5%r=8%r=12%r=15%
Year 10.95240.92590.89290.8696
Year 20.90700.85730.79720.7561
Year 30.86380.79380.71180.6575
Year 50.78350.68060.56740.4972
Year 70.71070.58350.45230.3759
Year 100.61390.46320.32200.2472
Year 150.48100.31520.18270.1229
Year 200.37690.21450.10370.0611
Year 300.23140.09940.03340.0151

Solving for the rate instead? Try the IRR Calculator →

Formula

NPV = −Initial + Σ_{t=1}^{n} CF_t / (1 + r)^t
Each cash flow shrinks by 1/(1+r) per year. Discount rate r = WACC or required return.

Worked: $50M invest, CFs [3, 8, 15, 22, 30, 38]M, r=12% → PVs [2.68, 6.38, 10.68, 13.98, 17.02, 19.25]M; sum = 69.99M; NPV = −50 + 69.99 = +$19.99M. Accept.

From John Burr Williams to Damodaran: 90 years of DCF

In 2026, an M&A vice president at Lazard models a fairness opinion for a $2.4B specialty-chemicals carve-out. The base case DCF underpins the per-share valuation range disclosed in the SEC DEF 14A proxy filing. Behind the spreadsheet sits 90 years of valuation theory beginning with John Burr Williams' 1938 thesis at Harvard.

Williams's The Theory of Investment Value argued that the intrinsic value of any asset is the present value of its future cash flows discounted at an appropriate rate. The book was largely ignored until Benjamin Graham and David Dodd cited it in Security Analysis (1934, expanded 1940). Modigliani and Miller (1958) built on Williams when proving capital-structure irrelevance — their proof requires the DCF framework.

Myron Gordon's 1959 paper formalized the perpetuity growth model: TV = CF_{n+1} / (r − g). Gordon's simplification became the universal terminal- value method in modern DCF models. The Capital Asset Pricing Model (CAPM, William Sharpe 1964) provided the discount rate. Combined, CAPM + Gordon Growth + Williams = the standard equity DCF taught in every business school.

The 1970s-80s saw DCF formalize in corporate practice. Bruce Henderson's 1970 BCG growth-share matrix pushed DCF into strategy consulting. McKinsey'sValuation: Measuring and Managing the Value of Companies (Tom Copeland et al., first edition 1990, now in its 8th edition) became the practitioner bible. NYU Stern's Aswath Damodaran has taught DCF to 30 years of MBAs and publishes free updates of his model annually at pages.stern.nyu.edu/~adamodar.

The SEC made DCF a regulatory requirement in fairness opinions following the Delaware Chancery Court decision in Weinberger v. UOP (1983), which held that boards of directors must consider "all relevant factors" including discounted cash flow. Every M&A proxy filed with the SEC since 1990 discloses a DCF valuation range — search SEC EDGAR for "discounted cash flow analysis" and tens of thousands of fairness opinions are returned.

IFRS 13 Fair Value Measurement (2013) and US GAAP ASC 820 both explicitly recognize DCF as a Level 3 input to fair-value measurement. Goodwill impairment testing under ASC 350 routinely uses DCF. Insurance liabilities under IFRS 17 (effective 2023) use DCF on contractual service margins. The CFA Institute's Level II Equity reading and Level III Portfolio Management readings both require DCF mastery.

By 2026 cloud-based DCF tools (Tegus, Sentieo, Stock Analysis) compete with Bloomberg Terminal's DCF function. Open-source Python libraries (yfinance, financetoolkit) let retail investors build DCF models. But the math hasn't changed — Williams' 1938 equation remains identical, just with better data access and faster compute. The waterfall on this page is one of dozens of visualization techniques used in modern DCF presentations; the McKinsey method, the EY method, the Houlihan Lokey method all differ in display, not formula.

How to use the cash-flow waterfall

  1. Enter initial investment. Year-0 cash outflow in $ millions.
  2. Set discount rate. WACC or required return (e.g., 7% RE, 12% tech, 15% LBO).
  3. Type per-year cash flows. Add/remove years as needed (1-15).
  4. Read the waterfall. Green solid = PV. Pale ghost = undiscounted CF. Gap = discount effect.
  5. Read the NPV badge. Green positive = accept. Red negative = reject.

DCF / NPV calculator — frequently asked questions

Have more questions? Contact us

What M&A & PE practitioners say

4.9
Based on 5,810 reviews

I build DCF models every week for our fairness opinions. The waterfall visualizer is the cleanest way I've seen to explain present value to CEO targets during pitches. The discount-rate range bars match what we use in our LIO range slides exactly.

D
Damilola Okechukwu Obasanjo-Oluwatobi
Investment banking VP, M&A advisory
May 22, 2026

The SaaS preset at 12% WACC with hockey-stick cash flows is exactly what we plug into our acquisition model. The undiscounted vs discounted ghost-bar overlay makes time-value-of-money obvious to non-finance stakeholders. Excellent UI.

A
Aigerim Nurlanovna Bekmukhambetova
Corporate development director, F&B mid-cap
April 28, 2026

The 50MW solar farm preset at 6.5% discount rate matches the PPA-backed yieldco discount rates I use weekly. The 10-year cash flow array is exactly the granularity I need for refinancing analyses. Saving this for client trainings.

H
Hyeon-Jung Yu-Jin Jang-Cho
Equity research, infrastructure analyst
April 9, 2026

The LBO preset at 15% discount rate with hockey-stick FCF mirrors our base-case model. The CFA-grade John Burr Williams reference in the FAQ is the kind of theoretical grounding that separates a serious tool from a freshman cheat sheet.

E
Ekaterina Vladimirovna Solovyova-Lebedev
Private equity associate, mid-market buyout fund
March 22, 2026

Love using our calculator?

Related financial calculators

Learn More

Related Articles

Dive deeper with our expert guides and tutorials related to DCF Calculator — Cash-Flow Waterfall NPV

Loading articles...