Model - Intro Walkthrough
- 01:24
Understand the components of the Google model.
Downloads
Glossary
Cash Sweep Model Debt TranchesTranscript
In this model walkthrough, we're not going to do any building of the model we're just going to have a look through it and familiarize ourselves. At the top, we've got our income statements, we've got assumptions and underneath that the income statement itself.
We can see that we've got three years of historicals plus space for our subtotals. Above that you've got the historical ratios, you've then got the forecast assumptions and here we've got room for our forecast figures. We've got very similar for our balace sheet, here are the assumptions then the calcs then the balance sheet itself three is historicals, subtotal's not done forecast room. And then underneath that we've got a cash flow statement, empty at the moment with no historicals. But the real interest in a cash suite model comes in the debt. We're going to look in much more detail at debt repayments and here we've got some assumptions, more detail on interest rates, and we've got four different types of debts in this model. We've got short-term borrowings, we've then got a 4% Term Loan a 3% bond and a 6% Term Loan. And what we'll have in this model are some mandatory repayments but also the ability to have accelerated or overpayments of their debt items if we're allowed to do it.