I now move on to the balance sheets. In the balance sheet, we'll leave cash empty, 'til we do the cash flow statements, but start now with receivables. And again, I go to the Model tab. I go to the 312.4 receivables on the Model tab, but I then need to ask myself how far through the year was that deal date? It's only 75% the way through. So I want 75% of this figure and 25% of the previous year's figure. So it feels a bit counterintuitive. It feels like it's the wrong way around, but it is right. I need to multiply that by the pre-deal percent. Then I'm going to add onto that last year's figure multiplied by the postdeal percent, I want 25% of that. Getting me to 308.9. Now again, I can copy that down to other current assets, other long-term assets, but I notice that this balance sheet has a Goodwill line in it and the previous balance sheet didn't. That means my lines are slightly off so I'm gonna change that model 69 to model 68.

I'll just check that's linking at the right place and it is, long-term assets. I'm gonna copy that same formula down again. That formula will be good for the revolving credit facility of zero. And accounts payable, other current liabilities, historical long-term debt, and other long-term liabilities. But again, this balance sheet is just slightly different in terms of its rows. I need to change model 84 to model 77.

Again, let's just prove that to you. So 104.6, fantastic. So it's a bit of, this is 104 and a bit of last is 104. I now need to fill in my net PP&E intangibles and equity and we had all of them on this tab. See if I scroll up, past the income statements, I get my PP&E.

Same for intangibles, up past income statements, There's my intangibles, 178.4. Goodwill didn't exist and the last item I need to do is equity. Scroll up past income statements. There's my equity, 710.8.

Now I just need to do the subtotals in the balance sheet and I can copy them from the previous year. If I use control + R, that copies last year's subtotal formulas across.

Total liabilities and equity. And then I do my balance check. Now, I still haven't done cash, so it is okay to be unbalanced and 269.7, that's the correct number to be unbalanced by.