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.

 

Webinar: The AI Edge in Investment Banking

Presented By LSEG & Macabacus: Learn practical insights about AI’s influence on the future of banking.

Thursday, Oct 30th at 10AM EDT / 2PM GMT.

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

Webinar: The AI Edge in Investment Banking
Join experts from Macabacus & LSEG to learn practical insights about AI’s influence on the future of banking.
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