Model - Cash and Debt in Balance Sheet
- 03:32
Model - Cash and Debt in Balance Sheet
Transcript
Here we do a couple of things. We do a little check on our cash and then we're going to put all of the debt items into the balance sheets and hopefully the balance sheet will still balance.
Let's bring together our figures here for cash and short term investments. I need beginning cash and cash equivalence. I can get that from the cash flow statements if I scroll up, find that.
And the next two line items I need are immediately below it so I can just select those two cells below and copy it down with control D.
My short term investments, I can get that from the balance sheet, so scroll up.
There it is.
And I can now add up my total interest earning assets being the cash and the short term investments, and it comes to 4,441.2 at the moment.
I'm actually going to need all of those figures for last year as well when I come on to do my interest calculation. So I'm just going to copy those three cells, move to the left, and now paste, and all of those figures have come through, fantastic. Now we just need our debt figures to appear in the balance sheets. If I scroll up to the balance sheets, we'll just see what's missing. Short-term borrowings is missing for the current year and long-term debt's also missing. But if we see where the previous figures came from, they came from E212 and E211. Let's go down to those cells. Here they are. We can see that this E211, the short-term borrowings, that's linking into the debt schedule, it's bringing down those short-term borrowings. All I can do is I can just copy that to the right and I can see my short-term borrowings were all paid off. They came to zero. If we just double check where that's come from, it's come from the short-term borrowings debt schedule. I can do exactly the same with the long-term debt. The long-term debt currently has three different debt tranches included in it. If I copy this to the right, the numbers will update for the year 51. Fantastic, they've all come through, and again if I just link up to where they've come from, fantastic. There's our first one, debt tranch one. Then the second one is the bonds and then the third one was the term loan, great. Those two figures now just need to appear in the balance sheet. So if we scroll up to our balance sheets, I can take last year's short-term borrowings formula, copy to the right, there's that zero that appears. And the same with the long-term debts. Take last year's subtotal, copy to the right, fantastic. Now, you may have noticed that the total assets number changed as we did that. Let me just toggle through it. The total assets number is changing at the top. What's happening there is that because we're paying off less debt, so instead of our debt going from 40,000 to zero, it's now going from 40,000 down to 24,919.5. That means we're using less cash. And if we go back up to our cash, this figure, which was horribly negative, is now 843.6. That's the minimum required cash that we wanted. A little cushion, just a safety net in case things went wrong. So my balance sheet is now done. If we scroll to the bottom of it, we can see that it still balances.