ACF Academy
Operations and IT Training Training
 Operations and IT Training
Targeted Audience:
 Anyone involved in the creation and use of company financial models
 A good working knowledge of Excel
CPE Credits:
 14 hours
Course Level:
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
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




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