Project Overview
When a company acquires another, GAAP requires a Purchase Price Allocation (PPA) under ASC 805: every identifiable intangible asset must be measured at fair value on the acquisition date. This model implements two standard appraisal methods — the Multi-Period Excess Earnings Method (MPEEM) for customer relationships and the Relief-from-Royalty (RfR) method for technology and trade names — computing amortizable fair values for each intangible asset and reconciling to total goodwill.
📋Problem Statement
After an acquisition closes, the acquirer must allocate the purchase price across all identifiable assets and liabilities at fair value — and separately value each intangible asset. Failure to do this correctly results in audit findings and restatements.
🎯Analytical Approach
Applied two GAAP-required appraisal methods: (1) MPEEM for customer relationships — projects the future cash flows attributable specifically to the acquired customer base, net of contributory asset charges, discounted to PV; (2) RfR for technology and trade name — estimates the royalty payments the company would owe if it had to license the IP from a third party, capitalized to a fair value.
💾Data Sources
Acquired company historical and projected revenues, customer attrition rates, operating margins, contributory asset charges (on working capital, fixed assets, workforce), appropriate discount rates, and market royalty rates for comparable technologies and brand names.
🔧Quantitative Methods
MPEEM: [Revenue × gross margin − contributory charges] discounted at WACC + risk premium. RfR: [Revenue × royalty rate × (1 − tax)] discounted at discount rate. Both methods compute fair value as present value of post-tax cash flows. Goodwill = purchase price − sum of all identified net assets at fair value.
✨Key Results
Fair value allocations for each intangible asset with supporting amortization periods, total identifiable intangibles value, and residual goodwill calculation. The model produces an output table directly usable in the acquisition journal entry and the financial statement footnote disclosure.
🧠Key Learnings
ASC 805 analysis sits at the intersection of accounting, valuation, and deal economics. Understanding how intangibles are valued (and how goodwill is measured as the residual) gives analysts critical insight into deal quality — high goodwill relative to identifiable intangibles often signals an acquirer overpaying for synergies that may never materialize.