DCF analysis deep dive — the four-step mechanics with worked example.

This Tactical provides the step-by-step mechanics and key inputs that drive DCF outputs for insurance agency transactions. The companion Tactical [Income Approach Overview] establishes when the income approach is the right tool; this one walks through how it actually works on a worked example.

§ 01 · Step 1 — Project normalized cash flowThe 3–5 year forecast.

The DCF model begins with Normalized EBITDA as the baseline. The buyer then projects how that cash flow grows over the forecast period (typically 5 years), based on historical growth rates, retention data, and new business pipeline.

Example, starting at $400K Normalized EBITDA, 5% projected growth: Year 1 — $400K. Year 2 — $420K. Year 3 — $441K. Year 4 — $463K. Year 5 — $486K. Growth assumptions are the most sensitive input. A 1% difference in annual growth rate can swing the final valuation by 10–20% over the forecast period. Sellers with documented 3+ years of 10%+ growth can support materially higher growth assumptions — which directly increases DCF output.

§ 02 · Step 2 — Apply the discount rateConverting future to present.

The discount rate converts future cash flows into present-day value. For insurance agencies, discount rates typically range from 8–15%. 8–10%: low-risk agency — strong documentation, professional management, diversified clients and carriers, low key-person dependency. 10–12%: average-risk agency — moderate retention, some owner dependency, reasonable carrier mix. 12–15%+: higher-risk agency — concentrated client risk, owner-dependent relationships, weak documentation, declining retention.

Using a 10% discount rate on the $400K EBITDA scenario above. Year 1: $400K × 0.909 = $363K PV. Year 2: $420K × 0.826 = $347K. Year 3: $441K × 0.751 = $331K. Year 4: $463K × 0.683 = $316K. Year 5: $486K × 0.621 = $302K. 5-Year PV Total ≈ $1.66M.

§ 03 · Step 3 — Calculate terminal valueThe 50–70% of total enterprise value.

Terminal value estimates the worth of the agency beyond the 5-year forecast period. This is the largest component of a DCF valuation — representing 50–70% of total enterprise value — and two methods are used.

Exit Multiple Method.

Assumes the agency is sold at the end of Year 5 at a market EBITDA multiple. A conservative 8× assumption on $486K EBITDA = $3.89M terminal value. Discounted to present: $3.89M × 0.621 ≈ $2.42M. This is the more common method in institutional transactions because it anchors to market comparables.

Perpetuity Growth Method.

Assumes the agency generates perpetual cash flow beyond Year 5 at a sustainable long-term growth rate. Formula: Terminal Value = (Year 5 EBITDA × (1 + g)) / (Discount Rate − g). Using 2.5% perpetual growth: ($486K × 1.025) / (0.10 − 0.025) ≈ $6.61M. Discounted to present: $6.61M × 0.621 ≈ $4.10M. This method produces higher terminal values but requires confidence that the business genuinely continues indefinitely.

§ 04 · Step 4 — Sum to enterprise valueThe output.

Enterprise Value = Present Value of 5-year cash flows + Present Value of terminal value. Using exit multiple method: $1.66M + $2.42M = ~$4.08M. Using perpetuity method: $1.66M + $4.10M = ~$5.76M. The spread between methods illustrates why terminal-value assumptions matter so much — and why sellers and buyers frequently differ on final valuations even when they agree on Normalized EBITDA.

The $4.08M output on $400K Normalized EBITDA implies a 10.2× multiple — clearing the 8–10× market band and pushing into the 10–12× competitive band of the canonical valuation framework. The $5.76M perpetuity output implies a 14.4× multiple — squarely in the 12–19× kill-zone band reserved for PE platform-thesis assets. The terminal-value method alone moved the agency between bands.

§ 05 · What drives the discount rateThe risk factors that buyers actually price.

The discount rate is composed of a risk-free rate (typically 3–5%, reflecting Treasury bond yields) plus a risk premium. Risk-premium factors for insurance agencies include key-person dependency (if the owner's personal relationships are the primary source of retention, transition risk → higher rate), client concentration (revenue concentrated in top 5–10 clients → higher discount), retention documentation (90%+ historical retention verified by AMS data supports lower rates; undocumented claims face skepticism), carrier diversification (over-concentration in one or two carriers → higher discount), operational maturity (documented procedures, staff depth, organized AMS, clear succession plan → lower discount), and seller financing (willingness to carry a seller note demonstrates confidence in ongoing performance → can support a lower discount rate).

§ 06 · The pre-sale checklistWhat a DCF buyer wants to see.

Sellers likely to encounter DCF analysis should prepare: three years of clean, normalized financials (P&L with all add-backs documented; Normalized EBITDA calculated and defensible); growth documentation (trailing 3-year revenue growth by LOB and in aggregate; new business written per year); retention data (annual client retention rate, broken out by LOB and producer, from AMS records); carrier documentation (all carrier appointments with tenure; commission history; no undisclosed concentration issues); operational documentation (procedures manual, staff roles, AMS currency — demonstrates the business runs without the owner's personal involvement); and forward projections, optionally (conservative internal forecasts signal growth confidence and give buyers a starting point for assumptions).

In practice, institutional buyers run both: DCF as the primary model, market comps as the validation check. If DCF output significantly exceeds market comps, they recalibrate growth assumptions or raise the discount rate. The seller's job is to make both outputs consistent — and high.

◆