Here we want to calculate the company's PP and e but also synergies if we scroll down.

We're going to do that PP and e-calculation here.

But there's a few things we need to do first. First of all, if we go up we're going to have to preciation on capex synergies. There are capex synergies available from the 2017 year onwards the capex and cheese come in fantastic.

So how do we calculate these well because they change between the years will have to calculate the depreciation on them separately. So if I go down to the 2017 row, I'll take the capex and G's from that year. I'll then lock that by pressing F4 but they need to divide that by the depreciation years. We're going to spread that 150 over 10 years.

That's fantastic. That's come through as 15.

The thing is though. I'll now copy that to the right and now I've got to appreciation for just the 2017 capex synergies, but I then need to do the same thing for 2018.

I can see we've got 300 of synergies here. And again, I'll need to divide that by the 10 years lock that.

But again, I'll have to copy that to the right.

I then repeat the same thing with the Nexus synergies lock and divide by 10.

And our final year again at 300 lock that and then divide by 10. I don't need to lock. So I'm not copying it to the right.

So what we end up with is this depreciation triangle and we can then total up each Year's depreciation.

To find the depreciation on just the capex synergies.

Fantastic that's going to be one of the line items in our PP and ecalculation underneath.

But the other thing we're going to need is depreciation on the pp&e step-ups.

When we bought this target, we stepped up the value of some of its PP and E. And that's going to lead to extra depreciation on that extra pp&e value. We're going to start this in column F. That's when our deal dates happening. I'm going to go to the opening balance sheet and find out what that value was at the deal dates and I can see that it was 951 in that pp&e row.

So that was the PPD Step Up balance at the deal date. We then go into the next year and we find that our beginning balance is the same figure. We now need to depreciate that. So I'm going to depreciate that using the minus Min function for that. I'll take the 951. I'll then lock onto that.

And then I want to divide that by the number of years. This is going to spread over that's on the assumptions tab. It's all the way down the bottom left hand corner the PPD step up to appreciation period is 10 years. And again, I'll lock onto that.

So I want the minimum of my depreciation or if I go back to my calcs tab.

The beginning balance close the brackets and I can see that it's been depreciated by 95.1 someone up and I now gets the ending balance of my PP and you step up but more importantly it includes the depreciation of 95.1.

Now I have everything I need to do my PP and e-calculation again. I'll start with the new codes ending mounts for PPE in column f i can get that from the opening balance sheets again, it's from the pp&e row, but now we're going to the Consolidated column. So 19,481.7 that becomes my beginning balance.

We now need to go through the two companies and find all of the reasons why people you may change for instance. We're going to have Standalone capex for the choir and the Target and capex energies. We'll then have stands alone depreciation for the choir and the targets and then depreciation savings from the capex synergies.

Will also then have to step up depreciation as well. So there's a lot of items coming together when we're consolidating two companies and we're doing things that step ups and synergies.

Let's go find them so much Standalone capex. I'll have to go to the acquire tab.

And I can see down in row 98 under the balance sheet side calculations. We've got to figure in column G of 2703 now, that's the depreciation for the acquirer. I need to get exactly the same for our calendars Target.

And the figure we've got in column G here is a 911.7.

So that gets me the Standalone capex for the acquirer and the Target now I can go get the capex synergies. That's up in row 13, but that's going to give us a negative. That's a saving that means I don't incur those costs of 150.

After that, the Standalone depreciation needs to be found. We can find that on the acquire tab again column G. There's the depreciation for the acquirer and then the calendarized target acquire FX.

Again, if we go down to Row 18, there's the depreciation in column G. That's the two stand-alone companies depreciation figures two to 90.8.

Along with that. I need the depreciation savings from the capex synergies. We've got that up in row 21, we calculated that.

That's a saving so it's a positive number.

But then we've got the Step Up depreciation. We just calculated that underneath the 95.1.

So if I now some all of the items above that gets me to my new co-end events of pp&e of 20,575.5.