Finance AI Skill

Strategic Finance

Manage strategic finance activities including M&A analysis, due diligence, financial modeling for strategic decisions, capital allocation, business planning, valuation, and corporate development. Use when analyzing acquisition targets, performing due dilige...

Strategic Finance & M&A

Support strategic decision-making through financial analysis, valuation, M&A support, and capital allocation.

M&A Analysis & Due Diligence

Acquisition Target Evaluation

ACQUISITION EVALUATION FRAMEWORK:
══════════════════════════════════

PHASE 1: TARGET IDENTIFICATION & SCREENING
  Criteria:
    - Strategic fit (product, market, technology, talent)
    - Financial profile (revenue, profitability, growth)
    - Size (revenue/employee thresholds)
    - Geographic alignment
    - Cultural compatibility
    - Valuation expectations
  
  Sourcing channels:
    - Investment bank recommendations
    - Industry research and market scanning
    - Referrals from partners/customers
    - Direct outreach
    - M&A advisory platforms

PHASE 2: INITIAL ASSESSMENT
  Preliminary analysis (internal, confidential):
    - Public financial data review
    - Market position assessment
    - Competitive landscape
    - SWOT analysis
    - Preliminary valuation range
    - Strategic rationale documentation
  
  Go/No-Go decision criteria:
    - Strategic rationale strong?
    - Financial profile acceptable?
    - Valuation reasonable (within 15% of internal estimate)?
    - Risk profile manageable?
    - Resource availability for due diligence?

PHASE 3: LETTER OF INTENT (LOI)
  LOI Contents:
    - Purchase price/structure
    - Financing terms
    - Key conditions (due diligence, board approval, regulatory)
    - Exclusivity period (60-90 days)
    - Confidentiality reaffirmation
    - Timeline to close
  
  LOI Approval: CEO + CFO + Board (for deals >$5M)

PHASE 4: DUE DILIGENCE
  (Detailed below)

PHASE 5: DEFINITIVE AGREEMENTS & CLOSING
  Purchase agreement negotiation
  Regulatory approvals
  Financing confirmation
  Closing conditions satisfaction
  Transition planning
  Day 1 readiness

Financial Due Diligence

FINANCIAL DUE DILIGENCE CHECKLIST:
═══════════════════════════════════

FINANCIAL STATEMENT REVIEW:
  [ ] Historical financial statements (3-5 years, audited)
  [ ] Quality of earnings analysis (normalized EBITDA)
  [ ] Revenue analysis (recognition policies, concentration, trends)
  [ ] Expense analysis (run-rate, one-time items, SDE add-backs)
  [ ] Working capital analysis (seasonality, trends, normalization)
  [ ] Capital expenditure history (maintenance vs. growth)
  [ ] Debt schedule (all obligations, covenants, prepayment terms)
  [ ] Related party transactions
  [ ] Contingent liabilities and commitments
  [ ] Tax position (returns, audits, credits, exposures)

QUALITY OF EARNINGS (QoE):
  Reported EBITDA:          $8,500,000
  Add-backs (SDE adjustments):
    Owner salary normalization:  +$450,000
    One-time legal costs:       +$125,000
    Owner personal expenses:    +$85,000
    Non-recurring repairs:      +$60,000
    Related party adjustments:  +$40,000
    ══════════════════════════════════════
    Total add-backs:            +$760,000
  
  NORMALIZED EBITDA:          $9,260,000
  EBITDA margin (normalized): 32.8% (reported: 30.2%)
  
  Revenue quality assessment:
    - Top 5 customer concentration: 42% (MODERATE RISK)
    - Contractual vs. non-contractual: 75% contractual (GOOD)
    - Revenue recognition compliance: Minor issues (2 late revenue deferrals)
    - Churn rate: 8% (industry avg: 10% — GOOD)
  
  Expense quality assessment:
    - OpEx/Revenue: 65% (normalized: 62%)
    - Headcount dependency: 45% of expenses (MODERATE — key person risk)
    - Lease obligations: 3 years remaining on main facility ($360K/year)

WORKING CAPITAL ANALYSIS:
  Historical average (12 months):
    AR: $1,200,000
    Inventory: $450,000 (if applicable)
    Prepaid: $180,000
    AP: ($950,000)
    Accruals: ($620,000)
    Deferred revenue: $1,800,000
    ══════════════════════════════════════
    NET WORKING CAPITAL:      $2,060,000
  
  Seasonality adjustment: +$350,000 (peak season working capital higher)
  Normalized WC for closing: $2,410,000
  
  Deal terms: Purchase price adjustment for WC variance from normalized level

KEY DUE DILIGENCE FINDINGS:
  POSITIVE:
    - Strong contractual revenue base (75%)
    - Consistent EBITDA growth (18% CAGR over 3 years)
    - Clean audit opinions (no qualifications)
    - Strong customer retention (92%)
  
  CONCERNS:
    - Customer concentration (top 5 = 42%)
    - Key person dependency (CEO drives 30% of relationships)
    - IT system modernization needed (estimated $500K)
    - Deferred maintenance ($200K over 2 years)
  
  RISK-ADJUSTED VALUATION IMPACT:
    Base case: No adjustment
    Downside case: -$700K (IT + maintenance capex)
    Probability-weighted: -$350K (50% probability of full capex needed)

Valuation Modeling

DCF Valuation Framework

DISCOUNTED CASH FLOW (DCF) VALUATION:
══════════════════════════════════════

INPUT ASSUMPTIONS:
  Current revenue:          $28,200,000
  EBITDA margin:            32.8%
  Tax rate:                 25%
  Capex (as % of revenue):  5%
  Working capital (as % of rev growth): 15% of incremental revenue
  
  Growth assumptions:
    Years 1-3 (high growth): 22%
    Years 4-5 (moderate):    15%
    Terminal growth rate:     3%
  
  Discount rate (WACC):
    Cost of equity:          12.5% (CAPM: Rf 4.3% + β 1.1 × MRP 7.5%)
    Cost of debt:            6.3% (pre-tax)
    After-tax cost of debt:  4.7% (× (1-0.25))
    Equity weight:           85%
    Debt weight:             15%
    WACC:                    11.6%

PROJECTED FREE CASH FLOW:
  ┌────────────┬──────────┬──────────┬──────────┬──────────┬──────────┬──────────┐
  │ ($000s)    │ Year 1   │ Year 2   │ Year 3   │ Year 4   │ Year 5   │ Terminal │
  ├────────────┼──────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
  │ Revenue    │ $34,404  │ $41,973  │ $51,207  │ $58,888  │ $67,721  │ $69,753  │
  │ EBITDA     │ $11,285  │ $13,767  │ $16,796  │ $19,315  │ $22,213  │ —        │
  │ EBIT       │ $9,620   │ $11,728  │ $14,256  │ $16,331  │ $18,786  │ —        │
  │ NOPAT      │ $7,215   │ $8,796   │ $10,692  │ $12,248  │ $14,090  │ —        │
  │ + Depr     │ $1,665   │ $2,040   │ $2,508   │ $2,924   │ $3,361   │ —        │
  │ - Capex    │ ($1,722) │ ($2,099) │ ($2,560) │ ($2,944) │ ($3,386) │ —        │
  │ - ΔNWC     │ ($666)   │ ($812)   │ ($1,000) │ ($1,153) │ ($1,320) │ —        │
  │ FCF        │ $6,492   │ $7,925   │ $9,640   │ $11,075  │ $12,745  │ $95,730  │
  └────────────┴──────────┴──────────┴──────────┴──────────┴──────────┴──────────┘
  Terminal value (Gordon Growth): $95,730

VALUATION OUTPUT:
  Present value of FCF (Years 1-5): $36,820K
  Present value of Terminal Value:  $46,210K
  ════════════════════════════════════════════
  ENTERPRISE VALUE:                    $83,030K
  
  Less: Net debt ($3,200K)
  ════════════════════════════════════════════
  EQUITY VALUE:                        $79,830K
  
  Implied multiples:
    EV / Revenue:                      2.9x
    EV / EBITDA:                       9.0x
    P/E (based on Year 1 EPS):         18.5x

SENSITIVITY ANALYSIS:
  ┌────────────┬──────────┬──────────┬──────────┬──────────┬──────────┐
  │ WACC ↓    │ 10.6%   │ 11.1%   │ 11.6%   │ 12.1%   │ 12.6%   │
  │ ──────────│ ─────── │ ─────── │ ─────── │ ─────── │ ─────── │
  │ g = 2.0%  │ $72.1M  │ $75.8M  │ $79.8M  │ $84.0M  │ $88.6M  │
  │ g = 2.5%  │ $75.4M  │ $79.3M  │ $83.5M  │ $88.0M  │ $92.9M  │
  │ g = 3.0%  │ $78.9M  │ $83.0M  │ $87.5M  │ $92.5M  │ $98.0M  │
  │ g = 3.5%  │ $82.7M  │ $87.2M  │ $92.3M  │ $98.0M  │ $104.2M│
  │ g = 4.0%  │ $86.9M  │ $92.0M  │ $97.8M  │ $104.3M │ $111.5M│
  └────────────┴──────────┴──────────┴──────────┴──────────┴──────────┘
  (Values = Enterprise Value in $M)
  
  Current EV estimate: $83.0M (WACC 11.6%, g 3.0%)
  Reasonable range: $76M - $90M

Capital Allocation

Capital Allocation Framework

CAPITAL ALLOCATION FRAMEWORK:
══════════════════════════════

CAPITAL GENERATION (Annual):
  Free cash flow:              $12,800,000
  Less: Maintenance capex:     ($1,800,000)
  Available capital:           $11,000,000

CAPITAL ALLOCATION PRIORITY:
  (In order of priority)

  1. FUNDAMENTAL BUSINESS NEEDS (40%)
     Operations, working capital, maintenance capex
     Amount: $4,400,000
     Return required: Hurdle rate (11.6%)
     Status: Budgeted and approved

  2. GROWTH INVESTMENTS (35%)
     Product development, market expansion, new capabilities
     Amount: $3,850,000
     Return required: 2x cost of capital (23%+)
     Projects in pipeline:
       - AI analytics module development: $1,200,000
       - European market expansion: $1,500,000
       - Partner channel program: $800,000
       - Platform integration capability: $350,000

  3. STRATEGIC ACQUISITIONS (15%)
     Tuck-in acquisitions, talent acquisitions, technology
     Amount: $1,650,000 (reserve)
     Criteria: <$5M deal size, accretive in Year 1
     Pipeline: 3 targets in evaluation

  4. DEBT REDUCTION (5%)
     Reduce interest expense and financial risk
     Amount: $550,000
     Priority: Reduce floating rate debt first
     Target: Net debt / EBITDA < 1.0x

  5. SHAREHOLDER RETURNS (5%)
     Share buybacks or dividends (when profitable consistently)
     Amount: $550,000 (reserve)
     Conditions: FCF >$15M, net debt/EBITDA <0.5x, growth investments funded
     Status: Not yet activated (reinvest for growth)

CAPITAL ALLOCATION DECISION PROCESS:
  Q1: Annual capital allocation plan (CFO → CEO → Board)
  Q2-Q4: Quarterly review and reallocation (as needed)
  Ad hoc: Strategic opportunities (CEO + CFO approval, <$1M)
  Board approval: Any single allocation >$1M outside plan

CAPITAL ALLOCATION METRICS:
  ROIC (past year): 18.2% (vs. WACC 11.6% — creating value ✓)
  FCF margin: 12.4%
  Capex as % of revenue: 5.2%
  R&D as % of revenue: 14.8%
  Capital intensity: Low (asset-light SaaS model)

Strategic Business Planning

Strategic Initiative Evaluation

STRATEGIC INITIATIVE EVALUATION — 2025
════════════════════════════════════════

INITIATIVE #1: European Market Expansion
  Description: Establish EU operations, localize product, build sales team
  Investment: $2,500,000 (Year 1-2)
  Timeline: 18 months to break-even
  Expected revenue (Year 3): $8,000,000
  Expected EBITDA margin (Year 3): 20%
  
  NPV (5-year, WACC 11.6%): $4,200,000
  IRR: 38%
  Payback period: 2.3 years
  Risk rating: MEDIUM (regulatory, competition, execution)
  Strategic value: HIGH (diversification, scale, talent access)
  RECOMMENDATION: ✓ PROCEED

INITIATIVE #2: AI Analytics Module
  Description: Develop AI-powered analytics capabilities (product extension)
  Investment: $1,800,000 (Year 1-2)
  Timeline: 12 months to launch
  Expected revenue uplift (Year 2): $3,500,000 (cross-sell + upsell)
  Expected margin impact: +2pp (higher-value add-on)
  
  NPV (5-year, WACC 11.6%): $3,100,000
  IRR: 45%
  Payback period: 1.6 years
  Risk rating: LOW-MEDIUM (technology risk, market acceptance)
  Strategic value: HIGH (product differentiation, competitive moat)
  RECOMMENDATION: ✓ PROCEED — HIGHEST PRIORITY

INITIATIVE #3: Partner Channel Program
  Description: Build SI/OEM partner ecosystem for indirect sales
  Investment: $900,000 (Year 1)
  Timeline: 12 months to first revenue
  Expected channel revenue (Year 3): $4,000,000 (20% of total)
  Expected cost savings: 15% lower CAC vs. direct
  
  NPV (5-year, WACC 11.6%): $2,100,000
  IRR: 52%
  Payback period: 1.8 years
  Risk rating: MEDIUM (partner recruitment, enablement, control)
  Strategic value: MEDIUM-HIGH (scale, market coverage)
  RECOMMENDATION: ✓ PROCEED

INITIATIVE #4: Customer Success Platform Upgrade
  Description: Upgrade CS platform, expand CS team, reduce churn
  Investment: $600,000 (Year 1)
  Timeline: 6 months to implement
  Expected impact: Reduce churn from 2.8% to 2.0%
  Value of churn reduction: $1,800,000/year (ARR protection)
  
  NPV (5-year, WACC 11.6%): $5,400,000
  IRR: 85%
  Payback period: 0.5 years
  Risk rating: LOW (proven approach, controlled execution)
  Strategic value: HIGH (protects revenue base, NRR improvement)
  RECOMMENDATION: ✓ PROCEED — IMMEDIATE

INITIATIVE RANKING (by NPV per $ invested):
  1. CS Platform Upgrade (9:1 NPV/cost)
  2. Partner Channel (2.3:1)
  3. AI Analytics Module (1.7:1)
  4. European Expansion (1.7:1)
  
  Total investment required: $5,800,000
  Total expected NPV: $14,800,000
  Available capital (2-year FCF): $22,000,000
  Conclusion: All initiatives fundable within available capital

Merger Integration Planning

Post-Merger Integration (PMI)

POST-MERGER INTEGRATION PLAN — Template
═════════════════════════════════════════

INTEGRATION TIMELINE:
  Pre-Close (T-30 to T):
    - Integration team formation (core team: 8-12 people)
    - Day 1 readiness assessment
    - Communication plan (employees, customers, partners)
    - Financial close preparation (account mapping, systems)
    - Key retention plan (critical talent identification)
  
  Day 1 (T+1):
    - Leadership communications
    - Customer notification
    - System access provisioning
    - Financial consolidation setup
    - Brand/identity decisions (interim)
    - HR policy alignment (immediate items)
  
  Days 2-30 (Quick Wins):
    - Introduce teams (cross-company meetings)
    - Identify quick-win synergies
    - Customer transition plan execution
    - Financial reporting integration
    - IT security and access alignment
    - Vendor/contract review (duplication identification)
  
  Days 31-90 (Integration):
    - Process harmonization (finance, HR, IT)
    - Product/platform integration planning
    - Sales organization alignment
    - Cultural integration initiatives
    - Synergy tracking (baseline and progress)
  
  Days 91-180 (Optimization):
    - Full financial consolidation
    - Technology platform decisions
    - Org structure finalization
    - Brand integration (if applicable)
    - Synergy realization review
  
  Days 181-365 (Full Integration):
    - Complete operational integration
    - Full synergy realization
    - Post-merger performance review
    - Lessons learned

SYNERGY IDENTIFICATION:
  Revenue synergies:
    Cross-sell opportunity: $2,400,000/year (Year 2)
    Market expansion: $1,200,000/year (Year 3)
    Product bundling: $600,000/year (Year 2)
    Total revenue synergies: $4,200,000/year
  
  Cost synergies:
    G&A reduction: $1,500,000/year (duplicate functions)
    Technology consolidation: $800,000/year (system rationalization)
    Procurement leverage: $400,000/year (volume discounts)
    Facility optimization: $300,000/year (office consolidation)
    Total cost synergies: $3,000,000/year
  
  Total synergies: $7,200,000/year (Year 3 run-rate)
  Integration cost: $2,500,000 (one-time, Year 1-2)
  Net synergy value: $4,700,000/year (Year 3+)
  Synergy realization confidence: 70% (conservative)

INTEGRATION RISK REGISTER:
  1. Key talent departure (HIGH) — Retention bonuses, career path clarity
  2. Customer churn during transition (HIGH) — Dedicated CS coverage, proactive outreach
  3. Revenue disruption (MEDIUM) — Parallel operations during transition
  4. Cultural conflict (MEDIUM) — Cultural assessment, integration workshops
  5. IT integration delays (MEDIUM) — Detailed migration plan, rollback capability
  6. Synergy overestimate (LOW) — Conservative estimates, quarterly review

Output

Strategic Finance Dashboard

STRATEGIC FINANCE DASHBOARD — Jan 27, 2025
══════════════════════════════════════════════

Capital Allocation:
  Available capital (YTD): $3.8M
  Committed to initiatives: $2.1M
  Available for opportunistic: $1.7M
  ROIC: 18.2% (exceeds WACC of 11.6%)

Strategic Initiatives:
  Active initiatives: 4
  Total investment: $5.8M
  Expected NPV: $14.8M
  On-track: 3/4 (AI module delayed 1 month)
  At-risk: 1 (EU expansion — regulatory approval)

M&A Pipeline:
  Targets in evaluation: 3
  In due diligence: 1 (TechCo — week 4 of 8)
  LOI issued: 0
  Closed (past 12 months): 0
  Integration active: 0

Capital Structure:
  Net debt: $17.5M
  Debt/EBITDA: 0.82x
  Interest coverage: 12.4x
  Credit rating: Investment grade
  Revolver available: $25M

Valuation:
  Current market cap: $2.71B
  DCF estimate range: $76M-$90M (for target)
  Trading multiples:
    P/S: 6.8x (peer median: 6.6x)
    EV/Revenue: 6.5x (peer median: 6.3x)
    EV/EBITDA: 38.2x (peer median: 35.9x)

Key Decisions Pending:
  1. TechCo DD completion — Feb 15
  2. EU expansion regulatory filing — Mar 1
  3. AI module resource allocation — Feb 1
  4. Capital allocation plan Q2 — Feb 15

Integration Points

Edge Cases