Short-Term Liquidity Model (XLSX) | Integrated Financial Model (XLSX) | Market Model (XLSX)
This course contains phase 1 ‘Status Quo Analysis & Business Modelling’ from the Old Fashioned case study.
What you’ll learn
- Structure a project like a strategy consultant.
- Build an integrated financial model like a corporate restructuring consultant.
- Plan short-term liquidity like a corporate restructuring consultant.
- Model the market like a strategy consultant.
Course Content
- Introduction to the Case Study –> 6 lectures • 47min.
- Planning Short-term Liquidity –> 7 lectures • 2hr 2min.
- Building an Integrated Financial Model –> 13 lectures • 2hr 7min.
- Modelling the Market –> 6 lectures • 48min.
Requirements
This course contains phase 1 ‘Status Quo Analysis & Business Modelling’ from the Old Fashioned case study.
It teaches everything you need to know to kick start your career with top-tier restructuring consultancies.
Why top-tier consultancies?
Because we’re not talking Big4, here.
The Big4 are great at all things modeling, but they completely lack the polish that well-storylined and -designed slides bring to the table.
That’s the real difference between Big4 and top-tier consulting.
And this course prepares you for the latter.
After completing this course, you will not only be a modeling wizard in Excel, you will also know how to surface so that you’re perceived like a top-tier consultant by the client.
This course includes professional, engagement-ready Excel models, including step-by-step iterations to help you learn:
- Short-Term Liquidity Model (XLSX)
- Integrated Financial Model (XLSX)
- Market Model (XLSX)
- The full presentation as both PPTX and PDF files is also included.
All models seamlessly integrate and work together.
The level of detail and complexity is far beyond anything that you’ll find in standard online course programs.
The modeling lectures contain separate output and input folders, so that you can build the Excel models alongside me.
If you aim for an unfair advantage in the early stages of your career, here you go.
Yes, some of the contents will be tough – but that’s exactly why this works.
Finally, here’s a list of stuff that I do NOT teach, because no restructuring professional would use it in modelling anyway:
- VLOOKUP (prone to errors, inflexible – best to forget this even exists)
- Pivot tables (can be used for a short glimpse at a table – but completely useless in modelling beyond that)
- VBA (no, you don’t need that – anyone who tells you you do, has never worked in this profession)