Contact Us

Please contact us today to discuss the best programme which can help you achieve your objectives.

City Training UK
100 Pall Mall
Saint James
London SW1Y 5NQ
United Kingdom

+44 (0) 203 815 6530

About Us

City Training is a world leading provider of premium public courses, in-house training and courses for universities and schools.

City Training was founded and is currently managed by several ex-investment bankers who are trainers themselves and passionate about training. 

Read more…

canstockphoto17262550

Financial Modelling

Thursday 1 – Friday 2 February 2018 London
Price: £1,470 + VAT
Registration close on Friday 26 January 2018

Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house models.

Key Topics 

  • Using Excel keyboard shortcuts
  • Using standards for best practise
  • Understanding circular references and iteration
  • Modeling a detailed three-statement financial model step-by-step
  • Modeling a detailed debt schedule include a cash sweep
  • Finding errors and integrity checking

Who Should Attend?

  • Financial analysts in investment banks
  • Junior equity research
  • Junior investment managers
  • Finance functions at corporations
  • All other interested Finance professionals

Robert has 20 years of experience in Accounting and Corporate Finance in London.

Robert started his career in Auditing at KPMG in London, where he focused on industrial and service clients.

He then moved to the Corporate Finance department of KPMG in London where he completed successfully a variety of M&A transactions in the mid-market segment.

Robert then set up his own Corporate Finance practice in London and has been training since 2010 on a regular basis Accounting, Financial Statement Analysis and Corporate Finance at leading institutions worldwide.

Robert has an MSc in Physics from Oxford and is a fully qualified Chartered Accountant.

Session 1

Financial Modeling Fundamentals

Participants will learn how to model and integrate the income statement, balance sheet and cash flow of a real company using Excel. In addition to learning the steps necessary to build a three statement financial model, participants will also cover how to build models accurately and efficiently through a series of best practice modeling rules. Participants also learn how to stress-test the assumptions used, to check their work efficiently and to document it.

  • Using keyboard shortcuts
  • Setting Excel up for maximum efficiency
  • Working with key modeling formulas and structures
  • Building 3-statement projections
  • Modeling cash and revolver
  • Addressing standards for good models
  • Constructing the income statement, balance sheet and cash flow statement
  • Introduction to checking methodologies
  • Performing audit trails
  • Incorporating interest income and expense

Session 2

Three Statement Modeling

Through the process of building a more complex three statement model, participants are taught how to model operating cash and calculate interest using average debt and average cash balances. The session is designed to expose participants to different three statement modeling styles: multi-sheet, tower, and different income statement layouts. Exposure to a mix of modeling styles will help prepare them to work on in-house models or models they may inherit from other finance professionals.

  • Modeling operating cash, excess cash and the revolver
  • Calculating interest on cash and debt balances
  • Working with intentional circular references
  • Avoiding non-intentional circular references
  • Building models with different styles and layouts
  • Calculating ratios

Session 3

Financial Modeling & Forecasting

Participants 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.  Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

  • Complex 3 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

Session 4

Integrity & Error Checking

Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.

  • Troubleshooting techniques for cash flow statements
  • Finding errors and integrity checking
  • 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

Please contact us today to discuss the best programme which can help you achieve your objectives.

City Training UK
100 Pall Mall
Saint James
London SW1Y 5NQ
United Kingdom
+44 (0) 203 815 6530