Acme Manufacturing, Inc.  ·  April 9, 2026    ← Exit
🏠 Landing ✍ Data Entry 📊 Results 📄 Executive Summary
Setup Working Capital Chain Cash Conversion Cycle A — Revenue & Margin B — Accounts Receivable C — Accounts Payable D — Inventory E — Banking F — FP&A Setup
Diagnostic Data Entry
All sections complete. Calculated fields update automatically as data is entered.

Engagement Setup

Complete
Client / Company Name
Acme Manufacturing, Inc.
Appears on all report pages and session list
Industry Sector
Manufacturing
Drives benchmark table selection (Manufacturing / Distribution / Retail)
Report Date
April 9, 2026
Auto-populated to today. Anchors Week 1 of the 13-week forecast.

Cash Conversion Cycle — Accounting View vs. Cash Reality

Calculated
All values calculated from data entered in Sections B, C, D, and E. No new inputs required.
✅ Accounting View — Working Capital Snapshot
$1,940,000
Accounts Receivable
+
$2,400,000
Inventory
−
$875,000
Accounts Payable
Net Working Capital
$3,465,000
The balance sheet says the business has $3.465M in working capital. Looks healthy.
⏱ Cash Reality — Cash Conversion Cycle
47
DSO (days)
+
90
DIO (days)
−
33
DPO (days)
Cash Conversion Cycle
104 days
Cash is out of pocket for 104 days before it returns. At $15M revenue, that requires $4.274M in working capital.
⚠ The Structural Gap — Why Cash Is Always Tight
Accounting says you have
$3,465,000
Cash timing actually requires
$4,274,000
Structural shortfall
$809,000
Available liquidity to cover it
$265,000
The accounting reports show $3.465M in working capital — which looks fine. But the cash conversion cycle reveals the business needs $4.274M just to fund the gap between when cash goes out and when it comes back. That's a $809,000 structural shortfall, with only $265,000 in available cash and credit to bridge it. This is why the P&L shows profit but the bank account is always tight.

Section A — Revenue & Margin

Complete
Monthly Revenue (Trailing 12 Months)
Monthly entry preserves seasonal patterns for forecast accuracy. SMB median: $1.2M/month at $15M annual.
Annual Revenue (auto-calculated)
$15,000,000
Sum of 12 monthly entries. SMB median $5M–$25M manufacturing band.
Annual COGS
$9,750,000
Cost of goods sold. Entered once — pre-fills read-only into Inventory section. SMB median: 60–70% of revenue.
Operating Expenses
$3,200,000
Total operating expenses excluding COGS. SMB median: 18–25% of revenue.
Selling Price per Unit
$125.00
Used for break-even and contribution margin calculations.
COGS per Unit
$81.25
Total Fixed Costs
$2,400,000
Used for break-even calculation. Exclude variable costs.
Prior Year Revenue
$14,200,000
Used for gross margin compression analysis. SMB median YoY growth: 5–8%.
Prior Year COGS
$8,882,000
Prior year cost of goods sold. Used for margin compression flag.

Working Capital Chain — Operational Timing

Complete
Steps 1–4 are entered. Steps 5–10 calculate automatically.
1
Order to Raw Material Receipt SMB median: 7–14 days
8 days
2
Raw Material to Production Start SMB median: 3–7 days
5 days
3
Production Start to Finished Goods SMB median: 12–21 days
18 days
4
Finished Goods to Customer Shipment SMB median: 5–10 days
7 days
5
Operational Cash Conversion Cycle Steps 1+2+3+4
38 days
6
Daily Revenue Rate $15,000,000 ÷ 365 — baseline for working capital calculations
$41,096 / day
7
Working Capital Required (Operational) Step 5 × Step 6
$1,561,644
8
Ratio-Based CCC DSO + DIO − DPO
104 days
9
Available Liquidity Cash + Available LOC
$265,000
10
CCC Divergence Flag |Ratio CCC − Operational CCC| = 66 days — REVIEW
66 days gap

Section B — Accounts Receivable

Complete
AR Balance
$1,940,000
Total outstanding accounts receivable. SMB median for manufacturing: 10–14% of annual revenue.
Payment Terms Offered
30 days (Net 30)
Your stated terms. This is the baseline for cash trapped calculation.
AR Aging Buckets
Current (0–30 days)
$980,000
31–60 Days
$540,000
61–90 Days
$310,000
90+ Days
$110,000
Actual DSO (calculated from aging)
47 days
Weighted average: (980K×15 + 540K×45 + 310K×75 + 110K×120) ÷ 1,940K = 47 days
Ratio DSO (for benchmarks)
47 days
($1,940,000 ÷ $15,000,000) × 365 = 47 days

Section C — Accounts Payable

Complete
AP Balance
$875,000
Total outstanding accounts payable. SMB median: 8–12% of annual COGS.
Vendor Payment Terms Received
45 days (Net 45)
Terms your vendors give you. You are entitled to use all 45 days.
Actual Average Days to Pay
22 days
How fast you actually pay. Paying faster than terms = voluntarily giving up free vendor financing.
Ratio DPO (calculated)
33 days
($875,000 ÷ $9,750,000) × 365 = 33 days

Section D — Inventory

Complete
Inventory Value (at cost)
$2,400,000
Total inventory at cost. SMB median for manufacturing: 22–28% of annual COGS.
Annual COGS (pre-filled from Section A)
$9,750,000
Read-only. Entered once in Section A.
Days Inventory Outstanding (DIO) (calculated)
90 days
($2,400,000 ÷ $9,750,000) × 365 = 90 days. Manufacturing median: 52 days.

Section E — Banking Position

Complete
Cash Balance
$145,000
Current bank balance. Negative values (overdraft) are valid and diagnostic.
Line of Credit Limit
$500,000
Current LOC Usage
$380,000
Amount currently drawn. Available LOC = Limit minus Usage.
Available Line of Credit (calculated)
$120,000
Monthly Debt Service
$35,000
Total monthly loan/lease payments. Spread weekly in the 13-week forecast.
Total Available Capital (calculated)
$265,000
Cash + Available LOC. This is your operational cushion.

Section F — FP&A Setup (Optional)

Skipped — Baseline Forecast Only
No forward data entered. The 13-week forecast will run in baseline mode, labeled "Baseline projection — no forward data entered."

To enable enhanced forecast: Enter revenue projections, seasonal patterns, planned capital expenditures, or known large payments/receipts.

All Sections Complete

CashLens has everything it needs. Click below to run the diagnostic and generate the full report.

Generate Diagnostic Report →
✓ All data auto-saved  ·  Session stored securely