
Finance
- 359 installs
- 86 repo stars
- Updated July 17, 2026
- travisjneuman/.claude
Use finance for development tasks
About
finance: A skill for development. This provides functionality for development workflows.
- finance
Finance by the numbers
- 359 all-time installs (skills.sh)
- +5 installs in the week ending Aug 5, 2026 (Skillselion tracking)
- Ranked #1,174 of 4,347 Backend & APIs skills by installs in the Skillselion catalog
- Data as of Aug 5, 2026 (Skillselion catalog sync)
npx skills add https://github.com/travisjneuman/.claude --skill financeAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 359 |
|---|---|
| repo stars | ★ 86 |
| Last updated | July 17, 2026 |
| Repository | travisjneuman/.claude ↗ |
What it does
Use finance for development tasks
Files
Financial Analysis Expert
Comprehensive financial frameworks for modeling, valuation, and corporate finance decisions.
Financial Statement Analysis
DuPont Analysis (5-Factor)
Decompose ROE into operational drivers:
ROE = Net Profit Margin x Asset Turnover x Equity Multiplier
Extended (5-Factor):
ROE = (EBIT/Sales) x (Sales/Assets) x (Assets/Equity) x (EBT/EBIT) x (NI/EBT)
= Operating Margin x Asset Turnover x Leverage x Interest Burden x Tax BurdenKey Financial Ratios
| Category | Ratio | Formula | Benchmark |
|---|---|---|---|
| Profitability | Gross Margin | Gross Profit / Revenue | Industry specific |
| Operating Margin | EBIT / Revenue | 15-25% (varies) | |
| Net Margin | Net Income / Revenue | 10-20% (varies) | |
| ROIC | NOPAT / Invested Capital | > WACC | |
| ROE | Net Income / Equity | 15-20%+ | |
| Liquidity | Current Ratio | Current Assets / Current Liabilities | 1.5-2.0x |
| Quick Ratio | (CA - Inventory) / CL | 1.0x+ | |
| Cash Ratio | Cash / Current Liabilities | 0.2-0.5x | |
| Leverage | Debt/Equity | Total Debt / Total Equity | < 1.0x |
| Debt/EBITDA | Total Debt / EBITDA | 2-3x (IG), 4-6x (HY) | |
| Interest Coverage | EBIT / Interest Expense | > 3x | |
| Efficiency | Asset Turnover | Revenue / Total Assets | Industry specific |
| Inventory Days | Inventory / (COGS/365) | Industry specific | |
| DSO | AR / (Revenue/365) | 30-45 days | |
| DPO | AP / (COGS/365) | 30-60 days |
Cash Flow Analysis
FREE CASH FLOW (FCF):
Operating Cash Flow
- Capital Expenditures
= Free Cash Flow
UNLEVERED FREE CASH FLOW (for valuation):
EBIT
x (1 - Tax Rate)
= NOPAT
+ Depreciation & Amortization
- Change in Working Capital
- Capital Expenditures
= Unlevered Free Cash Flow
LEVERED FREE CASH FLOW:
Unlevered FCF
- Interest Expense x (1 - Tax Rate)
- Mandatory Debt Repayments
+ Net Borrowing
= Levered Free Cash FlowValuation Methodologies
Discounted Cash Flow (DCF)
ENTERPRISE VALUE:
T UFCFt Terminal Value
EV = Σ ─────────── + ─────────────────────
t=1 (1+WACC)^t (1+WACC)^T
TERMINAL VALUE (Perpetuity Growth):
UFCF(T+1)
Terminal Value = ───────────
WACC - g
TERMINAL VALUE (Exit Multiple):
Terminal Value = EBITDA(T) x Exit Multiple
EQUITY VALUE:
Equity Value = Enterprise Value - Net Debt + CashDCF Model Template
| Year | 1 | 2 | 3 | 4 | 5 | Terminal |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Growth % | ||||||
| EBITDA | ||||||
| Margin % | ||||||
| D&A | ||||||
| EBIT | ||||||
| Tax | ||||||
| NOPAT | ||||||
| + D&A | ||||||
| - CapEx | ||||||
| - NWC Change | ||||||
| UFCF | ||||||
| Discount Factor | ||||||
| PV of UFCF |
Comparable Company Analysis
TRADING MULTIPLES:
- EV/Revenue
- EV/EBITDA
- EV/EBIT
- P/E
- P/B
SELECTION CRITERIA:
1. Industry/sector alignment
2. Size (revenue, market cap)
3. Growth profile
4. Profitability profile
5. Geographic exposure
6. Capital structure
ADJUSTMENTS:
- Control premium (20-30% for acquisition)
- Liquidity discount (10-30% for private)
- Size discount (10-20% for smaller)Precedent Transaction Analysis
TRANSACTION MULTIPLES:
- EV/LTM Revenue
- EV/LTM EBITDA
- EV/NTM EBITDA
- Transaction Premium to unaffected price
ADJUSTMENTS:
- Market conditions at time of deal
- Strategic vs. financial buyer
- Competitive auction vs. negotiated
- Synergy assumptions baked inSum-of-the-Parts (SOTP)
METHODOLOGY:
1. Identify distinct business segments
2. Value each segment independently
3. Apply segment-specific multiples/DCF
4. Sum segment values
5. Subtract corporate costs (capitalized)
6. Adjust for holding company discount (10-20%)
CONGLOMERATE DISCOUNT FACTORS:
- Complexity premium demanded by investors
- Capital allocation inefficiencies
- Management distraction
- Lack of pure-play comparablesLeveraged Buyout (LBO) Analysis
LBO Model Structure
SOURCES & USES:
Sources:
- Senior Debt (Term Loan A/B)
- Subordinated Debt (Mezz, High Yield)
- Equity Contribution
Uses:
- Purchase Price
- Refinance Existing Debt
- Transaction Fees
- Cash to Balance Sheet
KEY METRICS:
- Entry Multiple: EV / LTM EBITDA
- Exit Multiple: Assumed sale multiple
- Equity IRR: Target 20-25%+
- Cash-on-Cash: 2.0-3.0x in 5 years
- MOIC: Multiple of Invested CapitalLBO Returns Framework
| IRR Target | Hold Period | Required MOIC |
|---|---|---|
| 20% | 3 years | 1.7x |
| 20% | 5 years | 2.5x |
| 25% | 3 years | 2.0x |
| 25% | 5 years | 3.0x |
Value Creation Sources
% of Total Returns (typical)
EBITDA Growth 40-50%
- Revenue growth
- Margin improvement
Multiple Expansion 20-30%
- Market timing
- Operational improvement
- Strategic repositioning
Debt Paydown 20-30%
- Cash flow generation
- Working capital improvementM&A Financial Analysis
Accretion/Dilution Analysis
STANDALONE EPS (Acquirer):
Net Income / Shares Outstanding = EPS
PRO FORMA EPS:
(Combined Net Income - Synergies + Interest Cost) / New Shares = PF EPS
ACCRETION/(DILUTION):
(PF EPS - Standalone EPS) / Standalone EPS = %
BREAKEVEN SYNERGIES:
Synergies needed to make deal EPS neutralSynergy Analysis
| Synergy Type | Typical Range | Realization Timeline |
|---|---|---|
| Cost Synergies | 5-15% of target costs | 1-3 years |
| Revenue Synergies | 2-5% of combined revenue | 2-5 years |
Deal Structure Considerations
CONSIDERATION:
- Cash: Immediate value, tax implications
- Stock: Alignment, dilution, tax deferral
- Mixed: Balance of above
FINANCING:
- Debt capacity analysis
- Credit rating implications
- Optimal capital structure
- Bridge financing needsCapital Allocation Framework
Capital Allocation Hierarchy
1. MAINTAIN CORE BUSINESS
- Maintenance CapEx
- Working capital
- Required debt service
2. INVEST IN GROWTH
- Growth CapEx (> WACC hurdle)
- M&A (strategic fit + returns)
- R&D / Innovation
3. RETURN TO SHAREHOLDERS
- Dividends (sustainable payout)
- Share repurchases (below intrinsic value)
4. BUILD FLEXIBILITY
- Cash reserves
- Debt capacity
- Strategic optionalityInvestment Hurdle Rates
| Investment Type | Typical Hurdle | Risk Premium |
|---|---|---|
| Maintenance CapEx | WACC | None |
| Growth CapEx | WACC + 2-3% | Low |
| Domestic M&A | WACC + 3-5% | Medium |
| International M&A | WACC + 5-8% | High |
| Venture/Innovation | 25-30% IRR | Very High |
ROIC vs WACC Framework
VALUE CREATION:
ROIC > WACC → Value creating
ROIC = WACC → Value neutral
ROIC < WACC → Value destroying
ECONOMIC PROFIT:
Economic Profit = (ROIC - WACC) x Invested Capital
SPREAD ANALYSIS:
Track ROIC-WACC spread over time
Target: Positive and expanding spreadTreasury & Risk Management
Working Capital Management
CASH CONVERSION CYCLE:
CCC = DSO + DIO - DPO
DSO (Days Sales Outstanding) = AR / (Revenue/365)
DIO (Days Inventory Outstanding) = Inventory / (COGS/365)
DPO (Days Payable Outstanding) = AP / (COGS/365)
OPTIMIZATION LEVERS:
- Accelerate collections (DSO reduction)
- Improve inventory turns (DIO reduction)
- Extend payment terms (DPO increase)
- Supply chain financingHedging Strategies
| Risk Type | Hedging Instruments | Strategy |
|---|---|---|
| FX Risk | Forwards, Options, Swaps | Natural hedging, rolling hedge |
| Interest Rate | Swaps, Caps, Floors | Fixed/floating mix |
| Commodity | Futures, Options | Cost certainty for inputs |
| Credit | CDS, Insurance | Counterparty protection |
Capital Structure Optimization
OPTIMAL CAPITAL STRUCTURE:
Balance:
- Tax shield benefits of debt
- Bankruptcy/distress costs
- Financial flexibility
- Credit rating implications
CREDIT METRICS TARGETS:
Investment Grade:
- Debt/EBITDA: 2-3x
- Interest Coverage: > 5x
- FFO/Debt: > 30%
High Yield:
- Debt/EBITDA: 4-6x
- Interest Coverage: > 2x
- FFO/Debt: 15-25%Investor Relations
Earnings Call Preparation
KEY COMPONENTS:
1. Prepared remarks (10-15 min)
- Financial highlights
- Operational performance
- Strategic updates
- Guidance
2. Q&A preparation
- Anticipated questions
- Approved responses
- Escalation protocols
3. Supplemental materials
- Earnings release
- Investor presentation
- Financial supplementGuidance Framework
| Guidance Type | Frequency | Specificity |
|---|---|---|
| Revenue | Quarterly | Range |
| EPS | Quarterly | Range |
| Cash Flow | Annual | Target |
| CapEx | Annual | Range |
| Long-term Targets | Investor Day | Directional |
Financial Planning & Analysis
Rolling Forecast Model
FREQUENCY: Monthly or Quarterly
HORIZON: 12-18 months rolling
COMPONENTS:
- Revenue by segment/product
- Gross margin drivers
- Operating expense detail
- Working capital assumptions
- CapEx plan
- Cash flow projection
VARIANCE ANALYSIS:
- Budget vs. Actual
- Prior forecast vs. Current
- Volume vs. Price vs. MixBudget Process Timeline
| Phase | Timing | Activities |
|---|---|---|
| Strategic Planning | Q2 | Long-range plan update |
| Guidance Setting | Q3 | Preliminary targets |
| Detailed Budgeting | Q3-Q4 | Bottom-up plans |
| Review & Approval | Q4 | Executive/Board approval |
| Communication | Q4 | Cascaded targets |
See Also
- Fortune 50 Business Strategy
- Fortune 50 Risk Management
- Fortune 50 Operations
M&A Due Diligence Specialist Skill
Description
Comprehensive M&A due diligence expertise for Fortune 50 acquisitions. Provides systematic frameworks for financial, legal, operational, commercial, and strategic due diligence. Covers buy-side and sell-side perspectives, integration planning, and risk identification. This skill delivers investment banking and corporate development-level rigor for evaluating and executing M&A transactions.
When to Use This Skill
Use this skill when:
- Conducting buy-side due diligence on acquisition targets
- Preparing sell-side materials for divestiture or sale process
- Leading integration planning for announced deals
- Assessing M&A opportunities in strategic planning
- Conducting post-merger integration (PMI)
- Evaluating synergy opportunities and risks
- Building due diligence checklists and playbooks
- Training M&A teams on best practices
Core Due Diligence Frameworks
1. Due Diligence Project Management
Framework Overview: Systematic approach to managing the DD process from LOI to closing.
## M&A Due Diligence Project Plan - [Target Company] - [Date]
### Transaction Overview
**Target:** [Company Name]
**Industry:** [Sector]
**Acquirer:** [Our Company]
**Transaction Type:** [Strategic Acquisition / Carve-Out / Take-Private / Merger]
**Deal Size:** [$X Enterprise Value]
**Timeline:**
- LOI Signed: [Date]
- Due Diligence Period: [X weeks, Date - Date]
- SPA Signing Target: [Date]
- Expected Close: [Date]
**Deal Team:**
- **Sponsor:** [CEO / Business Unit President]
- **Project Lead:** [VP Corp Dev]
- **Finance Lead:** [VP FP&A / CFO's designee]
- **Legal Lead:** [General Counsel / External Counsel]
- **Integration Lead:** [VP Operations / PMO]
**External Advisors:**
- Financial DD: [Firm Name]
- Legal DD: [Law Firm]
- IT DD: [Consulting Firm]
- Environmental DD: [Specialist Firm]
- HR/Compensation DD: [Firm Name]
---
### Due Diligence Workstream Structure
#### Workstream 1: Financial Due Diligence
**Lead:** [Name, Title]
**Team:** [Names]
**External Support:** [Accounting Firm]
**Objectives:**
1. Validate financial statements and quality of earnings
2. Assess working capital requirements
3. Identify adjustments to EBITDA
4. Validate management projections
5. Analyze historical cash flow generation
6. Identify financial risks and opportunities
**Deliverables:**
- Quality of Earnings report
- Net Working Capital analysis
- Debt and debt-like items schedule
- Financial model with normalized EBITDA
- Synergy identification and validation
- Red flag memo
**Timeline:**
- Weeks 1-2: Data room review, management interviews
- Week 3: Draft findings
- Week 4: Final report and presentation
---
#### Workstream 2: Legal Due Diligence
**Lead:** [Name, Title]
**Team:** [Names]
**External Support:** [Law Firm]
**Objectives:**
1. Review material contracts and identify consent requirements
2. Assess litigation and regulatory risks
3. Validate IP ownership and freedom to operate
4. Review employment agreements and potential liabilities
5. Identify deal structure considerations (asset vs. stock)
6. Assess antitrust and regulatory approval requirements
**Deliverables:**
- Legal DD report with risk assessment
- Material contracts summary
- Required consents and approvals list
- IP portfolio assessment
- Litigation and regulatory matter summary
- Environmental liability assessment
**Timeline:**
- Weeks 1-4: Ongoing document review
- Week 3: Draft findings
- Week 4: Final report
---
#### Workstream 3: Commercial Due Diligence
**Lead:** [Name, Title]
**Team:** [Names]
**External Support:** [Strategy Consulting Firm]
**Objectives:**
1. Validate market size and growth projections
2. Assess competitive positioning
3. Evaluate customer concentration and satisfaction
4. Analyze pricing trends and dynamics
5. Validate revenue projections
6. Identify commercial synergy opportunities
**Deliverables:**
- Market assessment report
- Customer interviews summary (Top 10-15)
- Competitive landscape analysis
- Revenue build-up and validation
- Commercial synergy analysis
- Go-to-market strategy assessment
**Timeline:**
- Weeks 1-2: Market research, customer interviews
- Week 3: Analysis and synthesis
- Week 4: Final report
---
#### Workstream 4: Operational Due Diligence
**Lead:** [Name, Title]
**Team:** [Names]
**External Support:** [Operations Consulting Firm]
**Objectives:**
1. Assess manufacturing and operations efficiency
2. Evaluate supply chain resilience
3. Review IT systems and infrastructure
4. Assess organizational structure and talent
5. Identify operational improvement opportunities
6. Validate cost synergy assumptions
**Deliverables:**
- Operations assessment report
- Supply chain risk analysis
- IT systems architecture and integration assessment
- Organizational design and key talent review
- Cost synergy validation and roadmap
- CAPEX and maintenance requirements
**Timeline:**
- Weeks 1-2: Site visits, management interviews
- Week 3: Analysis
- Week 4: Final report
---
#### Workstream 5: Strategic & Cultural Fit
**Lead:** [Name, Title]
**Team:** [Names]
**Objectives:**
1. Validate strategic rationale
2. Assess cultural compatibility
3. Evaluate management team quality
4. Assess execution risks
5. Identify integration challenges
**Deliverables:**
- Strategic fit assessment
- Cultural assessment report
- Management team evaluation
- Integration risk matrix
- Day 1 readiness plan
**Timeline:**
- Weeks 1-4: Ongoing assessment
- Week 4: Final synthesis
---
### Due Diligence Work Plan (4-Week Example)
#### Week 1: Data Room Access & Initial Review
**Monday:**
- [ ] Kick-off meeting with full DD team
- [ ] Data room access granted
- [ ] Assign document review responsibilities
- [ ] Schedule management presentations
**Tuesday-Wednesday:**
- [ ] Financial data room review begins
- [ ] Legal document index creation
- [ ] Customer interview list finalized
- [ ] Site visit scheduling
**Thursday-Friday:**
- [ ] Management presentation (Day 1): Company overview, strategy
- [ ] Management presentation (Day 2): Financial deep dive
- [ ] Initial questions list compiled
- [ ] Week 1 team status meeting
---
#### Week 2: Deep Dive & Validation
**Monday-Tuesday:**
- [ ] Customer interviews (Top 10 customers)
- [ ] Supplier interviews (Top 5 suppliers)
- [ ] Site visits (main facilities)
- [ ] Deep dive on financial model
**Wednesday-Thursday:**
- [ ] Legal contract review
- [ ] IT systems review and architecture session
- [ ] HR policies and compensation review
- [ ] Environmental site assessments
**Friday:**
- [ ] Week 2 status meeting
- [ ] Preliminary findings discussion
- [ ] Additional information requests submitted
- [ ] Red flag identification
---
#### Week 3: Analysis & Synthesis
**Monday-Wednesday:**
- [ ] Complete customer and supplier analysis
- [ ] Finalize quality of earnings adjustments
- [ ] Complete market sizing and competitive analysis
- [ ] Assess operational improvement opportunities
- [ ] Validate synergy assumptions
**Thursday:**
- [ ] Draft DD reports from all workstreams
- [ ] Integration planning kickoff
- [ ] Preliminary valuation and returns update
**Friday:**
- [ ] Week 3 status meeting with executive sponsors
- [ ] Go/no-go preliminary discussion
- [ ] Negotiation strategy for SPA based on findings
---
#### Week 4: Finalization & Decision
**Monday-Tuesday:**
- [ ] Finalize all DD reports
- [ ] Integration plan draft (100-day plan)
- [ ] Financial model updates based on DD findings
- [ ] Returns analysis (IRR, payback, accretion/dilution)
**Wednesday:**
- [ ] Executive DD readout presentation
- [ ] Board materials preparation
- [ ] Final valuation and deal structure recommendation
**Thursday:**
- [ ] Board approval (if proceeding)
- [ ] SPA negotiation based on DD findings
- [ ] Integration team activation
**Friday:**
- [ ] Final go/no-go decision
- [ ] If GO: SPA signing, announcement planning
- [ ] If NO-GO: Walk-away communication, lessons learned
---
### Due Diligence Checklist Library
The following sections provide detailed checklists for each DD workstream.
---
## Financial Due Diligence Checklist
### Quality of Earnings Analysis
**Revenue Analysis:**
- [ ] Obtain monthly revenue by product/service line (last 3 years + YTD)
- [ ] Analyze revenue recognition policies (ASC 606 compliance)
- [ ] Identify and quantify non-recurring revenue
- [ ] Assess customer concentration (Top 10 customers)
- [ ] Review customer contracts for terms, pricing, duration
- [ ] Analyze churn/retention rates
- [ ] Validate backlog and deferred revenue
- [ ] Assess revenue growth drivers (volume, price, mix)
- [ ] Identify any channel stuffing or pull-forward tactics
- [ ] Review sales returns, credits, discounts trends
**Adjustments to Revenue:**
- [ ] One-time project revenue
- [ ] Related party revenue
- [ ] Revenue from exited product lines
- [ ] Pre-close discounts or unusual terms
- [ ] Unearned/deferred revenue adjustments
---
**Cost of Goods Sold Analysis:**
- [ ] Obtain COGS detail by category (materials, labor, overhead)
- [ ] Analyze gross margin trends by product/segment
- [ ] Review inventory accounting policies (FIFO, LIFO, weighted avg)
- [ ] Assess COGS allocation methodologies
- [ ] Identify non-recurring or unusual costs
- [ ] Review vendor concentration and pricing trends
- [ ] Analyze labor efficiency and productivity
- [ ] Review manufacturing overhead absorption
**Adjustments to COGS:**
- [ ] Non-recurring materials or supply chain issues
- [ ] Inventory write-offs or reserves
- [ ] Stock-based compensation allocated to COGS
- [ ] Related party purchases above/below market
---
**Operating Expenses Analysis:**
- [ ] Obtain OpEx detail by function and account (3 years + YTD)
- [ ] Analyze SG&A as % of revenue trend
- [ ] Review R&D spend and capitalization policy
- [ ] Identify corporate allocations (if carve-out)
- [ ] Assess management bonuses and incentive comp
- [ ] Review professional fees and outside services
- [ ] Analyze rent and facilities costs
- [ ] Review IT and software expenses
- [ ] Assess D&A and allocation methodologies
**Adjustments to Operating Expenses:**
- [ ] Owner/related party expenses (non-arms length)
- [ ] One-time professional fees (legal, consulting for this deal)
- [ ] Excess management compensation
- [ ] Corporate allocations (if carve-out)
- [ ] Stock-based compensation
- [ ] Non-recurring restructuring or severance
- [ ] Litigation settlements
- [ ] Under-invested functions (sales, IT, compliance)
---
**Below-the-Line Items:**
- [ ] Interest expense (review debt schedule)
- [ ] Interest income
- [ ] FX gains/losses (recurring vs. non-recurring)
- [ ] Equity method investments
- [ ] Other income/expense
- [ ] Tax provision and effective tax rate
---
**Normalized EBITDA Bridge:**
| Line Item | Reported EBITDA | Adjustments | Normalized EBITDA | Notes |
| ----------------------------- | --------------- | ----------- | ----------------- | --------------------- |
| LTM EBITDA | $X | | | Per management |
| Less: One-time revenue | | ($X) | | [Description] |
| Add: Excess owner comp | | $X | | [Normalize to market] |
| Add: Non-recurring legal fees | | $X | | [Deal-related] |
| Less: Under-investment (IT) | | ($X) | | [Ongoing need] |
| **Normalized EBITDA** | | | **$X** | |
**Quality of Earnings Rating:** [High / Medium / Low]
**Key Risks:** [List top 3 risks to earnings quality]
---
### Working Capital Analysis
**Net Working Capital (NWC) Components:**
| Item | Historical Avg | Mgmt Target | Due Diligence Estimate | Notes |
| ----------------------- | -------------- | ----------- | ---------------------- | ----------- |
| Accounts Receivable | $X | $X | $X | DSO: X days |
| Inventory | $X | $X | $X | DIO: X days |
| Prepaid Expenses | $X | $X | $X | |
| **Current Assets** | **$X** | **$X** | **$X** | |
| | | | | |
| Accounts Payable | ($X) | ($X) | ($X) | DPO: X days |
| Accrued Expenses | ($X) | ($X) | ($X) | |
| Deferred Revenue | ($X) | ($X) | ($X) | |
| **Current Liabilities** | **($X)** | **($X)** | **($X)** | |
| | | | | |
| **Net Working Capital** | **$X** | **$X** | **$X** | |
| NWC as % of Revenue | X% | X% | X% | |
**NWC Peg for SPA:**
- Recommended NWC Target: [$X]
- Basis: [LTM average / Industry norm / Normalized for growth]
- True-up mechanism: [Dollar-for-dollar adjustment at close]
**NWC Risk Factors:**
- [ ] Aggressive A/R collection (potential for aging deterioration)
- [ ] Excess inventory (obsolescence risk)
- [ ] Stretched payables (supplier relationship risk)
- [ ] Seasonality impact on NWC
- [ ] Growth investment requiring NWC increase
---
### Debt & Debt-Like Items
**Funded Debt:**
| Instrument | Outstanding | Interest Rate | Maturity | Prepayment Terms | Assumed/Repaid |
| -------------- | ----------- | ------------- | -------- | ---------------- | --------------- |
| Revolver | $X | L+Xbps | 20XX | None | Repaid at close |
| Term Loan | $X | L+Xbps | 20XX | X% penalty | Repaid at close |
| Senior Notes | $X | X% | 20XX | Make-whole | Assumed |
| **Total Debt** | **$X** | | | | |
**Debt-Like Items (Transaction Adjustments):**
- [ ] Unfunded pension liabilities: [$X]
- [ ] Deferred compensation: [$X]
- [ ] Contingent liabilities (litigation): [$X]
- [ ] Environmental remediation: [$X]
- [ ] Capital leases / finance leases: [$X]
- [ ] Earnouts from prior acquisitions: [$X]
- [ ] Seller notes or preferred stock: [$X]
**Total Debt + Debt-Like Items:** [$X]
**Enterprise Value Calculation:**
- Equity Purchase Price: [$X]
- Plus: Debt and debt-like items: [$X]
- Less: Cash (if retained): [($X)]
- **Enterprise Value:** [$X]
---
### Cash Flow Analysis
**Historical Free Cash Flow (3 Years):**
| Year | Cash from Ops | CAPEX | Free Cash Flow | FCF / Net Income | Notes |
| ------- | ------------- | ----- | -------------- | ---------------- | --------- |
| Year -2 | $X | ($X) | $X | X% | [Context] |
| Year -1 | $X | ($X) | $X | X% | [Context] |
| LTM | $X | ($X) | $X | X% | [Context] |
**Cash Flow Quality Assessment:**
- Operating cash flow trend: [Improving / Stable / Declining]
- FCF conversion (FCF/NI): [>100% = High / 80-100% = Medium / <80% = Low]
- CAPEX intensity: [Maintenance X%, Growth Y%]
- Working capital as % of revenue: [Increasing / Stable / Decreasing]
**Cash Flow Risks:**
- [ ] Customer payment terms extending
- [ ] Inventory build-up not supported by growth
- [ ] Deferred maintenance CAPEX
- [ ] Cash taxes lower than P&L due to NOLs (non-recurring benefit)
---
### Tax Analysis
**Effective Tax Rate Analysis:**
| Year | Pre-Tax Income | Tax Expense | Effective Tax Rate | Statutory Rate | Variance |
| ------- | -------------- | ----------- | ------------------ | -------------- | -------- |
| Year -2 | $X | $X | X% | X% | Xpp |
| Year -1 | $X | $X | X% | X% | Xpp |
| LTM | $X | $X | X% | X% | Xpp |
**Tax Rate Drivers:**
- Statutory federal rate: [X%]
- State/local taxes: [X%]
- Foreign rate differential: [X%]
- Permanent differences: [X%]
- Credits (R&D, etc.): [X%]
**Tax Due Diligence Items:**
- [ ] Review last 3 years of tax returns
- [ ] Assess NOL carryforwards: [$X, expiration dates]
- [ ] Identify tax contingencies and reserves
- [ ] Review transfer pricing policies (if multinational)
- [ ] Assess tax basis of assets (for Section 338(h)(10) or 754 election)
- [ ] Identify state tax nexus and exposures
- [ ] Review tax sharing agreements (if carve-out)
**Post-Acquisition Tax Planning:**
- Expected effective tax rate: [X%]
- Step-up in tax basis: [$X in future tax shields]
- Interest deductibility post-acquisition: [Assess Section 163(j) limitation]
---
## Legal Due Diligence Checklist
### Corporate & Governance
**Corporate Structure:**
- [ ] Articles of incorporation and bylaws
- [ ] Capitalization table (all equity securities)
- [ ] List of subsidiaries and ownership percentages
- [ ] Organizational chart
- [ ] Good standing certificates (all jurisdictions)
**Board & Shareholder Matters:**
- [ ] Board minutes (last 3 years)
- [ ] Shareholder meeting minutes (last 3 years)
- [ ] Shareholder agreements
- [ ] Voting agreements or proxies
- [ ] Stock option plans and grants
- [ ] Warrants, convertible securities
**Acquisition Structure Considerations:**
- [ ] Stock purchase vs. asset purchase analysis
- [ ] Section 338(h)(10) election eligibility (if S-corp)
- [ ] Section 754 election (if partnership)
- [ ] State law considerations (appraisal rights, consents)
---
### Material Contracts
**Criteria for "Material":**
- Contracts >$X annually
- Contracts >Y years in term
- Sole-source or exclusive arrangements
- Contracts with change-of-control provisions
- Contracts outside ordinary course of business
**Customer Contracts:**
- [ ] Top 20 customer contracts
- [ ] Contract terms (pricing, volume, duration)
- [ ] Termination provisions
- [ ] **Change of control provisions** (consent required?)
- [ ] Assignment restrictions
- [ ] Exclusivity or most-favored-nation clauses
- [ ] Pricing adjustment mechanisms
- [ ] Warranty and indemnification obligations
- [ ] IP ownership (especially in services/development contracts)
**Key Questions:**
- Which customers represent >10% of revenue?
- What % of revenue is under long-term contract vs. one-time POs?
- Any customer contracts expiring within 12 months post-close?
- Any pending disputes or dissatisfied customers?
---
**Supplier Contracts:**
- [ ] Top 10 supplier contracts
- [ ] Pricing terms and adjustment mechanisms
- [ ] Volume commitments or take-or-pay provisions
- [ ] **Change of control provisions**
- [ ] Sole-source dependencies
- [ ] Supply guarantees and allocation rights
- [ ] Quality standards and warranty
**Key Questions:**
- Any sole-source suppliers for critical inputs?
- What % of COGS is locked in under long-term contracts?
- Any supply chain disruptions or quality issues?
- Exposure to commodity price volatility?
---
**Other Material Contracts:**
- [ ] Leases (real estate, equipment)
- [ ] Remaining term and renewal options
- [ ] Rent escalation provisions
- [ ] Assignment and subletting restrictions
- [ ] **Landlord consent required for assignment?**
- [ ] Maintenance and CAPEX obligations
- [ ] IP Licenses (in-bound)
- [ ] Licensed IP description
- [ ] Royalty rates and minimums
- [ ] Exclusivity
- [ ] Term and termination
- [ ] **Change of control impact**
- [ ] Partnership/JV Agreements
- [ ] Economic terms
- [ ] Governance and control rights
- [ ] Exit rights and restrictions
- [ ] Loan Agreements
- [ ] Change of control provisions
- [ ] Prepayment penalties
- [ ] Consent required from lenders?
---
**Contract Consent Summary:**
| Contract Type | # Requiring Consent | Revenue/Cost Impact | Likelihood of Consent | Risk Level |
| ------------------ | ------------------- | ------------------- | --------------------- | ---------------- |
| Customer Contracts | X | $X revenue | High / Medium / Low | Green/Yellow/Red |
| Supplier Contracts | X | $X COGS | High / Medium / Low | Green/Yellow/Red |
| Leases | X | $X rent | High / Medium / Low | Green/Yellow/Red |
| IP Licenses | X | $X royalties | High / Medium / Low | Green/Yellow/Red |
**Mitigation Plan:**
- Obtain consents pre-closing vs. post-closing
- Identify replacement contracts if consent denied
- Negotiate seller reps and indemnities
---
### Intellectual Property
**Patents:**
- [ ] List of all patents (granted and pending)
- [ ] Patent portfolio by jurisdiction
- [ ] Assignment records (confirm company ownership)
- [ ] Maintenance fee payment status
- [ ] Inventorship verification
- [ ] Freedom to operate analysis (are we infringing others?)
- [ ] Any patent litigation (offensive or defensive)
**Trademarks:**
- [ ] Registered trademarks by jurisdiction
- [ ] Common law trademarks in use
- [ ] Assignment records
- [ ] Opposition or cancellation proceedings
- [ ] Domain names
**Copyrights:**
- [ ] Software code ownership
- [ ] Work-for-hire agreements (employees, contractors)
- [ ] Open source software usage and compliance
- [ ] Third-party code or libraries (licenses)
**Trade Secrets:**
- [ ] List of key trade secrets and know-how
- [ ] Protection measures (NDAs, restricted access, labeling)
- [ ] Employee confidentiality agreements
- [ ] Non-compete agreements (enforceability varies by state)
**IP Due Diligence Red Flags:**
- [ ] IP owned by founders, not company
- [ ] Missing assignments from employees/contractors
- [ ] Pending or threatened IP litigation
- [ ] Expired patents with no follow-on protection
- [ ] GPL or other "copyleft" open source software in product
- [ ] Infringement of third-party IP
---
### Litigation & Regulatory
**Current Litigation:**
- [ ] List of all pending or threatened litigation
- [ ] Parties, jurisdiction, claims
- [ ] Potential exposure (low/medium/high estimates)
- [ ] Insurance coverage
- [ ] Expected resolution timing
- [ ] Impact on business operations
**Categories:**
- [ ] Commercial disputes (customer, supplier, partner)
- [ ] Employment litigation (discrimination, wage/hour, wrongful termination)
- [ ] IP litigation (infringement, trade secrets)
- [ ] Product liability
- [ ] Regulatory enforcement
- [ ] Class actions
**Litigation Reserve Adequacy:**
- Accrued reserves: [$X]
- Potential additional exposure: [$X - $Y range]
- Uninsured exposure: [$X]
---
**Regulatory Compliance:**
- [ ] Industry-specific regulations (FDA, FAA, FCC, etc.)
- [ ] Environmental compliance (permits, inspections, violations)
- [ ] OSHA and workplace safety
- [ ] Export controls (ITAR, EAR)
- [ ] Anti-corruption (FCPA, anti-bribery laws)
- [ ] Data privacy (GDPR, CCPA, HIPAA if applicable)
- [ ] Consumer protection (FTC, state AGs)
**Regulatory Due Diligence Checklist:**
- [ ] Obtain copies of all material permits and licenses
- [ ] Review inspection reports and notices of violation (last 3 years)
- [ ] Assess pending regulatory proceedings or investigations
- [ ] Review compliance policies and training programs
- [ ] Assess regulatory approval requirements for transaction (HSR, CFIUS, etc.)
---
**Antitrust / HSR Filing:**
- [ ] Calculate Hart-Scott-Rodino thresholds
- [ ] Prepare HSR filing if required
- [ ] Timeline: 30-day initial waiting period (can be extended)
- [ ] Competitive overlap analysis
- [ ] Market share analysis
- [ ] Second request risk assessment
**CFIUS (Committee on Foreign Investment in the U.S.):**
- [ ] Assess if target is in sensitive industry (defense, tech, infrastructure)
- [ ] Determine if mandatory filing required
- [ ] Prepare voluntary filing if prudent
- [ ] Mitigation measures (if foreign acquirer)
---
### Employment & Benefits
**Employee Census:**
- [ ] Headcount by function, location, full-time/part-time
- [ ] Employee vs. contractor classification
- [ ] Union vs. non-union
- [ ] Demographics (tenure, age for pension/COBRA analysis)
**Employment Agreements:**
- [ ] Executive employment agreements (terms, severance, change-of-control)
- [ ] Key employee retention agreements
- [ ] Non-compete and non-solicitation agreements (enforceability)
- [ ] Confidentiality and IP assignment agreements
- [ ] Severance policies and plans
**Compensation & Benefits:**
- [ ] Salary and bonus structure
- [ ] Equity compensation (options, RSUs, phantom stock)
- [ ] Vesting acceleration on change of control?
- [ ] Total value of accelerated vesting: [$X]
- [ ] Commission and incentive plans
- [ ] Benefits summary (health, 401k, PTO, etc.)
**Equity Compensation Acceleration:**
| Plan | Outstanding Options/RSUs | Unvested | Acceleration on CofC? | Value if Accelerated |
| ------------ | ------------------------ | -------- | --------------------- | -------------------- |
| 2020 Plan | X options | X | 100% / 50% / None | $X |
| Exec Phantom | X units | X | 100% / 50% / None | $X |
| **Total** | | | | **$X** |
**Action:** Factor into purchase price / retention / post-close comp
---
**Employee Benefits Plans:**
- [ ] 401(k) plan documents and compliance testing
- [ ] Pension plans (if any): funded status, PBGC compliance
- [ ] Health and welfare plans: ERISA compliance, COBRA
- [ ] Severance plans: funding requirements post-close
- [ ] Deferred compensation plans: Section 409A compliance
**Labor & Employment Compliance:**
- [ ] Wage and hour compliance (exempt vs. non-exempt classification)
- [ ] I-9 and immigration compliance
- [ ] Equal employment opportunity (EEO) and affirmative action
- [ ] WARN Act compliance (if layoffs planned)
- [ ] State-specific employment laws
**Labor Relations (if unionized workforce):**
- [ ] Collective bargaining agreements (terms, expiration)
- [ ] Labor disputes or grievances
- [ ] Pension and retiree obligations
- [ ] Unfair labor practice charges
---
### Environmental
**Environmental Site Assessments:**
- [ ] Phase I ESA for all owned/leased properties
- [ ] Phase II ESA if Phase I identifies concerns
- [ ] Asbestos, lead paint, underground storage tanks
**Compliance:**
- [ ] Air, water, waste permits and compliance
- [ ] Hazardous materials handling and disposal
- [ ] Spill history and remediation
- [ ] Environmental violations and fines (last 5 years)
**Contingent Liabilities:**
- [ ] Superfund sites (current or former)
- [ ] Off-site disposal sites (CERCLA liability)
- [ ] Estimated remediation costs: [$X - $Y range]
- [ ] Insurance coverage (pollution liability)
**Allocation in SPA:**
- Pre-closing environmental liabilities: Seller retains
- Post-closing liabilities: Buyer assumes
- Known contamination: Negotiate escrow or indemnity
---
## Commercial Due Diligence Checklist
### Market Assessment
**Market Size & Growth:**
- [ ] Total addressable market (TAM): [$X]
- [ ] Serviceable addressable market (SAM): [$X]
- [ ] Target company's market share: [X%]
- [ ] Market growth rate (historical 3yr, forecast 5yr): [X% CAGR]
- [ ] Market drivers: [List key growth drivers]
- [ ] Market headwinds: [List risks to growth]
**Data Sources:**
- Industry reports (Gartner, Forrester, IDC, etc.)
- Trade associations
- Government data (Census, BLS, etc.)
- Customer interviews
- Analyst research
**Validation:**
- [ ] Compare management projections to industry growth
- [ ] Triangulate market size from multiple sources
- [ ] Assess reasonableness of market share assumptions
---
### Competitive Landscape
**Competitive Positioning:**
| Competitor | Market Share | Strengths | Weaknesses | Competitive Threat |
| ----------- | ------------ | --------- | ---------- | ------------------- |
| Incumbent A | X% | [List] | [List] | High / Medium / Low |
| Incumbent B | X% | [List] | [List] | High / Medium / Low |
| Target | X% | [List] | [List] | Our investment |
| New Entrant | X% | [List] | [List] | High / Medium / Low |
**Competitive Dynamics:**
- [ ] Industry concentration (HHI): [X - competitive / concentrated]
- [ ] Pricing trends: [Increasing / Stable / Declining]
- [ ] Basis of competition: [Price / Quality / Service / Innovation]
- [ ] Barriers to entry: [High / Medium / Low]
- [ ] Substitution threats: [High / Medium / Low]
**Target's Competitive Advantages:**
1. [Advantage 1 - e.g., proprietary technology]
- Sustainable? [Yes/No - Why]
- Quantified impact: [$X revenue, Xpp margin]
2. [Advantage 2 - e.g., exclusive distribution]
- Sustainable? [Yes/No - Why]
- Quantified impact: [$X revenue, Xpp margin]
**Competitive Risks:**
1. [Risk 1 - e.g., new technology disruption]
- Likelihood: [High/Medium/Low]
- Impact if realized: [$X revenue loss]
- Mitigation: [Strategy]
---
### Customer Analysis
**Customer Concentration:**
| Customer | LTM Revenue | % of Total | Contract Term | Churn Risk | Notes |
| ---------- | ----------- | ---------- | ------------- | ------------ | --------- |
| Customer 1 | $X | X% | X years | High/Med/Low | [Context] |
| Customer 2 | $X | X% | X years | High/Med/Low | [Context] |
| ... | | | | | |
| Top 10 | $X | X% | | | |
| All Others | $X | X% | | | |
**Customer Concentration Risk:**
- Top customer: [X%] of revenue
- Top 5 customers: [X%] of revenue
- Top 10 customers: [X%] of revenue
- Assessment: [Green <25% / Yellow 25-40% / Red >40% in top 10]
---
**Customer Interviews (Top 10-15):**
Interview guide:
1. How long have you been a customer?
2. What products/services do you purchase?
3. Why did you choose this vendor?
4. How satisfied are you? (NPS: 0-10 scale)
5. What could they improve?
6. How do they compare to competitors?
7. Are you increasing, maintaining, or decreasing spend?
8. Any concerns about the acquisition?
9. Would you provide a reference?
**Customer Interview Summary:**
| Customer | Interview Date | NPS | Key Insights | Churn Risk | Opportunity |
| ---------- | -------------- | ---- | ------------ | ------------ | ------------------ |
| Customer 1 | MM/DD | X/10 | [Summary] | High/Med/Low | [Upsell potential] |
**Aggregated Feedback:**
- Average NPS: [X/10]
- Top 3 strengths: [List]
- Top 3 improvement areas: [List]
- Change-of-control concerns: [X customers mentioned concerns]
**Customer Retention Risk:**
- High risk customers: [X customers, $Y revenue]
- Medium risk: [X customers, $Y revenue]
- Low risk: [X customers, $Y revenue]
- Mitigation plan: [Early engagement, retention incentives]
---
**Customer Cohort Analysis:**
| Cohort | # Customers | Avg. First Purchase | Avg. Annual Spend | Retention Rate Yr 1 | Retention Yr 2 | Retention Yr 3 |
| ------ | ----------- | ------------------- | ----------------- | ------------------- | -------------- | -------------- |
| 2021 | X | $X | $X | X% | X% | X% |
| 2022 | X | $X | $X | X% | X% | |
| 2023 | X | $X | $X | X% | | |
**Insights:**
- Retention improving/declining?
- Customer lifetime value (LTV): [$X]
- Customer acquisition cost (CAC): [$X]
- LTV/CAC ratio: [X.Xx - target >3.0]
---
### Revenue Analysis & Validation
**Revenue Build-Up (Bottom-Up Validation):**
**Historical Revenue (3 Years):**
| Segment / Product | Yr -2 | Yr -1 | LTM | Growth % | Driver Analysis |
| ----------------- | ------ | ------ | ------ | -------- | ------------------------ |
| Product Line A | $X | $X | $X | X% | [Volume +X%, Price +Y%] |
| Product Line B | $X | $X | $X | X% | [Volume +X%, Price +Y%] |
| Service Revenue | $X | $X | $X | X% | [Headcount +X, rate +Y%] |
| **Total** | **$X** | **$X** | **$X** | **X%** | |
**Management Projections:**
| Year | Revenue | Growth % | Key Assumptions |
| ---- | ------- | -------- | ----------------------------------------- |
| Yr 1 | $X | X% | [New product launch, X% price increase] |
| Yr 2 | $X | X% | [Market share gain, geographic expansion] |
| Yr 3 | $X | X% | [Organic + acquisition] |
| Yr 4 | $X | X% | [Steady state growth] |
| Yr 5 | $X | X% | [Market growth rate] |
**DD Team Validated Projections:**
| Year | Mgmt Projection | DD Validated | Adjustment | Rationale |
| ---- | --------------- | ------------ | ---------- | ------------------------------------------- |
| Yr 1 | $X | $X | -$X (-X%) | [New product delayed 6mo] |
| Yr 2 | $X | $X | -$X (-X%) | [Price increase unlikely given competition] |
| Yr 3 | $X | $X | $0 | [Reasonable] |
**Revenue Risk Factors:**
1. Customer concentration: [$X revenue at risk from top 3 customers]
2. New product execution: [$X revenue dependent on unproven product]
3. Market growth assumption: [Mgmt assumes X%, market data suggests Y%]
**Revenue Opportunity:**
1. Cross-sell with acquirer: [$X potential]
2. Geographic expansion: [$X potential]
3. Pricing optimization: [$X potential]
---
### Pricing Analysis
**Pricing Strategy:**
- [ ] Cost-plus pricing
- [ ] Value-based pricing
- [ ] Competitive pricing
- [ ] Dynamic pricing
**Pricing Trends (Last 3 Years):**
- Average price change: [+X% annually]
- Volume impact of price changes: [-Y% elasticity]
- Competitive pricing pressure: [High / Medium / Low]
**Pricing Power Assessment:**
- [ ] Strong (can raise prices faster than costs): [Differentiated product, high switching costs]
- [ ] Moderate (track inflation): [Some differentiation, moderate competition]
- [ ] Weak (price taker): [Commoditized, intense competition]
**Pricing Opportunity:**
- Underpriced vs. value delivered: [X% upside]
- Segment-based pricing: [Premium segment untapped]
- Volume discounting rationalization: [Xbps margin opportunity]
---
## Operational Due Diligence Checklist
### Operations & Manufacturing
**Facilities:**
| Location | Owned / Leased | Size (sq ft) | Function | Utilization | Condition | CAPEX Needs |
| --------- | -------------- | ------------ | ------------- | ----------- | -------------- | ----------- |
| Plant A | Owned | X | Manufacturing | X% | Good/Fair/Poor | $X |
| Plant B | Leased | X | Assembly | X% | Good/Fair/Poor | $X |
| Warehouse | Leased | X | Distribution | X% | Good/Fair/Poor | $X |
**Capacity Analysis:**
- Current production capacity: [X units/year]
- Current utilization: [X%]
- Available capacity: [X units/year]
- Revenue growth before capacity expansion needed: [X%]
- Cost of capacity expansion: [$X]
- Timeline for expansion: [X months]
---
**Production Efficiency:**
| Metric | Current | Industry Benchmark | Gap | Improvement Potential |
| ------------------------------------- | ------- | ------------------ | --- | --------------------- |
| OEE (Overall Equipment Effectiveness) | X% | X% | Xpp | $X annually |
| Defect rate | X% | X% | Xpp | $X annually |
| Downtime | X% | X% | Xpp | $X annually |
| Labor productivity (units/FTE) | X | X | X | $X annually |
**Operational Improvement Opportunities:**
1. Lean manufacturing: [$X annual savings]
2. Automation: [$X investment, $Y annual savings, Z year payback]
3. Yield improvement: [$X annual savings]
4. Preventive maintenance: [Reduce downtime Xpp, $Y annual savings]
---
### Supply Chain
**Supplier Concentration:**
| Supplier | Category | Annual Spend | % of COGS | Contract Term | Alternatives | Risk |
| ---------- | -------------- | ------------ | --------- | ------------- | -------------- | ------------ |
| Supplier A | Raw Material X | $X | X% | X years | Y alternatives | Low/Med/High |
| Supplier B | Component Y | $X | X% | Spot market | Single source | Low/Med/High |
**Supplier Risk Assessment:**
- Sole-source dependencies: [X suppliers, $Y spend, Z% of COGS]
- Geographic concentration: [X% of supply from Region Y]
- Financial health of key suppliers: [Assess D&B ratings]
- Lead time trends: [Increasing / Stable / Decreasing]
- Quality issues: [Defect rate trends, supplier scorecards]
**Supply Chain Resilience:**
- [ ] Dual sourcing for critical materials
- [ ] Safety stock levels: [X weeks/months]
- [ ] Alternate transportation modes
- [ ] Nearshoring / reshoring plans
- [ ] Supplier financial monitoring
**Supply Chain Opportunities:**
1. Supplier consolidation: [$X savings from volume]
2. Strategic sourcing: [$X savings from competitive bidding]
3. Payment term extension: [$X cash flow benefit]
4. Vertical integration: [Make vs. buy analysis]
---
### Information Technology
**IT Systems Landscape:**
| System | Vendor | Function | Users | Last Upgrade | Contract Expiration | Integration Complexity |
| ------ | ----------------- | --------------------- | ----- | ------------ | ------------------- | ---------------------- |
| ERP | [SAP/Oracle/etc.] | Financial, operations | X | 20XX | 20XX | High |
| CRM | [Salesforce/etc.] | Sales, marketing | X | 20XX | 20XX | Medium |
| MES | [Custom] | Manufacturing | X | 20XX | N/A | High |
| HRIS | [Workday/etc.] | HR, payroll | X | 20XX | 20XX | Low |
**IT Architecture Assessment:**
- Cloud vs. on-premise: [X% cloud, Y% on-prem]
- Technology debt: [Legacy systems requiring modernization]
- Scalability: [Can systems support X% growth without major investment?]
- Cybersecurity: [Posture assessment, recent audits/pentests]
- Data infrastructure: [Data warehouse, analytics capability]
**IT Integration Plan:**
- Day 1 requirements: [Email, VPN access, basic systems]
- Year 1: [Integrate financial systems, SSO, email migration]
- Year 2: [Full ERP integration vs. leave separate]
- Estimated integration cost: [$X]
- Integration risk: [High / Medium / Low]
**Cybersecurity Due Diligence:**
- [ ] Recent security audits (SOC 2, ISO 27001, pentest results)
- [ ] Incident history (breaches, ransomware, phishing)
- [ ] Security controls (MFA, encryption, DLP, EDR)
- [ ] Compliance (GDPR, CCPA, HIPAA if applicable)
- [ ] Cyber insurance coverage
- [ ] Vulnerability management and patching
**IT Cost Synergies:**
1. License consolidation: [$X annually]
2. Data center shutdown (move to cloud): [$X annually]
3. Headcount optimization: [$X annually]
4. **Total IT synergies:** [$X annually]
---
### Organization & Talent
**Organizational Structure:**
- [ ] Obtain current org chart
- [ ] Headcount by function and level
- [ ] Reporting relationships
- [ ] Span of control (avg. direct reports per manager)
**Management Team Assessment:**
| Name | Title | Tenure | Key Accomplishments | Retention Risk | Retention Plan |
| ---- | ----- | ------ | ------------------- | -------------- | -------------------- |
| CEO | CEO | X yrs | [List] | High/Med/Low | [Equity, role, comp] |
| CFO | CFO | X yrs | [List] | High/Med/Low | [Equity, role, comp] |
| CTO | CTO | X yrs | [List] | High/Med/Low | [Equity, role, comp] |
**Key Talent Identification:**
- [ ] Identify "must-retain" employees (top 20)
- [ ] Assess retention risk (compensation, role changes, culture fit)
- [ ] Develop retention packages (equity, cash, role commitments)
- [ ] Estimated retention cost: [$X]
**Organizational Design Post-Acquisition:**
- [ ] Standalone vs. integrated operating model
- [ ] Reporting structure (to acquirer CEO, BU president, etc.)
- [ ] Functional redundancies (finance, HR, IT, legal)
- [ ] Headcount reduction plan (if any): [X positions, $Y savings, $Z severance]
---
**Human Capital Metrics:**
| Metric | Current | Benchmark | Assessment |
| ----------------------------- | ------------ | --------- | ----------------------- |
| Employee turnover (voluntary) | X% | X% | High/Normal/Low |
| Time-to-fill (open positions) | X days | X days | Good/Concerning |
| Training spend per employee | $X | $X | Adequate/Under-invested |
| Engagement score | X% favorable | X% | Good/Concerning |
| Diversity metrics | X% | X% | Track |
**Talent Risks:**
1. Key person dependency: [CEO/CTO critical, no succession plan]
2. Compensation below market: [X% of employees underpaid, flight risk]
3. Cultural misalignment: [Entrepreneurial culture vs. corporate acquirer]
**Talent Opportunities:**
1. Access to acquirer's talent pool and training
2. Career path expansion for high performers
3. Improved benefits and compensation
---
## Synergy Identification & Validation
### Revenue Synergies
**Cross-Selling:**
| Product | Our Customer Base | Their Product | Estimated Adoption | Revenue Opportunity | Probability | Risk-Adjusted |
| --------------- | ----------------- | ------------- | ------------------ | ------------------- | ----------- | ------------- |
| Their Product A | X customers | $X avg. deal | X% | $X | X% | $X |
| Our Product B | Y customers | $X avg. deal | X% | $X | X% | $X |
**Total Cross-Sell Opportunity:** [$X risk-adjusted, Year 3 run rate]
**Geographic Expansion:**
- Our products in their geographies: [$X opportunity]
- Their products in our geographies: [$X opportunity]
- Investment required: [$X for sales coverage]
- Timeline: [X months to establish, Y years to ramp]
**Combined Product Offering (Bundling):**
- Bundle value proposition: [Integrated solution vs. point products]
- Pricing premium: [X% vs. standalone]
- Estimated bundle attach rate: [X%]
- Revenue opportunity: [$X by Year 3]
**Pricing / Market Position:**
- Market leadership allows pricing improvement: [+X%]
- Revenue impact: [$X]
- Probability: [Medium - depends on competitive response]
---
### Cost Synergies
**Overhead Reduction:**
| Function | Combined Headcount | Redundant Roles | Savings | Severance | Net Savings (Yr 1) |
| ------------- | ------------------ | --------------- | ------- | --------- | ------------------ |
| Finance | X | X | $X | $X | $X |
| HR | X | X | $X | $X | $X |
| IT | X | X | $X | $X | $X |
| Legal | X | X | $X | $X | $X |
| Facilities | | | $X | $X | $X |
| **Total G&A** | | | **$X** | **$X** | **$X** |
**Operational Synergies:**
| Initiative | Annual Savings | Investment | Payback | Timeline | Probability | Risk-Adjusted |
| ------------------------------ | -------------- | ---------- | ------- | -------- | ----------- | ------------- |
| Procurement (volume discounts) | $X | $X | X yrs | Year 1 | 90% | $X |
| Manufacturing consolidation | $X | $X | X yrs | Year 2 | 70% | $X |
| Logistics optimization | $X | $X | X yrs | Year 1 | 80% | $X |
| Shared services (IT, HR) | $X | $X | X yrs | Year 1 | 90% | $X |
**Technology Synergies:**
- Consolidate software licenses: [$X annually]
- Data center / cloud consolidation: [$X annually]
- Eliminate duplicate systems: [$X annually]
**Total Cost Synergies:**
| Category | Gross Annual Synergies | One-Time Costs | Risk-Adjusted Annual |
| ---------- | ---------------------- | -------------- | -------------------- |
| Overhead | $X | $X | $X |
| Operations | $X | $X | $X |
| Technology | $X | $X | $X |
| **Total** | **$X** | **$X** | **$X** |
**Synergy Phasing:**
- Year 1: [$X] ([X]% of total)
- Year 2: [$X] ([X]% of total)
- Year 3: [$X] (100% run rate)
---
## Integration Planning
### Day 1 Readiness Plan
**Critical Day 1 Requirements:**
- [ ] Legal close completed, funds transferred
- [ ] Announcement made (employees, customers, suppliers, media)
- [ ] Email and IT access for integration team
- [ ] Payroll continuity ensured
- [ ] Customer support transition plan
- [ ] Employee FAQ and town hall scheduled
- [ ] Interim governance and reporting structure
**Day 1 Checklist (Pre-Close Preparation):**
**Legal & Finance:**
- [ ] All closing conditions satisfied
- [ ] Funds wired, escrows established
- [ ] Transaction accounting entries prepared
- [ ] Tax filings completed (if required)
**Communications:**
- [ ] Internal: Employee announcement letter/email
- [ ] External: Customer letter, supplier letter, press release
- [ ] Media: FAQ, talking points for executives
- [ ] Website: Updated "about us," leadership pages
**HR & Payroll:**
- [ ] Payroll systems tested and ready
- [ ] Benefits continuation confirmed
- [ ] Employee onboarding packets prepared
- [ ] COBRA notices (if applicable)
**IT:**
- [ ] Email accounts created for integration team
- [ ] VPN / network access provisioned
- [ ] Day 1 system access (critical applications)
- [ ] IT help desk briefed on new employees
---
### 100-Day Integration Plan
**Days 1-30: Stabilize**
**Objectives:**
- Ensure business continuity
- Communicate clearly and frequently
- Establish governance
- Identify quick wins
**Key Milestones:**
- [ ] Day 1: Announce to employees, customers, suppliers
- [ ] Week 1: Town halls at all locations
- [ ] Week 2: Integration team kickoff
- [ ] Week 3: Functional deep dives (finance, ops, sales, etc.)
- [ ] Week 4: Quick win identification, 100-day plan finalized
---
**Days 31-60: Plan**
**Objectives:**
- Complete detailed integration planning
- Finalize organization design
- Develop synergy capture roadmap
- Assess cultural integration needs
**Key Milestones:**
- [ ] Organization design completed
- [ ] Retention offers extended to key employees
- [ ] Synergy initiatives prioritized and resourced
- [ ] Cultural assessment completed
- [ ] System integration plan finalized
---
**Days 61-100: Execute**
**Objectives:**
- Implement organization changes
- Begin synergy capture
- Execute system integrations (Phase 1)
- Monitor cultural integration
**Key Milestones:**
- [ ] New org structure announced and effective
- [ ] Quick win synergies delivered
- [ ] Customer retention program launched
- [ ] System integrations underway
- [ ] 100-day review with executive sponsors
---
### Integration Governance
**Steering Committee:**
- **Chair:** [CEO or BU President]
- **Members:** CFO, COO, CHRO, CIO, Corporate Development
- **Cadence:** Bi-weekly for first 3 months, then monthly
- **Purpose:** Decision-making, issue escalation, progress monitoring
**Integration Management Office (IMO):**
- **Leader:** [VP Integration / PMO]
- **Team:** Project managers, functional leads
- **Responsibilities:**
- Develop and maintain integration plan
- Track milestones and deliverables
- Identify and resolve blockers
- Report progress to Steering Committee
- Manage synergy tracking
**Functional Integration Teams:**
| Function | Lead | Objectives | Deliverables |
| ---------- | ---- | -------------------------------------------- | ---------------------------------------------- |
| Finance | CFO | Integrate accounting, reporting, treasury | Single GL, financial close process |
| HR | CHRO | Align comp/benefits, onboard employees | Org design, retention, cultural integration |
| IT | CIO | Integrate systems, cybersecurity | Day 1 access, email migration, ERP integration |
| Sales | CSO | Retain customers, cross-sell | Customer retention plan, joint sales training |
| Operations | COO | Maintain quality/delivery, capture synergies | Plant rationalization, procurement savings |
---
### Integration Risks & Mitigation
**Top Integration Risks:**
| Risk | Impact | Probability | Mitigation | Owner |
| --------------------------- | ------------------------------------ | ----------- | ------------------------------------------------------- | ----- |
| Key customer defection | -$X revenue | X% | Early engagement, service guarantees | CSO |
| Key employee attrition | Integration delay, knowledge loss | X% | Retention bonuses, clear roles | CHRO |
| System integration failure | $X cost overrun, business disruption | X% | Phased approach, expert resources | CIO |
| Cultural clash | Productivity decline, turnover | X% | Cultural integration program, transparent communication | CHRO |
| Synergy shortfall | -$X EBITDA | X% | Conservative assumptions, governance, accountability | CFO |
| Regulatory/compliance issue | Fines, deal conditions | X% | Pre-close remediation, compliance audit | Legal |
**Risk Mitigation Budget:** [$X reserved for contingencies]
---
## Post-Close Synergy Tracking
**Synergy Scorecard (Quarterly Updates):**
| Synergy Initiative | Owner | Annual Target | Q1 Actual | Q2 Actual | Q3 Actual | Q4 Actual | YTD % of Target | Status |
| ---------------------- | ----- | ------------- | --------- | --------- | --------- | --------- | --------------- | ---------------- |
| Headcount optimization | CHRO | $X | $X | $X | $X | $X | X% | Green/Yellow/Red |
| Procurement savings | CPO | $X | $X | $X | $X | $X | X% | Green/Yellow/Red |
| Facility consolidation | COO | $X | $X | $X | $X | $X | X% | Green/Yellow/Red |
| IT rationalization | CIO | $X | $X | $X | $X | $X | X% | Green/Yellow/Red |
| Cross-sell revenue | CSO | $X | $X | $X | $X | $X | X% | Green/Yellow/Red |
**Overall Synergy Achievement:**
- Total annual target: [$X]
- YTD actual: [$X]
- % of target: [X%]
- On track? [Yes / No - action plan if no]
---
## Lessons Learned & Continuous Improvement
**Post-Integration Review (12-18 Months Post-Close):**
**Questions to Address:**
1. Did we achieve the strategic objectives?
2. Did we realize the projected synergies?
3. What went well in the DD and integration process?
4. What would we do differently next time?
5. Were there any surprises we missed in DD?
6. How is the cultural integration progressing?
7. Have we retained key employees and customers?
8. What are the top 3 lessons learned?
**Capture Lessons Learned:**
- Update DD playbook and checklists
- Refine integration approach for future deals
- Share best practices across corporate development team
- Incorporate into M&A training
---
## Best Practices Summary
### Due Diligence
1. **Start early:** Begin DD planning before LOI if possible
2. **Use checklists:** Comprehensive, consistent, nothing falls through cracks
3. **External experts:** Bring in specialists for financial, legal, IT, environmental
4. **Customer validation:** Always interview top customers
5. **Conservative assumptions:** Risk-adjust projections and synergies
6. **Red flag process:** Escalate issues immediately, don't bury bad news
7. **Integration mindset:** Think about Day 1 and integration during DD
### Integration
1. **Speed matters:** Faster integration = faster synergy realization
2. **Communicate relentlessly:** Over-communicate during uncertainty
3. **Retain key talent:** Identify and lock up critical employees
4. **Quick wins:** Deliver early successes to build momentum
5. **Cultural integration:** Don't underestimate, address proactively
6. **Governance:** Clear decision rights, regular cadence, accountability
7. **Track synergies:** Monthly scorecards, ownership, course-correct quickly
### Common Pitfalls to Avoid
- Confirmation bias in DD (see what you want to see)
- Overpaying for "strategic" rationale without financial discipline
- Underestimating integration complexity and cost
- Neglecting cultural fit
- Losing key customers or employees during transition
- Over-synergizing (cutting too deep, hurting the business)
- Declaring victory too early (synergies take time to realize)
---
**Skill Maintenance:**
- Update checklists based on deal experience
- Incorporate regulatory changes (antitrust, tax, etc.)
- Refresh with recent M&A case studies
- Track industry best practices and emerging DD techniques