Cash Flow & Working Capital Dashboard

Meridian Tile & Stone Works
As of Dec 31, 2024
Days Cash Runway
47
+3d vs. last week
Cash on Hand
$52.4K
+$4.8K this week
Cash Conversion Cycle
41d
+2d vs. target
DSO (All Clients)
38d
Target: 30d
Credit Headroom
$42K
of $75K facility
Operating CF Margin
8.2%
+1.1pp YoY

13-Week Cash Position Forecast

Projected runway extends through Week 13. Critical threshold: $18K (3× weekly payroll).

December Cash Flow Waterfall

Cash Conversion Cycle Breakdown

Days Sales Outstanding (DSO) 38d
Days Inventory Outstanding (DIO) 24d
Days Payable Outstanding (DPO) 21d
Cash Conversion Cycle 41d
Formula: DSO + DIO − DPO

AR Aging Concentration Risk

Sunrise Hospitality
$31.2K
47d overdue
Desert Vista Homes
$18.4K
32d overdue
Arcadia Builders
$14.7K
28d overdue
Paradise Pool & Spa
$12.1K
19d overdue
Camelback Realty
$9.8K
11d overdue
Others (12 accts)
$22.6K
avg 8d
Total AR: $108.8K. Top client represents 28.7% of outstanding receivables.

DSO by Client Tier

Burn Rate Composition (12-Week Trend)

Fixed Burns: Payroll, rent, insurance
Variable Burns: Materials, subcontractors, fuel

Seasonal Cash Flow Variance

Payables Coverage Ratio

Current Liabilities (AP + Accruals) $47.2K
Quick Assets (Cash + AR) $161.2K
Coverage Ratio 3.42×
Target ≥2.0×. Current ratio indicates strong short-term liquidity.
DPO Trend (Days Payable Outstanding)

Payables & Receivables Aging Summary

Entity Name Type Amount Days Status
Sunrise Hospitality Group AR $31,200 47 Critical
Desert Vista Homes AR $18,400 32 Overdue
Arcadia Builders LLC AR $14,700 28 Warning
Arizona Tile Supply Co. AP $12,800 18 Current
Paradise Pool & Spa AR $12,100 19 Current
Pro-Line Grout & Sealant AP $8,400 22 Current
Camelback Realty Partners AR $9,800 11 Current
Phoenix Equipment Rental AP $6,200 14 Current

Emergency Reserve Coverage Trend

Coverage Ratio = (Cash + Credit Headroom) ÷ (Fixed Monthly Burn). Target ≥1.5×. November equipment purchase triggered reserve dip below threshold.