In forecasting our balance sheet, we'll be working in column J. This is the first full year after the stud period. We'll leave the cash cell blank. We'll do that once we've finished our cash flow statements. So we go down to receivables. And again, I can link this back to the Standalone Model tab. So, get that back to Model tab, find Receivables, but I make sure that I'm linking to column J. Now I can do something similar for Other current assets. So I'm gonna copy and paste that same formula down here. I can do the same for Other long-term assets. However, this balance sheet, its rows are slightly different to the other balance sheet because this one includes Goodwill. So I just need to change it from Model J69 to J68.

I can copy that formula down again into Accounts payable and Other current liabilities. So we've used a bit of a shortcut there. Let's go back up to the top and start working our way down. Total current assets is a subtotal. Net PP&E. We've got that in our calculations. It's just above our Income statement. It's 541. Net intangibles. The same place, just above the Income statement. That's 172.8.

Goodwill is going to be the same as last year. We won't assume there's any amortization going on. And then we can calculate our total current assets subtotal.

Now the revolving credit facility, we need to do our debt schedule first. We need to leave that alone for now, but Total current liabilities, we can do that. Historical long-term debt, that's the debt of the standalone company. That was all paid off when the company was taken over, when the LBO happened, so we're just gonna equal last year's figure of zero. But the remaining debt items, again we need that debt schedule. So we'll come back and do them later. Other long-term liabilities equals last year's figure and we're then going to go up to our Assumptions at the very top of the page. Other long-term liabilities change of zero. So we just add on that zero.

Total liabilities sub-total is done.

Almost at the bottom now. So Equity is up in our calcs, 675.7 and then Total liabilities and equity can be calculated.

You should then have a balance sheet check of 1,110.7. That's okay. We're missing cash, we're missing debt. Once we've done the cash flow statements, we should find that that balance sheet check is much closer to balancing. It'll probably be the same as the previous year. It'll be unbalanced by 12.