Financial Modelling and Project Finance for Professionals

Financial Modelling and Project Finance for Professionals

Course Date: 18th & 19th May 2023

Online + Live Streaming

Gulf Standard Time: 09:00 am – 3:00 pm

Singapore & Malaysia Time: 01:00 pm – 07:00 pm

Course overview

This intermediate-advanced level course will focus on the tools and techniques available in Microsoft Excel which will enable you to develop, run, and review financial models across multiple scenarios. You will gain a sound and practical insight in forecasting financial statements over five and ten year periods.

Throughout this course, you are encouraged to work on and develop solutions to your work based financial modeling challenges:

  • Discover how to save more time and work even faster with a financial model
  • How to automate tasks and processes
  • Gain frameworks to know with confidence your models are reliable and robust
  • Extend the breadth of your financial modelling expertise by ensuring you are up to date with the latest thinking in Excel, modelling and forecasting

Course Objectives

By the end of this course, you will be able to:

  • Analyse financial statements using modelling
  • Create a Budget and to make changes to different scenarios
  • Develop a model for investment decision
  • Create a sensitivity analysis model
  • How to use more advanced Excel functions that will allow faster model development and provide greater reliability.
  • Sophisticated methods of data analysis and visualisation that present information easily or highlight anomalies and areas of interest
  • Techniques for working with time series in models that allow automated date generation and summarisation at any level
  • Best practice guidelines and spreadsheet modelling standards: learn how to create models like the professionals do!
  • Advanced techniques for sophisticated model optimisation
  • How to apply the new features of Excel to increase advanced financial modelling productivity: for example, dynamic array functions

About Course Facilitator:

Our Finance Coach is an author, trainer, and business consultant specializing in Financial and Management Accounting. His international experience includes projects and consultancies carried out in the Middle East, Africa, Central Asia, South Asia, the Caucasus, the Balkans, Central Europe, and Denmark.

Some of Duncan’s clients include:

  • British Airways
  • Saudi Aramco
  • Kuwait Petroleum Corporation
  • Dubai Ministry of Finance
  • Zakum Development Company (ZADCO)
  • Mark and Spencer
  • Petrozim Line Pvt Ltd Zimbabwe

Who should attend?

  • Financial directors and managers
  • Financial controllers
  • Risk managers
  • Credit manages
  • Financial and management accountants
  • Financial project administrators
  • Project finance professionals
  • Financial planners
  • Anyone responsible for or involved in financial modelling
Day – 1
Application and Interpretation of Excel’s Functions
• Financial
• Mathematical
• Statistical
• Logical
• Security Prices and Yields
• Dynamic Array
Investment Decisions
• Calculating the NPV, XNPV, IRR, MIRR, XIRR, Profitability Indices and payback period
• Sensitivity Analysis for a Business Case
• Developing and Managing Scenarios
Advanced Modelling Techniques

• Using probability weighted sensitivity analysis as a proxy for stochastic simulation
• Multiple methods for automated S Curve allocation of capital budget expenditures
• Managing multiple capital budget projects
• Easy ways to perform depreciation modelling
• Debt modelling: senior debt, mezzanine finance and hybrid instruments
Reviewing Financial Statements

Income Statement
Balance Sheet
Statement of Cash Flow
• Terminology and Formats
• Reading a financial report
Financial Statement Analysis

• Analysing
—– Profitability
—– Return
—– Liquidity
—– Asset Usage
—– Cash Flow
—– Investor
• Common size statements
• Growth ratios
Day – 2
Forecasting Financial Statements
Forecasting techniques
• Simple averages
• Weighted averages
• Forecasting Functions
• Linear and non Linear Regression
• Exponential Smoothing
• Forecast Sheet
• Time Horizons
• Limitations
Business Intelligence 1
• Introduction to
—– Power Query
—– Power Pivot: the Data Model
• Comprehensive illustration of the application of business intelligence
—– Importing data
—– Cleaning and manipulating data
—– Creating Power Pivot tables
—– Enhancing the pivot tables and resulting reports with Cube functions
Leasing, Risk Assessment and Simulations
Financial Analysis of Leasing
• Leasing and Firm Financing
• The Equivalent Loan Method
• The Lessor’s Problem Calculating the highest acceptable lease rental
• Asset residual value and other considerations
Risk Modelling
• The risk modelling process
• Defining risk and risk analysis
• Building a Risk Model
Monte Carlo Simulations
• Continuous and discrete distributions
• Density and Cumulative Curves
• Measures of the central point
• Measures of Spread and of Risk
• The nature and examples of Monte Carlo Simulations
• Interpreting Basic Monte Carlo Simulation outputs