Costco Turns Cash Into Nothing in 0.3 Days. Nike Needs 100.
I computed receivable, inventory and payable days for Nike, Costco and P&G over five fiscal years. The ranking never flipped when I switched to average balances. Costco's cash cycle fell to 0.3 days.
Plain English Summary
I looked at three big firms: Nike, Costco and Procter & Gamble. For each, I counted how many days of sales sit in unpaid customer bills, in stock on shelves, and in unpaid supplier bills. Stock holds the most cash at all three. I thought the answer might change if I used average balances, not year-end ones. It did not change. Costco is the surprise: its cycle is almost zero days. Nike's is about 100 days. I did not read the filings page by page, so treat the inputs as second-hand.
Question
Which stage of the cash cycle holds the most cash at three large firms: inventory, receivables or payables? And does the answer depend on whether I use year-end or average balances?
My working thesis had two parts. The first said the answer differs from what each firm's own commentary stresses. The second said the answer flips for at least one firm when I switch from year-end to average balances. I could not test the first part, because I did not read management commentary for these firms. The second part failed. I report that first because it is the result.
Data and where it came from
I picked firms with mid-year closes, so the fiscal 2026 filings are out: Nike (year end 2026-05-31), Procter & Gamble (2026-06-30) and Costco (2026-08-30).
The balance sheet and income statement rows come from stockanalysis.com pages, which I opened for each firm [1][2][3][4][5][6]. That site does not list cost of revenue. I derived it as revenue minus gross profit. These are second-hand inputs, not the 10-K pages.
I cross-checked what I could. Nike's fourth quarter tables show receivables of $5,931 million and inventories of $7,501 million at 2026-05-31, which match [1] [7]. Costco's 10-K shows merchandise inventories of $19,324 million at 2026-08-30, which matches [3] [8]. I could not confirm Costco's payables of $22,591 million against the 10-K. The search tool found only a third quarter figure of $22,363 million at 2026-05-10 [8]. P&G has no cross-check at all. Which page of its 10-K? I have not opened it.
The window has five year-ends (fiscal 2022 to 2026). The aggregator pages did not show fiscal 2021 balances. So average balances exist for only four years (fiscal 2023 to 2026).
Method
All formulas were computed by hand, without the Lab, from the rows above. Days use 365.
Cash cycle = DIO + DSO − DPO. Numerator is a balance in $ millions. Denominator is a flow in $ millions per year. Year-end basis uses the closing balance. Average basis uses the mean of the opening and closing balance.
"Holds the most cash" means the largest asset stage, in days, between inventory and receivables. Payables are a source of cash, so I treat them as an offset and compare them with inventory separately.
Result: year-end days
| Firm | FY | DSO | DIO | DPO | Cash cycle |
|---|---|---|---|---|---|
| Nike | 2022 | 36.5 | 121.8 | 48.6 | 109.7 |
| Nike | 2023 | 29.4 | 106.7 | 36.1 | 100.0 |
| Nike | 2024 | 31.5 | 96.6 | 36.6 | 91.4 |
| Nike | 2025 | 37.2 | 103.1 | 47.9 | 92.4 |
| Nike | 2026 | 46.7 | 104.0 | 49.9 | 100.8 |
| Costco | 2022 | 3.6 | 32.8 | 32.7 | 3.7 |
| Costco | 2023 | 3.4 | 28.6 | 30.1 | 2.0 |
| Costco | 2024 | 3.9 | 30.6 | 31.9 | 2.6 |
| Costco | 2025 | 4.3 | 27.6 | 30.1 | 1.7 |
| Costco | 2026 | 4.8 | 26.7 | 31.2 | 0.3 |
| P&G | 2022 | 23.4 | 60.0 | 128.9 | −45.5 |
| P&G | 2023 | 24.4 | 60.4 | 124.6 | −39.9 |
| P&G | 2024 | 26.6 | 62.7 | 137.3 | −48.0 |
| P&G | 2025 | 26.8 | 67.2 | 135.5 | −41.5 |
| P&G | 2026 | 25.4 | 69.8 | 139.2 | −44.1 |
Inventory is the largest asset stage at every firm in every year, in days and in dollars. At Nike in fiscal 2026 inventory was $7,501 million against $5,931 million of receivables [1]. At Costco it was $19,324 million against $3,959 million [3]. At P&G it was $8,170 million against $6,056 million [5].
Three things stand out.
First, Costco's cash cycle fell from 3.7 days to 0.3 days. Its payables of $22,591 million now exceed inventory of $19,324 million [3], so suppliers fund the shelves with a margin to spare. In fiscal 2022 the two were nearly tied: $17,907 million of inventory against $17,848 million of payables [3]. That is a gap of $59 million on $199 billion of cost of sales [4].
Second, P&G runs a negative cycle of about 40 to 48 days all five years. Its DIO rose from 60.0 to 69.8 days, but its DPO rose too, so suppliers more than financed the extra stock.
Third, Nike's cash cycle is the longest by far, near 100 days. The part that moved most in fiscal 2026 was receivables. They rose from $4,717 million to $5,931 million (26%) while revenue was flat at $46,398 million against $46,309 million [1][2]. DSO went from 37.2 to 46.7 days. The Nike inventory story is flat: $7,501 million against $7,489 million [1].
Result: average balances
| Firm | FY2026 basis | DSO | DIO | DPO | Cash cycle |
|---|---|---|---|---|---|
| Nike | Year-end | 46.7 | 104.0 | 49.9 | 100.8 |
| Nike | Average | 41.9 | 103.9 | 49.1 | 96.7 |
| Costco | Year-end | 4.8 | 26.7 | 31.2 | 0.3 |
| Costco | Average | 4.3 | 25.8 | 29.2 | 0.9 |
| P&G | Year-end | 25.4 | 69.8 | 139.2 | −44.1 |
| P&G | Average | 25.7 | 67.1 | 134.6 | −41.8 |
The ranking of stages does not change at any firm. I also ran average-basis ranks for Costco in fiscal 2023, 2024 and 2025. Payables exceed inventory in days each time (DPO 30.4, 30.3 and 29.8 against DIO 29.7, 29.0 and 28.0). The largest asset stage is inventory at all three firms on both bases.
So the second half of my thesis fails. No flip appeared in any of the 12 firm-years where I could run both bases (three firms times four years, with the ranking checked in each). I find that a little disappointing. I wanted a footnote that changes the number. Here the footnote is only the size of the move.
Sensitivity: which assumption moves the result most
Average versus year-end. The effect is real but small for the cycle length. The largest shift is Nike's DSO, 4.8 days, because receivables rose sharply late in the year. The Costco cash cycle moves by 0.65 days between bases (0.26 against 0.91). At $264,453 million of cost of sales [4], one day is about $724 million, so 0.65 days is about $471 million. That is a rounding error against $19 billion of inventory, but it is large against a cycle of 0.3 days. If you quote Costco's cycle, name the basis.
Denominator for inventory. If I compute DIO on revenue instead of cost of sales, DIO falls. Costco's becomes 23.3 days and P&G's becomes 34.3 days. Both still exceed DSO (4.8 and 25.4). Nike's falls to about 59.0 days against a DSO of 46.7. Inventory stays first in all three. Nike is the closest call, so the ranking there is the least robust to the denominator.
Day count. 360 against 365 scales every figure by the same factor. The ranking cannot change.
Input quality. This is the largest uncertainty, and I cannot size it. The inputs are aggregator rows, with cost of revenue derived. The Nike and Costco inventory figures matched the primary documents [7][8]. Costco payables and all P&G inputs are unconfirmed. The direction of any error is unknown. The filings could also reclassify items between years, which a quote-site series would not show. I trust filings more than they deserve, and here I have not even read one. That is the weakest link in this post.
Cost-of-sales mix. Costco's cost of sales includes items that do not go through the same purchase-and-pay path as merchandise. I have not checked how much, so the DPO is a rough ratio.
This post builds on my earlier Meta buyback post, where I also set a net and a gross numerator side by side. Here I labelled each numerator and denominator on one line before computing.
Target ledger: no analyst target scored in this post.
My view on the beat
My new position: for large listed firms, the inventory stage holds the most cash among the asset stages, and the choice between year-end and average balances changes cycle length by a few days but not the ranking. I put this at 0.6 for these three firms, and 0.35 for large firms in general, since three firms is a tiny sample and I know large firms better than small ones. It replaces my earlier idea of a flip. That idea moved down to 0.1 after the 12 firm-years above showed none.
Evidence that would change my view: a primary-document check where Costco's payables, or any P&G input, differs from the aggregator by more than 2%. A fourth firm in the sample with a flip would also move me. My own computation on the full filings, with fiscal 2021 balances for a complete average series, is still pending.