Working Capital Schedule

Definition¶

A working capital schedule is the section of a financial model that calculates the period-by-period movements in a company's or project's net current assets — the difference between current assets (principally trade receivables) and current liabilities (principally trade payables and accrued liabilities). It translates revenue and cost accruals from the income statement into actual cash flows by capturing the timing difference between when economic activity is recognised and when cash is received or paid.

Working capital is defined as:

Net Working Capital = Current Assets - Current Liabilities

Where Current Assets include: Trade receivables, inventory, prepayments
Where Current Liabilities include: Trade payables, accrued liabilities, advance receipts

The working capital schedule calculates the change in net working capital in each period, which is a cash flow adjustment in the cash flow statement:

• An increase in net working capital is a cash outflow (cash is being absorbed into receivables or inventory)
• A decrease in net working capital is a cash inflow (cash is being released from payables or receivables)

Why It Matters¶

Working capital is a critical bridge between the income statement and the cash flow statement. A model that omits working capital or models it incorrectly will show a cash flow profile that does not reflect the actual timing of cash receipts and payments.

In most corporate and project finance models, working capital movements are smaller than operating cash flows. However, in businesses with:

• Long payment cycles (large receivables balances)
• High inventory requirements
• Short payment terms to suppliers (rapid creditor turnover)
• Seasonal cash flow patterns

...working capital movements can be material and their mismodelling can lead to significant cash flow forecasting errors, incorrect DSCR calculations, and incorrect debt sizing.

Technical Background¶

Key Working Capital Metrics¶

Working capital is calculated and projected using debtor days, creditor days, and inventory days:

Debtor Days (Days Sales Outstanding, DSO) The average number of days between revenue recognition and cash receipt:

Debtor Days = (Trade Receivables / Revenue) × Number of Days in Period

A debtor days assumption of 45 means that, on average, customers pay 45 days after the invoice is raised. In the model, this translates to:

Trade Receivables Balance = Revenue × (Debtor Days / Days in Period)

Creditor Days (Days Payable Outstanding, DPO) The average number of days between cost recognition and cash payment:

Creditor Days = (Trade Payables / Operating Costs) × Number of Days in Period

A creditor days assumption of 30 means the company pays its suppliers 30 days after the invoice is received.

Inventory Days (Days Inventory Outstanding, DIO) The average number of days of inventory held:

Inventory Days = (Inventory / Cost of Goods Sold) × Number of Days in Period

For project finance models and service businesses without physical inventory, the inventory calculation is typically zero or omitted.

Working Capital Schedule Structure¶

A standard working capital schedule in a financial model contains the following rows:

The net working capital movement flows into the cash flow statement as an adjustment to cash from operations.

Working Capital in the Cash Flow Statement¶

In the indirect method cash flow statement:

Operating Cash Flow = 
  Net income
+ Depreciation and amortisation
+ / - Change in working capital
  (Increase in receivables = negative)
  (Decrease in receivables = positive)
  (Increase in payables = positive)
  (Decrease in payables = negative)
- Capital expenditure
= Free Cash Flow

The working capital schedule feeds the "Change in working capital" line in the cash flow statement. Errors in the working capital schedule propagate directly into free cash flow, CADS, and DSCR.

Working Capital in the Opening Year¶

The opening year of the model requires special treatment because there is no prior period from which to derive the opening balance:

• For a new project, working capital balances start at zero and build up over the first operating period
• For a model based on an existing business, the opening balance sheet should provide the starting working capital balances

A common error is to assume zero opening balances for an existing business, understating the cash required to fund the existing working capital position.

Seasonal Working Capital¶

For businesses with seasonal revenue patterns, a monthly or quarterly working capital model is more accurate than an annual one. An annual model may understate the peak working capital requirement if revenues are concentrated in certain months.

Working Capital in Project Finance¶

Many project finance assets have minimal working capital because: - Revenue is received promptly (monthly availability payments, for example) - Suppliers are paid on short credit terms - There is no inventory

Where this is the case, it is acceptable to model working capital as a small percentage of revenue or costs, or to model it with a simplified debtor days and creditor days approach.

However, for project finance assets with longer payment cycles — such as power projects where offtake payments are made quarterly in arrears — working capital movements can affect DSCR at the quarterly level, even if the annual impact is modest.

Audit Considerations¶

1. Debtor and Creditor Days Basis¶

Verify that the debtor days and creditor days assumptions are: - Based on the contractual payment terms in the relevant agreements (offtake agreements, EPC contracts, O&M contracts) - Or, for businesses without specific contractual terms, based on industry norms or historical performance - Documented with a stated basis in the model's assumption register

2. Consistency with Income Statement¶

Confirm that the working capital schedule uses the same revenue and cost figures as the income statement. A discrepancy between the revenue used in the working capital calculation and the revenue in the income statement will produce a cash flow error.

3. Balance Sheet Reconciliation¶

Verify that the closing trade receivables and trade payables balances from the working capital schedule appear correctly in the balance sheet. The three financial statements must reconcile.

4. First Period Treatment¶

Check the opening working capital balance assumption. For a new project, zero is correct. For an existing business, the model should use the actual opening balances from the balance sheet.

5. Working Capital Change Direction¶

As a sanity check: when revenue is growing, trade receivables should be growing, and the change in working capital should be negative (cash outflow). If the model shows growing revenue but a positive working capital cash inflow, this is likely an error.

6. Days in Period¶

Confirm that the days in period used in the working capital calculation matches the model's period structure. A model with semi-annual periods should use 182.5 days (or the actual number of days per semi-annual period); an annual model should use 365 days.

Common Errors¶

Best Practices¶

Build the working capital schedule in a dedicated section of the model, clearly separated from the income statement and directly linked to the cash flow statement and balance sheet. Avoid embedding working capital calculations within the income statement rows — this obscures the logic and makes auditing more difficult.

Document the source of debtor days and creditor days assumptions explicitly in the assumption register. State whether the assumption is based on contractual terms, historical performance, or market norms.

Include a working capital summary table showing the opening and closing balances of trade receivables and trade payables at each period end, and the net movement. This makes the working capital cash flow auditable without requiring the reviewer to trace through the full calculation.

Continue Reading¶

Prerequisites¶

• What Makes an Excel Financial Model Reliable? — the parent pillar

Related Pillars¶

• What Makes an Excel Financial Model Reliable?
• Financial Statements in Financial Modelling — how the working capital schedule connects to the cash flow statement and balance sheet within a three-statement model

Related Technical Guides¶

• Formula Consistency in Financial Models
• Statement Linking Mechanics — the working-capital sign conventions used to link this schedule into the cash flow statement

Related Glossary¶

• Cash Waterfall
• Project Finance Model
• Depreciation Schedule