Open Courses

Financial Modelling and Decision Making

F11

Introduction

Modern managers need to possess and master a variety of short and long-term financial decision-making techniques.  This course will explore these techniques through a series of practical scenarios which illustrate how they can be used in the business environment.  Excel is used extensively to develop a range of financial models to demonstrate technique application. The course will further explore the incorporation of risk and uncertainty into the decision-making process by using more advanced Excel, and will also explore scenario modelling and sensitivity analysis using Excel.

Who should attend

This practical and interactive course is aimed at managers working in a variety of positions. Financial decision makers wishing to develop their Excel skills would benefit from this course.  Delegates wishing to attend should be competent in the use of Excel as the course is designed to improve delegates’ ability to use Excel to make decisions rather than to teach delegates to use Excel.

COURSE PROFILE

 Short-term Financial Decision Making Using Excel

  • Short-term financial decision making and its uses
  • Approaches to short-term financial decision making
  • Using Excel to improve short-term financial decision making

 Modelling Capital Investment Decisions Using Excel

  • Approaches to capital investment decisions
  • Relevant cash flow and investment decision making
  • Using excel to refine investment decision making

 "What If" Analysis and Scenario Modelling

  • Changing the parameters of a financial model
  • Sensitivity Analysis
  • Using Excel to support scenario modelling

Decision Making under Risk and Uncertainty

  • The impact of risk and uncertainty on decision making
  • Incorporating risk and uncertainty into decision making
  • Using Excel to model risk and uncertainty

Modern Reporting Techniques

  • Using modern dashboards
  • Creating a rapport using KPIs
  • Excel presentation of results
SKILLS

At the end of the course delegates will be able to:

  • Understand different approaches to decision making
  • Make short term financial decisions
  • Develop Excel models to support short term decision making
  • Understand different approaches to investment appraisal and the use of Excel to support these decisions
  • Use sensitivity and "what if" analyse to explore the impact of changing scenarios on decision outcomes
  • How to incorporate risk and uncertainty into decision making
  • How to build Excel spreadsheets to model risk and uncertainty and support sensitivity analysis
  • Understand reporting presentation, using modern dashboards
  • Implement the use of Key Performance Indicators
COMPETENCIES
  • Capital Investment
  • Capital Investment Analysis
  • Dashboard
  • Decision Making
  • Finance
  • Financial Modelling
  • MS Excel for Finance
  • Risk Management
  • Scenario / What If Analysis
  • Scenario Planning
  • Setting Key Performance Indicators (KPIs)
BOOKING

VAT: Courses held in London are subject to VAT at the current rate