Financial Modelling in Excel

This course is being finalised. Join the waiting list to be the first to attend Download brochure Join Waiting List
This course is being finalised. Join the waiting list to be the first to attend Download brochure Join Waiting List

* Claim back your VAT
Find out more

Overview

Featuring:

  • Model design and structure
  • International spreadsheet best practice
  • Testing and auditing a model
  • Forecasting techniques
  • Sensitivity and risk
  • Optimisation and targeting
  • Management dashboards and reporting

On completion of this 3-day training programme delegates will be able to:

  • Understand the different types of financial models and their application
  • Construct models that are robust and scalable
  • Incorporate elements such as risk, sensitivity, optimisation and forecasting into models
  • Produce management reports, summaries and meaningful charts


Course Structure
Day 1: Overview of modelling techniques
Day 2: Forecasting, risk and scenarios
Day 3: Optimisation, data analysis and reporting


Teaching Methodology
The programme is taught using demonstrations combined with practical and interactive case studies. The exercises in each session reinforce the concepts covered in each 0f the units. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Comprehensive product notes and modelling software are provided for future reference.


Course Background
When looking at any financial opportunity, the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment, the capability to just manipulate spreadsheets is not enough. You have to be able to incorporate all the “what if” scenarios and stress test any proposal to its limits. A working financial model can facilitate and 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 – for many it is the key to success.
The course begins by concentrating on the advanced use of Excel. These skills will be applied to the construction of financial, valuation and investment models. Delegates will then learn how to incorporate forecasting, optimisation, risk assessment and sensitivity scenarios into these models.
The course is taught using a step-by-step approach so delegates will be able to construct financial models for a wide range of practical scenarios.

 

Venue

Venue to be confirmed

All our courses are held in 4 or 5 star city centre hotels. Further details will be sent on registration.

Related Courses

Inhouse


 

Do you have five or more people interested in attending this course? Do you want to tailor it to meet your company's exact requirements? If you'd like to do either of these, we can bring this course to your company's office. You could even save up to 50% on the cost of sending delegates to a public course.

To find out more about running this course in-house:





Our Tailored Learning Offering

If you want to run this course at a location convenient to you or if you want a completely customised learning solution, we can help.

We produce learning solutions that are completely unique to your business. We'll guide you through the whole process, from the initial consultancy to evaluating the success of the full learning experience. Our learning specialists ensure you get the maximum return on your training investment.

inhouse-learn-more

We can offer any of our public courses delivered at your office or we can devise completely tailored solutions:


Read more about our offering or complete a call back request to speak to a learning specialist.

 

Agenda


Day 1: Overview of Modelling Techniques


Module 1: Introduction and Overview

  • Outline of financial modelling
  • Examples of Excel financial models
  • Useful Excel features and techniques
  • Exercise: analysing examples of modelling techniques

 
Module 2: Spreadsheet Best Practice

  • Model design and structure – key steps
  • Financial analysis basics – financial statements
  • Cash flow and ratios
  • Case outline - introduction
  • Exercise: Defining a model plan for a financial analysis model
  • Model design
  • Exercise: Techniques for modelling financial statements

 
Module 3: Auditing and Testing

  • Examples of spreadsheet errors
  • Essential testing and auditing techniques
  • Example: testing financial analysis model with cash flows and ratios
  • Exercise: debugging and checking a financial model

 
Module 4: Practical – Project Model 1

  • Practical project model exercise
  • Questions and answers

 

Day 2: Forecasting and Risk

 
Module 5: Macros and Security

  • Visual Basic in Excel
  • Writing and auditing and macros
  • Spreadsheet security
  • Exercise: writing and auditing macros


Module 6: Forecasting Models and Time Series Analysis

  • Review of forecasting methods
  • Understanding financial ‘drivers’ for analysis, valuation and project models
  • Exercise: deriving forecast free cash flow and ratios
  • Linear methods
  • Smoothing and seasonality
  • Exercise: producing a forecast with time series analysis

 
Module 7: Risk Techniques

  • Valuation model and cost of capital fundamentals
  • Exercise: calculating the cost of capital
  • Risk and multiple answers
  • Scenario techniques
  • Advanced financial functions
  • Exercise: Producing a valuation and testing the results


Module 8:
Practical – Project Model 2

  • Review of initial answers and identification of potential risks
  • Adding risk techniques to the project model in module 4
  • Questions and answers
     
     

Day 3: Optimisation and Reporting 

  
Module 9: Optimisation and Targeting

  • Overview of optimisation and targeting
  • Goal seek and Solver methods
  • Example: targeting using the composite valuation model

 
Module 10: Practical – Project Model 3

  • Extend the project model to answer management questions and target specific results
  • Completing and auditing the project model


Module 11: Management Reporting

  • Requirement to consolidate and summarise data
  • Exercise: consolidating data from different sources
  • Excel report manager
  • Exercise: pivot tables
  • Techniques for summarising data
  • Exercise: producing a management analysis

 
Module 12: Practical - Management Reporting and Forecasting

  • Analysis of company financial data
  • Exercise: extend the valuation model to produce a meaningful management summary report with charts
  • Questions and answers

 
Course summary and close

Why us


We have a combined experience of over 60 years providing learning solutions to the world’s major organisations and are privileged to have contributed to their success. We view our clients as partners and focus on understanding the needs of each organisation we work with to tailor learning solutions to specific requirements.

We are proud of our record of customer satisfaction. Here is why you should choose us to help you achieve your goals and accelerate your career:

  • Quality – our clients consistently rate our performance ‘excellent’ or ‘outstanding’. Our average overall score awarded to us by our clients is nine out of ten.
  • Track record – we have delivered training solutions for 95% of worlds’ top 100 banks and have trained over 250,000 professionals.
  • Knowledge – our 150 strong team of industry specialist trainers are world leading financial leaders and commentators, ensuring our knowledge base is second to none.
  • Reliability – if we promise it, we deliver it. We have delivered over 20,000 events both in person and online, using simultaneous translation to delegates from over 180 countries.
  • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 96% on service and 95% on product