Working-capital facility envelopeSeasonal peak applied after the base operating cycle
Business
Working Capital Capacity Calculator
Convert an available revolving facility into a sales-support capacity using the operating cash cycle. The model reserves a liquidity floor, applies receivables, inventory, and payables intensity to each revenue dollar, adds a seasonal peak factor, and identifies whether the entered sales plan fits inside the funding envelope.
Funding-supported annual sales-
Usable operating funding-
Base working capital per sales dollar-
Peak funding for sales plan-
Facility headroom / gap-
Receivables funding at peak-
Supplier funding offset-
Capacity status-
Planned peak funding relative to usable facility capacity
Funding envelope
See which operating balance consumes each dollar of liquidity
Funding consumedSupplier offset and headroom
| Case | DSO | Inventory days | DPO | Supported sales | Change vs base |
|---|
Facility planning
How to convert a liquidity limit into sales capacity
- Enter the committed facility rather than an uncommitted or aspirational limit.
- Protect a minimum liquidity reserve for volatility and non-operating cash needs.
- Describe the operating cycle with DSO, inventory days, DPO, and gross margin.
- Apply a seasonal peak factor to the base funding intensity.
- Compare funding-supported sales with the commercial plan and test operating levers before requesting more debt.
Capacity logic
Sales capacity is constrained by peak dollars required per sales dollar
The facility does not finance the entire business. It finances the receivables and inventory not already funded by suppliers, plus the reserve that management refuses to spend. A high gross margin reduces the inventory and payable basis, while seasonality scales the resulting operating requirement.
Detailed calculation process
Working-capital capacity formulas
Base intensity = DSO ÷ 365 + (1 − Gross margin) × (DIO − DPO) ÷ 365Peak intensity = Base intensity × (1 + Seasonal peak factor)Usable funding = Facility limit − Liquidity reserveFunding-supported sales = Usable funding ÷ Peak intensityHeadroom = Usable funding − Planned sales × Peak intensityLever sequencing
Use the sensitivity table as an operating queue
Faster collections usually change funding without changing product availability. Inventory reduction can release more cash but must be checked against service levels. Longer supplier terms may be valuable, yet purchasing should test price and continuity consequences before treasury counts the benefit.
Facility sizing check
Show why the entered sales plan exceeds borrowing capacity
Base funding per sales dollar = 50 / 365 + 63% x (65 - 40) / 365 = $0.1801Peak funding per sales dollar = $0.1801 x 1.18 = $0.2126Usable facility = $4,500,000 - $600,000 = $3,900,000 The facility supports about $18,347,619 of sales at the modeled peak. A $28,000,000 plan requires $5,951,726, leaving a $2,051,726 shortfall before any unmodeled covenant or borrowing-base haircut.
Credit committee packet
Evidence that strengthens a capacity conclusion
- Borrowing-base eligibility and concentration limits
- Monthly seasonal peaks, not annual averages
- Customer and supplier term distributions
- Inventory obsolescence and advance-rate exclusions
Important limitation
The result is operating capacity, not legal availability
Covenants, borrowing-base exclusions, letters of credit, lender discretion, and intra-month cash timing can reduce usable liquidity below the entered facility limit.
Working capital capacity FAQ
Common facility-planning questions
Why preserve a reserve?
A fully drawn facility leaves no protection for forecasting error, payroll timing, tax, or a delayed customer payment.
What if DPO exceeds inventory days?
The supplier offset may be large, but the model still includes receivables. Validate that long terms are durable.
Does supported sales equal a revenue forecast?
No. It is a funding ceiling under the entered operating-cycle assumptions.
Practical examples
Working Capital Capacity Calculator in real planning situations
- Size sales capacity under a fixed borrowing-base limit.
- Measure the capacity gained from reducing inventory days.
- Test whether seasonal working-capital peaks exceed available liquidity.
Important note
Before relying on this result
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Additional Working Capital Capacity Calculator questions
Is the facility limit the same as usable funding?
No. The liquidity reserve is held back before the model supports operating growth.
What if payables exceed inventory funding?
The receivables component still remains; the model floors total working-capital intensity above zero.
Does this replace a borrowing-base certificate?
No. Eligibility, concentration, advance rates, and lender covenants require a separate borrowing-base model.
Why apply a seasonality factor?
Peak sales or inventory periods may require more funding than the annual average.