--- name: strategic-finance description: 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 diligence, building valuation models, evaluating capital allocation, assessing strategic alternatives, or managing corporate development. Triggers on phrases like "M&A", "due diligence", "acquisition", "valuation", "DCF model", "capital allocation", "strategic planning", "business case", "investment analysis", "corporate development", "merger integration", "synergy analysis". --- # 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 - ERP/GL (NetSuite, SAP): Financial data for modeling and analysis - BI platforms (Tableau, Power BI): Modeling outputs visualization - Planning tools (Anaplan, Adaptive): Strategic planning and scenario modeling - CRM (Salesforce): Pipeline data for synergy analysis - HRIS: Headcount and compensation data for integration planning - Data rooms (Ansarada, Firmex): Due diligence document management - Legal platforms: Contract review, transaction documentation - Market intelligence (Bloomberg, Capital IQ): Comparable analysis, benchmarks - Board portals: Strategic presentations, approval workflows - Project management tools (MS Project, Smartsheet): Integration planning ## Edge Cases - **Cross-border M&A**: Regulatory approvals (CFIUS, antitrust); currency risk; tax structuring; local compliance - **Reverse merger/SPE**: Alternative to IPO; disclosure requirements; valuation challenges - **SPAC transactions**: De-SPAC timeline; PIPE financing; post-merger compliance; market perception - **Distressed acquisitions**: Asset vs. stock purchase; liability assessment; turnaround planning - **Tuck-in vs. transformational**: Different integration approaches; resource allocation; board communication - **Deal breakup**: Breakup fee negotiation; reputational management; pipeline redirection - **Integration failure risk**: Cultural assessment; change management; customer retention; parallel operations - **Earn-out structures**: Performance metric definition; manipulation risk; payment tracking - **Rolling closure**: Staged deal execution; partial integration; milestone tracking - **Spin-off/divestiture**: Carve-out financials; stand-alone systems; employee communication