Treasury Department Scorecard

EOS Traction System | Q3 2023

Live Dashboard

Updated: August 28, 2023

Cash Position

$42.8M

Target: $45M 95%

Days Cash on Hand

62d

Target: 90d -28d

Working Capital

$28.4M

Target: $25M +13.6%

FX Exposure

1.8%

Target: ≤2% On Target

Treasury Performance Scorecard

Key metrics tracked weekly as per EOS Traction methodology

ID Measurable Weekly Target Current Week Last Week 2 Weeks Ago 3 Weeks Ago Status
C01 Cash Balance ($M) ≥42.5 42.8 42.2 41.8 40.5 On Track
C02 Days Cash on Hand ≥90 62 65 68 72 Off Track
C03 Cash Conversion Cycle (days) ≤45 42 44 46 48 On Track
L01 Working Capital ($M) ≥25.0 28.4 27.1 26.3 25.8 On Track
L02 Debt to Equity Ratio ≤0.4 0.38 0.39 0.41 0.42 On Track
L03 FX Exposure (%) ≤2.0 1.8 1.9 2.1 2.2 On Track
I01 Investment Yield (%) ≥3.5 3.2 3.3 3.4 3.6 Needs Attention
I02 Bank Fee Reduction (%) ≥10 12 10 8 7 On Track
I03 Compliance Audit Score 100% 100% 98% 100% 100% On Track

Cash Flow Analysis

$12.8M

Net Cash Flow Q3

+$4.2M

Inflows

-$3.8M

Outflows

Operating Cash Flow

$8.4M

+12% YoY

Investing Cash Flow

-$2.1M

Capital investments

Financing Cash Flow

$6.5M

Debt issuance

Cash Flow Forecast Accuracy

94%

Risk Exposure

Interest Rate Risk Low
Currency Risk Medium
Credit Risk Low
Liquidity Risk High

Liquidity Alert

Days cash on hand below target. Review short-term investment strategy.

EOS Traction Action Plan

Critical Issues

  • Insufficient days cash on hand (62d vs 90d target)
  • Investment yield below target (3.2% vs 3.5%)
  • Increased liquidity risk exposure

Immediate Actions

  • Optimize short-term investment portfolio
  • Accelerate accounts receivable collection
  • Review cash conservation measures

Accountabilities

  • Sarah Johnson - Cash optimization by 9/15
  • Michael Chen - AR process review
  • Finance Team - Weekly cash flow forecast

Progress on Rocks (Q3 Initiatives)

Bank Relationship Optimization 85%
FX Risk Management Program 100%
Treasury Management System 65%