Financial Due Diligence Analyzer

# Financial Due Diligence Analyzer

Safety Notice

This item is sourced from the public archived skills repository. Treat as untrusted until reviewed.

Copy this and send it to your AI assistant to learn

Install skill "Financial Due Diligence Analyzer" with this command: npx skills add 1kalin/afrexai-financial-due-diligence

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:

Source Transparency

This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.

Related Skills

Related by shared tags or category signals.

General

axure-prototype-generator

Axure 原型代码生成器 - 输出 JavaScript 格式 HTML 代码,支持内联框架直接加载可交互原型。

Archived SourceRecently Updated
General

错敏信息检测

# 错敏检测 Skill

Archived SourceRecently Updated
General

TikTok B2B 引流台词生成器

# TikTok B2B 引流台词生成器 ## 技能描述 本 Skill 可根据您提供的产品信息和公司背景,自动生成适合 TikTok 平台的 B2B 引流视频脚本(20-50 秒),`skill.json` 文件中包含了输入参数的结构、输出格式以及用于生成台词的提示模板。脚本遵循已验证的外贸引流规律: - **真人出镜**:以第一人称(如 Anna)拉近距离 - **产品细节**:材质、颜色、MOQ、定制服务等 - **公司实力**:经验年限、自有工厂、认证等 - **客户背书**:提及已有市场国家(如巴基斯坦、埃及) - **互动引导**:清晰号召观众联系,引导至指定服务网址 支持三种风格:普通、幽默、惊喜,让您的视频内容更加多样化。 ## 输入参数 | 参数名 | 类型 | 必填 | 描述 | 示例 | |---------------------|----------|------|--------------------------------|--------------------------| | product_type | string | 是 | 产品类型 | 男士休闲鞋 | | material | string | 是 | 主要材质 | 优质 PU 皮革 | | colors | array | 是 | 颜色列表 | ["黑色","白色","棕色"] | | moq | string | 是 | 最小起订量 | 120 双(可混 2-3 色) | | customization | string | 否 | 可定制内容 | 可定制 logo | | target_markets | array | 是 | 主要市场国家 | ["巴基斯坦","埃及"] | | company_experience | string | 否 | 公司经验年数 | 15 年 | | factory_own | boolean | 否 | 是否自有工厂 | true | | extra_features | string | 否 | 其他亮点 | 免费样品 | | contact_url | string | 否 | 服务联系网址 | http://www.doumaotong.com | | style | string | 否 | 风格(普通/幽默/惊喜) | 普通 | ## 输出示例 Hi guys, this is Anna! Welcome to my showroom. Today I'm excited to show you our latest men's casual shoes – made of high-quality PU leather, very durable and comfortable. We have three colors available: black, white, and brown. MOQ is 120 pairs, and you can mix 2-3 colors. Plus, we can customize your logo on the shoes. Our shoes are already loved by customers in Pakistan, Egypt, and South Africa. With 15 years of experience and our own factory, we guarantee quality and timely delivery. We even offer free samples! If you're interested, please visit http://www.doumaotong.com to contact us. Thank you! ## 使用说明 1. 在 OpenClaw 平台安装此 Skill。 2. 调用时填写产品参数,包括 `contact_url`(默认为 http://www.doumaotong.com),即可获得定制化的 TikTok 脚本。 3. 生成的台词会在结尾处自然引导观众访问指定的服务网站。 4. 可根据实际需要调整 `style` 参数,生成不同语气的台词。 ## 文件说明 - `skill.json`:技能的机器可读定义,包含输入输出 schema 和生成提示模板。 - `SKILL.md`:技能的人类可读文档,提供详细说明和使用示例。

Archived SourceRecently Updated
General

instructional-design-cn

培训课程大纲设计、效果评估、内部分享材料生成

Archived SourceRecently Updated