Finance For Non-Finance Professionals (Simplify Simulation Excel Approach)

2 Days Workshop

Introduction

If you have little or no financial background, this course is meant for you. Will guide you step by step using simulation approach to managing profit & cash flow, investment, budgeting processes & read financial statements. Free practical well tested excel templates are provided.

Course Objectives                                                                                                                                   
By the end of this course you will be able to (practical hands on experience)

  1. How to manage your profit & loss & cash flow position

  2. How to design your working capital requirement 

  3. How to plan your budgets 

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

Methodology

Case Study & Group Discussion. 

Who Should Attend

Entrepreneurs, Business Managers, Marketing Managers, Supervisors, Executives and Managers and all professionals who are interested in Finance for non-Finance

Special Feature:

NOTE: Please bring laptop along

Programmed Outline

Day 1

Module 1-2: Managing P&L & Cash Flow (Simulation exercise)

Objective:

  • with little or zero accounting knowledge, will walk you through

 Your business or new business on sales, purchases, operating expenses, investment, capital injection, depreciation & interest payment

  • you see your own P&L, Balance sheet, cash flow & equity

  • provide strategies (using goal seek) to improve your cash flow & P&L position

Management Game: 15 min

Module 3: Cash Flow Statement (simulation exercises)

Objective:

  • You will learn why you fund increase or decrease 

  • What are the causes: operational, investing or financial driven?

  • Using goal seek will improve your cash flow position.

Module 4:  Working Capital Management (Simulation Exercises)

Objective: how much resources needed (eg. Capital) to hit the sales budget 2018

  • Will show you how to manage your inventory, debtors & suppliers

Module 5: Financial Ratios Analysis (Simulation on Real Listed Companies Case Studies)

Objective: you will understand how to reading the financial ratios 

  • Liquidity 

  • Solvency 

  • Efficiency 

  • Profitability 


Day 2

Module 6: Burning Issues in Financial Matters 

Objective: consultancy approach using strategic management framework – planning, execution & evaluation approach for problem solving. Issues are as follows:

  • Manpower issues

  • Budget Constraint 

  • Lots of payment for overtime

  • High maintenance cost 

  • etc..

Module 7: Investment Appraisal (simulation Case Study)

Objective: Based on capex, sales, cost of sales assumptions, you will know how to calculate working capital, weighted average cost of capital and decide whether to proceed or reject your proposal or project.

Will learn how to:

  • Calculate return on investment (ROI), 

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

Management Game: 15 Min

Module 8: Budgeting (Simulation Exercises)

Objective: Will guide you step by step in arriving at the following budget:

  • Sales 

  • Cost of sales

  • Gross profit

  • Operation expenses

  • Net profit 

Using goal seek to hit your profit & cash flow target

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 a 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 managed multi-national corporations in South Asia and the ASEAN region. He has accumulated more than 28 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

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

Testimonials From Past Participants

“This course is good to refresh my knowledge on accounting treatment. It also helps me in making analysis on financial statement as well as preparing scenario and sensitivity analysis which are relevant to my current task at Fiscal and Economic Division.” Fiskal dan Ekonomi , Ministry of Finance

“I've learnt the systematic ways to measure company's performance right from the beginning when the project kicked-off until forecasting the ability of the company to survive in the industry. This knowledge is very useful which it is very much related to my work nature.” Nur Diyana Binti Ab. Manap, Government Investment Corporation, GIC, Ministry of Finance

“Knowledge gained from this course has opened my eyes towards the intricacies of finance in private sector and maybe contribute back this knowledge to the government.”, Aizwan bin Anuar, Housing Loan Division, Ministry of Finance

“This course has assisted me in analysing financial statements better. Discussions using case studies have helped us to better understand & relate to our day to day tasks. My favourite session was the financial statements preparation & problem solving on burning issues” Nurhidayah binti Lamien, Tax Division, Ministry of Finance

Managing P&L, Cash Flow & Budgeting

Accounting for Fixed Assets & Asset Management

0