Analytical thinking & predictive financing modeling - Workshop 2020

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