This model has a lot of tabs, but we can boil it down to pre-deal info, deal date, and post deal.

The pre-deal information is summarizing the assumptions tab, acquirer, target local effects, and calendar target acquire effects.

On the assumptions tab here we can see that sources and uses on the right hand side.

Under that is Goodwill.

And lots of inputs such as interest rates Etc On the next three tabs we have a standalone model of the acquire, it's already built so we don't have anything to do here but notice at the top that it's in euros.

The target local FX is a similar standalone model, but here's our problem, it's in US dollars.

We can't merge these two models at the moment, so the last tab has the target's model again.

But this time converted into Euros and it's been calendarized.

Now we have numbers that we can use.

So that's the pre deal information then regarding the deal-day information, we bring the two companies together. This is on the opening balance sheets. Their balance sheets will be added plus any deal adjustments which have been split out into separate columns, but could easily be all in one column. We then see the combined balance sheets ready for us to start forecasting with.

Which brings us nicely onto the post deal information The Calcs tab and the NewCo tabs will allow us to forecast the combined entity or NewCo so that we can then do some analysis to determine whether the deal will be a success or not.

We check that on the remaining tabs such as the analysis tab which has EPs accretion and dilution. Underneath, it has equity ownership and credit ratings check.

The value creation tab calculates the value of synergies and return on invested capital, and the remaining tabs allow other analyzes to happen as well.

So to recap we start pre deal by getting the two standalone models into the right currency and calendarized, and build our assumptions.

Then we combine the companies in the opening balance sheet and that's the deal date and we finish the model build by forecasting the future on the NewCo tab, the analysis can then happen giving us the ability to make recommendations to our clients.