--- name: valuation-business-combinable description: Perform business valuations using DCF, comparable company analysis, precedent transactions, and other valuation methodologies. Calculate enterprise value, equity value, and valuation multiples. Use when valuing a business, startup, division, or asset for M&A, financing, reporting, or strategic decisions. Triggers on phrases like "business valuation", "DCF analysis", "comparable companies", "precedent transactions", "enterprise value", "equity value", "valuation multiples", "EV/EBITDA", "discounted cash flow", "terminal value", "WACC", "market approach", "income approach", "asset approach", "buyout valuation". --- # Business Valuation & Combinations Perform business valuations using DCF, comparable company analysis, precedent transactions, and purchase price allocation for business combinations. ## Workflow ### 1. DCF Valuation ``` DISCOUNTED CASH FLOW VALUATION ═══════════════════════════════════════ Target Company: CloudTech Solutions Industry: SaaS / Enterprise Software FREE CASH FLOW PROJECTION (LTM: FY 2023): ═══════════════════════════════════════ ($ in thousands) FY2023 FY2024E FY2025E FY2026E FY2027E FY2028E Revenue $45,000 $58,500 $76,050 $98,865 $128,525 $163,107 Growth Rate 30.0% 30.0% 30.0% 30.0% 27.0% COGS ($9,000) ($11,700) ($15,210) ($19,773) ($25,705) ($32,621) Gross Profit $36,000 $46,800 $60,840 $79,092 $102,820 $130,486 Gross Margin 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% OpEx: R&D ($9,900) ($12,870) ($16,731) ($21,750) ($28,275) ($35,904) S&M ($13,500) ($17,550) ($22,815) ($29,659) ($38,558) ($48,932) G&A ($6,300) ($8,190) ($10,647) ($13,841) ($17,993) ($22,841) Total OpEx ($29,700) ($38,610) ($50,193) ($65,250) ($84,826) ($107,677) EBITDA $ 6,300 $ 8,190 $10,647 $13,841 $17,993 $22,841 EBITDA Margin 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% D&A ($1,200) ($1,560) ($2,028) ($2,636) ($3,427) ($4,353) EBIT $ 5,100 $ 6,630 $ 8,619 $11,205 $14,566 $18,488 Tax (21%) ($1,071) ($1,392) ($1,810) ($2,353) ($3,059) ($3,882) NOPAT $ 4,029 $ 5,238 $ 6,809 $ 8,852 $11,507 $14,606 Changes in NWC ($1,500) ($1,950) ($2,535) ($3,296) ($4,285) ($5,442) CapEx ($2,400) ($3,120) ($4,056) ($5,273) ($6,855) ($8,713) FREE CASH FLOW $ 129 $ 168 $ 218 $ 283 $ 367 $ 451 WACC CALCULATION: ═══════════════════════════════════════ Component Value Weight Cost Weighted ───────────────────────────────────────────────────────────────────── Equity $150,000K 75.0% 10.5% 7.88% (Beta: 1.2, Rf: 4.5%, ERP: 6.0%) Debt $50,000K 25.0% 5.5% 1.38% (After-tax: 5.5% × (1-0.21)) ───────────────────────────────────────────────────────────────────── Total Capital $200,000K 100.0% 9.26% WACC = 9.26% TERMINAL VALUE: ═══════════════════════════════════════ Perpetual growth method: Terminal FCF = FY2028 FCF × (1 + g) = $451 × 1.03 = $465 Terminal Value = $465 / (WACC - g) = $465 / (0.0926 - 0.03) = $7,473 Exit multiple method (cross-check): FY2028 EBITDA: $22,841 Exit multiple: 15x EBITDA (based on comparable companies) Terminal Value: $22,841 × 15 = $342,615 (Significantly higher — suggests growth is undervalued in perpetuity method) DISCOUNTED CASH FLOW: ═══════════════════════════════════════ ($ in thousands) FY2024 FY2025 FY2026 FY2027 FY2028 Terminal FCF $168 $218 $283 $367 $451 $7,473 Discount factor (9.26%) 0.915 0.838 0.767 0.702 0.642 0.642 PV of FCF $154 $183 $217 $258 $289 $4,802 ───────────────────────────────────────────────────────────────────── Present Value of FCF: $5,903 ADJUSTMENTS: ═══════════════════════════════════════ Enterprise Value (from DCF): $5,903K Less: Net Debt: ($45,000K) Add: Non-operating assets: $2,000K ───────────────────────────────────────────── EQUITY VALUE (DCF): ($37,097K) ⚠ NEGATIVE EQUITY VALUE from DCF alone — this suggests either: 1. WACC is too high (company is early-growth) 2. Terminal value understates potential (use exit multiple) 3. High cash burn not yet reaching profitability ADJUSTED DCF (using exit multiple terminal value): ═══════════════════════════════════════ PV of Terminal Value (exit multiple): $342,615 × 0.642 = $219,959 PV of explicit period FCF: $154 + $183 + $217 + $258 + $289 = $1,099 ───────────────────────────────────────────── Enterprise Value (exit multiple): $221,058K Less: Net Debt: ($45,000) Add: Non-operating assets: $2,000 EQUITY VALUE: $178,058K Implied share price: $178,058 / 10,000K shares = $17.81 ``` ### 2. Comparable Company Analysis ``` COMPARABLE COMPANY ANALYSIS ═══════════════════════════════════════ Target: CloudTech Solutions Comparable Companies (SaaS / Enterprise Software): Company Revenue Growth EBITDA EV EV/Rev EV/EBITDA P/E ($M) Rate Margin ($M) (x) (x) (x) ───────────────────────────────────────────────────────────────────────────────────────── Salesforce (CRM) $31.4B 24% 28% $180B 5.7x 64x 200x Workday (WDAY) $6.4B 18% 32% $60B 9.4x 47x 300x ServiceNow (NOW) $8.2B 22% 30% $130B 15.9x 55x 500x HubSpot (HUBS) $1.7B 30% 20% $8.0B 4.7x 40x 150x Snowflake (SNOW) $2.7B 40% 10% $50B 18.5x 500x NM Adastra (ADSK) $3.4B 12% 25% $25B 7.4x 36x 100x ───────────────────────────────────────────────────────────────────────────────────────── MEDIAN/Mean: 24% 28% 7.4x 55x AVERAGE: 24% 25% 8.7x 75x TARGET METRICS: ═══════════════════════════════════════ CloudTech: Revenue: $45M Growth rate: 30% (above peer average) EBITDA margin: 14% (below peer average) EV/Revenue peer range: 4.7x - 18.5x EV/EBITDA peer range: 36x - 500x VALUATION RANGE: ═══════════════════════════════════════ Multiple Low Target High (Pess.) (Median) (Optim.) ───────────────────────────────────────────────── EV/Revenue 5.0x 7.4x 10.0x Enterprise Val $225M $333M $450M EV/EBITDA 30x 45x 60x Enterprise Val $189M $284M $378M ADJUSTED VALUATION: → CloudTech grows faster (30%) than peer avg (24%) → premium multiple → CloudTech has lower margin (14%) than peer avg (25%) → discount multiple → Net effect: Use median multiple with slight growth premium RECOMMENDED ENTERPRISE VALUE: $350M-$400M → Using EV/Revenue of 7.8x-8.9x → Using EV/EBITDA of 55x-64x (normalized margin) EQUITY VALUE: $350M - $45M debt = $305M IMPLIED SHARE PRICE: $305M / 10M shares = $30.50 ``` ### 3. Precedent Transactions ``` PRECEDENT TRANSACTIONS ANALYSIS ═══════════════════════════════════════ Recent SaaS Acquisitions (last 24 months): Acquirer Target Revenue Growth EV/Rev EV/EBITDA Deal Premium (Sold) ($M) Rate (x) (x) (%) ────────────────────────────────────────────────────────────────────────────────── Salesforce Tableau $1,450 35% 11.7x 90x 115% Microsoft GitHub $410 25% 8.0x 80x 132% Intuit Mailchimp $500 25% 10.0x 67x 110% Adobe Workfront $300 25% 7.5x 50x 95% Cisco Splunk $3.6B 30% 8.7x 58x 105% Oracle Cerner $10B 10% 13.0x NM 140% ────────────────────────────────────────────────────────────────────────────────── AVERAGE PREMIUM: 116% MEDIAN EV/Revenue: 9.4x MEDIAN EV/EBITDA: 67x TARGET VALUATION (Precedent Transaction Approach): ═══════════════════════════════════════ Using median precedent transaction multiples: EV/Revenue: 9.4x × $45M = $423M EV/EBITDA: 67x × $6.3M = $422M ACQUISITION PREMIUM (assuming 116% average premium): Current implied market value: $305M equity ($30.50/share) With 116% premium: $305M × 2.16 = $659M equity Per share: $30.50 × 2.16 = $65.88 REALISTIC ACQUISITION PRICE RANGE: → Conservative: $350M equity ($35.00/share) — 15% premium → Mid-range: $450M equity ($45.00/share) — 47% premium → Aggressive: $600M equity ($60.00/share) — 97% premium STRATEGIC BUYER VS FINANCIAL BUYER: ═══════════════════════════════════════ Strategic buyer: $450M-$600M (synergies justify premium) Financial buyer (PE): $300M-$400M (LBO capacity, no synergy premium) ``` ### 4. Purchase Price Allocation (PPA) ``` PURCHASE PRICE ALLOCATION — Acquisition Scenario ═══════════════════════════════════════ Acquisition Price: $400M equity + $45M debt assumed = $445M Enterprise Value NET ASSETS ACQUIRED: ═══════════════════════════════════════ ($ in thousands) Book Value Fair Value Difference ───────────────────────────────────────────────────────────────── Cash & Equivalents $30,000 $30,000 $0 Accounts Receivable $8,000 $7,500 ($500) Inventories $0 $0 $0 PP&E $15,000 $12,000 ($3,000) Technology (IP) $5,000 $60,000 $55,000 Customer Relationships $0 $40,000 $40,000 Trademark $0 $10,000 $10,000 Accounts Payable ($5,000) ($5,000) $0 Accrued Liabilities ($3,000) ($3,000) $0 Deferred Revenue ($4,000) ($4,000) $0 Other Liabilities ($2,000) ($2,000) $0 ───────────────────────────────────────────────────────────────── Net Identifiable Assets $44,000 $145,500 $101,500 GOODWILL CALCULATION: ═══════════════════════════════════════ Purchase Price: $445,000 Less: Fair Value of Net Assets ($145,500) ──────────────────────────────────────────── GOODWILL: $299,500 Goodwill represents: → Synergies from integration → Brand reputation → Assembled workforce → Market position → Revenue synergies (cross-selling) GOODWILL ALLOCATION TO REPORTING UNITS: ═══════════════════════════════════════ Reporting Unit Goodwill Rationale ────────────────────────────────────────────────── Enterprise Software $180,000 Primary revenue driver Managed Services $80,000 Complementary offering Professional Services $39,500 Client relationships ────────────────────────────────────────────────── TOTAL $299,500 INTANGIBLE ASSET AMORTIZATION SCHEDULE: ═══════════════════════════════════════ Asset Fair Value Useful Life Annual Amort. Method ──────────────────────────────────────────────────────────────────────────── Technology (IP) $60,000K 7 years $8,571K Straight-line Customer Relations $40,000K 10 years $4,000K Straight-line Trademark $10,000K 15 years $667K Straight-line ──────────────────────────────────────────────────────────────────────────── Total Annual Amort: $13,238K IMPACT ON POST-ACQUISITION EARNINGS: ═══════════════════════════════════════ EBITDA (standalone): $6,300K Less: Additional D&A: ($13,238K) Adjusted EBIT: ($6,938K) (Significant impact — amortization exceeds EBITDA) NOTE: This is expected in SaaS acquisitions where most value is in intangibles. Reporters should disclose pro forma adjusted earnings (ex-amortization). ``` ## Edge Cases - **Early-stage companies**: Negative cash flows make DCF unreliable; use comparable transactions - **Cyclical companies**: Use normalized EBITDA (multi-year average) for multiples - **Distressed companies**: Asset-based valuation may be more appropriate than income approach - **Non-profit acquisition**: No purchase price allocation needed - **Reverse merger**: Accounting acquirer may differ from legal acquirer ## Integration Points - **Financial data**: Bloomberg, Capital IQ, PitchBook (comparable data) - **Accounting systems**: GL data for asset/liability fair value assessment - **Valuation software**: Oracle Hyperion Valuations, FactSet, AlphaLab - **PPA platforms**: Versant, PPA management systems - **Reporting**: SEC filings (Form 8-K, 10-K), audit workpapers - **M&A systems**: Dealroom, M&A management platforms ## Output ### Valuation Summary ``` BUSINESS VALUATION SUMMARY — CloudTech Solutions ═══════════════════════════════════════ Valuation Method Enterprise Value Equity Value Share Price ───────────────────────────────────────────────────────────────────────── DCF (exit multiple) $221M $176M $17.60 Comparable Companies $333M-$450M $288M-$405M $28.80-$40.50 Precedent Transactions $423M $378M $37.80 WEIGHTED VALUATION RANGE: $200M-$400M Enterprise Value RECOMMENDED RANGE: $300M-$380M Enterprise Value For acquisition purposes: → Financial buyer: $300M-$350M → Strategic buyer: $380M-$450M (with synergy premium) ```