Operating schedules · in 12 models

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.

Integrated three-statement model
  • 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…
Discounted cash flow model
  • 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
Leveraged buyout model
  • Assumptions, row 39: Net working capital, % of revenue
  • Operating Model, rows 23–24: Net working capital balance, Less increase in net working capital
Container shipping model: liner company
  • 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…
Medtech installed-base and consumables model
  • 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
Healthcare services model: hospital operator
  • 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…
Airline operating and valuation model
  • 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…
Professional services utilisation model
  • 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
Multi-store retail model
  • 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…
Restaurant franchise roll-out model
  • Cash Flow, rows 15–16: Net working capital, Less: increase in net working capital
Telecom operator model: mobile and fibre
  • 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…
Airbnb operating model
  • 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

Vocabulary: Working Capital.

Other operating schedules

Capex and depreciation (PP&E roll-forward)Airline capacity and traffic: ASK, RPK and load factorAirline unit revenue and unit cost: RASK and CASKAirline fuel cost and hedgingType curves and production declineOil and gas reserves roll-forwardRealised prices and the field netbackUnits-of-production DD&AContainer fleet: owned, chartered, newbuilds and scrappingMine plan: from ore reserve to payable metalC1 cash cost and all-in sustaining costMine closure and rehabilitation provisionLiftings and freight rate: a liner’s revenueSystem sales and royalties: a franchisor’s units and volumesRestaurant unit economics: restaurant margin and new-unit returnsBunker fuel and the bunker adjustment factorRate base roll-forwardAllowed revenue: the building blocksRegulatory lag: earned against allowed returnHeadcount pyramid: hiring, attrition and promotionMobile subscriber roll-forward: gross adds, churn, net addsFibre build: homes passed, penetration and connectionsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTenancy roll-forward: anchor, colocation and the tenancy ratioTower unit economics: yield on cost by tenantGround lease schedule: rent, escalators and buy-outsUtilisation and realisation: hours to fee revenueProfit per partner: pay, bonus pools and partnership profitStore estate roll-forward and cohortsRetail sales: density, like-for-like and onlineFour-wall EBITDA and new-store paybackStore leases under IFRS 16Driver-based budget: volume, price, heads and cost per headRolling forecast: actuals, reforecast and the outturnPrice-volume-mix: revenue and margin varianceCost variances: rate, volume, heads and cost per headEBITDA bridge: plan to actual and forecastCapacity cohorts: MW, GPUs, utilisation and revenueBacklog roll-forward: contracts to revenue to cashCapital roll-forwardRisk budgetTrading cost baseSponsorship revenue