Buyer’s Historical P&L

The first step in our merger analysis is to model BuyerCo’s income statement to include historical results and projections. When sufficient data is available, we can calculate both “cash” and GAAP net income and EPS figures. Cash figures exclude the non-cash amortization and stock-based compensation (“SBC”) expenses and non-recurring charges that GAAP figures include.

 

Build Models & Decks 10x Faster with Macabacus

Gain access to 100+ shortcuts, formula auditing visualizations, easy Excel-to-PowerPoint linking, and productivity tools to build models and presentations faster than ever.

It is important to calculate cash figures when BuyerCo trades on cash, rather than GAAP, multiples. For example, BuyerCo might trade at 18.4x 2008 cash EPS. You can tell if a company trades on cash figures by comparing GAAP EPS with the EPS figures that Wall Street research analysts compute. If these numbers are different, then analysts are using cash figures.

Companies often embed SBC expenses in SG&A (or COGS). We separate SBC from SG&A (or COGS) whenever possible to facilitate the calculation of cash figures and the reconciliation of cash to GAAP. You can usually determine how much of SG&A (or COGS) expense is attributable to SBC by examining the footnotes of a company’s public filings.

We also separate depreciation and amortization expenses because 1) doing so facilitates calculation of cash figures and the cash-to-GAAP reconciliation and 2) depreciation and amortization are projected differently into the future as we will soon see.

Note that some line items are computed as “% Margin” and others as “% of Sales”. The latter term generally applies to expenses and the former generally applies to income/earnings.

Most of the historical inputs to our historical income statement come from either a BuyerCo’s public filings or, if the historical figures require adjustment to account for acquisitions, divestitures, etc., from Wall Street research reports.

Download Template

Download Template

Buyer's Historical P&L

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
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