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
Prepaid Expense Workpaper
Track and amortize prepaid expenses with a structured workpaper that keeps your schedules accurate and audit-ready every close.
Close ManagementStandard Month-End Close Checklist
A comprehensive checklist to ensure nothing falls through the cracks during your month-end close. Track every task, owner, and deadline in one place.
Close ManagementClose Calendar Template
Plan out your entire month-end and quarter-end close timeline with a structured calendar. Coordinate across teams and set clear deadlines.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.