Model - Balance Sheet
- 03:02
Understand how to build the balance sheet.
Glossary
Balance sheet ForecastTranscript
In building the balance sheet, we'd often start at the top and gradually work our way down. However, in this balance sheet, we've got a number of side calculations that need to be done in order for us to come up with some of these numbers. So we'll come back and we'll do them later. Let's just mark out those items that we're not gonna touch for now. So we're not going to touch cash because we need to do a cash flow statement first. Net PP&E requires us to do a BASE analysis, so B-A-S-E, beginning, add, subtract, ending.
Other intangibles needs a BASE.
Short-term borrowings and long-term debts require us to do the debt schedule. And total equity requires a base. So let's go back to the top and fill in all the items that we can do at the moment. So, short-term investments. I'm gonna scroll up, find my balance sheet assumptions, and we're told change in short-term investments amount is zero. So I'm going to add to that zero onto last year's figure. So there's last year.
Current operating assets. Again, scroll up and we're told it's 20% of revenues. Now, I'm going to multiply that. I'm gonna scroll up again, find the revenues line, and I'm going to memorize that that is in F20, because I'm going to need that a few more times. I don't want to keep scrolling up and down. So revenues are in F20.
That gets my total current assets. Quick check, that looks okay. Long-term investments, scroll up to my assumptions again. Again, I'm told that there is a zero change in long-term investments amount, so I'll add that onto last year's figure, and it hasn't changed. Now, goodwill, there's no assumption given. This is because goodwill only happens when a company buys another company. That's something very difficult to forecast. These are by their very nature non-recurring items. So if it's difficult for us to forecast a company buying another company, it's difficult for us to forecast a change in goodwill. Assuming there's no amortization of goodwill, we are going to just stick with last year's figure.
Other long term assets, scroll up to the assumptions again, and we're just given the amount, so I can just link straight to that.
Current operating liabilities. Again, up to the assumption, and it's 21.5% of revenues, so I'm going to multiply that by F20. That was our revenue figure.
And then lastly, other non-current liabilities, 8.5% of revenues. So again, that's in F20.
And that gets us through all the items we can do. At the moment, we've got a balanced check of 79,564.7.