DCF calculator

Same mechanics as the optional DCF overlay in the valuation suite. Use it to stress-test discount rate, growth, and exit multiple before you commit assumptions in a live process.

Free Cash Flow to Firm (FCFF) DCF: NOPAT + D&A − CapEx − ΔNWC, projected over an explicit period and discounted at WACC. Terminal value via Gordon Growth (perpetuity) or exit EV/EBITDA multiple. Constant EBITDA-margin assumption — anchored to your base year.

Inputs

Implied base-year EBITDA margin: 20.0%

Revenue (Year 0)

Base EBITDA (Year 0)

Depreciation & Amortization (Year 0)

Revenue growth %

WACC %

Tax %

CapEx %

NWC %

Terminal value

Terminal growth g % (must be < WACC)

Projection years (explicit)

Mid-year discounting convention

Bank standard: cash flows arrive evenly through the year, so year-t flow discounts at (1+WACC)^(t−0.5). Uncheck for year-end.

Indicative enterprise value

PV of explicit FCFF + PV of terminal value.

$3,281,903

PV explicit period: $1,305,408
PV terminal: $1,976,495
Terminal-year EBITDA: $734,664
Terminal-year FCFF: $430,187
Terminal method used: Gordon Growth
Terminal value % of EV: 60%
Implied exit EV/EBITDA: 5.0×
Discounting: Mid-year