1---2name: analyze-qoe-reconciliation3task_id: corporate-ma/analyze-qoe-reconciliation4description: Guides line-by-line reconciliation of competing quality-of-earnings reports and a preliminary purchase price allocation, producing structured workbooks and a deal-team memo that quantifies the enterprise value impact of EBITDA differences.5activates_for: [planner, solver, checker]6metadata:7 source: https://skillmd.com/skills/finchipaiorg/analyze-qoe-reconciliation8---910# Skill: Analyze QoE Reconciliation and PPA1112## 1. Subject-matter triage13- Identify the source set first: both QoE reports, the purchase agreement definitions that govern EBITDA and working capital, closing schedules, and the preliminary PPA support.14- If a concept appears in only one source, flag it as a definitional mismatch rather than harmonizing it by assumption.15- If there is only one relevant party, period, or valuation scenario in scope, say so affirmatively before analyzing; if there are multiple, separate them and analyze each on its own row.16- Keep the work product transaction-focused: the goal is not a generic diligence summary, but a reconciliation that can be used to pressure-test purchase price, adjustment mechanics, and financial reporting allocation.1718## 2. Failure modes the skill is correcting19- Accepting one side’s EBITDA figure without reconciling the buyer’s and seller’s positions item by item and translating the difference into enterprise value impact.20- Collapsing distinct add-backs, normalization items, or accounting adjustments into a single “net adjustment” that obscures the economics.21- Treating working capital as a pure accounting exercise and missing how definitional choices change the post-closing adjustment.22- Carrying forward the preliminary PPA without checking whether changes in consideration, net assets, or assumptions flow through to goodwill and identifiable intangibles.23- Producing narrative notes without the supporting workbooks that let the deal team audit the math and trace each conclusion.24- Failing to distinguish supportable normalization from management preference, especially for owner compensation, non-recurring items, and technical accounting classifications.2526## 3. Legal frameworks / domain conventions that apply27- QoE reconciliation: reconcile disputed add-backs using the source documents, accounting conventions, and any available benchmarking support; do not treat either report as controlling without testing the underlying rationale.28- Owner compensation normalization: benchmark replacement compensation to a market rate for a comparable role at a similarly situated business, not to historical draws or distributions.29- Working capital peg: compare closing net working capital to the agreed target using the transaction’s defined methodology; test which balance-sheet items are included, excluded, or reclassified.30- Purchase price allocation: allocate consideration across identifiable intangible assets and goodwill consistent with business-combination accounting; assess customer relationships, technology, non-compete, trade names, backlog, or similar assets only if supportable on the record.31- Goodwill math: goodwill is the residual after fair value allocation to identifiable net assets; any adjustment to consideration or fair values must flow through the residual calculation.32- Evidence hierarchy: where the source set contains competing schedules or definitions, prioritize the transaction documents and reconciled schedules over narrative assertions.3334## 4. Analytical scaffolds35- Start by listing every disputed EBITDA item, working-capital line item, and PPA component as a separate row before drawing conclusions.36- For each disputed item, record: the buyer position, the seller position, the source support, the recommended position, and a short rationale tied to the documents.37- Close each issue with three moves: state the scale or economic size of the item from the source set, cross-reference the other provision or schedule it interacts with, and state the downstream consequence for price, adjustment, financing, or reporting.38- Where multiple periods, categories, or assumptions exist, analyze them one by one rather than using a representative sample.39- For EBITDA:40 - build a bridge from unadjusted EBITDA to recommended adjusted EBITDA;41 - isolate each add-back or subtraction;42 - compute the implied enterprise value under the agreed multiple for each competing position;43 - explain the value difference in transaction terms.44- For working capital:45 - reconcile each current asset and current liability category;46 - compare closing net working capital to the peg;47 - identify any definitional issue that changes the adjustment outcome.48- For PPA:49 - list each identifiable intangible asset category separately;50 - state the useful life and valuation premise for each category;51 - recompute goodwill after any correction to consideration or net asset values.52- Keep the recommended position explicit; do not leave disputed items unresolved or buried in prose.53- If the source set contains a governing definition or methodology, cite it by name and section in the workbook or memo so the reader can trace the conclusion.5455## 5. Vertical / structural / temporal relationships56- Treat the three workstreams as linked, not siloed: EBITDA reconciliation informs enterprise value, enterprise value affects consideration, and consideration feeds the PPA and goodwill.57- Check whether the working-capital adjustment or any other purchase-price adjustment changes the amount available for allocation in the PPA.58- If closing balance-sheet timing differs from the QoE reference period, note the temporal mismatch and explain whether it changes the comparison baseline.59- Preserve the sequence of effects: operating adjustments first, price mechanics second, accounting allocation third.60- When a conclusion depends on an earlier conclusion, make that dependency explicit rather than restating the same assumption in multiple places.6162## 6. Output structure conventions63- Produce the memo and three workbooks as separate, fully populated deliverables; do not substitute a summary for any workbook.64- The memo should open with the headline economic takeaway from the EBITDA reconciliation, then synthesize the working-capital and PPA implications.65- Cross-reference workbook tabs, rows, or line items for every material conclusion so the deal team can trace the source of each recommendation.66- Use conventional workbook tabs or sections for: EBITDA reconciliation, enterprise value bridge, working capital reconciliation, purchase price allocation, and goodwill sensitivity or roll-forward if needed.67- Each workbook row should be a self-contained analysis unit, with the disputed amount, the source positions, the recommended treatment, and the consequence.68- End the memo with an explicit Recommended Actions section that assigns an action, a responsible role, and a timing anchor tied to the deal timeline or closing process.69- Keep the writing operative and audit-ready: every conclusion should be traceable to a source document, a calculation, and a downstream effect.