Cash-to-GAAP Reconciliation

Our next step is to reconcile our “cash” net income and EPS figures to the “GAAP” figures reported by BuyerCo in its public company filings. We do this by subtracting the tax-effected amortization and stock-based compensation expenses, as well as one-time items, from cash net income. Recall that we omitted these charges from our calculation of cash net income in the last step.

 

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.

Start your Free Trial
 

We’ll also add a line for capital expenditures (“capex”). Although not part of the income statement, capex is included here because when we project the income statement into the future, we should observe that capex and depreciation expense tend to converge over time. Also, capex is often projected as a percent of sales, so it makes sense to include capex in the P&L.

Download Template

Cash-to-GAAP Reconciliation

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