Analytical thinking & predictive financing modeling - Workshop 2020

This workshop is available in Kuala Lumpur (14 and 15 May). This workshop will guide you step by step using simulation approach to manage & report business intelligence of profit & cash flow, investment, budgeting processes & read financial statements in a dashboard manner.

My Offerings

Overview

For REP’s, Member staff and Group (3+) registrations, complete & email registration form to cpd.malaysia@cpaaustralia.com.au

Download brochure & registration form

  • Save 10% when you register online at least 1 month prior to the workshop date

 Presenter (s):

Dr Steven Liew

This workshop will guide you step by step using simulation approach to manage & report business intelligence of profit & cash flow, investment, budgeting processes & read financial statements in a dashboard manner. Free practical well tested Financial Modelling - Reports & Dashboard excel templates are provided using pivot table, Goal Seek & Solver

Key topics covered:

  • Module 1-2: Excel Dashboard for Financial Performance (Simulation exercise)
  • Module 3: Excel Dashboard for Cash Flow Statement (simulation exercises)
  • Module 4: What Excel skills are most valuable for finance and accounting?
  • Module 5: Excel Dashboard for Working Capital Management (Simulation Exercises)
  • Module 6: Excel dashboard on Financial Ratios Analysis (Simulation on Real Listed Companies Case Studies)
  • Module 7: Excel Dashboard for Investment Appraisal (simulation Case Study)  
  • Module 8: Excel Dashboard for Budgeting (Simulation Exercises)

     

Objectives

  • Manage reports and dashboard for financial performance
  • Manage reports and dashboard for cash flow statement
  • To design dashboard for working capital requirement
  • To plan your budgets and dashboard reporting
  • Using goal seek to hit management expectations on sales, profit & cash flow
  • Tp identify Excel skills that are most valuable for finance and accounting

 All our workshops are available via in-house training.

 

Audience

Entrepreneurs, Accountants, Business Managers, Marketing Managers, Treasurers, Supervisors, Executives and Managers and all professionals who are interested in Financial Modelling - Reports & Dashboard

Details

108181448

2 day

System is currently experiencing issues and we are working on a solution. If you encounter an error, please come back shortly and try again.
loading...