Financial Modelling

2 days’ workshop

INTRODUCTION

If you want to turnaround the companies, strengthen your financial planning and evaluation skills, this course is for you. Using case studies and excel spreadsheet, you will have amazed how problem could easily be analyzed and solved by financial modeling techniques. 

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

  1. Use your company financial statements to identify areas for improvement including assets management, cost reduction technique, sales and collection skill. 

  2. Understand how much funding is needed to grow your business 

  3. Consider taxation, working capital, shareholder expectations, prices & quantity changes in investment decision making processes

  4. Review of Financial performance (Case Study)

  5. Applying Interactive Budgeting & creating dashboard

  6. Understanding Risk Modelling Skills 

METHODOLOGY

Case Study & Group Discussion. Real-current financial & business cases will be analyzed and scenario solutions will be discussed within the workshop.

WHO SHOULD ATTEND

Entrepreneurs, Bankers, Accountants, CFO, CEO, Business Managers, Marketing Managers, Supervisors, and Managers

Special Feature: NOTE: Please bring laptop along

PROGRAMME OUTLINE

Day1

Module 1: Managing P&L and Cash Flow 

Balance Sheet 

  • How to read a balance sheet 

  • Assessment of company financial strength and risk 

  • Working capital management 

Profit & Loss Statement 

  • How to read Profit & Loss Statement 

  • Use Profit and Loss Statement to evaluate performance 

  • Why profit is different from cash 

Module 2: Module 1: Managing Cash Flow

  • Lifeblood of business – Cash Flow Statement 

  • Relationship between cash flow statement and balance sheet 

  • 3 streams of cash flow, Operating ,Investing &Financing 

  • How to determine financial health from cash flow pattern 

Module 4:  Improve Cash Flow & Profitability Position (Practical Case Study)

  • Applying what if analysis (goal seek & solver)

  • Applying profitability strategy management framework

      • Formulation stage

      • Execution stage

      • Evaluation stage

Module 5: Formulation of Business Turnaround Strategies (Case Study) 

Objectives

  • Asset conversion

  • Fees & Collection 

  • Spreading costs 

  • Manpower review 

  • Stock management

  • Product market study  

  • Purchasing policy

  • Sales  


Day 2

Module 6: Investment Techniques & Time Value of Money (Case Study)

Objectives

  • Calculate return on investment (ROI),

  • Calculate net present value (NPV), internal rate of return (IRR), and payback period

  • Recommendation to proceed or reject based on financial & non-financial considerations

Module 7: Review of Financial performance (Case Study)

Objectives

  • Analysis of Cash Flow position

  • Prepare forecast Statement of Comprehensive Income and Statement of and Financial Position 

  • Understanding financial performance & gearing level  

Module 8: Interactive Budgeting 

  • Planning Process

  • Preparation Of Budgeting ( Operational & financial Budget)

  • Budgeting and Human Behavior 

  • Goal seek tool

Module 9: Risk Modelling Skills 

  • Analyzing the potential risks facing an organization 

  • Mitigating controls 

  • Weight the financial impact 

  • Cost/benefit decision analysis

  • Risk Model software

DSC00558.jpg
 

 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 he is a GST Tax Consultant and had successfully completed the Custom examination

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 GST, Forecasting , Fast closing monthly,  leadership, Strategic Planning, budgeting, accounting, finance, Cost reduction, credit management & loan recovery.

Testimonials from Past Participants

 “I really like the way Dr Steven Liew delivered on this financial modelling using Ms Excel especially the  Business turnaround strategies & the Proactive way to solve problem” – Assistant Finance  & Admin Manager, TH Hotel & Residence Sdn Bhd

“The speaker delivery skill in financial modelling is very good and practical. He knows the subject well and able to held out our attention throughout the 2 days program with exercises & case studies”- General Manager- Finance UDA Holdings Sdn Bhd

Final Accounts, Analysis & Control

Financial Analysis

0