certified course: financial modelling

Financial modelling is the umbrella term used for a set of practical skills, techniques, methodologies and disciplines used to create a graphic analytical tool. This tool is used to aid understanding and decision making in areas such as financial planning, investment analysis, valuation and strategy.

The modern business environment now expects everyone to have at least basic Excel skills; to stand out, finance professional needs to have more than just the ability to use a spread-sheet in their arsenal. The skills required to develop quality financial models are highly sought after in the marketplace and provide a tangible advantage to a business career.

At Capworth Training you will learn essential, best practice financial modelling techniques, and how to apply them in different situations, giving you the confidence and ability to develop sophisticated financial models.

Module Learning Objectives

On completion of this highly practical, hands-on training course, attendees will be able to:

  • Build a financial model from a blank sheet
  • Design models which minimise errors
  • Write models which can be maintained and augmented in the future
  • Develop models with advanced techniques such as risk, sensitivity, optimisation and forecasting 

Course Outline

  • Excel basics and the basics of design: ten essential Excel shortcuts; design principles; key elements of model structure; group edit tools.
  • Building the framework: setting up the model structure; input versus formulae conventions; absolute versus relative references;
  • Building the schedules: using naming conventions; using 'corkscrews' and 'BASE' calculations; using 'if' to create flexibility; operations schedule; fixed-asset schedule.
  • Building the debt schedule: a simple approach to debt; using 'if' to solve more complex problems; using the function wizard.
  • Balancing - straight away: integrating the financials and balancing the balance sheet as we go - a stepwise approach; building in a balance check; a structured approach to model development.
  • Cash flows: linking cash from operations; linking fixed assets and financing; implementing some simple checking calculations.
  • Tax and valuation: modelling UK corporate tax in more detail; tax loss schedules; valuation and related functions; building the valuation module.
  • Analysis and presentation: dynamic labelling/text strings; number formatting; Excel's handy analytical tools - data tables; goal seek; print management
  • Building a Model
  • Income Statements and Balance sheets
  • Introduction to Sensitivity Analysis
  • Introduction to DCF Valuation
  • Graphics & Data Tables
  • Model Structure and Planning
  • Financial Analysis and Valuation
  • Non cash flow methods
  • Forecasting and Equity Valuation
  • Free Cash Flows
  • Cost of Capital
  • Initial Equity Valuation
  • Alternative Cash Flow Valuation
  • Risk and Sensitivity
  • Optimum Structure and Targeting
  • Management Reporting and Model Review

Who Should Attend?

The course will be of value to professionals in the following areas:

  • Finance Directors/Financial Controllers/CFO’s
  • Business/Financial/Treasury/Market Analysts
  • Corporate/Structured/Project Finance Officers
  • Financial/Strategic Planners
  • M&A Specialists
  • Private Equity
  • Project/Commercial Management
  • Business Development and Marketing
  • Systems Analysts
  • Budget Managers
  • Profit Centre Managers
  • Credit Risk/Treasury Managers
  • Actuaries

 

The Capworth Training team will take steps to ensure that in house programmes are run at a time that suits you. Contact our client liaison team corporate@capworthtraining.com to discuss running this programme in house.

Location: London

Dates: 20th June – 1 st July 2016

Contact Capworth for price details.