lev-os Modeling Purchase Price Allocation
Structures PPA analysis with tangible/intangible asset identification, useful life estimation, and goodwill calculation.
When To Use
- Modeling purchase accounting for a completed or contemplated acquisition under ASC 805 / IFRS 3 [VERIFY: applicable standard based on reporting framework]
- Allocating total deal consideration (cash, stock, earnouts, assumed liabilities) across acquired tangible and intangible assets
- Estimating post-close amortization impact on pro forma earnings and accretion/dilution analysis
- Preparing preliminary PPA for board books, fairness opinions, or integration planning
- Stress-testing goodwill levels to assess impairment risk under various purchase price scenarios
Inputs To Gather
- Total consideration: Cash at close, stock component (exchange ratio, share price, shares issued), deferred consideration, earnout terms and estimated fair value, assumed debt
- Target balance sheet: Most recent audited or management-prepared balance sheet with asset and liability line items at book value
- Tangible asset detail: PP&E schedules, real estate appraisals, inventory breakdown (raw/WIP/finished), lease schedules
- Intangible asset identification: Customer lists and churn data, technology/IP descriptions, brand/trade name revenue attribution, in-process R&D status, non-compete agreements, favorable/unfavorable contracts
- Valuation inputs: Discount rates (WACC, IRR of transaction), royalty rates for relief-from-royalty method, attrition/decay rates for customer relationships, revenue/cost projections for MEEM analysis, comparable transaction multiples
- Tax information: Applicable tax rate, whether transaction is asset vs. stock deal [VERIFY: Section 338(h)(10) election status], deferred tax liability/asset implications of step-up
Workflow
Calculate total consideration
- Sum cash, fair value of equity issued (shares x price), present value of deferred payments, estimated fair value of contingent consideration (earnouts), and net assumed liabilities
- Identify and separate transaction costs (not part of consideration under ASC 805)
Mark tangible assets to fair value
- Revalue PP&E from book to appraised fair value; note step-up or step-down
- Revalue inventory: finished goods to selling price less costs to sell and reasonable profit on selling effort; raw materials to replacement cost
- Adjust other balance sheet items (receivables to collectible value, debt to market value)
Identify and value intangible assets
- Customer relationships: Multi-period excess earnings method (MEEM) — project revenue, subtract contributory asset charges, discount at appropriate rate; assign useful life based on attrition curve
- Technology / IP: Relief-from-royalty method — apply market royalty rate to projected revenue, tax-effect, discount to present value; or cost-to-recreate approach for proprietary systems
- Trade names / brands: Relief-from-royalty with brand-specific royalty rate; determine definite vs. indefinite life [VERIFY: indefinite-life treatment requires annual impairment testing]
- In-process R&D: Estimate probability-weighted completion cost and post-launch cash flows; indefinite-life until project completes or is abandoned
- Non-compete agreements: With-and-without method — model cash flows with and without the agreement, discount the difference
- Favorable/unfavorable contracts: Present value of above- or below-market terms over remaining contract life
Calculate deferred tax impact
- Compute DTL on book-tax basis differences created by asset step-ups (fair value less tax basis x tax rate)
- DTL itself reduces net identifiable assets, which increases residual goodwill — solve iteratively or use gross-up formula: Goodwill = (Consideration - Net FV tangible - Intangibles + DTL) where DTL = (Intangible step-up) x tax rate / (1 - tax rate) for the circular component [VERIFY: confirm gross-up formula applicability with tax advisor]
Derive goodwill
- Goodwill = Total consideration - Fair value of net identifiable tangible assets - Fair value of identified intangible assets + Net deferred tax liability on step-ups
- Benchmark goodwill as a percentage of total consideration against comparable transactions; flag if outlier (typically 30-60% for asset-light targets, lower for asset-heavy)
Build amortization schedule
- Assign useful lives to each definite-life intangible (customer relationships: 8-15 yrs; technology: 3-7 yrs; trade names: 10-20 yrs or indefinite; non-competes: contract term) [VERIFY: useful life estimates against industry norms and valuation specialist guidance]
- Model straight-line or accelerated amortization as appropriate
- Calculate annual pre-tax amortization expense and after-tax EPS impact for accretion/dilution model
Sensitivity and scenario analysis
- Vary purchase price +/- 10-20% and show impact on goodwill and annual amortization
- Test key valuation assumptions: royalty rates +/- 1%, discount rates +/- 100 bps, attrition rates +/- 2%
- Model goodwill impairment trigger scenarios (revenue decline thresholds where reporting unit FV falls below carrying value)
Output
- PPA summary table: Total consideration breakdown, fair value of each asset/liability class, identified intangibles with valuation method and useful life, residual goodwill
- Intangible asset detail: One tab/section per intangible with valuation methodology, key assumptions, and sensitivity ranges
- Amortization schedule: Year-by-year amortization by intangible asset with totals, pre-tax and after-tax
- Goodwill analysis: Goodwill as % of deal value, benchmarked against precedent transactions, impairment scenario summary
- Assumption log: Every material assumption tagged with source (management, third-party appraisal, comparable data, or [VERIFY] if unconfirmed)
Quality Checks
- Total consideration components reconcile to signed purchase agreement or LOI terms
- Sum of allocated values (tangible FV + intangible FV + goodwill - DTL) ties back to total consideration with zero residual
- Intangible asset useful lives are consistent with valuation methodology decay/attrition assumptions
- Discount rates used for intangible valuations are internally consistent (weighted average return on assets reconciles to transaction IRR)
- Goodwill percentage is reasonable relative to comparable M&A transactions in the sector
- Amortization schedule correctly flows into pro forma income statement and accretion/dilution analysis
- All tax rate assumptions and asset/stock deal structure implications are flagged for tax advisor confirmation [VERIFY]
- No intangible asset is double-counted (e.g., customer relationships and favorable contracts from the same customer base)