Purchase Price Allocation

Let’s shift gears and perform the purchase price allocation. Recall that we calculated the equity purchase price in a previous step. We will first make some assumptions about how we will allocate this purchase price, and then calculate goodwill using these asusmptions and the method we described in detail in our section on purchase price allocation. You may need to scroll the spreadsheet to the right to see our calculations in the transaction summary/assumptions block of our model.

 

Build Models & Decks 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking, and productivity tools to build models and presentations faster than ever.

Note that we have included a line for transaction fees in the purchase price allocation, but manually entered $0. Under recent accounting changes introduced by FAS 141r, we no longer include transaction fees and expenses as part of the purchase price. We have left this line in the model to make clear that we are using the FAS 141r accounting rules.

No IRC Section 338 election is available in a stock purchase when the acquirer is not a C corporation. In LBOs, the acquirer is usually organized as a LLC, so we make no provision here for a Section 338 election as we did in our merger model.

Download Template

Download Template

Purchase Price Allocation

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more