London

Venue and transport links

course-venue-pic
  • Aldgate East
  • The White Chapel Building
    5th floor
    10 Whitechapel High Street
    London
    E1 8QS
  • View venue
"It's great to have access to the AMT online platform. I found the videos and quizzes really useful to refer back to after my public course. The videos in particular were simple and easy to understand." ~ analyst, private equity firm

Who should attend the course?

Undergraduates, Interns and Graduates

Securing a graduate scheme at a top financial organisation without work experience can be challenging. Ideally, they would like you to have intern experience and to be passionate about finance. Financial institutions will often select only the best prepared candidates to be fast tracked into their graduate scheme. If you aspire to work in corporate finance, M&A, private equity, asset management, private banking, global markets or sales and trading, you will need to be numerate and excel at analyzing financial and market information. By attending an AMT public course, you will learn about financial statement analysis, financial modeling and valuation. You will gain the knowledge and skills for those all important interviews.

 

Experienced Finance Professionals

Working for a leading financial institution means you will be working in a highly competitive environment. In order to stay ahead you will need to keep pace with your colleagues. AMT’s public courses ensure that you maintain and enhance the knowledge and skills you need to continuously deliver a professional level of service to your clients. Hence becoming more effective in the workplace and helping advance your career. Learn or refresh your skills in financial statement analysis, financial modeling and valuation, and stay ahead of the curve.

 

What courses complement this one?

Financial Modeling

To get a comprehensive understanding of Financial Modeling, study over 3 days:

 

 

Book all 3 courses

 

Course details

Financial Modeling and Forecasting

Delegates will learn how to build a three statement model using a detailed revenue forecast with price and volume drivers. A full debt schedule, including a cash sweep, is incorporated into the model. In addition to the main class case model, delegates are given exercises to help them understand more complex modeling issues (e.g. detailed depreciation schedules and working capital items). Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

 

Learning outcomes

  • Complex three statement models
  • Modeling a detailed revenue forecast
  • Modeling a cash sweep
  • Modeling a detailed debt schedule include a cash sweep
  • Consolidating and re-applying knowledge of circularity, iteration and a toggle switch
  • Building cash flow statements from scratch
  • Troubleshooting techniques for cash flow statements
  • Finding errors and integrity checking

Integrity and Error Checking

Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

 

Learning outcomes

  • Troubleshooting techniques for cash flow statements
  • Finding errors and integrity checking
  • Using Excel tools to help with integrity checking
  • Finding unidentified hard numbers quickly and easily
  • Using Excel’s “jump tool” to trace through formulas with ease
  • Using Excel to show the formulas underlying output
  • Using Excel to find inconsistencies in the model
  • Using Excel’s auditing tool to trace formulas

What will you receive on the course?

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:

 

  • printed course binder with copy of the slides
  • laminated summary sheets
  • 24/7 access to AMT Online (AMTO)
  • class recordings
  • course notes
  • quizzes
  • electronic homework/study files