Financing Adjustments

In this step, we make adjustments to the combined company’s balance sheet based on financing assumptions modeled in the “S&U” tab. You can see that we zero-out TargetCo’s stockholders’ equity because BuyerCo is purchasing that equity.

 

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.

Start your Free Trial
 

Note that since we are using the new acquisition accounting rules (e.g. FAS 141r), we expense the advisory fees as incurred, rather than including them in the purchase price. Since we assume that these fees are incurred at the close of the transaction, we expense them immediately and deducted them from retained earning of the combined company.

We then sum each line item horizontally to arrive at the pro forma balance sheet for the combined business. Be sure to verify that total assets equal total liabilities plus stockholders’ equity.

Download Template

Download Template

Financing Adjustments

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more