Kion Model - Balance Sheet Assets
- 04:02
 
Building the balance sheet for an industrials company, Kion.
Glossary
Industrials Modelling Sector ModelsTranscript
We're going to continue our build by doing some more calculations. The first is equity, which we're going to build as we would any other base account.
We're going to take the historical, let it become the beginning, then our liability to our shareholders will increase as we generate net income. And we're going to need dividends.
We've got dividends per share, and we're going to times that by the shares that are out there. We're not going to pay dividends to shares, which are part of dilution because they don't exist yet.
You can see that's generated at positive, which I'll need to flip because dividends reduce the liability for how much we owe to our shareholders, and we now have ending equity, which will be handy for our balance sheet. The current operating assets and liabilities, we could pinch from the column before. because what they do is add up all of the operating assets, inventory, receivables, et cetera, and then the liabilities. Okay, which are just a single figure. They then net them out to say that the net cash need for operating working capital is, and you can see rolling that forward doesn't work. And that's because the balance sheet is not there yet. What we'll have to do is just come back and check that this is working okay. Once we've done our balance sheet, so moving on to the balance sheet, we'll make a start on it and perhaps just do assets. The cash we'll need to come back to because we need the cash flow statement for that. The receivables, we will model using our assumptions around receivables days. We're going to divide that by 365 and just hard code that, and then multiply it by sales. And that's because the receivables days represent a proportion of the years worth of sales.
Quick reasonableness check, yes, that's in line and you can see that it's also turned up in the operating assets. We're going to do the same with inventories and we have inventory days, but the inventory days will be a proportion not of sales, but will be more accurately models using the operating expenses. And you can see now why perhaps we're calculating those operating expenses. We need them for various line items like this one. A quick reasonableness check says that's okay. We now have other current assets.
The change in other current assets, it's being modeled as a change, so we'll need to add that to last year. And there's no predicted change, so it's going to stay put. We can then add together the total current assets. They'll be misrepresented because of the lack of cash, but let's get the whole thing working and then we'll tie things up after the cash flow statement. We can then go and fetch our PP&E from our base.
We can do long-term investments as a change compared to last year and goodwill, we're simply going to flatline because that is a non-amortizing asset, which will be subject to impairment, which we're not going to predict.
The amortizing intangibles we've modeled in the base up here, and that would include the development capitalized R&D.
Other long-term assets we are modeling as a percentage of revenues, so they'll grow or shrink along with the business, and that then gives us the total assets.