New York City (NYC)

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

In reality, more time is wasted trying to find out why your model does not balance than the time you took to build it in the first place. This program focuses on useful tips and tricks that can be used to interrogate the data in financial models and useful methods for finding errors quickly. It will also provide tips and tricks to reduce errors in the first place.

 

Learning outcomes

  • Understanding the keys to integrity and efficiency in modeling
    • The importance of matrix integrity
    • Building copyable formulas where possible
    • Sanity checking
    • Matrix integrity checking
    • Stress testing
  • Debugging models
  • 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
  • Dealing with circular references
    • Finding unintentional circularities
    • Sorting out model “blow-ups” caused by iteration and circularities
    • Protecting the model from “blow-ups” using “circularity” switches
    • Using Excel’s circular reference toolbar
    • Circularity macros
  • Error diagnostics
  • Using a series of sixteen models with one error in each, delegates will go through the most time efficient process for error diagnosis
  • Delegates will be given a full model with many errors and will use the “balance sheet check” method to quickly find the reasons why the balance sheet is not balancing
"Using AMT Online (AMTO) was excellent as it allowed me to work through the course material at my own pace. AMT Online was very easy to use and navigate through." ~ graduate, leading business school

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:

 

  • 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

Related courses