Financial Intelligence: Project Financing, Modelling & Forecasting with Power BI Integration

Overview

This course is a mixture of toolbox and practical application through case studies of real-world problems using real world data. This course will focus on the tools and techniques available in Microsoft Excel and Power BI that will enable you to develop, run and review financial models across multiple scenarios.

By toolbox, we mean using the techniques, functions and formulas to solve business and financial problems. By practical application we mean that we provide delegates with a case or exercise that uses data from a real situation and that we consider from start to finish to solve a problem, create a workable template or resolve the case in some way. There are many financial modelling courses on the market these days and you might already have attended one or more of them. In this course, however, we are introducing you to financial modelling with project finance.

In project finance we discuss the nature of a project from the financial standpoint, including an assessment of the various aspects of risk. This includes project appraisal, project costs, project cash flows and cash flows through the waterfall. We will take you by storm too. Potentially, millions of rows analysed, eye catching dashboards have never been so easy to construct and share.

In addition, we are also including the mainstay topics for revision or for review for the first time. Every financial and non financial manager is welcome to attend this course and once you have seen what we are offering, you will definitely want more!

Benefits of attending

By the end of the workshop, delegates 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
MANAGE existing financial proposals to deliver the best returns
CREATE Business Intelligence reports and analysis
APPLY and EVALUATE aspects of IFRS techniques and methodologies

Schedule

Day 1
Day 2

Session 1: Working with Financial Statements Income Statement, Balance Sheet and Statement of Cash Flow

Terminology and Formats
Reading a Financial Report
Analysing
Profitability
Return
Liquidity
Asset Usage
Cash Flow
Investor
Common Size Statements
Growth Ratios

Session 2: Budget Models

Revenue
Expenses
Inventory
Forecasting & Projections Models: historic, trend lines
Develop key drivers in forecasting financials

Session 3: Statistical Analysis of Data 1

Golden Rules of Data Analysis
Ordinary Least Squares Regression Analysis
Multiple Regression Analysis
Apply the techniques to forecasting models and in setting standards and KPIs

Session 4: Business Intelligence 1

Introduction
Power Query
Power Pivot
Power BI

Session 1: Capital Budgeting, Risk Assessment and Simulations Calculating the Cost of Capital

Using the CAPM to determine the Cost of
Equity
Calculating the Cost of Debt
Computing the WACC
Calculating the NPV, XNPV, IRR, MIRR, XIRR, Profitability Indices and payback period
Sensitivity Analysis for a Business Case
Developing and Managing Scenarios

Session 2: Statistical Analysis of Data 2

Further work on multiple regression analysis
Non Linear regression analysis using LINEST and
LOGEST

Session 3: Monte Carlo Simulations

The nature & examples of Monte Carlo Simulations
Profit simulations
Capital Budgeting simulations
Interpreting Monte Carlo Simulation outputs

Session 4: Project Finance

How do investors analyse an investment?
Why has (infrastructure) investment increasingly taken on the form of project finance?
Why is there a specialized area for project finance?
Types of Risks
Commercial risks
Interest rate risks
Inflation Risks
Exchange rate risks
Regulatory and Political risks
Sensitivity Analysis and Downside Risk Analysis
Model inputs and Outputs
Model Architecture
Typical Inputs
Project costs
Operating cash flows
Debt service capacity

Trainer's Profile

Your course leader, Mr. Duncan Williamson, 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. He combines his extensive academic and training experience with significant manufacturing and commercial work.

He has published widely over the years and his publications listing includes an online series published by www.bookboon.com entitled Excel Solutions for Accountants (in preparation); a Self-Paced Study Text for non-accounting managers entitled The Bookkeeping and Accounting Coach, published by Hodder and Stoughton; a textbook on Cost and Management Accounting published by Prentice-Hall, eBooks on a variety of accounting topics, numerous.

At its core BIZREV is a global business to business event company that has embraced the digital age. We create a blend of live & digital events that drives corporate innovation.