Frankfurt

Download Brochure Download Calendar

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

Course details

Financial Modeling - Cash Sweep

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.

 

Learning outcomes

  • 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.

 

Learning outcomes

  • 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 public course I attended proved extremely enriching, especially when discussing case studies, current affairs or other practical applications of the theory." ~ analyst, global investment firm

View video to get a flavour of the course

Course materials

While this is a face to face training course, a blended learning approach is taken and delegates will be provided with access to AMT Online. Our study materials contain both the knowledge and practice materials required to assist with the learning process and help you in your job role. Course materials include:

 

  • e-binder
  • laminated summary sheets
  • 24/7 access to DELTA online learning environment
  • class recordings
  • course notes
  • quizzes
  • electronic homework/study files