Accretion/Dilution: Cash-Stock Mix

Now let’s determine the accretion/dilution for the cash/stock consideration mix we have assumed for this deal over a range of possible transaction prices. We have set up this section of the analysis to default to a 50%/50% cash/stock mix in the event that the transaction assumptions call for an all-stock or all-cash transaction.

 

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.

At this point, you should check that the accretion/dilution computed on this tab for the for the selected transaction price matches the accretion/dilution computed on the pro forma P&L for 2009. When performing this check, make sure you are comparing “apples to apples” by verifying that you are using the same accounting method (i.e. cash vs. GAAP) and synergies (i.e. synergies vs. no synergies).

Download Template

Download Template

Accretion/Dilution: Cash-Stock Mix

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The 2024 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