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