Private Equity Working Capital Velocity Test

Separate cash absorbed by activity growth from cash absorbed or released by changes in receivables, inventory, and supplier-payment velocity, then test the next-period requirement if the current cycle persists.

About this interactive

The analysis converts prior and current revenue, COGS, DSO, DIO, and DPO into working-capital balances, then decomposes each balance change into activity and velocity effects. That makes it possible to see when an unchanged cash-conversion cycle is masking deterioration in receivables or inventory that is being offset by supplier terms. A forward test applies entered next-period activity growth to the current days. No external working-capital benchmark is imposed. The view supports operating cash review within our Private Equity FP&A practice.

Revenue from the prior comparison period.
Revenue from the current comparison period.
COGS from the prior comparison period.
COGS from the current comparison period.
Receivable days in the prior comparison period.
Receivable days in the current comparison period.
Inventory days in the prior comparison period.
Inventory days in the current comparison period.
Supplier-payment days in the prior comparison period.
Supplier-payment days in the current comparison period.
Management-entered change applied to current revenue for the forward cash test.
Management-entered change applied to current COGS for the forward cash test.
Cash-conversion cycle55.0 → 55.0 daysPrior to current
Net working-capital cash change−$2.35MPositive releases cash; negative absorbs cash
Activity / growth effect−$1.75MCash effect from changed revenue and COGS
Velocity / terms effect−$607KCash effect from changed DSO, DIO, and DPO
Forward cash requirement−$1.00MIf current days persist into entered growth

Working-capital decomposition

Cash effect by operating component

Each component is decomposed exactly into the portion caused by changed activity and the portion caused by changed days. Receivables and inventory increases consume cash; payables increases release cash.

Activity / growth effect Velocity / terms effect Zero cash effect

Balance reconciliation

What changed underneath the headline cycle

The table keeps the balance movement, cash effect, and exact decomposition visible together, which matters when offsetting changes leave the aggregate cycle unchanged.

ComponentPrior balanceCurrent balanceCash changeActivity effectVelocity / terms

What the interactive shows

CITY SHIFT FINANCE

Create your account

Continue your analyses, email calculation records, and return to your work from one account.

Have an account?

Contact us

Contact us

Contact

Topics of Interest:

Sign up to download