Advanced Financial Modeling with Business Intelligence
- City: kuala lumpur
- Date: 15 APRIL - 16 APRIL
Workshop
Advanced Financial Modeling with Business Intelligence
15 -16 April 2018 Grand Millennium Hotel, Kuala Lumpur, Malaysia
06 - 10 May 2018 : Istanbul
24 - 28 Jun 201 8 : Jakarta
08 - 12 Jul 2018 : Singapore
Workshop Overview
This 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 financial modeling building, comparison of financial values and evaluation of financial risks.
Key benefits of attending this workshop
- 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
Who Should Attend?
This workshop will be of particular interest to banks, corporate financiers, accountants, financial modellers and consultants faced with such corporate finance decisions, including:
- CEO / CFO / COO / Finance Directors / Financial Controllers / Heads of Finance
- Financial Analysts
- Directors / Heads / Managers of Strategic Planning
- Directors / Heads / Managers of Business Development
- Financial / Equity / Treasury Analysts
- Project Managers
- Project Financiers and Lenders
- Accountants and Auditors
- Financial controllers
- Risk managers
- Credit manages
- Financial and management accountants
- Financial project administrators
- Project finance professionals
- Financial planners
Why you Should Attend?
There are many financial modeling 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 modeling with business intelligence. Business Intelligence includes Power Query and Power Pivot technologies that are built into Microsoft Excel now and we will also be introducing you to Microsoft’s free Power BI software. Together Power Query, Pivot and BI are taking the business intelligence world by storm.
We will take you by storm too. Millions of rows analyzed, 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 fi rst 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!
DAY1
Session 1Working 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 amazon.com, Apple and Google
Session 2 Budget Models
- Preparing the Functional Budgets:
- Revenue
- Expenses
- Inventory
Forecasting and Projections models: historic, trend lines. Key drivers in forecasting financials
Session 3 Variance analysis and breakeven analysis
- Budget variances
- Cash flow budgets
- Monthly cash model
- Breakeven analysis in theory and in practice
Case: variance analysis is crucial to a full understanding of the financial results of an organisaon 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
- Importing data
- Cleaning and manipulating data
- Creating Power Pivot tables
Case: get external data just became one of the most important things I can do at work … say why this is true in your presentaon to your CFO as you bid for addional funds for training in Business Intelligence for you and your staff
Day 2
Session 1 Capital Budgeting, Risk Assessment and Simulaons
- 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 ficon isn't it; aer all the WACC doesn't actually exist
Session 2 Risk2 Modelling
- The risk modelling process
-Defining risk and risk analysis
- Building a Risk Model
Case: Roll the dice, toss the coins, choose some random numbers, however you play it Monte Carlo Simulaons are a very power ally in the quest for greater certainty in business
Session 3 Monte Carlo Simulaons
- The nature and examples of Monte Carlo Simulations
- The Profit simulations
- Capital Budgeting simulations
Interpreting Monte Carlo Simulation outputs
Case: Roll the dice, toss the coins, choose some random numbers, however you play it Monte Carlo Simulaons are a very power ally in the quest for greater certainty in business
Session 4 Business Intelligence
-Comprehensive illustrating the application of business intelligence
-Enhancing the pivot tables and resulting reports withPower BI
-Introduction to DAX
-Calculated columns
-Measures …
--CALCULATE()
--PREVIOUSQUARTER()
--SUM()
--AVERAGE()
--RELATED()
Case: Use Power Pivot technology to analyse the 200,000 rows of data your marketing people are collecting every week … are you joking? No! Just do it!!
Schedule
08:30 Registration and coffee
09:00 Workshop commence
10:30 Networking break (Refreshment)
10:45 Workshop re-commence
12:15 Networking lunch
13:30 Workshop commence
15:00 Afternoon refreshment
15:15 Workshop re-commences
16:45 Workshop concludes
Fees
The Fee for the Workshop, including instruction materials, documentation, lunch, coffee/tea breaks & snack :
- Us$ 2,000 per person – Kuala Lumpur