Target’s Income Statement

We create TargetCo’s P&L in nearly the exact same way that we put together BuyerCo’s P&L, so we’ll skip the intermediate steps and go straight to the final product.

 

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.

Since we are building a merger model, it is necessary to align the target’s reporting period with the acquirer’s reporting period. For example, if TargetCo has a fiscal year end of December 31 and BuyerCo has a fiscal year end of September 30, we need to time-shift TargetCo’s P&L to match BuyerCo’s reporting period. In this example, we assume that TargetCo and BuyerCo both have a fiscal year end of September 30.

Additionally, we apply the acquirer’s tax rate to the target’s income statement when building a merger model. So, we link the tax rates in TargetCo’s income statement to those in BuyerCo’s P&L. It may sometimes be helpful to plug the target’s actual historical tax rates into the spreadsheet first to ensure that the GAAP figures you calculate match those that were reported, then link to the acquirer’s tax rates.

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

Target's Income Statement

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