This Euromoney Training course will provide you with the skills you need to improve the reliability and quality of your decision-making. Modelling techniques are used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, financial analysis and forecasting. Banks and businesses worldwide rely on the information produced by financial models and consequently, reliable modelling is inextricably linked to market success. When looking at any financial opportunity the ability to perform accurate and realistic analysis is imperative. In today's ever-changing business environment having the capability to write simple spreadsheets is not enough. You ought to be able to incorporate the range of "what if" scenarios and thus stress any proposal to its limits, this expert programme with ensure you have the confidence to do this.

How will this course assist you?

Learn how to construct different financial models and analyse their applications and uses. In only 3-days this course will ensure you can:

• Understand the different types of financial models and when each should be applied.
• Construct financial models making use of a broad range of Excel methods and techniques.
• Incorporate elements such as risk, sensitivity, optimisation and forecasting into financial models.
• Produce meaningful management reports and charts for communication.

Who Should Attend?

This is a course for analysts and practitioners who want to improve their modelling skills, including:

• Financial Analysts
• CFO's
• Financial Controllers
• Analysts
• Accountants
• Credit Managers
• Treasury Managers
• Risk Managers
• Middle Office staff
• Mergers, Acquisitions and
• Buyout specialists
• Corporate finance staff

Supported by:

Day 1

Registration commences at 8:30
Programme runs from 9:00 - 5:00 daily

Introduction

• Overview of the course.
• Scope of modelling.
• Objectives of modelling.
• Different models by application.
• Useful Excel features.
• Listing of modelling techniques.
• Exercise: model review.

Building a model I

• Model design and structure – key steps.
• Exercise: defining a model plan.
• Model objective.
• Flowchart and information flow.
• Defining outputs.
• Defining inputs and variables.
• Setting up modules.
• Menu structure.
• Help.
• Documentation.
• Example: financial analysis model.

Building a model II

• Testing and auditing a model.
• Example: testing a financial analysis model with cashflows and ratios.
• Exercise: debugging a financial model.
• Exercise: investment analysis 1.
• Investment model exercise.

Day 2

Risk scenarios and simulation

• Forecasting models

• Review of forecasting methods.
• Macro forecasting.
• Linear methods.
• Smoothing techniques.
• Seasonal forecasts.
• Multiple regression.
• Example: adding a forecast to a financial analysis model.

Risk techniques

• Understanding risk.
• Sensitivity table.
• Scenario analysis.
• Dynamic what-if.
• Standard deviation and coefficient of variation.
• Certainty equivalents
• Example: adding risk techniques to financial analysis / valuation model.

Risk and simulation

• Building a simulation model.
• Monte Carlo simulations.
• Example: financial analysis model.
• Exercise: investment analysis II.
• Adding sensitivity to the investment model.

Day 3

Optimisation and reporting

Optimisation and targeting

• Overview of optimisation and targeting.
• Goal seek method.
• Optimisation using solver.
• Linear programming.
• Example: financial analysis / valuation.
• Example: investment analysis III.
• Extend the investment model and calculate optimum net present value.

Management reporting

• Management summary.
• Reporting.
• Consolidations.
• Summary and pivot tables.
• Example: monthly management model.
• Example: consolidation model.
• Exercise: management reporting and forecasting.
• Analysis of company financial data.
• Exercise: produce a management summary report with charts.

Course summary and close

• Alastair Day

  Alastair is a finance professional with extensive experience of business analysis systems, accounting, funding and treasury activities. As a Director of Technology Group Limited, he was responsible for establishing the treasury function and modelled large transactions for evaluation and lease portfolio acquisition.
  
  As an alternative to flotation, the directors subsequently sold the company to a public financial services group. Alastair established an independent lessor and consultancy. He has conducted a range of modelling and consulting assignments producing models for financial analysis, valuation, mergers, buyouts, projects and data analysis.
  
  In addition, Alastair works as a consultant with Euromoney Training in Europe, Asia, Middle East, Africa and America, designing and delivering courses covering financial modelling from general modelling to specific valuation, leasing and other courses.
  
  Alastair has a degree in German and Economics from London University and an MBA from the Open University Business School. He is an associate lecturer at the Open University Business School and has written a number of books and publications.

  Courses run by this instructor

  • Advanced Lease Finance - UK

Financial Modelling in Excel

Interested in holding this course in-house? Please fill out your details and a member of our team will be in touch with more information.

Company Analysis: Valuation, Forecasting and Modelling

12-16 Mar 2012 (London, UK)
2-6 Jul 2012 (London, UK)
3-7 Dec 2012 (London, UK)

This 5-day course will provide you with a wide range of fundamental analytical and forecasting skills, which will be of relevance in today's business, banking and financial services world.

London School of Corporate Finance

23-27 Apr 2012 (London, UK)
1-5 Oct 2012 (London, UK)

A 5 day practical "how to" financial training course taught by an internationally renowned corporate finance expert. The course takes you through all the forms of Corporate Finance from M&A to IPO's to LBO's. Strategy, structuring and valuation are key themes throughout, and upon return to your organisation you will be fully prepared to put your learning into practice.

Private Equity

25-27 Jun 2012 (London, UK)

This 3-day financial training course is about analysing, valuing and financing private equity deals

Mergers and Acquisitions

21-24 Aug 2012 (London, UK)

A 4-day training programme looking at structuring and financing M&A deals

Advanced Company Analysis Valuation and Financial Modelling

20-24 Feb 2012 (London, UK)
17-21 Sep 2012 (London, UK)

A 5-day case study based workshop covering advanced fundamental analysis and forecasting skills

Mergers & Acquistions Modelling

22-25 May 2012 (London, UK)

This 4-day comprehensive modelling course is designed to teach delegates the best practices of developing and using M&A financial models as well as analysing, pricing and structuring LBO transactions.

IPOs: Managing, Underwriting and Pricing

3-6 Jul 2012 (London, UK)

A 4-day intensive programme about arranging, managing and pricing successful IPO's

Oil & Gas Valuation

14-17 Feb 2012 (London, UK)

This 4-day course provides the necessary practical skills to model and value oil and gas companies, from the perspective of an investor, an equity analyst or as part of a corporate transaction.

 

Comments