Financial Modelling in Excel

An intensive 3-day, computer based practical training course with case studies and worked examples. With a step-by-step approach, this course will guide you through the various techniques available, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can be practically applied through the use of Excel.

  • Course Instructor

     


An intensive 3-day computer based practical financial modelling in Excel training course with case studies and worked examples, featuring how to:

  • Design and structure different models and translate them into Excel
  • Calculate free cash flow
  • Use Monte-Carlo simulations
  • Identify decision trees - problems and solutions
  • Develop models incorporating risk, sensitivity, optimisation and forecasting using solver

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

  • Know the different types of financial models and when each should be applied
  • Be able to design models and translate these in Excel
  • Be able to develop models for their own use, incorporating elements such as risk, sensitivity, optimisation and forecasting

Course background

Financial modelling techniques allow users to improve the reliability, quality and timing of their decision making. Modelling techniques are now used in many different areas, such as investment appraisal, capital planning, budgeting, valuation and financial analysis and forecasting. With a step-by-step approach, this course will guide you through the various techniques available, providing you with a comprehensive understanding of advanced modelling, as well as how each technique can be practically applied through the use of Excel.

Course structure

The course starts by focusing on the advanced use of Excel in modelling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimisation and forecasting into the models. With the help of the course director and through a proven step-by-step approach, delegates will then construct models of different types. Delegates will leave this intensive three-day course with the ability to effectively apply modelling techniques in Excel in a wide range of practical scenarios.

Who should attend

This course has been designed for:

  • CFOs
  • Financial controllers and managers
  • Financial and business analysts
  • Risk managers
  • Accountants
  • Corporate treasury managers
  • Middle office staff
  • General managers



 
Euromoney Training is part of the Euromoney Institutional Investor PLC group of companies.
Click here for more details on our group's activities and how we will use your information.
By submitting your details, you will be indicating your consent to the use of your data as described.

Your marketing choices
Please tick if you don't want to receive offers from our group companies by:
or from Companies outside our group
By submitting this form you agree to the Privacy Policy & Terms and Conditions.
Close
Euromoney Institutional Investor PLC group companies provide a range of business to business products and services. These are focused on international finance, metals, commodities, telecoms, law, tax, insurance, energy, transport and emerging markets. Products and services include magazines, newsletters, books, directories, electronic information and data, training, seminars and conferences. Full details are available at www.euromoneyplc.com

We will use the information you provide here to process your order/registration/request including communicating with you about it. If you are registering for a trial, you will receive follow up emails and/or a telephone call about your trial. As part of the trial, you may also receive email updates and other features as specified for that product. We may monitor your use of our website(s). As an international group, we may transfer your data on a global basis. Subject to your choices on the form, we may also use your data for marketing purposes. Further information is set out in our privacy policy on this site.

Close