Working Capital Forecast Template
Forecast changes in working capital (receivables, inventory, payables). Plan for cash needs or surpluses driven by operating growth.
How to use this template
Build working capital model
Create schedule showing projected accounts receivable, inventory, and accounts payable for next 12 months based on revenue and expense projections.
Project receivables
Calculate projected AR based on sales growth and days sales outstanding. Model seasonal impacts on cash collection timing.
Project inventory
Calculate projected inventory based on cost of goods sold and inventory turnover assumptions. Model lead time impacts.
Project payables
Calculate projected AP based on COGS and operating expense growth, using days payable outstanding assumptions.
Calculate cash impact
Calculate net working capital changes period-over-period. Project whether operating growth requires additional financing or generates free cash.
Why use this template
- Projects cash needs driven by business growth
- Identifies whether growth can be self-financed or requires external funding
- Supports planning for credit facilities or capital raises
- Enables management to optimize cash conversion cycle
Related templates
Rolling Forecast Model
Create a rolling 12-month forecast that updates each period. Replace outdated monthly budgets with current projections based on actual performance.
FP&AHeadcount and Compensation Forecast
Forecast future headcount and compensation by department and level. Project payroll expense and track personnel costs.
FP&ACash Flow Projection Model
Build detailed cash flow projection for the next 12-24 months. Forecast operating, investing, and financing cash flows monthly.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.