Finance AI Skill
Valuation Business Combinable
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&...
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.812. 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.503. 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)