Working Capital Excel Template
Free Excel Financial Model Download
Receivables, payables and inventory days driving the cash conversion cycle.
Other examples (33 models)
Used by professionals from
About this working capital schedule
A working capital schedule forecasts receivables, inventory, payables, and other operating balances that drive the cash conversion cycle. It converts days sales outstanding, days inventory, days payable, and revenue or COGS assumptions into balance sheet and cash flow impacts.
Use this free Excel working capital schedule preview to see how models handle NWC rollforwards, cash conversion, and operating liquidity. It is useful for 3-statement models, acquisition models, credit analysis, and cash flow forecasts where timing of receipts and payments matters.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Frequently asked
What does the Working Capital schedule do?+
A working capital schedule forecasts receivables, inventory, payables, and other operating balances that drive the cash conversion cycle. It converts days sales outstanding, days inventory, days payable, and revenue or COGS assumptions into balance sheet and cash flow impacts.
When should I use a Working Capital schedule?+
Use this free Excel working capital schedule preview to see how models handle NWC rollforwards, cash conversion, and operating liquidity. It is useful for 3-statement models, acquisition models, credit analysis, and cash flow forecasts where timing of receipts and payments matters.
What is included on this Working Capital schedule page?+
The page includes a live Excel preview, source model examples, sheet-name variants, and related schedules for the working capital workflow.
Can I download the workbook behind this Working Capital example?+
Yes. Use the download button or open one of the linked source models to download the full Excel workbook that contains this schedule.
Have more financial modelling questions? Contact us
