ACF Academy
Operations and IT Training Training
Category:
 Operations and IT Training
Targeted Audience:
 Anyone involved in the creation and use of company financial models
Prerequisites:
 A good working knowledge of Excel
CPE Credits:
 14 hours
Course Level:
 Intermediate
 
Date  DurationCostVenueRegister
31 Jan - 1 Feb 2019  2 days$1575.00New York
11-12 Feb 2019  2 days$1575.00Please select

Financial Modeling Masterclass

 
The principal objectives of this intensive two-day seminar are to:
 
  Explain how to construct sound and reliable financial models
  Demonstrate good modelling style
  Develop delegates’ skills in implementing and interpreting financial models
  Explore different modelling techniques
  Highlight the limitations of financial models
  Give delegates practical experience of building different types of financial models
 
Course Outline
   
 Introduction
   
Objectives of financial modelling
Scope of financial models
   
 Developing a Financial Model
   
Conceptualizing the model
Identifying key model variables
Programming the model
Organizing the workbook: Data, Assumptions, Results
Allowing for flexible scenarios
Producing reports
   
Case Study: Modelling a Company
   
Analyzing the company data
Designing the model
Building and verifying the company model
Creating the initial position
Modelling the operating environment
Applying accounting rules and business logic
Creating P&L, cash flow, and balance sheet statements
Verifying the model
Running the model
Generating and interpreting the results
   
 Auditing and Problem Solving
   
Checking the integrity of a financial spreadsheet
Getting a financial spreadsheet to “balance”
Moving from the past, through the present, and into the future: from facts to forecasts
Dealing with part-year accounts and differing year-ends
Auditing a spreadsheet
Resolving circular references
Documenting spreadsheets
 
   
Risk Analysis
   
Risk and uncertainty
Scenario analysis
Using Excel Scenarios for different assumptions
Sensitivity analysis
Using Excel Data Tables to perform structured sensitivity analyses
Monte Carlo simulation
   
 Company Valuation
 
Modelling the cash flows
Estimating terminal value
Exit multiples, growth models, and WACC
Applying valuation techniques to company model
   
 Modelling a Merger
   
Target and bidder financials (historical and projections)
Modelling implications of primary financing structures
Incorporating synergies and sensitivities
Analysis of key output ratios
   
 Modelling a Buy-out
   
Modelling the financing structure
IRR, equity ratchets and covenants
Incorporating sensitivities
 

 

NB All practical sessions are highlighted like this:
means a Workshop or Simulation
means a Case study

 

 
Accreditation


 

"The material was not delivered in a vacuum. The instructor always had an example / actual article to illustrate his point, so the class turned out to be a lot more interesting about real-life markets."

– Heajun H.