Financial Modeling Masterclass

  Intermediate CPD: 14 hours   4 half-days   Virtual


Financial Modeling Masterclass

The Financial Modeling Masterclass is a highly practical course run virtually over four half-days that will enable you to master the creation, adaptation, and use of corporate financial models.

What really sets our program apart is the way in which we take you, step-by-step, through how a financial model works, and how the different financial statements fit together. We explain how the whole modeling process works, demystify the complexities, and really bring the topics to life.

Learning Outcomes

By attending this course, you will:

  • Understand how to construct sound and reliable financial models
  • Learn good modeling style
  • Develop your skills in implementing and interpreting financial models
  • Explore different modeling techniques
  • Appreciate the limitations of financial models
  • Obtain practical experience of building different types of financial models

Who Should Attend

Anyone involved in the creation and use of company financial models.


A good working knowledge of Excel.

Book Now!

Seminar Content

  • Objectives of financial modeling
  • 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
computer Case Study: Modeling a Company
  • Analyzing the company data
  • Designing the model
  • Building and verifying the company model
  • Creating the initial position
  • Modeling 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
  • computer 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
  • computer Resolving circular references
  • Documenting spreadsheets
Risk Analysis
  • Risk and uncertainty
  • Scenario analysis
  • computer Using Excel Scenarios for different assumptions
  • Sensitivity analysis
  • computer Using Excel Data Tables to perform structured sensitivity analyses
  • computer Monte Carlo simulation
Company Valuation
  • Modeling the cash flows
  • Estimating terminal value
  • Exit multiples, growth models, and WACC
  • computer Applying valuation techniques to company model
Modeling a Merger
  • Target and bidder financials (historical and projections)
  • Modeling implications of primary financing structures
  • Incorporating synergies and sensitivities
  • Analysis of key output ratios
  • computer Modeling a Buy-out
  • Modeling the financing structure
  • IRR, equity ratchets and covenants
  • computer Incorporating sensitivities
Virtual Learning

When and Where
   22 Jul 2024 - 25 Jul 2024
   a.m. sessions – 08:00 to 12:00 (for Asia / EMEA participants)
   p.m. sessions – 13:00 to 17:00 (for EMEA / Americas participants)
   All times are GMT (London time)
   Data Science

Book Now!

Other Dates and Locations
Search for Financial Modeling Masterclass in our course schedule for alternative dates and locations where this course is offered.

If you live outside the UK, use coupon code VCNOVAT to remove the VAT charge.


Ticket Type Price Spaces
Course Fee - 1 attendee a.m. sessions (inc. VAT) £1,890.00
Course Fee - 1 attendee p.m. sessions (inc. VAT) £1,890.00

Registration Information

Payment and Confirmation

ACF specialises in creating tailored courses for our clients. Fill out the details below to obtain more information on how to run a customised version of this course in-house for your firm.

Fields marked with * are required