Financial Modelling and Project Finance for Professionals
Course Date: 18th & 19th May 2024
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
- SABIC
- Petrozim Line Pvt Ltd Zimbabwe
- ADNOC
- Amazon.com
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 |