Working Capital Metrics Cheat Sheet: AR, AP, and Inventory Formulas with 3-Statement Forecasts

Master working capital management using key turnover ratios and day conversions. Includes all formulas and 3-statement model examples you need.

1. Accounts Receivable Turnover

What it measures: Efficiency of collecting receivables.

Formula: Net Credit Sales / Average Accounts Receivable

Learn more / Practice:
📄 Accounts Receivable Turnover Formula & 3-Statement Forecast
🔍 Accounts Receivable Turnover Concept & Practices

2. Accounts Receivable Days

What it measures: Average days to collect receivables.

Formula: (Accounts Receivable / Net Credit Sales) * 365

Learn more / Practice:
📄 Accounts Receivable Days Formula & 3-Statement Forecast
🔍 Accounts-Receivable Days Concept & Practices

3. Accounts Payable Turnover

What it measures: How quickly a company pays suppliers.

Formula: Cost of Goods Sold / Average Accounts Payable

Learn more / Practice:

📄 Accounts Payable Turnover Formula & How to Use It in a 3-Statement Forecast
🔍 Accounts Payable Turnover & Practices

4. Accounts Payable Days

What it measures: Average days to pay suppliers.

Formula: (Accounts Payable / Total Cost of Goods Sold) * 365

Learn more / Practice:

📄 Accounts Payable Days Formula & How to Use It in a 3-Statement Forecast
🔍 Accounts Payable Days Concept & Practices

5. Inventory Turnover

What it measures: Efficiency of inventory management.

Formula: Cost of Goods Sold / Average Inventory

Learn more / Practice:
📄 Inventory Turnover Formula & 3-Statement Forecast
🔍 Inventory Turnover Concept & Practices

6. Inventory Days

What it measures: Average days inventory is held.

Formula: (Inventory / Total Cost of Goods Sold) * 365

Learn more / Practice:
📄 Inventory Days Formula & 3-Statement Forecast
🔍 Inventory Days Concept & Practices

Conclusion

These six metrics form the foundation of working capital management and are essential for effective financial modeling. For a deeper understanding and hands-on practice, explore the interactive 3-statement forecast examples linked above, as well as our Balance Sheet Forecast Practice, and Cash Flow Building Practice.