DCF for Italian SME: Complete Guide with Downloadable Excel Template

DCF (Discounted Cash Flow) applied to an Italian SME is the valuation method that returns the most “intrinsic” value — what future cash flows are worth discounted to present. It’s the principal method for cash-generative, asset-light businesses with visible growth prospects. It’s also where the most mistakes happen: extreme sensitivity to assumptions, Terminal Value worth 60-70% of total, mis-calculated WACC. This guide is the operational framework I use on mandates, with downloadable Excel template at end.

When DCF is the dominant method

• Businesses with stable cash flows (recurring revenue, multi-year contracts)
• Asset-light companies (software, B2B services, advisory)
• Sectors without recent transaction comps
• Internal valuations for strategic decisions (M&A, capex, divisional spin-off)
• Equity raise where you want to justify valuation with projection

When NOT to use DCF as primary method: cyclical businesses (FCF volatility), early-stage companies (no reliable projections), structurally loss-making.

The 5 DCF components — overview

Critical note: Terminal Value weighs 50-70% of final value. A small variation in “g” (perpetual growth rate) or WACC changes everything. Sensitivity analysis on these two drivers is mandatory.

Step 1 — Free Cash Flow for next 5 years

Base formula:

FCF = EBITDA × (1 − t) − ΔWorking Capital − CapEx + Depreciation × t

Where t = tax rate (24% IRES + 3.9% IRAP for Italian SME = ~28% effective).

Step 2 — Terminal Value (the heaviest component)

Method A — Perpetuity Growth (Gordon)

TV = FCF year 6 / (WACC − g)

Where g = perpetual growth rate, typically 1.0-2.5% for mature Italian SMEs.

Example: FCF year 6 = $2.95M, WACC = 10%, g = 2% → TV = $36.9M

Method B — Exit Multiple

TV = EBITDA year 5 × Exit Multiple

Exit Multiple = expected EV/EBITDA at sale year. Typically “steady-state” sector multiple. For Italian manufacturing SME: 5.5-7x.

Compare the two methods. Differences >25% indicate assumption problem (g too high or exit multiple too low).

Step 3 — WACC (Weighted Average Cost of Capital)

WACC = (E/V) × Ke + (D/V) × Kd × (1−t)

Cost of Equity (Ke) — pattern for Italian SME

Ke = Rf + Beta × ERP + Country Premium + Size Premium + Illiquidity Premium

• Rf (risk-free rate) = Italian 10Y BTP ≈ 3.5-4.0%
• Beta = market sensitivity. For Italian mid-market SME: 0.9-1.2
• Equity Risk Premium (ERP) = 5.0-6.5% Italy 2024-2025
• Country Premium = 0.5-1.5% (sovereign risk Italy vs DE/FR)
• Size Premium = 1.5-3.0% (for illiquid SME)
• Illiquidity Premium = 1.0-2.5% (private)

Typical Ke range for Italian mid-market SME: 12-16%.

Cost of Debt (Kd)

Average bank financing cost of the specific SME, typically 4-7% in Italy 2025.

Final WACC

For Italian mid-market SME with moderate leverage (30-40% D/V): WACC 9-13%.

Step 4 — Discount + Sum

Step 5 — Sensitivity Analysis (mandatory)

5×5 matrix on the two most important drivers:

Plausible EV range: $22-40M depending on assumptions. Communicate to client: “Central value $27M, but range $22-32 plausible with WACC ±1% and g ±0.5%”.

Excel template — download

I prepared a ready-to-use Excel template for Italian mid-market SMEs:

• 5 sheets: Assumptions, FCF Build, WACC Calculation, DCF Summary, Sensitivity
• Colored cells for editable inputs (yellow) vs calculated outputs (gray)
• Automatic sanity checks (warning if WACC < 7% or > 18%, if g > 3%, if Terminal Value > 80% of total value)
• Italian taxation integrated (IRES + IRAP)

Available on request: write to info@saveriocanepa.it with subject “DCF Template” and you’ll receive the Excel file within 24h.

Typical founder mistakes when doing DCF alone

1. Revenue growth too aggressive: 15%+ CAGR without justified drivers = valuation inflated 40%+
2. Unmotivated margin expansion: assuming +500bps in 5 years requires proof
3. WACC too low: using 7-8% because “risk-free rates are low”. For illiquid Italian SME minimum 10-11%
4. Perpetual growth too high: 3-4% perpetual growth implies indefinite above-inflation growth. Cap at 2.0-2.5% for mature SMEs
5. Wrong capital structure: using current leverage instead of target post-deal
6. Working capital underestimate: Italian SMEs have WC typically 12-20% of revenue
7. D&A not reconciled with CapEx: in long run D&A ≈ CapEx (steady-state)

Frequently Asked Questions

Can I use DCF for pre-revenue startups?

Technically yes, practically wrong. DCF for startups has standard error ±100%+ because everything depends on Terminal Value on 10+ year projection. For startups dominant pattern: Revenue multiples or scorecard method or Berkus method.

What changes between “unlevered” and “levered” DCF?

Unlevered DCF (more common): discounts Free Cash Flow to Firm at WACC → gets Enterprise Value → subtract net debt for Equity Value. Levered DCF: discounts Free Cash Flow to Equity at Cost of Equity → directly gets Equity Value. Unlevered is more robust because separates operational decision from financial decision.

How do I handle inflation in DCF?

Two approaches: (1) nominal — FCF projection at current prices (inflation included), discount at nominal WACC; (2) real — FCF projection at constant prices, discount at real WACC (WACC − inflation). Result identical if consistent.

Should I include tax optimization in DCF?

For standalone valuation: no, use current effective tax rate. For M&A valuation with tax synergies (e.g. fiscal consolidation post-deal): yes, model buyer-specific scenario.

What to do if the 2 Terminal Value methods give very different results?

If Gordon TV > 25% above Exit Multiple TV: g is too high OR exit multiple too low. Verify: use g max cap 2%, exit multiple not below sector median.

Is there a “rule of thumb” benchmark to validate DCF?

Yes: DCF should converge within ±20% with market multiples for the same company. If DCF gives $30M and multiples give $18M: probable too-aggressive assumption in DCF or peer multiples used below-band. Professional pattern: always calculate both and investigate gaps >25%.