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.

 

Speed Up Financial Modeling with Macabacus


Try the leading Microsoft 365 add-in for finance and banking. Create complex financial models and branded presentations in record time.

Start a Free Trial

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

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