Working capital schedule
Receivables, inventory and payables in days.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: working capital schedule.Updated 30 September 2026
Part of m&a and private equity models, with the models, labs and guides around it.
Part of project finance and infrastructure models, with the models, labs and guides around it.
Part of healthcare financial models, with the models, labs and guides around it.
Part of technology company financial models, with the models, labs and guides around it.
What it does
Receivables follow revenue, inventory and payables follow cost of sales, each through a days assumption. The balances go to the balance sheet; the year-on-year change goes to the cash flow statement as a use or source of cash. In a DCF the same idea appears as net working capital as a share of revenue.
Where it lives
The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.
- Assumptions, rows 30–33: Days sales outstanding (DSO), Days inventory outstanding (DIO), Days payables outstanding (DPO), Days in the year
- Working Capital, rows 6–10: Accounts receivable, Inventory, Accounts payable, Net working capital…
- Assumptions, rows 11–12: Net working capital, % of revenue, Net working capital, last reported year
- Forecast, rows 17–18: Net working capital balance, Less increase in net working capital
- Assumptions, row 39: Net working capital, % of revenue
- Operating Model, rows 23–24: Net working capital balance, Less increase in net working capital
- Assumptions, rows 59–60: Net working capital, % of revenue, Tonnage tax
- P&L & Cash Flow, rows 17–22: Net working capital, Less: increase in net working capital, Less: capital spending, Add: scrap proceeds…
- Assumptions, rows 29–33: Research and development, % of revenue, Selling, general and administrative, % of revenue, Tax rate, Net working capital, % of revenue…
- Cash Flow, rows 9–10: Net working capital, Less: increase in net working capital
- Assumptions, rows 64–65: Net working capital, % of revenue, Tax rate
- Cash Flow, rows 22–27: Net working capital, Less: increase in net working capital, Less: capital spending, Unlevered free cash flow…
- Assumptions, rows 82–84: Air traffic liability, days of passenger and ancillary revenue, Receivables, days of revenue, Payables, days of operating costs before rent and depreciation
- Financials, rows 27–31: Receivables, Air traffic liability (unearned revenue), Payables, Net working capital…
- Assumptions, rows 89–96: Days in the year, Work in progress, days of revenue, Receivables, days of revenue (DSO), Work in progress, end of FY0A…
- Working Capital and Cash, rows 6–13: Revenue, Work in progress, closing, Billed to clients, Receivables, closing…
- Working Capital and Cash, rows 16–17: Bonuses accrued, closing, Bonuses paid
- Assumptions, rows 69–81: Stock days, on cost of goods sold, FY0, Stock days, base, Stock days, downturn, Stock days, upside…
- Cash Flow, rows 14–24: Cost of goods sold, Stock days assumed, Stock, Receivables…
- Cash Flow, rows 15–16: Net working capital, Less: increase in net working capital
- Assumptions, rows 75–76: Net working capital, % of revenue, Tax rate
- P&L & Cash Flow, rows 18–27: Net working capital, Less: increase in net working capital, Less: capital spending, Less: tax on EBIT…
- Reported, rows 126–130: Unearned fees at 30 June 2025, Unearned fees at 30 June 2026, Funds receivable and amounts held on behalf of customers at 30 June 2026, Net cash provided by operating activities, first half of 2025…
- Derived, rows 45–52: Unearned fees at year end / GBV, Unearned fees at year end / revenue, Change in unearned fees on the balance sheet, Cash flow line less balance-sheet change (currency and other)…
- Forecast, rows 41–46: Growth in unearned fees in FY2026E (editorial, every case), Unearned fees / GBV in FY2030E, base (editorial), Unearned fees / GBV in FY2030E, downside (editorial), Unearned fees / GBV in FY2030E, upside (editorial)…
- P&L & Cash Flow, rows 48–51: Unearned fees at year end (the company’s fees, collected before the stay), Change in unearned fees: cash collected ahead of revenue, Memo: customer funds held for hosts and guests, Memo: the matching amount payable to hosts and guests
What a reviewer looks for
- Building payables from revenue rather than cost of sales.
- Taking the change with the wrong sign, so growth generates cash.
- Days assumptions that jump from the last actual year with no reason given.
Learn it, then build it
Build · Lab · ~8 min
Three-Statement Linker
Walk any event through all three statements in the right order, with the right signs, and prove the balance sheet balances rather than asserting it.
Read · Guide · 15 min
How to Build a Three-Statement Model That Actually Balances
Read · Guide · 7 min
"Walk Me Through the Three Statements" and Every Follow-Up
Vocabulary: Working Capital.