Pro Forma Balance Sheet

Now that we have completed the purchase price allocation and specified our financing arrangements, we can enter all the adjustments needed to go from the LTM balance sheet to the pro forma balance sheet at closing. We begin by adding lines to the balance sheet we set up previously that reflect changes in the capital structure (i.e. new debt and/or preferred stock), then enter the adjustments by linking to cells in our selected financing scenario and purchase price allocation.

 

Create Financial Models 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking and productivity tools to help you accelerate financial modeling and presentations.

Recall that our financing expenses were capitalized and will be amortized over time. Transaction expenses, on the other hand, are expensed immediately under FAS 141r. Therefore, capitalized financing costs appear as an asset on the balance sheet, while transaction expenses reduced retained earnings. Note that we also wipe out existing shareholders’ equity, since we are purchasing it and replacing it with new equity.

To be sure that you entered the balance sheet adjustments properly, check that the pro forma balance sheet balances.

Download Template

Download Template

Pro Forma Balance Sheet

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The 2024 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