To create our balance sheet at the end of the stub period, we're going to do this in the Deal_Date tab and in column I. We'll leave cash for now. We'll need a cash flow statement to do that so we move on to receivables. And the question I ask myself here is has receivables already been calculated somewhere and could I just steal that figure? And it has, it's been calculated in the model tab. This was the standalone model and I know that the standalone model's receivables aren't going to be any different to our taken over LBO company's receivables. So I can just press equals, go to the model tab, and down in the receivables line, I can go to column I and I can find the 312.4. I don't need to do any pre-deal percent or post-deal percent 'cause the balance sheet is just a point in time. Now I can copy that formula and I can paste it to the cell below for other current assets and I can almost do it for other long-term assets. The slight problem we have is that this balance sheet has a goodwill line, whereas the standalone model didn't. So our rows aren't quite in line with the model tab. So I need to just change this from model 69 to model 68. Again, I can copy that down to a couple more lines as well. I can put it into accounts payable, other current liabilities. A few other line items need to be filled in. Things like Net PP&E, we can find further up the page in our calculation section. There's our Net PP&E. I can do a similar thing for intangibles and again I can do the same for equity. So down to equity press equals, up to my calcs, and I can find ending equity. Nearly all of the items have been done now, but I just need to copy across subtotals from the previous period to this period. Yep, total current assets is working. So let's do exactly the same for our other subtotals.

Of the items that are missing, let's have a quick look through them. The first one is goodwill. Seeing as we calculated the goodwill at the deal date we're going to assume that that stays constant. So I'm gonna press equals and just make it equals to the previous period. We'll assume there's no amortization of goodwill. The other items missing are the debt items. We've got a revolving credit facility of 20 and we've got lots and lots of debt all missing. We'll have to do the debt schedule and we'll be using cash to try and pay off that debt before we can fill these items in.

The only other item left is the other long-term liabilities. We did originally have a 104.6 balance there, but that included the pension deficit. So we paid off 100 of that deficit to leave us with 4.6. So our balance now is gonna start with that 4.6, but we still need an assumption for if there are any changes. We've got that right up at the very top.

Our other long-term liabilities change we've got as a zero.

Now that we've got all of that done, let's go down to the bottom and I'm unbalanced by 1247.7.

That's okay. I'm still missing cash and debt. Once they're filled in, this should balance.