In this model, the acquirer has a year end of the 31st of December.

The latest financial year is year 15.

Unfortunately, the target has a different year end of the 31st of August their latest financial year is year 16.

If we're to build a model that merges these two sets of numbers, we need them both on the same year end, which will be the acquirers 31st of December.

Let's look at the year to the 31st, December 16.

We'll need to take eight twelfths or 66.8% from the target's current year and 4/12 or 33.2% from the target's next year.

That's summarized at the bottom of the screen as well.

Let's see that in the model.

On the acquire tab we confirm that the latest financial year is to 31st December 15 and if we go to the Target local FX tab it is to the 31st of August 16.

Also note, that the acquire tab reports in Euros whereas the target is in US dollars.

We'll get them calendarized on the calendar Target acquire FX tab.

In cell G3 we have the calendar percentage and that cell has been named calendar up in the top left-hand corner.

It's currently showing us a negative 66.8% on the right hand side.

We've shown some workings to break down the calendarization formula. We've taken the negative calendar figure to get a positive 66.8% and OnePlus the counter figure to get positive 33.2% We've then taken the target local FX figures from cells D7 and E7.

Let's have a quick look at that tab just to confirm those numbers.

And there they are D7 and E7.

They're our figures to the 31st of August 14 and 15.

Great, if we multiply those percentages by their respective columns sales, we get calendarized sales in Dollars, then we multiply by the FX rates and we get the calendarized I sales in Euros 14,808.09.

That's the correct number and those were some workings to help explain what's going on, but it's all done in one handy formula in cell D7.

Here the formula says if the targets latest financial year.

Is before the acquire latest financial year we do this which I'm selecting at the moment.

But we know the targets latest financial year is not before the acquires it's after, so we ignore the bit being selected right now and instead look to the last bit.

We take one plus the calendar percentage getting us a 33% multiplied by the targets E7, next year sales, then we add on the negative calendar percentage positive 66.8% and multiply that by the targets D7 the targets current year sales.

Multiply all of that by FX and what do we get? That's exactly what we had in our workings off to the right hand side. And we see the same figure of 14,808.09 as the output.

That calendarization formula has been copied all the way to the right and down through the whole of this tab giving us a calendarized income statement, balance sheet, and cash flow statements all in Euros, which can now be merged with the acquirers amazing.