Who should attend the course?
- New hires who have joined the firm late and missed the in-house program
- Individuals looking to fill a knowledge gap
- Experienced bankers looking to refresh their technical skills
- Teams employed in financial strategy roles from non-banking corporations
- Graduates preparing to interview for a role in the finance sector
- Students at business school and looking for a career in finance
Dates and Times
14th May 2020 @ 09:00-17:00 BST (London)
Financial Modeling - Cash Sweep
In this session we build a three statement operating model for a real company, which incorporates a detailed revenue forecast based on price and volume drivers. We set up a hierarchy of a series of debt items and we learn how to model the sequential debt paydown using a ‘cash sweep’ approach. Best practice modeling techniques are emphasized throughout.
- Building a detailed debt schedule
- The waterfall of debt repayments
- Building a simple cash sweep
- Modeling revolver
- Modeling a price/volume revenue forecast
Financial Modeling - Troubleshooting
This session covers a range of error-checking techniques to find and correct the most common errors found in financial models. We use a series of financial models to allow participants to practice error-checking.
- Stabilizing a model
- Making a model map
- Sanity checking a model
- Fixing a non-balancing balance sheet
- Troubleshooting techniques for cash flow statements
- Checking the model’s matrix
- Finding unidentified hard numbers
- Using Excel’s ‘Jump tool’ to trace through formulas with ease
- Using Excel to show the formulas underlying output
- Using Excel’s auditing tool to trace formulas
""The virtual classroom was engaging and it felt like a classroom training"" ~ HR, International Investment Bank
View video to get a flavour of the course
What is a Virtual Classroom?
Virtual Classroom training is a new and highly engaging way of delivering programs remotely with enhanced levels of interactivity compared to conventional webinars. In AMT’s Virtual Classroom participants are encouraged to activate their own webcams and mics throughout the class allowing for real-time engagement, both verbal and non-verbal, with fellow participants and their trainer. Participants can also share their screens to get instant assistance in any technical exercise; just like asking the trainer to walk over and help in the classroom! We have seen a step-change in participant engagement with this new technology. The trainer’s ability to see a selection of their participants’ faces in real-time, and to react to their verbal and non-verbal cues creates a remarkably realistic classroom-like experience. For an example of the technical requirements of for our Virtual Classrooms click here.
A solid understanding of financial statement accounting is needed for this course. Our Financial Statement Analysis courses will provide the knowledge you require:
- Accounting Fundamentals, the Income Statement and Working Capital
- Non-Current Assets, Cash Flow Statements, Debt and Equity