Practice

DCF Valuation

Discounted Cash Flow — 5 year projection

DCF Model — 5 yearsTax rate: 25% · CAPEX: 5%
RevenueM€
Revenue Growth%
EBITDA Margin%
WACC%
Terminal Growth%
Net DebtM€
Output
Enterprise Value188 M€
Equity Value138 M€
% Terminal Value74.1%
Year 5 FCF14.7 M€
FCF Projection
Y1Y2Y3Y4Y5
FCF10.811.712.613.614.7
PV(FCF)9.99.89.79.69.5
Y1
Y2
Y3
Y4
Y5

Go further

Our DCF Excel template includes multiple scenarios, sensitivity analysis, and a comprehensive dashboard.

View DCF template