What You Will Learn :
- Using Excel’s ‘Jump tool’ to trace through formulas with ease
- Troubleshooting techniques for cash flow statements
- Building a detailed debt schedule
- Using Excel’s auditing tool to trace formulas
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.
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.
Who is this course for?
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