# Working Capital Dashboard

Monitor AR, inventory, AP, and cash conversion cycle trends from DSO, DIO, and DPO assumptions, then review working capital needs and cash flow effects across operating scenarios.

- Canonical: https://finamodel.com/excel-dashboard/working-capital
- Excel download: https://finamodel.com/templates/working-capital.xlsx

## About this dashboard

Working Capital Dashboard connects DSO, DIO, and DPO assumptions to accounts receivable, inventory, and accounts payable balances. It shows how collection timing, inventory holding, and supplier terms shape the cash conversion cycle and the funding required to support operations.

Dashboard outputs include CCC trends, working capital as a percentage of revenue, and the cash flow impact of changes in AR, inventory, and AP. The supporting workbook contains the component roll-forward schedules and sensitivity assumptions; the dashboard presents the resulting balances, ratios, and cash effects for review.

Use the dashboard for liquidity planning, revolving credit facility sizing, operational improvement reviews, and cash flow forecasting. Compare collection, inventory, and payment-term scenarios to understand where cash is tied up and how changes in operating assumptions affect funding needs and cash generation. Review peak requirements alongside operating growth to support financing discussions and planning decisions.

## What's included

- DSO, DIO, and DPO operating assumptions
- Accounts receivable, inventory, and accounts payable balances
- Cash conversion cycle trends
- Working capital as a percentage of revenue
- Cash flow impact of balance changes
- Collection, inventory, and supplier-term scenarios

## Frequently asked questions

### Which working capital drivers does the dashboard use?

The dashboard uses Days Sales Outstanding, Days Inventory Outstanding, and Days Payable Outstanding to derive receivables, inventory, and payables. Revenue, COGS, and purchasing assumptions in the supporting workbook determine the associated balance calculations.

### What does the cash conversion cycle show?

Cash conversion cycle equals DSO plus DIO minus DPO. It indicates how long operating cash is tied up between paying suppliers and collecting from customers, with lower or negative values indicating more efficient cash conversion.

### Which cash flow effects are displayed?

The dashboard displays the cash impact of changes in accounts receivable, inventory, and accounts payable. The supporting schedules calculate those movements, while the dashboard summarizes how working capital changes affect operating cash flow.

### Can I compare operating improvement scenarios?

Yes. Change collection timing, inventory days, or supplier payment terms in the supporting workbook to compare scenarios. The dashboard updates the related balances, cash conversion cycle, working capital percentage, and cash flow effects.

### Who can use this dashboard?

CFOs, treasurers, credit analysts, and corporate planners can use it to assess liquidity needs, size revolving facilities, review operating initiatives, and connect working capital assumptions with cash flow forecasts.

## Related dashboards

- [Financial Health Dashboard](https://finamodel.com/excel-dashboard/financial-health)
- [Board Reporting Pack Dashboard](https://finamodel.com/excel-dashboard/board-reporting)
- [Cash Flow Dashboard](https://finamodel.com/excel-dashboard/cashflow)
- [Income Statement Dashboard](https://finamodel.com/excel-dashboard/income-statement)