Modeling Synergies

Let’s see how we incorporate synergies into the pro forma income statement. In this merger, we contemplate both COGS and SG&A synergies. However, whether you identify COGS, SG&A, or revenue synergies depends on the nature of the transaction and the businesses to be combined.

 

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 our synergies can be toggled on and off from our assumptions tab in our model. Also, note that we don’t expect synergies until FY09, since the deal will probably not close until near the end of FY08.

The are two assumptions we make in the TargetCo P&L that are worth noting. First, we think that applying 2010’s 0.5% revenue growth to years 2011 and 2012 is a bit too conservative, so we instead input a growth rate of 1.0%. Second, capital expenditures (“capex”) was not available for 2010 in the Wachovia research report used, so we flatlined 2010 capex using 2009’s capex as a percent of sales.

Download Template

Download Template

Modeling Synergies

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