Finance and deals

Diligence Data Analysis

The transaction-level data of the target analyzed for the deal team or the accounting firm running diligence: revenue quality, customer cohorts and concentration, margin by product, working capital patterns.

Price
From $7,500
Duration
Two to three weeks
Part of
Financial Analysis and Modeling
  • Deal teams with a data room full of transaction-level data and no time to analyze it.
  • Accounting firms running quality of earnings work who want the data analysis done in code that can be rerun.
  • Lenders checking a borrower's revenue, customers and margins before a facility.
  • Reproducible analysis: the code and the queries are delivered with the results
  • Data room index and a list of what is missing
  • Red-flag memo with the supporting tables

Supports a quality of earnings report and is not one. The report of record stays with your CPA firm.

Two to three weeks, in steps

  1. Days 1 to 3: the data

    A data room index, the data loaded and reconciled to the reported totals, and the list of what is missing.

  2. Week 2: the analysis

    Revenue quality, customer cohorts and concentration, margin by product, and working capital patterns.

  3. Week 3: the memo

    The red-flag memo with its supporting tables, and the code and queries handed over. Smaller data sets finish in two weeks.

  • Data room access or exports: invoices or orders, customer lists, general ledger detail.
  • The questions the deal team must answer, ranked.
  • A contact on the deal team for questions about the data.

Scope, price and dates are confirmed in writing before the work starts. You own what is delivered. A complete example is published: the sample deliverable.

Ask about this package

About the Diligence Data Analysis

Does this replace a quality of earnings report?

No. It supports one. The report of record stays with your CPA firm.

What if the data does not reconcile to the reported figures?

Then that is the first finding. Every table is reconciled to the reported totals before any analysis, and the differences are listed.

What do we receive besides the memo?

The code and the queries, so the analysis can be rerun when the seller sends updated data.

From $7,500, two to three weeks. Scope confirmed in writing first.

Tell us your situation and when you need the result. A reply comes within one business day, from the person who would do the work.