---
name: due-diligence-financial
description: Conduct comprehensive financial due diligence for M&A transactions, investments, or partnerships. Use when evaluating acquisition targets, performing pre-investment analysis, reviewing target company financials, building due diligence checklists, analyzing financial red flags, assessing quality of earnings, or coordinating virtual data room reviews. Triggers on phrases like "financial due diligence", "FDD", "acquisition diligence", "target company review", "quality of earnings", "QoE", "virtual data room", "VDR", "M&A diligence", "pre-investment analysis".
---

# Financial Due Diligence

Execute thorough financial due diligence to validate target company financials, identify risks, and support informed M&A or investment decisions.

## Workflow

### Phase 1: Planning & Scoping

1. **Define DD scope and objectives**:
   ```
   DUE DILIGENCE SCOPE DOCUMENT
   ════════════════════════════════════════
   Transaction: [Buyer acquiring Target]
   Deal value: $X million
   Target industry: [Industry]
   Target size: Revenue $Y, EBITDA $Z
   
   Scope areas:
   □ Revenue quality and sustainability
   □ Cost structure and operating margins
   □ Working capital normalization
   □ Debt and contingent liabilities
   □ Tax position and exposures
   □ Related-party transactions
   □ Cap table and equity structure
   □ IT systems and data integrity
   □ ESG and compliance risks
   
   Timeline:
   → Kick-off: [date]
   → VDR access: [date]
   → Management presentations: [date]
   → Draft report: [date]
   → Final report: [date]
   → Deal close target: [date]
   
   Team:
   → Lead financial due diligence: [firm/team]
   → Tax due diligence: [team]
   → Legal due diligence: [team]
   → IT/technical due diligence: [team]
   ```

2. **Request data room setup and document list**:
   - Send standard request list to seller's advisors
   - Cover all material financial areas
   - Include custom items based on industry/transaction specifics

### Phase 2: Data Room Review

3. **Systematic VDR review**:
   ```
   VDR REVIEW CHECKLIST
   ════════════════════════════════════════
   
   FINANCIAL STATEMENTS:
   □ Historical income statements (3-5 years, monthly + annual)
   □ Historical balance sheets (3-5 years)
   □ Historical cash flow statements (3-5 years)
   □ Year-to-date financials (latest available)
   □ Segment reporting by product/geography
   □ Variance analysis and management commentary
   
   WORKING CAPITAL:
   □ AR aging report (detailed, current month)
   □ AP aging report
   □ Inventory roll-forward (if applicable)
   □ Unbilled receivables schedule
   □ Deferred revenue schedule
   □ Working capital bridge (prior year to current)
   
   REVENUE:
   □ Customer concentration (top 20 customers by revenue)
   □ Contract database (key terms, renewal dates)
   □ Revenue by product/service line
   □ Pricing schedules and discount history
   □ Recurring vs. non-recurring revenue breakdown
   
   COSTS & EXPENSES:
   □ Employee compensation report (headcount, salaries, bonuses)
   □ Top 20 vendor spend
   □ Lease inventory and obligations
   □ One-time/non-recurring expenses identified
   □ Benefit plan details (health, retirement, equity)
   
   CAPITAL STRUCTURE:
   □ Cap table (current and fully diluted)
   □ Debt schedule (all borrowings, terms, covenants)
   □ Equity agreements (options, warrants, preferred)
   □ Capital expenditures history and budget
   □ Dividend history and policy
   
   TAX:
   □ Tax returns (3-5 years, federal + state + international)
   □ Tax provision calculations
   ✓ Transfer pricing documentation
   □ Open tax audits or disputes
   □ NOL position and expiration schedule
   
   LEGAL & CONTINGENCIES:
   □ Litigation register
   □ Material contracts (customer, vendor, lease)
   □ Environmental liabilities
   □ Regulatory compliance status
   □ Employee disputes/claims
   ```

### Phase 3: Analysis

4. **Quality of Earnings (QoE) Analysis**:
   ```
   QUALITY OF EARNINGS ADJUSTMENTS
   ════════════════════════════════════════
   
   Reported EBITDA (LTM):              $10,000,000
   
   Add-backs (non-recurring/non-core):
     + One-time legal settlement:        $500,000
     + Founder salary above market:      $300,000
     + Related-party management fee:     $200,000
     + Non-recurring restructuring:      $150,000
     + Owner personal expenses:           $75,000
     + Non-operating income:             ($100,000)  [reduce]
     Total add-backs:                    $1,125,000
   
   Normalizations (market-rate):
     + Short-revenue (working capital):  $350,000
     + Deferred maintenance:              $100,000
     + Below-market leases (related):     $50,000
     Total normalizations:               $500,000
   
   Adjusted EBITDA:                    $11,625,000
   
   Quality assessment:
     → % Recurring: 92% (strong)
     → % Owner-dependent revenue: 8% (moderate risk)
     → Revenue concentration (top 5 customers): 45% (monitor)
     → EBITDA margin trend: Improving (12% → 15% → 18%)
   ```

5. **Working Capital Analysis**:
   ```
   WORKING CAPITAL NORMALIZATION
   ════════════════════════════════════════
   
   Current working capital:            $3,200,000
   
   Normalization adjustments:
     → AR: Add-back bad debt reserves for collectible accounts: $150,000
     → AR: Exclude unbilled receivables not in normal course: ($200,000)
     → Inventory: Remove slow-moving/obsolete inventory: ($180,000)
     → AP: Add short payables (invoices received post-close): $120,000
     → Deferred revenue: Treat as seller obligation (reduce): ($300,000)
   
   Normalized working capital:        $2,790,000
   
   Define target working capital for deal:
     → 12-month rolling average of normalized WC: $2,650,000
     → Or: X days of revenue benchmark
     → Seller brings WC to target at closing; buyer pays adjustments
   ```

6. **Revenue Quality Assessment**:
   - Contract analysis: recurring vs. one-time, renewal terms, termination rights
   - Customer concentration risk: top customer %, churn rates, NRR/GRR
   - Revenue recognition practices: compliance with ASC 606 / IFRS 15
   - Channel revenue quality: distributor load-and-churn, reseller relationships
   - SaaS metrics (if applicable): MRR, ARR, churn, expansion rate, CAC payback

7. **Liability and Contingency Review**:
   - Known and unknown liabilities
   - Litigation exposure (quantify probable outcomes)
   - Tax exposures (open audits, transfer pricing risks)
   - Environmental liabilities
   - Employee-related liabilities (unfunded pension, severance exposure)
   - Debt covenants and compliance status
   - Off-balance-sheet arrangements

### Phase 4: Management Interviews

8. **Conduct structured management presentations**:
   ```
   MANAGEMENT INTERVIEW AGENDA
   ════════════════════════════════════════
   
   CFO/Controller Presentation (2 hours):
     → Walk through historical financials and trends
     → Explain significant variances and one-time items
     → Discuss revenue streams and pricing strategy
     → Review cost structure and margin trends
     → Working capital trends and management practices
     → Capital structure and financing history
     → Open issues, risks, and forward outlook
   
   CEO/COO Presentation (1.5 hours):
     → Business model and competitive positioning
     → Customer relationships and concentration
     → Product roadmap and R&D pipeline
     → Key operational metrics
     → Growth strategy and investment plans
     → Organizational structure and key personnel
   
   Sales/Revenue Team (1 hour):
     → Sales process and pipeline
     → Customer acquisition and retention
     → Pricing strategy and discount patterns
     → Sales compensation structure
   
   Key questions to ask:
     → "What are the top 3 risks to the business?"
     → "What deals would you not close knowing what you know now?"
     → "What would you invest in first with new capital?"
     → "What keeps you up at night?"
   ```

### Phase 5: Reporting

9. **Draft due diligence report**:
   ```
   FINANCIAL DUE DILIGENCE SUMMARY REPORT
   ════════════════════════════════════════
   
   EXECUTIVE SUMMARY:
   Target: [Company Name]
   Deal value: $[X] million (implied [Y]x EBITDA multiple)
   Assessment: [PROCEED / PROCEED WITH CONDITIONS / RECONSIDER]
   
   KEY FINDINGS:
   
   ✓ Strengths:
     → Strong and improving EBITDA margins (12% → 18%)
     → Diversified customer base (no single customer >10%)
     → Recurring revenue: 78% of total
     → Clean balance sheet, manageable debt levels
   
   ⚠ Issues Identified:
     → Related-party transactions totaling $800K/year
        ■ Not at arm's length; normalize post-close
        ■ Impact: $200K EBITDA adjustment
     → Deferred maintenance on facilities: ~$150K
        ■ Capex investment needed within 12 months
     → Tax position: open audit for 2022-2023
        ■ Potential exposure: $300-500K (probable outcome: $200K)
        ■ Recommend: indemnification reserve
     → Key person dependency: founder drives 25% of revenue
        ■ Retention agreement recommended
        ■ Non-compete already in place (3 years)
   
   DEAL STRUCTURE RECOMMENDATIONS:
     → Purchase price adjustment: $X based on QoE adjustments
     → Working capital mechanism: true-up based on 12-month avg
     → Indemnities: tax exposures, litigation, related-party transactions
     → Escrow: 15% of price for 18 months
     → Retention agreements: key employees (CFO, founder, top 3 customers)
   
   RED FLAGS:
     □ None identified that would stop the deal
     □ All issues quantifiable and manageable through deal terms
   ```

## Key Risk Categories

```
DUE DILIGENCE RISK MATRIX
═══════════════════════════════════════

HIGH IMPACT:
  → Revenue quality issues (aggressive recognition, fake revenue)
  → Hidden liabilities (contingent, environmental, tax)
  → Customer concentration / churn risk
  → Key person dependency
  → Regulatory compliance failures
  → Fraud indicators

MEDIUM IMPACT:
  → Working capital normalization adjustments
  → Related-party transactions
  → Deferred maintenance capex needs
  → Tax exposures from open audits
  → IT system limitations
  → Cultural misalignment (for integrations)

LOW IMPACT:
  → Minor accounting policy differences
  → Below-market executive compensation
  → Incomplete financial reporting history
  → Non-material contract issues
```

## Red Flags to Watch

```
IMMEDIATE RED FLAGS (Deal-Breaking Potential)
═══════════════════════════════════════

Financial:
  → Revenue decline >10% YoY without strategic explanation
  → Negative free cash flow despite reported profitability
  → Unexplained working capital increases
  → High accounts payable aging (>30% past 60 days)
  → Frequent restatements or accounting changes
  → Off-balance-sheet financing

Operational:
  → Losing largest customers with no pipeline replacement
  → Key employee exodus or high turnover
  → Technology debt / legacy systems at breaking point
  → Regulatory enforcement actions pending
  → Supply chain dependency on single vendor

Legal/Compliance:
  → Material litigation with probable loss >10% of deal value
  → Material tax exposure unresolved
  → Intellectual property disputes
  → Data security breaches
  → Environmental liabilities
```

## Integration Points

- **Virtual Data Rooms**: Intralinks, Firmex, Datasite, Ansar
- **ERP Systems**: SAP, Oracle, NetSuite (target financial data)
- **CRM**: Salesforce, HubSpot (pipeline, customer data)
- **Document Management**: SharePoint, Google Drive
- **Analytics Tools**: Excel, Alteryx, Tableau
- **Project Management**: Asana, Monday.com (DD tracking)
- **Communication**: Zoom, Teams (management presentations)

## Edge Cases

- **Distressed acquisitions**: Focus on liquidation value, asset quality, creditor hierarchy; stress-test assumptions
- **Cross-border deals**: Add currency risk, transfer pricing, tax structure optimization, regulatory approvals
- **SPAC mergers**: Emphasize pro forma compliance, PIPE terms, redemption risk, lock-up analysis
- **Early-stage startups**: Focus on unit economics, burn rate, runway, cap table, investor rights; limited historical financials
- **Asset vs stock purchase**: Different DD emphasis (asset = individual asset/liability review; stock = full entity review)
- **Reverse due diligence**: Understand if target is conducting DD on buyer (competitive intelligence risk, financing certainty)

## Output

### Due Diligence Deliverables Package

```
DELIVERABLES CHECKLIST
═══════════════════════════════════════

1. Quality of Earnings Report (detailed)
2. Net Working Capital Analysis
3. Capital Expenditure Review
4. Debt and Capital Structure Memo
5. Tax Due Diligence Summary
6. Identified Issues Memo (with quantification)
7. Management Interview Notes and Observations
8. Financial Projections Assessment (vs historical trends)
9. Deal Structure Recommendations
10. Integration Planning Brief (synergies, day-1 actions)

Supporting:
  → Detailed financial models (bridges, normalizations)
  → Customer and revenue analytics
  → Working capital normalization workbook
  → Liability matrix
  → Risk register with mitigation recommendations
```