Skip to content This library is free, offered as dana. If it helps your work, donate here →
penguin tree ai
← back to libraryDonate here

This is one of 3,622 free prompts in the penguin tree ai library. Sign up once and the whole library opens, with new prompts by email.

open the library →

Working capital benchmarking analyzer

Benchmarks a company's working capital metrics (DSO, DPO, DIO, CCC) against sector quartile ranges, ranks the performance gaps, and calculates the implied cash release available if the company reaches median and…

download .md

Purpose

Convert a company's working capital metrics into a peer-benchmarked, cash-quantified diagnostic — showing exactly which levers (receivables, payables, inventory) are lagging the sector, ranked by the cash they would release. Turns abstract DSO/DPO/DIO/CCC figures into a defensible number for how much cash is trapped versus median and upper-quartile peers.

When to Use

Invoke this skill when the user asks to:

  • Benchmark working capital or cash conversion cycle against industry peers
  • Compare DSO, DPO, DIO, or CCC to sector quartiles
  • Quantify how much cash is trapped in receivables, inventory, or payables timing
  • Build a case for a working capital improvement or liquidity release program
  • Identify which working capital metric to prioritize for cash generation
  • Prepare a peer-comparison slide or CFO narrative on cash performance

Inputs Required

Before starting, collect:

  • Sector / industry: The peer group to benchmark against (e.g., specialty retail, industrial distribution, SaaS, food manufacturing)
  • Annual revenue: Used to translate day-based gaps into cash amounts
  • Annual COGS: Used to convert DIO and DPO days into cash (revenue is not the correct base for these)
  • DSO: Days Sales Outstanding — current
  • DPO: Days Payable Outstanding — current
  • DIO: Days Inventory Outstanding — current
  • CCC: Cash Conversion Cycle — current (if omitted, calculate as DSO + DIO − DPO)
  • Benchmark source (optional): If the user supplies quartile figures, use them; otherwise apply representative sector quartile ranges and state the assumption explicitly.

If benchmark quartiles are not provided, use reasonable sector-typical quartile ranges and flag them as estimates to be validated against a subscription peer dataset (e.g., CapIQ, PwC/REL, Hackett).

Instructions

Step 1: Validate and Normalize Inputs

  • Confirm CCC reconciles: CCC = DSO + DIO − DPO. If the supplied CCC does not match within ±1 day, flag the discrepancy and use the component-derived value.
  • Establish the correct cash base for each metric:
  • DSO → daily revenue (Revenue ÷ 365)
  • DIO → daily COGS (COGS ÷ 365)
  • DPO → daily COGS (COGS ÷ 365)
  • Note that improving DPO (paying slower) is a cash source, while improving DSO/DIO (collecting/turning faster) reduces the days figure.

Step 2: Assemble the Sector Quartile Benchmark

For each of DSO, DPO, DIO, and CCC, establish four reference points:

  • Top quartile (best-in-class): DSO/DIO/CCC low; DPO high
  • Median
  • Bottom quartile (laggard): DSO/DIO/CCC high; DPO low
  • Company position: Place the company against these ranges and label it (e.g., "between median and bottom quartile")

Present this as a comparison table: Metric | Company | Top Quartile | Median | Bottom Quartile | Position.

Step 3: Calculate the Days Gap to Median and Upper Quartile

For each metric, compute:

  • Gap to median (in days): the improvement needed to reach the median
  • Gap to upper quartile (in days): the improvement needed to reach best-in-class
  • Direction matters: for DSO/DIO the company must reduce days; for DPO the company must increase days. Where the company already outperforms median, report the gap as zero (no cash release from that lever) and note the outperformance.

Step 4: Convert Days Gaps into Implied Cash Release

For each metric and each target (median, upper quartile):

  • DSO cash release = Days gap × (Revenue ÷ 365)
  • DIO cash release = Days gap × (COGS ÷ 365)
  • DPO cash release = Days gap × (COGS ÷ 365)

Show the arithmetic for at least the largest lever. Sum the metric-level releases into a total implied cash release at median and a total implied cash release at upper quartile. Do not double-count — CCC is a summary of the three components, so cash release is aggregated from the components, not from CCC separately.

Step 5: Rank the Gaps by Cash Opportunity

Produce a ranked list of the three levers (DSO, DIO, DPO) ordered by implied cash release at upper-quartile performance, largest first. For each ranked lever include:

  • Cash release at median and at upper quartile
  • Days gap
  • A one-line read on difficulty/realism (e.g., DPO extensions may strain supplier relationships; DIO reductions depend on demand forecasting; DSO reductions depend on collections discipline and terms)

Step 6: Write Per-Metric Commentary

For each of DSO, DIO, DPO, and CCC, write 2–4 sentences covering:

  • Where the company sits versus peers and by how much
  • The likely operational driver of the gap
  • The specific lever to pull and one realistic first action
  • A caveat where relevant (seasonality, one-off inventory build, terms concentration, factoring, sector payment norms)

Step 7: Summary Recommendation

State the single highest-value lever, the realistic near-term cash target (median), the stretch target (upper quartile), and the one initiative to launch first. Be specific and quantified.

Output Format

  • Structure: Benchmark comparison table → days-gap table → implied cash release table (median and upper quartile) → ranked gap analysis → per-metric commentary → summary recommendation
  • Length: 800–1,100 words plus tables
  • Format: Structured document with three tables and prose commentary; numbers formatted with currency and day units
  • Sections: Quartile Benchmark → Gap to Median/Upper Quartile → Implied Cash Release → Ranked Opportunity → Per-Metric Commentary → Summary Recommendation
  • Tone: FP&A director — quantitative, plain-spoken, defensible; every claim tied to a number

Quality Checklist

Before delivering output, verify:

  • [ ] DSO cash uses revenue base; DIO and DPO cash use COGS base (not mixed)
  • [ ] CCC reconciles to DSO + DIO − DPO, and any discrepancy is flagged
  • [ ] Total cash release is aggregated from the three components, not double-counted with CCC
  • [ ] Every metric shows both a median gap and an upper-quartile gap in days
  • [ ] The ranked opportunity list orders levers by cash release, largest first
  • [ ] Benchmark figures are either user-supplied or explicitly labeled as sector estimates to validate

Notes

  • DPO improvement is real cash but carries relationship and supply-chain risk — flag it rather than treat it as free money, especially where the company already sits near sector norms.
  • A negative CCC (common in retail and marketplaces) is a feature, not a defect — benchmark it against sector peers rather than treating "lower is always better" as universal.
  • Where the company already outperforms median on a metric, say so plainly; overstating the opportunity undermines the credibility of the whole analysis.
  • Seasonality and period-end snapshots distort day-based metrics; recommend using a trailing-average balance where the user has the data.

How to use this skill

This file is a Claude Code skill in Anthropic's standard format — markdown with YAML frontmatter at the top.

Installing in Claude Code:

  • ~/.claude/skills/<folder-name>/SKILL.md — auto-loads in every session anywhere on your machine (recommended for skills you'll use across multiple projects)
  • <your-project>/.claude/skills/<folder-name>/SKILL.md — auto-loads only when working in that project (recommended for project-specific skills)

Restart Claude Code or open a new session to register.

Using in Claude.ai, ChatGPT, Gemini, or other AI tools:

  1. Drag this file into a new chat, or copy and paste its contents
  2. Send your task or request as your next message — the AI will apply the skill where it fits

For Claude Code skill details: https://docs.anthropic.com/en/docs/claude-code/skills