See how recurring revenue, receivable timing, inventory commitments, supplier terms, payroll, and collection delay combine across thirteen weeks to create or relieve liquidity pressure.
About this interactive
The analysis converts an entered weekly revenue path into customer cash and inventory requirements, places inventory orders ahead of sales using the entered lead time, applies supplier-payment timing, and carries recurring payroll and operating cash cost. A separate collection-delay stress path shows how much additional liquidity is required when receivables move later. No external working-capital benchmark is imposed. The view supports cash forecasting within our Private Equity FP&A practice.
Liquidity path
Each weekly revenue cohort creates same-week cash plus a delayed receivable. Inventory purchases are placed ahead of sales and supplier cash follows the entered payment lag, so collection timing and operating commitments can move in different weeks.
Weekly cash conversion
The ledger separates recognized revenue, customer cash, inventory purchase commitments, supplier cash, recurring operating cash cost, and the two resulting ending-cash paths.
What the interactive shows
PRIVATE EQUITY CASH CONVERSION CALENDAR — ILLUSTRATIVE DEFAULT RECORD INPUTS Starting cash: $2,500,000 Week 1 revenue: $500,000 Week 13 revenue: $650,000 Cash collected at sale: 20% Base collection lag: 35 days Collection-delay stress: +14 days Inventory cost share of revenue: 55% Inventory purchase lead: 2 weeks before sales Supplier payment lag: 28 days Weekly payroll: $125,000 Weekly other cash operating cost: $90,000 Minimum cash reserve: $1,500,000 COMPUTED POSITION 13-week revenue recognized: $7,475,000 Base collections inside horizon: $4,975,000 Stress collections inside horizon: $4,045,000 Base revenue still uncollected at Week 13: $2,500,000 Stress revenue still uncollected at Week 13: $3,430,000 Supplier payments committed beyond Week 13: $1,423,125 Lowest base cash: $1,661,250 in Week 5 Lowest stress cash: $852,500 in Week 9 Base funding required to maintain reserve: $0 Stress funding required to maintain reserve: $647,500 Additional funding exposure from collection delay: $647,500 FINDING A 14-day collection delay moves $930,000 of customer cash outside the 13-week horizon relative to the base case and creates $647,500 of additional funding exposure against the entered reserve. METHOD STATUS Management-entered planning assumptions. Weekly revenue changes linearly from Week 1 to Week 13. The entered cash-at-sale share is collected in the revenue week and the remaining receivable is collected after the entered lag. Inventory orders are placed ahead of the sales week using the entered lead time and cost share, with Week 13 revenue held flat only for post-horizon sales needed to calculate purchase orders placed inside the horizon. Supplier cash follows the entered payment lag. Payroll and other cash operating cost recur weekly. No external benchmark is used.
Continue your analyses, email calculation records, and return to your work from one account.
By creating an account, you agree to the Terms of Use and acknowledge the Privacy Policy.
Enter the 6-digit code sent to .
