Financial Due Diligence (QoE)

A scoped request list, an EBITDA bridge you can defend, a working capital peg, a net debt schedule and a findings log that turns every diligence issue into a price, structure or protection decision.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Financial Due Diligence (QoE), and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help your team organise its work. It is not financial, investment, tax, accounting or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with qualified, licensed advisers in the countries concerned. Investing can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

201

Starter tasks

💹 Private Equity & Venture Capital

Financial Due Diligence (QoE)

Running financial diligence on a target: quality of earnings, normalised EBITDA, the working capital peg, net debt items and how findings change the price.

  1. Financial diligence scope and request list
  2. Data room index and document tracker
  3. Three-year monthly historical financial pack
  4. Management accounts to audited accounts reconciliation
  5. Choosing and scoping the QoE provider
  6. QoE engagement letter and scope sign-off
  7. EBITDA bridge from reported to pro forma
  8. Materiality threshold and findings log
  9. Diligence workplan against the exclusivity period
  10. Weekly QoE adviser status call
  11. Open items triage during fieldwork
  12. Diligence question log with management
  13. Findings to model hand-off routine
  14. Current trading review during exclusivity
  15. Personal library of QoE adjustments
  16. Diligence findings versus actual results review
  17. Financial diligence checklist upkeep
  18. QoE adviser panel scorecard
  19. Reading a quality of earnings report critically
  20. Normalised EBITDA adjustments that hold up
  21. Revenue quality and cut-off analysis
  22. Proof of cash and bank reconciliation testing
  23. Net working capital analysis and seasonality
  24. Net debt and debt-like items schedule
  25. Gross margin analysis by product and customer
  26. Cash conversion and maintenance capex review
  27. Accounting policies and GAAP differences review
  28. Setting the working capital peg
  29. Turning findings into a price adjustment
  30. Locked box or completion accounts choice
  31. Run-rate and pro forma adjustments review
  32. Findings routed to purchase agreement protections
  33. Red flag or full scope diligence decision
  34. Buy-side review of a vendor QoE
  35. CFO walkthrough of the management accounts
  36. QoE draft report readout session
  37. Financial diligence summary for the deal team
  38. Bring-down review before signing
  39. Completion accounts and peg true-up
  40. First financial diligence as a new associate
  41. Diligence on cash-basis and owner-run books
  42. Carve-out standalone cost analysis
  43. Financial diligence on a loss-making or stretched target
  44. Cross-border target with local GAAP and currency
  45. Lean diligence on a small deal budget
  46. Subscription revenue and cohort analysis
  47. Inventory valuation and provisioning review
  48. Payroll, headcount and accrual testing
  49. Coordinating tax diligence with financial findings
  50. Forensic red flags and when to escalate

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Financial diligence scope and request list

Most diligence overruns start with a request list copied from the last deal, which asks for forty things the target does not have and misses the three that matter. A scope written around this deal's thesis and its likely weak points, turned into a numbered request list, tells management what to prepare and tells advisers what to price.

First tasks

  • Write the five questions the financial diligence must answer for this deal
  • Draft the request list by area, starting from monthly accounts for three years
  • Mark each request essential or nice to have
  • Send the list to the target's finance lead with a requested return date

Data room index and document tracker

Data rooms fill up in bursts, files get renamed and replaced, and a week into fieldwork nobody knows which version of the debtor ledger the adviser used. A tracker that maps every request number to the document that answers it, with the upload date and version, keeps the team and the advisers working from the same files.

First tasks

  • Export the current data room index into a spreadsheet
  • Match each request number to the file that answers it
  • Flag every request that still has no document
  • Mark superseded files and note which version the adviser is using @recurring(weekly:thu)

Three-year monthly historical financial pack

Every later piece of diligence, from the EBITDA bridge to the working capital peg, is built on the same monthly profit and loss, balance sheet and cash flow. Assembling three years plus the latest trailing twelve months in one consistent layout, before any adjustments, gives the team a single starting point everyone can tie back to.

First tasks

  • Load the raw monthly trial balances onto a separate untouched tab
  • Associate maps the target's chart of accounts to the fund's standard layout
  • Build the trailing twelve months column for each line
  • Tie each month's totals back to the management accounts

Make it yours.

Install Financial Due Diligence (QoE), then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.