Finance for the Supply Management Professional: Supplier Financial Analysis

Course Objective:
- To learn what is important to look for in financial statements
- Identifying potential financial misstatements
- Recognizing the "Red-Flags" on financial statements
- Using ratios for quick analysis
- Using a range of Excel® models to analyze a supplier with little information.

WHAT YOU WILL LEARN

  • A proven set of decision-making tools and financial analysis techniques
  • How to effectively evaluate suppliers’ financial status
  • How to apply best-practice financial practices to SMP.
  • How to build a convincing case study for decision-making

WHO SHOULD ATTEND?

Supply Management professionals who want to learn about the relationship between finance and procurement while learning and/or revisiting the advanced concepts of the financial side of the business.

  • Financial professionals
  • Operational managers
  • Process owners
  • Project managers
  • Everyone tasked with the effective and efficient evaluation of potential investments, acquisitions, outsourcing agreements, or long-term contracts
  • Those responsible for the making or evaluating management of a decision-making process and want to use Excel® more effectively and an analytical tool

    Each participant will receive an Excel® workbook of the case study templates to be worked through during the program so please bring your laptops loaded with Excel® 2010 or later.


    Course Outline

    I. Finance and Accounting introduction

    • Basic financial statement understanding
    • Balance Sheet
    • Income Statement
    • Cash Flow Statement
    • Case study: Find the Links between the 3 financial statements
    • Non-Cash Deductions & its Impact
    • Depreciation vs. Amortization vs. Depletion (with Excel examples)
    • Financial vs. Management Accounting (with Excel examples)

      II. Key Ratios for Analysis

      • What are Ratios & why are they important
      • Liquidity; Turnover; Leverage & Profitability (Excel Ratio model)
      • Case study: ROE, ROA & Equity Multiplier calculations using the DuPont Model
      • Suppliers Benchmarking model
      • Case study: Compare Supplier Ratios to Peer group
      • Operating Cycle vs. Cash Cycle
      • Case study: Calculate the Cash & Operating cycles of a Supplier

      III. Financial Analysis

      • Altman Z-Score to measure financial Solvency – 3 approaches
      • Case study: Calculate the Z Score model; predict bankruptcy
      • Beneish M-Score model & what it tells us about earnings manipulation
      • Case study: Apply the Beneish model to determine if earnings are real
      • The F-Score & how is reveals potential fraud
      • Case study: Calculate a supplier’s F-Score to determine accuracy of financials
      • The Sloan Index to compare cash flow to profits
      • Case study: Calculate this index to see how solid their cash flow is

      IV. Supplier Analysis

      • Sourcing analysis (Excel model)
      • Sourcing alternative analysis (Excel model)
      • The value of taking/passing on a Discount
      • Case study of a Supplier Discount
      • What is the value of the Economic Order Quantity (EOQ) (Excel model)?
      • Target Costing Model (Excel example)
      • How do you know how much External Funding is Needed by a Supplier?
      • Case study: Calculate EFN to make sure they have enough