Financial Modelling: 2-3 Day Workshop

Objective

Financial modelling techniques allow users to improve the reliability, quality and timeliness of their corporate decision making. This Microsoft Excel® spreadsheet-based workshop introduces attendees to various techniques in investment appraisal, capital planning, budgeting, valuation and financial analysis, and forecasting.

Our workshop is based on practical and interactive case studies and worked examples. Attendees gain practical experience of the design and construction of Microsoft Excel® financial models that emphasise the concepts of risk, sensitivity, optimisation and forecasting.

Basics of Modelling and Overview

Workshop overview
Scope of modelling
Objectives of modelling
Different models by application:

  • Macroeconomic
  • Industry
  • Corporate finance
  • Specialised

Different models by technique:
  • Deterministic
  • Risk and Sensitivity
  • Simulation and scenarios
  • Decision trees
  • Optimisation and targeting
  • Forecasting
  • Econometric
  • Specialised models (eg options pricing)

Building a Model

Model design and structure – key steps:

  • Objectives
  • Flowchart
  • Setting up modules
  • Testing

Deterministic Models

Time value of money (TVM) and cash flows
Financial calculator
Discounted cash flows
Accounting and finance models (eg project finance)

Company Valuation

Concepts and problem issues – cost of capital, Capital Asset Pricing Model (CAPM)
Calculating free cash flows
Weighted average cost of capital

Risk and Sensitivity

Understanding of risk
Sensitivity
Scenario ("what-if") analysis
Standard deviation and coefficient of variation
Certainty equivalents

Optimisation and Forecasting

How to achieve a specific target
Goal seek
Optimisation using Excel "Solver"
Integer programming
Targeting
Forecasting and Econometric Models:

  • Forecasting
  • Simple linear
  • Simple exponential
  • Multiple regression
  • Regression statistics
  • Non-linear trend forecasts
  • Seasonal forecasts
  • Econometric

COPYRIGHT © OAKBRIDGE LIMITED 1998-2020


Leading Cloud Surveillance, Recording and Storage service; IP camera live viewing

Leading Enterprise Cloud IT Service; cloud file server, FTP Hosting, Online Storage, Backup and Sharing

Powered by FirstCloudIT.com, a division of DriveHQ, the leading Cloud IT and Cloud Surveillance Service provider since 2003.