Purchase Price Allocation in Excel: ASC 805 M&A Guide (2026)

July 27, 2026 · VeloraAI Team
Financial Modeling Formulas Data Analysis

When Microsoft closed the $75.4 billion Activision Blizzard deal in 2023, roughly $51 billion of the purchase price landed on the balance sheet as goodwill and another $22 billion as identifiable intangibles — customer contracts, developed technology, and trade names carved out of the residual. That split was not a guess. It was the output of a purchase price allocation exercise run in Excel by a valuation team over several months, tested by auditors, and reported to the SEC on the first 10-Q after close. The mechanics matter: every dollar allocated to an amortizing intangible reduces future GAAP earnings, and every dollar of goodwill sits on the balance sheet at risk of an impairment charge in the next downturn.

This guide walks through building a purchase price allocation in Excel from scratch under ASC 805 (Business Combinations) — from the opening balance sheet fair-value uplift, through the identification and valuation of each intangible asset, to the deferred tax gross-up and the goodwill plug that lands the whole thing on your combined balance sheet.

What Is a Purchase Price Allocation?

A purchase price allocation (PPA) is the accounting exercise required whenever one company acquires another. The buyer must allocate the total consideration transferred — cash, stock, contingent consideration, and assumed debt — to each identifiable asset acquired and liability assumed at fair value on the acquisition date. Anything left over becomes goodwill.

The output is a single opening balance sheet for the acquired business, restated at fair value, that feeds directly into the combined entity's consolidated balance sheet on Day 1 of ownership. Under US GAAP (ASC 805) the framework is called the acquisition method; under IFRS 3 it is nearly identical, with a handful of practical differences around bargain purchases and non-controlling interests.

The three levers that shape every PPA are:

  1. Fair value of consideration transferred — cash paid, buyer stock issued, contingent consideration, and effective settlement of pre-existing relationships.
  2. Fair value of net identifiable assets — every asset and liability, tangible and intangible, marked to fair value.
  3. Goodwill — the residual plug that balances the equation.

ℹ️ Note: Goodwill is not amortized under US GAAP after ASC 350's 2001 overhaul. It sits on the balance sheet indefinitely, tested annually for impairment. Identifiable intangibles with finite lives, however, amortize through the income statement — which is why the split between "intangible" and "goodwill" is the single most consequential judgment in a PPA.

When Is a Purchase Price Allocation Required?

Any transaction that meets the ASC 805 definition of a business combination triggers a full PPA. Asset acquisitions — where the acquired set of activities does not meet the definition of a business — follow a simpler cost-allocation model without goodwill. The FASB's 2017 "screen test" (ASU 2017-01) made it easier to conclude an acquisition is an asset deal, which matters because asset deals are cheaper and faster to close from an accounting perspective.

A PPA is required when:

  • A public company acquires another entity that meets the definition of a business
  • A private company acquires a business and does not elect the private company alternatives for goodwill and certain intangibles
  • A carve-out or spin-off is treated as a business combination by the receiving entity
  • Contingent consideration or step acquisitions require remeasurement of prior interests

Most SEC registrants file a preliminary PPA in the first 10-Q after close and finalize it within the ASC 805 measurement period — up to one year from the acquisition date — as valuations, working capital true-ups, and tax positions get refined.

The Six-Step Purchase Price Allocation Process

Every PPA in Excel follows the same six-step process. The complexity is in step 4 — identifying and valuing intangible assets — but the surrounding mechanics matter just as much for tying the numbers back to the combined balance sheet.

graph TD
    A[1. Determine Consideration Transferred] --> B[2. Book Target at Historical Values]
    B --> C[3. Mark Tangible Assets and Liabilities to Fair Value]
    C --> D[4. Identify and Value Intangible Assets]
    D --> E[5. Calculate Deferred Tax on Fair Value Step-Ups]
    E --> F[6. Solve for Goodwill as the Residual]
    F --> G[Combined Opening Balance Sheet]

Step 1 — Determine consideration transferred

Consideration is the sum of everything the buyer gives up. In an Excel model, group each component on its own row so the audit trail is transparent.

Component How to measure Common source
Cash Face amount Wire transfer at close
Buyer stock issued Buyer share price × shares issued at acquisition date Merger agreement, exchange ratio
Contingent consideration (earnout) Fair value at acquisition date (Monte Carlo or PWERM) Valuation report
Replacement equity awards Fair value attributable to pre-combination service Option pricing model
Assumed debt Fair value, typically discounted at market yield Trading price or comparable spreads
Settlement of pre-existing relationships Fair value less any refund due Contract review 
Consideration_Transferred =
    Cash_Paid
  + Shares_Issued * Buyer_Share_Price_Close
  + Fair_Value_Earnout
  + Pre_Combination_Replacement_Awards
  + Assumed_Debt_FV
  - Effective_Settlement_Credits

⚠️ Warning: Transaction costs — banker fees, legal fees, diligence costs — are not part of consideration under ASC 805. They are expensed as incurred. Under IFRS 3 the treatment is identical. Rolling them into the purchase price is one of the most common junior-analyst errors and it inflates goodwill directly.

Step 2 — Book the target at historical carrying values

Pull the target's most recent balance sheet at the acquisition date (or the closest cut-off available) and load it as the starting point. This becomes the "before" column in your PPA schedule.

Step 3 — Mark tangible assets and liabilities to fair value

Every asset and liability that will remain on the combined balance sheet needs a fair value adjustment. Common items include:

  • Inventory — stepped up to selling price less cost to complete and a reasonable selling-effort margin. This creates a one-time cost-of-goods hit as the stepped-up inventory turns.
  • Property, plant, and equipment — appraised at market, often by a specialist. Depreciation resets over remaining useful life.
  • Long-term debt — remeasured at current market yield. An acquired 8% coupon bond in a 5% rate environment shows a premium on the buyer's books.
  • Deferred revenue — written down to the cost of fulfilling the obligation plus a normal profit margin (the "Vitas" adjustment familiar to SaaS acquirers).
  • Uncertain tax positions — remeasured to reflect the acquirer's assessment.

Structure the schedule with one row per line item and three columns: Historical, Fair Value Adjustment, and Fair Value. This lets an auditor tie every adjustment back to a source valuation.

How Do You Identify Intangible Assets in a Purchase Price Allocation?

Under ASC 805, an intangible asset must be recognized separately from goodwill if it is either separable (can be sold, transferred, or licensed on its own) or arises from contractual or legal rights. The FASB provides an illustrative list, and in practice the same five families show up in almost every deal.

The single-paragraph rule of thumb: if a market participant would pay for it separately, or if it is enforceable by a contract, it is an intangible asset and must be broken out of goodwill.

Intangible category Examples Typical valuation method Common useful life
Marketing-related Trademarks, trade names, internet domain names Relief-from-royalty 5–20 years or indefinite
Customer-related Customer contracts, customer relationships, order backlog Multi-period excess earnings (MPEEM) 3–15 years
Contract-based Licensing agreements, franchise agreements, employment contracts Discounted cash flow Contract term
Technology-based Patented technology, unpatented technology, in-process R&D Relief-from-royalty or MPEEM 3–10 years
Artistic-related Copyrighted material, plays, film libraries Discounted cash flow Legal life

The assembled workforce — the value of hiring a trained team versus building one from scratch — is explicitly not recognized as a separate intangible under ASC 805. It gets subsumed into goodwill. Same for internally generated goodwill of the target and any synergies expected from the combination.

Non-competition agreements are their own line item

If the founders sign a non-compete at closing, its fair value is a separate intangible asset — valued as the differential cash flow to the buyer between "founder competes" and "founder does not compete" scenarios, probability-weighted. It typically amortizes over the non-compete period.

How Do You Value Intangible Assets in a PPA?

Three valuation approaches — income, market, and cost — cover every intangible you will encounter. The income approach dominates in practice because most intangibles generate identifiable cash flows. Market comparables are used sparingly, mostly for trade names of consumer brands. The cost approach is a floor, used for internal-use software and workforce-related items.

The three income-approach techniques a valuation team will actually run in Excel are the Multi-Period Excess Earnings Method (MPEEM), the Relief-from-Royalty Method, and the With-and-Without Method.

Multi-Period Excess Earnings Method (MPEEM) for customer relationships

MPEEM is the workhorse for customer relationships. It isolates the cash flow attributable to the existing customer base, then subtracts a contributory asset charge (CAC) — a fair-return rent paid to every other asset that helps generate that cash flow (working capital, PP&E, workforce, brand).

The projection engine looks like this in Excel:

Revenue_from_Existing_Customers = Base_Revenue * (1 - Attrition_Rate) ^ Year
Contribution_Margin = Revenue_from_Existing_Customers * EBITDA_Margin
Contributory_Asset_Charges =
      Working_Capital_Charge
    + Fixed_Asset_Charge
    + Workforce_Charge
    + Brand_Charge
Post_Tax_Cash_Flow = (Contribution_Margin - CAC) * (1 - Tax_Rate)
Discounted_CF = Post_Tax_Cash_Flow / (1 + WACC) ^ Year

Sum the discounted cash flows over the customer relationship's useful life, then add the tax amortization benefit (TAB) — the present value of the tax shield the buyer will get from amortizing the asset. The TAB can add 15–25% to the fair value depending on the tax rate and useful life.

TAB_Factor = 1 / (1 - (Tax_Rate * PV_Annuity(WACC, Useful_Life) / Useful_Life))
Fair_Value_Customer_Relationships = Sum_Discounted_CF * TAB_Factor

💡 Pro Tip: The attrition rate is the single most sensitive assumption in an MPEEM. Pull it from the target's historical churn data — cohort by cohort — not from a management projection. Auditors will challenge anything that looks like it was reverse-engineered to hit a target intangible value.

Relief-from-Royalty Method for trademarks and technology

The idea: if the buyer did not own the trademark, it would have to license it from a third party. The value of the trademark is the present value of the royalty payments avoided.

Royalty_Savings_Year_N = Revenue_Year_N * Royalty_Rate * (1 - Tax_Rate)
PV_Royalty_Savings = Sum(Royalty_Savings / (1 + WACC) ^ Year)
Fair_Value_Trademark = PV_Royalty_Savings * TAB_Factor

The royalty rate comes from arm's-length licensing databases (Ktmine, RoyaltySource, RoyaltyStat). For consumer brands, rates typically range 2–8% of revenue. For enterprise software, 8–25%. Document your source — auditors will ask.

With-and-Without Method for non-competes

Model two DCFs: one assuming the founder competes post-close, one assuming they do not. The fair value of the non-compete is the difference in enterprise value, probability-weighted by the likelihood the founder would actually compete absent the agreement.

Building the Full PPA Schedule in Excel

A production-grade PPA workbook in Excel has five tabs:

  1. Consideration — sources of consideration, tied to the merger agreement
  2. Fair Value Adjustments — line-by-line uplifts to tangible assets and liabilities
  3. Intangibles — one column per intangible with the DCF engine underneath
  4. Deferred Tax — the gross-up calculation
  5. PPA Summary — the opening balance sheet that feeds the combined model

The summary tab is where the plug lands. Structure it as a bridge:

Line Amount ($M) Source
Consideration transferred 1,500.0 Consideration tab
Less: Book value of net assets acquired (420.0) Target balance sheet
Excess over book value 1,080.0 Subtotal
Less: Fair value step-ups on tangible net assets (85.0) FV Adjustments tab
Less: Identifiable intangible assets (620.0) Intangibles tab
Add: Deferred tax liability on step-ups 176.6 Deferred Tax tab
Goodwill (residual) 551.6 Plug

Every number on the summary should be a direct link to a source tab. If your goodwill number is a hard-coded value, you have a problem — auditors will unwind the entire model to trace it.

Goodwill =
    Consideration_Transferred
  - Book_Value_Net_Assets
  - FV_Step_Up_Tangibles
  - Identifiable_Intangibles
  + Deferred_Tax_Liability
  - Non_Controlling_Interest_FV

Example: A buyer pays $1,500M for a target with $420M book equity. Fair-value step-ups add $85M to PP&E and inventory, $620M of customer relationships and technology are identified, and the deferred tax gross-up on the step-ups is $176.6M (using a 25% blended rate). Goodwill lands at $551.6M — approximately 37% of the purchase price, consistent with recent middle-market software deal comps.

How Do You Calculate Deferred Tax on a Purchase Price Allocation?

Fair value step-ups create book-tax differences because the step-up is recognized for financial reporting but not for tax purposes (in a stock deal). This drives a deferred tax liability (DTL) at closing, which grosses up goodwill dollar-for-dollar.

The mechanics differ by deal structure:

  • Stock deal (most common for public targets): tax basis carries over at historical values. Every fair-value step-up creates a DTL. Goodwill for tax purposes is $0.
  • Asset deal or Section 338(h)(10) election: tax basis is stepped up along with book basis. No DTL. Goodwill is tax-deductible over 15 years under IRC §197.
  • Foreign target: apply local statutory rates for the DTL calc. Anti-deferral regimes (GILTI, BEAT) may layer on further complexity.

The formula is mechanical:

DTL_on_Step_Up = (Fair_Value - Tax_Basis) * Statutory_Tax_Rate

Do this line by line for each stepped-up asset, then aggregate. The DTL sits on the balance sheet and unwinds through the tax provision as the underlying asset amortizes or depreciates — reducing effective tax rate volatility in future periods.

⚠️ Warning: In a stock deal, do not compute a DTL on the goodwill line itself for US GAAP purposes. Goodwill has no tax basis and no book amortization, so no temporary difference exists. Calculating one is a classic recurring error that overstates the deferred liability and creates a permanent-difference reconciliation nightmare.

graph LR
    A[Fair Value Step-Up] --> B{Deal Structure}
    B -->|Stock Deal| C[Book Basis > Tax Basis]
    B -->|Asset Deal / 338h10| D[Book Basis = Tax Basis]
    C --> E[Recognize DTL at Stat Rate]
    D --> F[No DTL]
    E --> G[Grosses Up Goodwill]
    F --> H[Higher Deductible Depreciation]

Preliminary vs Final Purchase Price Allocation

ASC 805 gives buyers a measurement period of up to one year to finalize the PPA. During that window, new information about facts and circumstances existing at the acquisition date can be reflected retrospectively as measurement period adjustments — meaning prior-quarter goodwill and intangibles get restated, not adjusted through current earnings.

The typical timeline in a public-company deal:

  1. Day 1 (close): book preliminary PPA using management estimates and internal DCFs
  2. Quarter 1 (10-Q): disclose preliminary allocation with narrative on what remains open
  3. Quarters 2–4: work with third-party valuation specialist to refine intangibles, working capital true-ups, tax positions
  4. Within 12 months: finalize PPA, restate prior periods for any measurement period adjustments
  5. Beyond 12 months: any changes flow through current earnings, not goodwill

The single largest source of measurement period adjustments is working capital true-up. The purchase agreement typically defines a target working capital level, with a dollar-for-dollar adjustment against the purchase price for any deviation. Final settlement often comes 90–120 days after close and can shift the consideration line by tens of millions in mid-market deals.

Bargain Purchases and Negative Goodwill

If the fair value of net identifiable assets exceeds the consideration transferred, you have a bargain purchase. This is rare — fair markets rarely gift buyers upside — and ASC 805 requires you to first reassess the entire PPA before recognizing a gain, because the mostly likely explanation is that you missed an intangible or overvalued an asset.

If the bargain remains after reassessment, the excess is recognized as a gain from bargain purchase in the income statement on the acquisition date. Under IFRS 3 the treatment is identical, though the disclosure requirements are stricter.

Bargain purchases show up in three real-world contexts:

  1. Distressed sales — motivated seller in bankruptcy or forced disposal
  2. Regulatory forced divestitures — buyer of a spun asset with limited bidding population
  3. Public-to-private with dislocated equity — when public market misprices an asset relative to fundamental value

Common Purchase Price Allocation Mistakes

Ten years of restated filings and PCAOB comment letters point to the same recurring errors. Any PPA you build in Excel should have a validation check for each one:

  1. Including transaction costs in consideration — banker fees are expensed, not capitalized.
  2. Missing customer relationships as an intangible — the FASB assumes they exist in virtually every deal with recurring revenue.
  3. Ignoring the tax amortization benefit — omitting the TAB understates intangible fair values by 15–25%.
  4. Using management projections without normalization — auditors expect market-participant assumptions, not synergy-loaded internal forecasts.
  5. Double-counting synergies in the DCF — buyer-specific synergies belong in goodwill, not identifiable intangibles.
  6. Missing the deferred tax gross-up in stock deals — the DTL is a required grossup, not optional.
  7. Booking assembled workforce as a separate intangible — explicitly prohibited under ASC 805.
  8. Failing to remeasure contingent consideration — earnouts remeasured to fair value at each reporting period, not just at close.
  9. Using book value for assumed debt — market-yield discounting can materially move the DTL and goodwill.
  10. Forgetting the measurement period disclosures — every 10-Q needs a narrative on what remains preliminary.

💡 Pro Tip: Build a one-cell integrity check on the PPA summary tab: =Goodwill_Formula - Consideration + Sum(All_FV_Adjustments) + Sum(Intangibles) + Book_Equity. This should always resolve to zero. Auditors love a self-tying schedule, and your future self will love finding a broken link in five seconds instead of five hours.

PPA Under IFRS 3 vs US GAAP

The two frameworks are 95% aligned. The differences that matter for cross-border deals:

Topic US GAAP (ASC 805) IFRS 3
Non-controlling interest Fair value method required Fair value or proportionate share of net assets
Bargain purchase Gain recognized after reassessment Gain recognized after reassessment (identical)
Contingent consideration classified as equity No remeasurement No remeasurement (identical)
Contingent consideration classified as liability Remeasured through P&L Remeasured through P&L (identical)
Restructuring provisions Cannot be assumed unless the target had a pre-existing obligation Same — cannot be a "restructuring reserve" set up by the buyer
Goodwill impairment ASC 350 — annual test, one-step (post-2017 ASU 2017-04) IAS 36 — annual test, cash-generating unit approach

The single practical difference that keeps cross-border deal teams busy is NCI measurement. Under IFRS 3 the buyer can pick the proportionate share method, which produces a lower NCI and a lower goodwill number — sometimes materially so in a partial acquisition.

Frequently Asked Questions

What is the difference between purchase price allocation and purchase accounting?

They refer to the same accounting exercise. "Purchase accounting" is the older term from APB 16 that was replaced when FASB issued SFAS 141 (now ASC 805) in 2001, along with the elimination of pooling-of-interests. "Purchase price allocation" is the more precise current usage — the exercise is fundamentally about allocating the total consideration to identifiable assets, with goodwill as the residual.

How long does a purchase price allocation take to complete?

A preliminary PPA is booked within 60–90 days of close, coinciding with the first post-close 10-Q. The final PPA is due within one year (the ASC 805 measurement period). Complex deals with multiple intangibles, foreign operations, or contingent consideration typically use the full 12 months and rely on third-party valuation specialists for the intangibles work.

Can I use the purchase price directly as the enterprise value in a PPA?

Not directly. Enterprise value is the value of the operating business; consideration transferred in a PPA is the fair value of everything the buyer gave up, which includes items like assumed debt, contingent consideration, and equity awards attributed to pre-combination service. Bridge them explicitly in the Consideration tab of your Excel workbook.

What percentage of a purchase price is typically allocated to goodwill?

It varies wildly by industry. In middle-market software deals, goodwill typically lands between 25% and 55% of the purchase price. Consumer brands with strong trademarks push closer to 20–30% goodwill because the trade name absorbs value. Asset-light services businesses with high customer concentration can see goodwill above 60%. The 2023 Microsoft-Activision transaction landed at approximately 68% goodwill on a $75B purchase price.

Do private companies need to do a purchase price allocation?

Yes, if the transaction meets the ASC 805 business-combination definition. Private companies can elect the Private Company Council alternatives — subsuming non-compete agreements and customer-related intangibles that are not capable of being sold or licensed separately into goodwill, and amortizing goodwill over 10 years — which materially simplifies the exercise. Most VC-backed private acquirers elect these alternatives.

How does an earnout affect the purchase price allocation?

An earnout is contingent consideration measured at fair value on the acquisition date and included in the consideration transferred. Its fair value flows directly into the goodwill calculation. Subsequent remeasurements of a liability-classified earnout hit the income statement — not goodwill — which is why post-deal EPS volatility is often driven by earnout mark-to-market rather than operating performance.

Bringing It All Together

A clean purchase price allocation in Excel is the connective tissue between the M&A model, the combined three-statement forecast, and the SEC-filed opening balance sheet. Every dollar you allocate to an amortizing intangible pushes GAAP earnings down for the useful life; every dollar left in goodwill sits waiting for the next impairment test. The best analysts treat the PPA not as a compliance exercise but as a forecasting tool — a look at how the acquired business will actually depress earnings and drive tax rate volatility over the next five to ten years.

Once the PPA structure is in place, the modeling patterns repeat across every deal: consideration bridge, fair-value adjustments schedule, intangibles DCF engine, deferred tax gross-up, goodwill plug. Analysts using VeloraAI's Excel add-in can generate the DCF and TAB engines from a plain-English brief and jump straight to the judgment work — challenging attrition rates, testing royalty benchmarks, and stress-testing the goodwill implied by the residual. The mechanics get automated; the seat at the table comes from the assumptions.