Advance Financial Modelling, Project Financing & Budgeting Forecasting with Power BI
- 23 - 24 January, 2024
Schedule
Session 1: Working with 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
Case: From the financial reports you have been given, summarise your understanding of the success or otherwise of almost any company eg Apple, google, Petronas … for spreadsheet modelling has to be useful for budget preparation
Session 2: Budget Models
- Preparing the Functional Budgets:
- Forecasting and Projections models: historic, trend lines.
- Key drivers in forecasting financials
Case: review the idea that using best practice standards for spreadsheet modelling has to be useful for budget preparation.
Session 3: Statistical Analysis of Data 1
Case: variance analysis is crucial to a full understanding of the financial results of an organisation at the end of a period.
Case: break even analysis only works with accountants who can only think in straight lines … is that true?
Session 4: Business Intelligence 1
- Introduction to
- 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
- Investment Decisions
- Calculating the NPV, XNPV, IRR, MIRR, XIRR, Profitability Indices and payback period
- Sensitivity Analysis for a Business Case
- Developing and Managing Scenarios
Case: What do you think of this, from Norman the recent graduate: the cost of capital is a fiction isn’t it; after all the WACC doesn’t actually exist
Session 2: Risk Modeling
- The risk modelling process
- Defining risk and risk analysis
- Building a Risk Model
Case: the riskiest thing in the world is trying to model your risk and then believing in and using the results of your efforts … true or false!
Session 3: Dynamic Array Functions and Business Simulations
- The new Dynamic Array Functions
- Cost and Profit simulations
- Capital Budgeting simulations
- Interpreting Simulation outputs
Case: Roll the dice, toss the coins, choose some random numbers, however you play it these Business Simulations are a very power ally in the quest for greater certainty in business
Session 4: Business Intelligence 2
- Comprehensive illustrating the application of business intelligence
- Importing data
- Cleaning and manipulating data
- Creating Power Pivot tables
- Enhancing the pivot tables and resulting reports with Power BI
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.
popular links
Contact Us
- 1630 Connecticut Ave Washington District Of Columbia DC 20009
- info@bizrevgroup.com
- +92-345-3185381