The preparation of a Schedule of Changes in Working Capital involves detailing the changes in current assets and current liabilities over a specific period, typically a year or a quarter. This schedule is essential for understanding how working capital has evolved and identifying factors driving the changes.
Steps to Prepare a Schedule of Changes in Working Capital:
-
Identify Current Assets:
List all current assets that include cash and cash equivalents, accounts receivable, inventory, and short-term investments.
-
Identify Current Liabilities:
List all current liabilities such as accounts payable, short-term debt, accrued expenses, and other short-term obligations.
-
Initial Period Balances:
Record the balances of each current asset and current liability at the beginning of the period (e.g., start of the year or start of the quarter).
-
Final Period Balances:
Record the balances of each current asset and current liability at the end of the period (e.g., end of the year or end of the quarter).
-
Calculate Changes in Current Assets:
- For each current asset, calculate the change by subtracting the initial balance from the final balance.
- Example: Change in Accounts Receivable = Final Accounts Receivable – Initial Accounts Receivable
-
Calculate Changes in Current Liabilities:
- For each current liability, calculate the change by subtracting the initial balance from the final balance.
- Example: Change in Accounts Payable = Final Accounts Payable – Initial Accounts Payable
-
Prepare the Schedule:
- Create a table or spreadsheet listing each current asset and current liability.
- Include columns for initial balances, final balances, changes, and any additional notes or explanations for significant changes.
-
Analysis and Interpretation:
- Analyze the changes in working capital components to understand the factors contributing to the overall change in working capital.
- Identify trends, such as increases or decreases in accounts receivable, inventory levels, or changes in accounts payable that affect liquidity and operational efficiency.
Example of a Schedule of Changes in Working Capital
| Current Assets/Liabilities | Initial Balance | Final Balance | Change |
| Cash and Cash Equivalents | $50,000 | $60,000 | +$10,000 |
| Accounts Receivable | $80,000 | $70,000 | -$10,000 |
| Inventory | $120,000 | $130,000 | +$10,000 |
| Short-term Investments | $20,000 | $25,000 | +$5,000 |
| Total Current Assets | $270,000 | $285,000 | +$15,000 |
| Accounts Payable | $40,000 | $35,000 | -$5,000 |
| Short-term Debt | $30,000 | $25,000 | -$5,000 |
| Accrued Expenses | $15,000 | $20,000 | +$5,000 |
| Other Current Liabilities | $10,000 | $12,000 | +$2,000 |
| Total Current Liabilities | $95,000 | $92,000 | -$3,000 |
| Net Change in Working Capital | +$12,000 |
Importance of Schedule of Changes in Working Capital:
-
Financial Analysis:
Provides a detailed breakdown of changes in liquidity and operational efficiency.
-
Management Decision-making:
Helps in assessing the impact of working capital changes on overall financial health and strategic planning.
-
Investor Transparency:
Offers transparency to stakeholders regarding how effectively working capital is managed and utilized.