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

16-17 Jul, 2025, CONCORDE HOTEL KUALA LUMPUR

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

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 managing multi-national corporations in South Asia and the ASEAN region. He has accumulated more than 36 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 Human Resources Development Corporation (Pembangunan Sumber Manusia Berhad). And he is a GST Tax Consultant and has 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 specializing in Finance and Accounting, Strategic Planning, Budgeting, Fast Closing Monthly, Cost Reduction, Credit Management & Loan Recovery.

 

WHAT YOUR COLLEAGUES ARE SAYING ABOUT THE COURSE…
“Overall good. I am a bit slow due to not being very good at accounting. I can say it is totally new to me. Big thank you, Dr Steven. I will discuss with my top management regarding the budget aspects of my role for the next management meeting. Will implement this budget analysis to control branding & advertisement costs in 6-month times”: Brand Development & Operation Manager, DC Comics Superheroes

 

“Good introduction to the basics of accounting and financial analysis using practical real-life examples. Participants can grasp concepts quicker as it is hands on and interactive.” Legal Division, Ministry of Finance

 

“This course gives me better understanding about accounting & financial analysis as a preparation when public sectors start using accrual accounting.” Internal Audit Division, Ministry of Finance

 

“I now understand the following better: Understanding the balance sheet, know how to identify the profitable company/projects, understanding more on problem solving tools, more input for decision making process”: Treasury, Sabah Malaysia, Ministry of Finance

 

“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.” Fiscal dan Economic, 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

 

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

 

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysi,
Phone : +603 2144 2200

https://kualalumpur.concorde hotelsresorts.com/

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Module 1: Understanding Finance & Costing Terminology
  • Module 2: Managing P&L & ROI (Simulation Exercise)
  • Module 3: Improve Cash Flow & Profitability Position (Practical Case Study)
  • Module 4: Financial Reporting: Creating Excel Interactive Dashboard
  • Module 5: Working Capital Management (Simulation Exercises)
  • Module 6: Specific Formula & Function
  • Module 7: Budgeting (Simulation Exercises)
  • Module 8: How To Monitor Your Sales, Costs & Collection
OVERVIEW

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.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Managing Your Profit & Loss, ROI & Cash Flow Position.
  2. Designing Your Working Capital Requirement.
  3. Financial Reporting On Using Interactive Dashboard.
  4. Planning Your Budgets Effectively.
  5. Using Goal Seek To Hit Management Expectations On Sales, Profit & Cash Flow.
  6. Recognising Areas Of Concern And Recommend Ideas For Improving Financial Performance And Productivity.
  7. Contributing More Effectively To Budgeting Negotiations.
WHO SHOULD ATTEND
Entrepreneurs, Business Managers, Marketing Managers, Supervisors, Executives and Managers and all professionals who are interested in Finance for non-Finance.
METHODOLOGY

Interactive Lectures, Case Studies & Group Discussion. Real-Current Cases will be analysed and scenario solutions will be discussed within the course.

Special Feature: Participants Will Receive a Set of Practical Templates suitable for all sectors. These templates:
• Ease in planning, reporting & decision-making process
• Snapshot of overall issues & problem
• Financial modeling using goal seek strategies for cash flow, profit, sales target, budgeting & working capital requirements.

DAY 1
9:00

MODULE 1: UNDERSTANDING FINANCE & COSTING TERMINOLOGY

  • Recognition of Revenue & Recognition of Cost of Sales
  • Cost of Sales Vs Opex
  • When Inventory should be charged out to P&L
  • Components for GP, EBITDA, OPEX, PBT, PAT
  • Criteria to recognise an item as Capex & when depreciation will commence.
  • EBIT Vs EBITDA
  • What is Goodwill?
10.45

MODULE 2: MANAGING P&L & ROI (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
1:00 Lunch
2:00

MODULE 3: IMPROVE CASH FLOW & PROFITABILITY POSITION (PRACTICAL CASE STUDY)
Objective: Use financial tools of goal seek & solver to meet management target of sales,
profit & cash flow position

  • Applying what if analysis (goal seek & solver)
  • Applying profitability strategy management framework
    o Formulation stage
    o Execution stage
    o Evaluation stage
3:45

MODULE 4: FINANCIAL REPORTING: 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
5:00 End of Day 1
DAY 2
9:00

MODULE 5: WORKING CAPITAL MANAGEMENT (SIMULATION EXERCISES)
Objective: how much resources needed (e.g., Capital) to hit the Sales Budget

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

MODULE 6: SPECIFIC FORMULA & FUNCTION

  • Create Interactive Excel Dashboard
  • Gantt Chart (Project scheduling)
  • Scenario Planning (Best, worst & Likely scenario)
  • Sensitivity Analysis
1:00 Lunch
2:00

MODULE 7: 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

3:45

MODULE 8: HOW TO MONITOR YOUR SALES, COSTS & COLLECTION

  • Define your sales projection, factor in fluctuation (q1, q2, q3 & q4)
  • Do your monthly average sales & expenses
  • Used Variance techniques (2+10, 5+7, 8+4)
    and use SMART (specific, measurable,
    achievable, realistic & timebound)
  • Make sure your budget is always relevant during the year
5:00 End of Course