Skip to content This library is free, offered as dana. If it helps your work, donate 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 →

Cash release opportunity quantifier

Quantifies the cash freed by working capital improvement initiatives across DSO, DPO, and DIO levers — converting current AR, AP, and inventory balances plus target improvement percentages into per-lever cash release…

download .md

Purpose

Turn a working capital balance sheet and a set of target improvement assumptions into a defensible cash release model — showing how much cash each lever frees, the total one-time and recurring benefit, and a risk-adjusted estimate that survives CFO scrutiny. Eliminates the back-of-envelope guesswork that makes most working capital business cases unfundable.

When to Use

Invoke this skill when the user asks to:

  • Size the cash impact of a working capital or liquidity improvement program
  • Quantify how much cash a DSO, DPO, or inventory reduction would release
  • Build the financial case for a receivables, payables, or inventory initiative
  • Compare which working capital lever delivers the most cash for the effort
  • Produce a risk-adjusted cash release estimate for a board or treasury committee
  • Translate target days-improvement assumptions into a dollar cash figure

Inputs Required

Before starting, collect:

  • Annual revenue: Trailing-twelve-month or forecast revenue figure
  • Annual COGS: Cost of goods sold (used for inventory and payables math)
  • Current AR balance: Outstanding accounts receivable, or current DSO if balance is unknown
  • Current AP balance: Outstanding accounts payable, or current DPO if balance is unknown
  • Current inventory balance: On-hand inventory value, or current DIO if balance is unknown
  • Target improvements: Per-lever targets — either days reduction (e.g., DSO from 52 to 45) or percentage improvement
  • Cost of capital / hurdle rate: Used to value the recurring carrying-cost benefit of released cash

If the user provides balances but not days metrics (or vice versa), derive the missing figure using the standard formulas. If a hurdle rate is missing, default to 10% and flag the assumption.

Instructions

Step 1: Establish the Baseline Working Capital Position

Calculate or confirm the current days metrics for each lever:

  • DSO = (AR ÷ Revenue) × 365
  • DPO = (AP ÷ COGS) × 365
  • DIO = (Inventory ÷ COGS) × 365
  • Cash Conversion Cycle (CCC) = DSO + DIO − DPO

Present the baseline as a small table: current balance, current days, and the daily revenue/COGS rate underpinning each lever. State the per-day cash value for each lever (Revenue ÷ 365 for AR; COGS ÷ 365 for AP and inventory) so every downstream number is traceable.

Step 2: Translate Targets Into Days Movement

For each lever, convert the user's target into a consistent days-improvement figure:

  • If given a target days value, use the delta from current.
  • If given a percentage improvement, apply it to the current days metric.
  • Normalize all three levers to the same unit (days improved) before calculating cash.

Flag any target that is aggressive relative to typical benchmarks (e.g., DSO improvements beyond ~10 days, DPO extensions beyond ~10 days without supplier renegotiation, DIO reductions beyond ~20%) — these affect the confidence weighting in Step 4.

Step 3: Calculate Per-Lever Cash Release

Compute the one-time cash released by each lever:

  • AR (DSO) release = Days improved × (Revenue ÷ 365)
  • Inventory (DIO) release = Days improved × (COGS ÷ 365)
  • AP (DPO) release = Days improved × (COGS ÷ 365) — note this is cash retained, not collected, but it lands the same on the balance sheet

Then split each into two benefit types:

  • One-time cash release: The balance sheet reduction — cash freed once when the lever moves to its new level.
  • Recurring annual benefit: The carrying-cost saving on released cash = One-time release × hurdle rate. This is the annual value of no longer financing that working capital.

Present a per-lever table: lever, days improved, one-time cash released, recurring annual benefit.

Step 4: Apply Confidence Weighting

Assign each lever a confidence factor based on execution difficulty and assumption aggressiveness:

  • High confidence (85–95%): Targets within benchmark, lever under direct internal control (e.g., tightening collections process, SKU rationalization on slow movers).
  • Medium confidence (60–80%): Moderate stretch, requires cross-functional or customer cooperation (e.g., revised payment terms on new contracts).
  • Low confidence (40–55%): Aggressive targets, depends on supplier/customer negotiation or demand-side change.

State the chosen factor and the one-line reason for each lever. Compute the risk-adjusted cash release = One-time release × confidence factor, and the risk-adjusted recurring benefit = Recurring benefit × confidence factor.

Step 5: Aggregate the Total Opportunity

Build the summary roll-up:

  • Total gross one-time cash release (sum across levers)
  • Total gross recurring annual benefit
  • Total risk-adjusted one-time cash release
  • Total risk-adjusted recurring annual benefit
  • Resulting improvement to the Cash Conversion Cycle (days)

Step 6: Rank and Recommend

Rank the three levers by risk-adjusted one-time cash release. Identify the single highest-value, most-controllable lever to pursue first, and note any lever whose gross opportunity looks large but collapses under confidence weighting (a common trap). Be opinionated about sequencing.

Output Format

  • Structure: Baseline table → targets table → per-lever cash release table → confidence-weighted table → aggregate summary → ranked recommendation
  • Length: 700–1,000 words plus tables
  • Format: Structured document with calculation tables; prose limited to assumptions, flags, and the recommendation
  • Sections: Baseline Position → Target Movement → Per-Lever Cash Release → Confidence Weighting → Total Opportunity Summary → Lever Ranking & Recommendation → Key Assumptions
  • Tone: Finance director — precise, numbers-first, every figure traceable to an input and formula; no hedging on the recommendation

Quality Checklist

Before delivering output, verify:

  • [ ] Every cash figure traces to a stated formula and input (per-day rate × days improved)
  • [ ] AR uses Revenue ÷ 365; AP and inventory use COGS ÷ 365 — not mixed up
  • [ ] One-time release and recurring benefit are reported separately for every lever
  • [ ] A confidence factor with a one-line reason is assigned to all three levers
  • [ ] Risk-adjusted totals are lower than gross totals (confidence applied correctly)
  • [ ] CCC improvement in days is calculated and reconciled to the dollar figures
  • [ ] The hurdle rate used is stated, and any defaulted assumption is flagged

Notes

  • The most common error in working capital cases is double-counting recurring benefit as if it were additional cash released — keep the one-time balance sheet reduction and the annual carrying-cost saving in separate columns.
  • DPO extension frees cash but carries relationship risk; weight it lower if the user has not confirmed supplier willingness.
  • Released cash is one-time and non-repeating unless the new days level is sustained — note that the recurring benefit assumes the improved CCC holds.
  • If the user wants a phased view, the lever ranking in Step 6 doubles as a sequencing plan: pursue high-confidence, internally-controlled levers before negotiation-dependent ones.

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