← 返回
数据分析 中文

Financial Due Diligence Analyzer

Performs detailed financial due diligence on deals by analyzing earnings quality, working capital, revenue, liabilities, cash flow, red flags, and valuation...
{"answer":"通过分析盈利质量、营运资金、收入、负债、现金流、警示信号及估值,对交易进行详细的财务尽职调查。"}
1kalin
数据分析 clawhub v1.0.0 1 版本 99816.8 Key: 无需
★ 3
Stars
📥 2,119
下载
💾 55
安装
1
版本
#acquisition#due diligence#ebitda#finance#latest#m&a#valuation

概述

Financial Due Diligence Analyzer

Run comprehensive financial due diligence on acquisition targets, investment opportunities, or partnership prospects. Built for PE firms, corporate development teams, and founders evaluating deals.

What This Does

Generates a complete due diligence package:

  • Quality of Earnings (QoE) — normalize EBITDA, strip one-time items, identify recurring vs non-recurring revenue
  • Working Capital Analysis — NWC trends, peg calculation, seasonal adjustments
  • Revenue Quality — customer concentration, churn, cohort analysis, contract backlog
  • Debt & Liabilities — hidden obligations, off-balance-sheet items, contingent liabilities
  • Cash Flow Bridge — EBITDA to free cash flow conversion, capex requirements
  • Red Flag Scanner — 23 common deal-killers ranked by severity

How to Use

Tell your agent: "Run financial due diligence on [company/deal]"

Provide what you have:

  • Financial statements (P&L, balance sheet, cash flow) — even partial
  • Revenue breakdown by customer/product
  • Known deal terms (purchase price, structure)

The agent will generate a structured diligence report with findings, risks, and negotiation points.

QoE Framework

EBITDA Normalization Checklist

Adjustment CategoryCommon ItemsDirection
---------
Owner compensationAbove/below market salary, personal expenses+/-
One-time revenuePPP loans, insurance claims, litigation settlements-
One-time expensesRestructuring, M&A costs, natural disaster+
Related partyAbove/below market rent, intercompany charges+/-
Accounting changesRevenue recognition timing, reserve adjustments+/-
Run-rate adjustmentsNew contracts, lost customers, price changes+/-

Revenue Quality Score (0-100)

FactorWeightScoring
---------
Recurring vs one-time25%>80% recurring = 25, >60% = 18, >40% = 12, <40% = 5
Customer concentration20%Top customer <10% = 20, <20% = 15, <30% = 10, >30% = 3
Retention rate20%>95% = 20, >90% = 15, >85% = 10, <85% = 5
Contract backlog15%>12mo coverage = 15, >6mo = 10, >3mo = 6, <3mo = 2
Growth trajectory10%>30% YoY = 10, >15% = 7, >5% = 4, declining = 1
Pricing power10%Annual increases + low churn = 10, some = 6, none = 2

Working Capital Peg

NWC Peg = Average of trailing 12 months normalized NWC

Normalized NWC = Current Assets (excl. cash) - Current Liabilities (excl. debt)

Adjustments:
- Remove seasonal spikes (use monthly data, not quarterly)
- Strip one-time receivables/payables
- Normalize inventory to steady-state
- Adjust for known post-close changes

If NWC at close > Peg → Seller receives difference
If NWC at close < Peg → Buyer receives difference

Red Flag Scanner (23 Points)

Critical (Deal-killers)

  1. Revenue concentration >40% single customer
  2. Declining revenue with no credible turnaround plan
  3. Negative or deteriorating cash conversion (EBITDA to FCF <50%)
  4. Undisclosed litigation or regulatory action
  5. Key person dependency with no succession plan
  6. Material related-party transactions at off-market terms
  7. Unrecorded liabilities (tax, environmental, legal)

Serious (Price adjustments)

  1. Customer churn accelerating quarter-over-quarter
  2. Gross margin compression >200bps annually
  3. Capex requirements understated (deferred maintenance)
  4. Working capital trends moving against buyer
  5. Aggressive revenue recognition policies
  6. Unusual pre-close transactions (dividends, bonuses)
  7. Technology debt requiring material investment
  8. Regulatory changes threatening core business model

Notable (Negotiation points)

  1. Management team retention risk
  2. Vendor concentration >30% single supplier
  3. IP ownership gaps or licensing dependencies
  4. Insurance coverage gaps
  5. Environmental liabilities (real estate)
  6. Employee benefit obligations (pension, OPEB)
  7. Tax position optimization opportunities
  8. Integration complexity indicators

Valuation Sanity Check

Quick Multiples Reference (2025-2026)

SectorEV/RevenueEV/EBITDANotes
------------
SaaS (<$10M ARR)4-8x15-25xHigher for >120% NRR
SaaS ($10-50M ARR)6-12x20-35xRule of 40 premium
Professional Services1-2x8-12xPeople-dependent discount
Manufacturing0.5-1.5x6-10xAsset-heavy adjustment
Healthcare Services1-3x10-15xRegulatory moat premium
Fintech5-15x20-40xWide range, growth-dependent
E-commerce1-3x10-18xBrand and margin quality

Purchase Price Allocation

Enterprise Value
- Net Debt (total debt - cash)
- Transaction Expenses
- Working Capital Adjustment (vs Peg)
+ Earnout (if applicable, risk-adjusted at 50-70% probability)
= Equity Value to Seller

Output Format

Your due diligence report should include:

  1. Executive Summary — deal overview, key findings, go/no-go recommendation
  2. Quality of Earnings — normalized EBITDA bridge with adjustments
  3. Revenue Analysis — quality score, concentration, trends
  4. Working Capital — NWC peg, seasonal analysis, close estimate
  5. Cash Flow — EBITDA to FCF bridge, capex analysis
  6. Red Flags — scored findings with severity and $ impact
  7. Valuation Check — multiples comparison, sanity test
  8. Negotiation Points — specific items for purchase agreement

Built by AfrexAI — AI context packs for business operations ($47 each).

More tools:

版本历史

共 1 个版本

  • v1.0.0 当前
    2026-03-29 00:27 安全

安全检测

腾讯云安全 (Keen)

安全,无风险
查看报告

腾讯云安全 (Sanbu)

suspicious
查看报告

🔗 相关推荐

data-analysis

A股量化 AkShare

mbpz
A股量化数据分析工具,基于AkShare库获取A股行情、财务数据、板块信息等。用于回答关于A股股票查询、行情数据、财务分析、选股等问题。
★ 165 📥 59,985
data-analysis

Data Analysis

ivangdavila
{"answer":"数据分析与可视化。查询数据库、生成报告、自动化电子表格,将原始数据转化为清晰可行的见解。适用于:(1) 您……"}
★ 198 📥 65,098
data-analysis

Excel / XLSX

ivangdavila
创建、检查和编辑 Microsoft Excel 工作簿及 XLSX 文件,支持可靠的公式、日期、类型、格式、重算及模板保留功能。
★ 368 📥 140,427