Virtual Classroom

Download Brochure

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 - Fundamentals Part 1

This session teaches participants how to build a three statement integrated financial model, comprising income statement, balance sheet and cash flow statement. Best-practice modelling techniques are demonstrated, to ensure maximum accuracy and efficiency. Participants also learn how to stress-test the assumptions used, to check the model for mistakes and to document it. This session uses simplified teaching models as well as a real company forecast model.

 

Learning outcomes

  • Setting Excel up for maximum efficiency
  • Best-practice keyboard shortcuts for modelling
  • Key modeling formulas
  • Alternative model layouts
  • Structure of an integrated three statement forecast model
  • Constructing the income statement, balance sheet and cash flow statement
  • Balancing the forecast balance sheet using cash and revolver
  • Incorporating interest income and expense
  • Introduction to checking methodologies
  • Performing audit trails

Financial Modeling - Fundamentals Part 2

Using a real company forecast model, we start the session by reviewing the structure and key components of an integrated three statement forecast model. We then focus on modeling operating cash (required cash) and separating it from excess cash. We then teach participants how to build a forecast cash flow statement from scratch, using income statement and balance sheet inputs. The last part of this session focuses on interest calculations and circularities, where we teach participants the difference between using beginning, ending or average debt/cash balances and how to work safely and effectively with or without circular formulae in a model.

 

 Learning outcomes

  • Review of the structure and key components of a forecast model
  • Review of the modelling steps to build a three statement integrated model
  • Modeling operating cash (require cash) and excess cash
  • Building a forecast cash flow statement from scratch
  • Calculating interest on cash and debt balances
  • What is a circular formula?
  • Working with intentional circular references
  • Avoiding non-intentional circular references

 

 

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

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.

Course trainers

Related courses

Prerequisite

A solid understanding of financial statement accounting is needed for this course. AMT's Financial Statement Analysis courses will provide the knowledge you require: