Finance for Non-Finance Professionals FULL SESSION

12-19 Dec, 2020, Webinar Classroom Training

IPA Training is Registered with

Venue Details

Webinar Classroom Training


Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

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.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Knowing how to manage your profit & loss, ROI & cash flow position
  2. Knowing how to design your working capital requirement
  3. Knowing how to plan your budgets
  4. Using goal seek to hit management expectations on sales, profit & cash flow
  5. Recognise areas of concern and recommend ideas for improving financial performance and productivity
  6. Contributing more effectively to Budgeting negotiations
  7. Understanding Corporate Tax Computation
  8. Having experienced Financial Reporting using Power Business Intelligent (BI)
WHAT YOUR COLLEAGUES ARE SAYING ABOUT THE COURSE…
  • “Good introduction to the basics of accounting and financial analysis using practical real-life examples. Participants are able to 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 in 2015.”
    Internal Audit Division, Ministry of Finance
  • “The benefit from this course is the complete coverage of tax area for a new career. Dr Steven Liew shared a lot of references and tips that can be applied to my job.”
    Tax Accounting, Group Financial Controller, Petroleum National Bhd (Petronas)
  • “Very good exposure on taxation and correct ways of computing & the legal ways for tax planning.”
    Finance Executive, Nova Spectra Sdn Bhd
  • “I now understand Power BI can do extraordinary data visualization and its ability to highlight financial performance to senior management.”
    Treasurer, Kolej University Islam Perlis
  • “Good introduction to the basics Power BI. It can show detailed financial results & enabling a clearer presentation to management.”
    Admin Assistant, Panji Alam Sdn Bhd
  • “Power Bi has the ability to show the financial results in multiple presentation and with deeper data analysis.”
    Accounting Manager, CJ Bio Malaysia Sdn Bhd
WHO SHOULD ATTEND
Entrepreneurs, Business Managers, Marketing Managers, Supervisors, Executives and Managers and All Professionals who are interested in Finance for non-Finance
METHODOLOGY
Case Study & Group Discussion
Session 1 | 12th December 2020
Saturday, 9.00am-1.00pm (4 hours)
9:00

MODULE 1: UNDERSTANDING ACCOUNTING & 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
11:00

MODULE 2: MANAGING TRIAL BALANCE, P&L & ROI (RETURN ON INVESTMENT)
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
 

THE PREPARATION OF FINANCIAL STATEMENTS AND UNDERSTANDING WHAT THEY MEAN
The Structure and Format of Financial Statements Profit and Loss Statement

  1. Revenue
  2. Cost of Goods Sold
  3. Gross profit
  4. Income and Expenses
  5. Net profit
 

BALANCE SHEET

  1. Equity
  2. Liabilities
  3. Assets
1.00 End of Session 1
Session 2 | 12th December
Saturday, 2.00pm-6.00pm (4 hours)
2.00

MODULE 3: BREAKEVEN SALES & CASH FLOW CRISIS MANAGEMENT

  • Review next 6 months performance
  • Review your cost structure
  • How to manage your fixed costs & salary
  • Impact on your bottom-line
  • Review your term of collection & payment
  • Create cash flow scenarios
  • Reduce cash flow deficit
 

CASH FLOW STATEMENT

  • 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
  • Determining if the company is using internal cash flow to finance growth or relying on external financing
4.00

MODULE 4: 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
6.00 End of Session 2
Session 3 | 19th December 2020
Saturday, 9.00am-1.00pm (4 hours)
9:00

MODULE 5: FINANCIAL RATIOS ANALYSIS (SIMULATION ON LISTED COMPANIES CASE STUDIES)
Objective: You Will Understand How To Read The Financial Ratios

  • Liquidity
  • Solvency
  • Efficiency
  • Profitability
  • Asset Management
11.00

MODULE 6: FINANCIAL REPORTING- POWER BUSINESS INTELLIGENT (BI)

  • What is Power Business Intelligent?
  • Steps in Power BI?
    - Data source must be a RAW data (No Formulas)
    - Data source must be in a table format (Headers must be on TOP)
    - Get Data (Query)
    - Transform/ Data Cleansing
    - Creating Reports
    - Publish to Power Bi Service
    - Create Dashboard
1.00 End of Session 3
Session 4 | 19th December 2020
Saturday, 2.00pm-6.00pm (4 hours)
2.00

MODULE 7: UNDERSTANDING TAX

  • Income tax computation
  • Non allowable deduction
  • Special deduction
  • Double deduction
  • Capital allowance
  • Approved Donation
  • Tax rate
3.30

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
5.00

MODULE 9: 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 3 estimate techniques (2+10, 5+7, 8+4) and also use SMART (specific, measurable, achievable, realistic & timebound)
  • Make sure your budget is relevant at all times during the year
6.00 End of Course