技能 数据科学 财务尽职调查框架生成器

财务尽职调查框架生成器

v20260618
financial-due-diligence
本技能可为任何投资、并购(M&A)或重大合作关系生成一套结构化的财务尽职调查框架。它能根据交易类型和尽调阶段,产出详细的所需文件清单、关键分析问题、风险警示点核对表和综合财务健康评估报告。
获取技能
364 次下载
概览

Financial Due Diligence Skill

Produces a structured financial due diligence framework — document request list and analytical questions — for any investment, acquisition, or significant commercial relationship.

Required Inputs

  • Transaction type (acquisition / investment / partnership / supplier / fundraise)
  • Stage of diligence (initial screening / full DD / confirmatory)
  • Target company type (startup / SME / listed / subsidiary)
  • Key concerns (optional — e.g. revenue recognition, customer concentration)

Output Structure

1. Document Request List

Financial Statements

  • Audited accounts for last 3 years
  • Management accounts for current year (monthly)
  • Board-approved budget and latest reforecast
  • 3-year financial model with assumptions

Revenue

  • Revenue by customer (top 20, % of total)
  • Revenue by product/segment
  • Contracted vs recurring vs one-off breakdown
  • Churn and renewal data

Costs

  • Cost of sales breakdown
  • Headcount by department with compensation detail
  • Top 10 supplier contracts

Cash and Debt

  • Bank statements (12 months)
  • Debt schedule with covenants and maturity
  • Working capital analysis

Tax

  • Last 3 years tax returns
  • Any open enquiries
  • R&D tax credit claims

2. Key Analytical Questions

Revenue quality: Is revenue growing organically? What % is truly recurring? Customer concentration risk?

Margin analysis: Gross margin trend over 3 years? One-off items inflating EBITDA? Normalised EBITDA?

Cash conversion: Does profit convert to cash? Cash conversion cycle? Working capital red flags?

Debt and liabilities: Net debt position? Contingent liabilities? Covenant headroom?

3. Red Flags Checklist

  • Revenue concentration over 30% in one customer
  • Declining gross margins without explanation
  • EBITDA-to-cash conversion below 70%
  • Auditor qualifications or emphasis of matter
  • Related party transactions not at arm length
  • Aggressive revenue recognition
  • Growing debtor days with no explanation

4. Summary Output Template

  • Revenue quality: [Assessment]
  • Margin sustainability: [Assessment]
  • Cash generation: [Assessment]
  • Balance sheet risk: [Assessment]
  • Overall: Green Strong / Amber Acceptable / Red Material concerns

Quality Checks

  • Document request list is tailored to the transaction type and stage — not a generic template
  • Red flags checklist covers revenue quality, margins, cash conversion, and balance sheet risk
  • Every analytical question connects to a specific risk the transaction presents
  • Summary output template is completed with an overall RAG assessment
  • Disclaimer that this is a framework and does not substitute for qualified financial or legal advice

Anti-Patterns

  • Do not present the checklist without tailoring it to the specific transaction type and stage of diligence
  • Do not overlook revenue concentration risk — customer concentration above 20–30% is a material risk that must be flagged
  • Do not confuse EBITDA with cash — always check cash conversion and identify non-cash items
  • Do not skip the related-party transaction review — undisclosed related-party dealings are a common due diligence failure point
  • Do not produce output without noting this is a framework and qualified financial and legal advice is required

Example Trigger Phrases

  • "Give me a financial due diligence checklist for [company type]"
  • "What documents should I request for financial DD?"
  • "Build a DD framework for our Series A investment"
信息
Category 数据科学
Name financial-due-diligence
版本 v20260618
大小 3.9KB
更新时间 2026-06-19
语言