💲 Cash Trapped by Component
$2,162,000 total ▼
Accounts Receivable
$702,000
Customers are paying in 47 days instead of your Net 30 terms. That 17-day gap means $702,000 of your money is sitting in their bank accounts right now.
$1,940,000 × (47−30) ÷ 47 = $702,000
Inventory
$1,013,000
You're carrying 90 days of inventory vs. the 52-day manufacturing benchmark. The 38-day excess represents cash already spent on product that doesn't need to be sitting in your warehouse.
$2,400,000 × (90−52) ÷ 90 = $1,013,000
AP Timing Gap
$447,000
You're paying vendors in 22 days when their terms allow 45. You're voluntarily handing back 23 days of free vendor financing every payment cycle.
$875,000 × (45−22) ÷ 45 = $447,000
Total Cash Trapped in Operations
Recoverable through operational changes — no new capital required
$2,162,000
⚠ Severity-Ranked Findings
3 HIGH | 1 MEDIUM | 2 ALERT ▼
High
Cash Conversion Cycle (CCC) — 104 Days
$4,274,000 working capital required
Your business needs 104 days of cash tied up before it comes back. At your revenue level, that requires $4,274,000 in working capital — against $265,000 in available liquidity. You are funding your operations with 16× more cash than you have access to.
HIGH threshold: CCC >90 days. Your CCC: 104 days (DSO 47 + DIO 90 − DPO 33). Industry median: 71 days.
High
Working Capital Gap — Available Liquidity vs. Required
$4,274,000 required vs. $265,000 available
Your operational working capital requirement exceeds your available cash + credit by $4,009,000. This gap is the reason cash is always tight even when the P&L looks profitable. You are using vendor credit, customer deposits, and LOC draw to bridge a structural funding gap.
HIGH threshold: Required working capital >150% of available capital. Your ratio: 1,613%. Available = $145,000 cash + $120,000 LOC = $265,000.
High
Days Inventory Outstanding (DIO) — 90 Days
$1,013,000 trapped in excess inventory
You are carrying 38 days of inventory beyond the manufacturing benchmark. Every extra day product sits in the warehouse, it represents cash that has already been spent but hasn't come back yet. Reducing to benchmark would free over $1M immediately.
HIGH threshold: DIO >30 days over sector benchmark. Your DIO: 90 days. Manufacturing median ($5M–$25M): 52 days. Gap: 38 days.
Medium
Days Payable Outstanding (DPO) — Paying Vendors Too Fast
$447,000 in free financing given away
Your vendors give you 45 days to pay — you're paying in 22. Every payment cycle, you're voluntarily handing back 23 days of free cash that your vendors aren't asking for. This is the easiest fix: stop paying early.
MEDIUM threshold: paying >15 days earlier than vendor terms. You are paying 23 days early. Manufacturing median DPO: 35 days.
Alert
Days Sales Outstanding (DSO) — 17 Days Over Terms
$702,000 in cash owed by customers
Customers are taking 47 days to pay against your Net 30 terms. The 17-day overage means $702,000 is effectively an interest-free loan to your customers — funded by you.
ALERT threshold: any days over stated payment terms. Your DSO: 47 days vs. Net 30 terms. 17-day gap. Manufacturing median: 38 days.
Alert
Gross Margin Compression — Declining Year-Over-Year
↓ 2.2 percentage points
Gross margin has declined from 37.2% last year to 35.0% this year. On $15M in revenue, each percentage point of margin is worth $150,000. This 2.2-point drop costs $330,000 in gross profit annually — a trend that compounds if not addressed.
ALERT threshold: gross margin declining vs. prior year. Prior year: 37.2%. Current: 35.0%. Compression: −2.2pp. Manufacturing floor benchmark: 25%.
📈 CCC Scorecard & Benchmark Comparison
CCC: 104 days | Median: 55 days ▼
Cash Conversion Cycle Components
Days Sales Outstanding (DSO)
47 days
Days Inventory Outstanding (DIO)
90 days
Days Payable Outstanding (DPO)
33 days
Cash Conversion Cycle (CCC)
104 days
Daily Cash Burn
$41,096 / day
Working Capital Required
$4,274,000
Total Available Capital
$265,000
Coverage Ratio
0.1×
Benchmark Comparison — Manufacturing, $5M–$25M
| Metric | Your Performance | Industry Median | Best-in-Class |
|---|---|---|---|
| DSO | 47 days | 38 days | 28 days |
| DIO | 90 days | 52 days | 35 days |
| DPO | 33 days | 35 days | 48 days |
| CCC | 104 days | 55 days | 15 days |
Source: RMA Annual Statement Studies — Manufacturing, $5M–$25M revenue band.
For DPO, higher values indicate better use of vendor terms.
For DPO, higher values indicate better use of vendor terms.
💵 Margin Analysis
Gross 35.0% | Operating 13.7% ▼
Gross Margin
35.0%
(Revenue − COGS) ÷ Revenue
↓ −2.2pp vs. prior year
Operating Margin
13.7%
(Revenue − COGS − OpEx) ÷ Revenue
Contribution Margin / Unit
$35.75
$125.00 − $89.25 variable costs
Contribution Margin %
28.6%
$35.75 ÷ $125.00
Break-Even Analysis
Break-Even Units
67,133 units
Fixed Costs $2,400,000 ÷ $35.75 CM
Break-Even Dollars
$8,391,608
Fixed Costs ÷ 28.6% CM%
Current Volume Cushion
+52,867 units
79% above break-even — OK
📅 13-Week Cash Position Forecast
Critical: Week 10 | LOC draw starts Week 6 ▼
Baseline projection — no forward data entered. Receipts lagged by 47-day actual DSO. Disbursements based on COGS payment schedule (22-day DPO) plus $35,000/month debt service. Starting position: $145,000 cash + $120,000 available LOC = $265,000 total capacity.
| Week | Week Starting | Receipts | Disbursements | Net Cash Flow | Cash Position | Status |
|---|---|---|---|---|---|---|
| 1 | 04/14/2026 | $235,000 | $268,000 | ($33,000) | $112,000 | OK |
| 2 | 04/21/2026 | $248,000 | $271,000 | ($23,000) | $89,000 | OK |
| 3 | 04/28/2026 | $251,000 | $295,000 | ($44,000) | $45,000 | OK (large vendor pmt) |
| 4 | 05/05/2026 | $256,000 | $272,000 | ($16,000) | $29,000 | ⚠ Warning |
| 5 | 05/12/2026 | $252,000 | $274,000 | ($22,000) | $7,000 | ⚠ Warning |
| 6 | 05/19/2026 | $244,000 | $271,000 | ($27,000) | ($20,000) | ⚠ Drawing LOC |
| 7 | 05/26/2026 | $258,000 | $268,000 | ($10,000) | ($30,000) | ⚠ Drawing LOC |
| 8 | 06/02/2026 | $261,000 | $274,000 | ($13,000) | ($43,000) | ⚠ Drawing LOC |
| 9 | 06/09/2026 | $265,000 | $278,000 | ($13,000) | ($56,000) | ⚠ Drawing LOC |
| 10 | 06/16/2026 | $268,000 | $312,000 | ($44,000) | ($100,000) | 🔴 Critical — LOC at limit |
| 11 | 06/23/2026 | $274,000 | $271,000 | +$3,000 | ($97,000) | 🔴 Critical |
| 12 | 06/30/2026 | $278,000 | $268,000 | +$10,000 | ($87,000) | ⚠ Recovering |
| 13 | 07/07/2026 | $282,000 | $265,000 | +$17,000 | ($70,000) | ⚠ Recovering |
Cash Position = bank balance. Negative values indicate LOC draw. LOC capacity: $120,000. Critical threshold = LOC exhausted at ($120,000).