[Online, NEW] Modernization of Finance
Course Information
  • 13-Dec-2022
  • Online
  • Dr. Steven Liew
  • English
  • RM 1340 RM 1270
    Until 06 Dec 2022
  • 9:00am - 5:00pm

 

[01] INTRODUCTION

 

The primary goal of this Finance Transformation workshop is to assist finance executives with assessing their finance strategy and vision and helps design and implement change to their finance organization, process, and systems to improve the overall value of finance.

 

The integrated finance transformation processes, technologies, and tools provide an analytics-driven framework that can reduce the cost of finance; improve performance and transparency.  Besides, it can greatly enhance decision-making, enable better use of capital and enhance risk management.

 

 

[02] COURSE OBJECTIVES

                                                                                                                                
By the end of this course, you will be able to:

     - Use Profit & Loss Model to navigate & improve your profitability & cash flow

     - Understand the connections of the financial statement to the business

     - Using goal seek to hit management expectations on sales, profit & cash flow

     - Implementing Process Improvement Project

     - Redefining the Role for Finance Managers

     - Learnt from successful budgeting using beyond budgeting approach

     - Plan how to achieve optimum profitability under budget constraints

     - Build a Dynamic 3-Statement Financial Model

     - Understand Gantt Chart (Project scheduling)

     - Apply Sensitivity analysis & Scenario Planning (Best, worst & Likely scenario)

 

 

[03] METHODOLOGY 

 

Case Study & Group Discussion

 

 

[04] WHO SHOULD ATTEND

 

Accountants, CFO, Business Managers, Finance Managers, Supervisors, Managers and All Professionals Who Are Interested in “Modernization of Finance”

 

NOTE:

Attendees need to bring along laptop with Microsoft Excel (Ver 2016 and above) installed. For better effectiveness, attendees are encouraged also activate webcam and mics for interaction purpose, when requested.

 

 

[05] DATE/ TIME/ FEE

 

Date:               13-14 December 2022 (Tue-Wed)

Time:               9.00am – 5.00pm

Level:             Intermediate

 

FEE               [ HRD CORP CLAIMABLE ]       

 

          - Early Bird Offer (before 22 Nov 2022)          –        RM1,200

          - Special Offer (before 6 Dec 2022)          –         RM1,270

          - Normal Pricing         –         RM1,340

 

Fee includes Course Notes & Certificate of Completion and 6% Service Tax

 

** OFFER **

- 10% Cashback for SST2u Learner Card+ (SLC+) members. T&Cs applied.

 

 

[06] COURSE SCOPE

 

Day 1

 

Module 1: Understanding Fast Closing

     - Fast closing definition

     - Closing schedule

 

Module 2: Fast Closing Discussion

     - Discuss on how to shorter the MTh end closing

     - Discussion on systematic way of closing the accounts

     - How to do minimum adjustments to closing of accounts

     - Discuss ways to redesign a simple finance accounting cycle

 

Module 3: Fast Closing Contribution to The Organization’s Bottom Line

     - Asset conversion

     - Collection

     - Cost reduction

     - Revenues

     - Purchasing policy

 

Module 4:  Improve Cash Flow & Profitability Position

     - Tax optimization

     - Cash flow optimization

 

Module 5: How to Monitor your Sales, Costs & Collection

     - Define your sales projection, factor in fluctuation

     - Do your monthly average sales & expenses

     - Used variance techniques and use SMART (specific, measurable, achievable, realistic & timebound)

     - Make sure your budget is always relevant during the year

 

End of Day 1

 

 

Day 2

 

Module 6: Build a Dynamic 3-Statement Financial Model

     - Income Statement

     - Balance Sheet

     - Cash Flow

     - Fixed Assets

 

Module 7: Sensitivity & Scenario Analysis

     - Sensitivity Analysis

     - Scenario Analysis & Planning

     - Gantt Chart (Project scheduling)

 

Module 8: Creating Excel Interactive Dashboard 

     - From data sets to pivotal table

     - From pivotal table convert to pivot charts

     - From pivot chart convert to interactive dashboard

     - Slicers link to dashboard

 

Module 9: How to Use Microsoft Power Query

     - How to get Power Query

     - Transform data

     - Applied steps

     - Add Column

     - Insert pivot table & chart

     - Importing additional data

 

Conclusion & Recap

 

 

[07] TRAINER PROFILE

 

DR STEVEN LIEW 

Certified HRDF Trainer, Consultant

 

Dr Steven Liew is a fellow member of the Chartered Institute of Management Accountants, UK and is a Chartered Accountant by profession. He has an Asia Pacific Executive MBA (for senior executives) from the National University of Singapore and a PhD in international finance with Rushmore University of USA. Dr Liew had worked in private sector companies, ranging from family-run businesses to professionally manage multi-national corporations in South Asia and the ASEAN region. He has accumulated more than 30 years working experience in senior financial & operational management positions spearheading the profitability and growth of companies. He has worked for the MBF Finance & its related group of companies over the 10 years’ period.

He is a registered Trainer with the Government Human Resources Development Berhad (Pembangunan Sumber Manusia Berhad) and a GST Tax Consultant. Dr Steven Liew had conducted various seminars for corporate clientele including Association of Credit Management Malaysia, Chartered Institute of Management Accountants, Malaysia Institute of Management, Malaysia Institute of Accountants, Institute of Bank Bank Malaysia, Nestle, IQPC Worldwide Pte Ltd, Singapore, Lexis Nexis, Proton Edar Malaysia , Brunei Investment Agency, Small Medium Industries Development Corporation , Ministry of Development, Brunei , BICPA Asean Management, Brunei, Risda Group Of Companies, Sales & Marketing Training Forum, Sri Lanka, Giant Retail Sdn Bhd, Telekom Brunei & Ministry of Foreign Affairs, Malaysia, Sabah Electricity Sdn Bhd, Bank Islam Brunei Darussalam. Continental Tyres, Sime Darby Bhd, Sony Malaysia Sdn Bhd, Perodua Sdn Bhd & Credit Guarantee Corporation (M) Bhd; Fujixerox, UDA Holdings, SPNB, Diners Club, Elk Desa Capital Bhd, Antah Schindler, UCSI & Ministry of Finance; Seccom Sdn Bhd; Bridgestone Chemical Products (M) sdn Bhd; Dialog Group Bhd; SEDCO, KK; Hosiden Electronics (M) Sdn Bhd; STO Maldives; Indah Water Consortium Sdn Bhd; CPA Australia (M) Sdn Bhd.

He is currently providing management consultancy and training specialising in Forecasting, Fast closing monthly, leadership, Strategic Planning, budgeting, accounting, finance, cost reduction, credit management & loan recovery.

 

 

[08] TESTIMONIALS

 

Testimonials from Past Participants

 

“Case studies most beneficial to me are “how to manage the account & the Burning issues in fast closing”

- Finance Manager

 

“What impresses me most from Dr Steven is the “Solution in solving accounting problem & also the Finance strategy” that he shared

- Account Supervisor

 

“I really appreciated Mr. Liew imparting his Real-life story of actual application of cost reduction strategies & many case studies”

- Plant Controller; Ceramica Indah Sdn Bhd

 

Two key points I learnt from Dr Liew are “Impact on P&L, BS, Cash Flow & Equity from your transactions    (sales, expenses, assets) & Impact of operating, investing & financing activities on cash flow position”

- Project/business analyst

 

“Instructor explains clearly and easily to understand.  I have learned the Skill in Risk Financial Planning & Forecasting”

- Norazima Hussain, Sr Manager HR & Corporate Planning

 

“Got many hidden technique and formula in excel “

- Product Development Engineer UMW Corporation Sdn Bhd

 

 

[09] ENQUIRY & REGISTRATION

 

Enquiry: yes@sst2u.com

Contact:

- Teo (011 - 3178 9203)

- Logesh (012 - 503 0346)

- Siti (012 - 383 8603)

- Han (019 - 323 0507)