Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Walt Disney Co., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Walt Disney Co. inventory turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Walt Disney Co. receivables turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Walt Disney Co. number of days of receivables outstanding improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Walt Disney Co. operating cycle improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
Inventory Turnover
Walt Disney Co., inventory turnover calculation (quarterly data)
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
1 Q1 2024 Calculation
Inventory turnover
= (Cost of revenues, exclusive of depreciation and amortizationQ1 2024
+ Cost of revenues, exclusive of depreciation and amortizationQ4 2023
+ Cost of revenues, exclusive of depreciation and amortizationQ3 2023
+ Cost of revenues, exclusive of depreciation and amortizationQ2 2023)
÷ Inventories
= (15,587 + 13,728 + 14,471 + 14,616)
÷ 1,954 = 29.89
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Walt Disney Co. inventory turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
Receivables Turnover
Walt Disney Co., receivables turnover calculation (quarterly data)
| Dec 30, 2023 | Sep 30, 2023 | Jul 1, 2023 | Apr 1, 2023 | Dec 31, 2022 | Oct 1, 2022 | Jul 2, 2022 | Apr 2, 2022 | Jan 1, 2022 | Oct 2, 2021 | Jul 3, 2021 | Apr 3, 2021 | Jan 2, 2021 | Oct 3, 2020 | Jun 27, 2020 | Mar 28, 2020 | Dec 28, 2019 | Sep 28, 2019 | Jun 29, 2019 | Mar 30, 2019 | Dec 29, 2018 | Sep 29, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 30, 2017 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||||
| Revenues | 23,549) | 21,241) | 22,330) | 21,815) | 23,512) | 20,150) | 21,504) | 19,249) | 21,819) | 18,534) | 17,022) | 15,613) | 16,249) | 14,707) | 11,779) | 18,025) | 20,877) | 19,100) | 20,245) | 14,922) | 15,303) | 14,307) | 15,228) | 14,548) | 15,351) | ||||||||
| Receivables, net | 14,115) | 12,330) | 13,112) | 12,770) | 13,993) | 12,652) | 13,685) | 13,746) | 14,882) | 13,367) | 13,355) | 12,533) | 14,051) | 12,708) | 12,622) | 14,532) | 17,100) | 15,481) | 15,673) | 14,593) | 10,123) | 9,334) | 10,071) | 9,678) | 9,886) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||
| Receivables turnover1 | 6.30 | 7.21 | 6.70 | 6.81 | 6.03 | 6.54 | 5.93 | 5.57 | 4.90 | 5.04 | 4.76 | 4.66 | 4.32 | 5.15 | 5.53 | 5.38 | 4.39 | 4.49 | 4.13 | 4.10 | 5.87 | 6.37 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||
| Alphabet Inc. | — | 6.41 | 7.24 | 7.46 | 7.90 | 7.03 | 8.13 | 7.79 | 7.79 | 6.55 | 7.03 | 6.89 | 7.02 | 5.90 | 6.89 | 7.83 | 7.64 | 6.39 | — | — | — | — | — | — | — | ||||||||
| Comcast Corp. | — | 8.80 | 9.42 | 9.29 | 9.78 | 9.58 | 10.17 | 10.18 | 9.77 | 9.69 | 9.50 | 9.81 | 9.48 | 9.03 | 10.11 | 10.32 | 10.06 | 9.65 | — | — | — | — | — | — | — | ||||||||
| Meta Platforms Inc. | — | 8.34 | 9.81 | 9.63 | 10.63 | 8.66 | 10.52 | 10.36 | 10.51 | 8.40 | 9.29 | 8.96 | 9.19 | 7.58 | 9.84 | 10.04 | 10.06 | 7.43 | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
1 Q1 2024 Calculation
Receivables turnover
= (RevenuesQ1 2024
+ RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023)
÷ Receivables, net
= (23,549 + 21,241 + 22,330 + 21,815)
÷ 14,115 = 6.30
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Walt Disney Co. receivables turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
Working Capital Turnover
Walt Disney Co., working capital turnover calculation (quarterly data)
| Dec 30, 2023 | Sep 30, 2023 | Jul 1, 2023 | Apr 1, 2023 | Dec 31, 2022 | Oct 1, 2022 | Jul 2, 2022 | Apr 2, 2022 | Jan 1, 2022 | Oct 2, 2021 | Jul 3, 2021 | Apr 3, 2021 | Jan 2, 2021 | Oct 3, 2020 | Jun 27, 2020 | Mar 28, 2020 | Dec 28, 2019 | Sep 28, 2019 | Jun 29, 2019 | Mar 30, 2019 | Dec 29, 2018 | Sep 29, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 30, 2017 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||||||
| Current assets | 25,971) | 32,763) | 30,174) | 28,263) | 26,912) | 29,098) | 31,422) | 31,427) | 32,913) | 33,657) | 33,966) | 32,877) | 34,874) | 35,251) | 41,330) | 33,274) | 27,776) | 28,124) | 31,370) | 34,277) | 17,537) | 16,825) | 17,729) | 16,808) | 17,274) | ||||||||
| Less: Current liabilities | 31,033) | 31,139) | 28,234) | 28,056) | 27,070) | 29,073) | 30,704) | 29,601) | 30,037) | 31,077) | 27,413) | 26,642) | 26,546) | 26,628) | 30,917) | 35,473) | 34,797) | 31,341) | 44,593) | 44,376) | 17,619) | 17,860) | 20,214) | 19,728) | 19,875) | ||||||||
| Working capital | (5,062) | 1,624) | 1,940) | 207) | (158) | 25) | 718) | 1,826) | 2,876) | 2,580) | 6,553) | 6,235) | 8,328) | 8,623) | 10,413) | (2,199) | (7,021) | (3,217) | (13,223) | (10,099) | (82) | (1,035) | (2,485) | (2,920) | (2,601) | ||||||||
| Revenues | 23,549) | 21,241) | 22,330) | 21,815) | 23,512) | 20,150) | 21,504) | 19,249) | 21,819) | 18,534) | 17,022) | 15,613) | 16,249) | 14,707) | 11,779) | 18,025) | 20,877) | 19,100) | 20,245) | 14,922) | 15,303) | 14,307) | 15,228) | 14,548) | 15,351) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||
| Working capital turnover1 | — | 54.74 | 45.26 | 420.20 | — | 3,308.88 | 112.96 | 41.96 | 25.38 | 26.13 | 9.70 | 9.36 | 7.30 | 7.58 | 6.70 | — | — | — | — | — | — | — | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||||
| Alphabet Inc. | — | 3.43 | 3.30 | 3.18 | 3.06 | 2.96 | 2.82 | 2.51 | 2.33 | 2.08 | 1.96 | 1.84 | 1.69 | 1.55 | 1.48 | 1.58 | 1.56 | 1.51 | — | — | — | — | — | — | — | ||||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | 165.10 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Meta Platforms Inc. | — | 2.53 | 2.65 | 3.04 | 4.33 | 3.59 | 3.32 | 3.54 | 3.13 | 2.59 | 1.95 | 1.59 | 1.46 | 1.42 | 1.47 | 1.32 | 1.35 | 1.38 | — | — | — | — | — | — | — | ||||||||
| Netflix Inc. | — | 31.89 | 13.41 | 11.35 | 14.73 | 23.67 | 29.95 | 91.06 | 84.84 | — | 20.95 | 15.57 | 12.30 | 12.78 | 12.62 | 24.13 | — | — | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
1 Q1 2024 Calculation
Working capital turnover
= (RevenuesQ1 2024
+ RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023)
÷ Working capital
= (23,549 + 21,241 + 22,330 + 21,815)
÷ -5,062 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
Walt Disney Co., average inventory processing period calculation (quarterly data)
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
1 Q1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 29.89 = 12
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. |
Average Receivable Collection Period
Walt Disney Co., average receivable collection period calculation (quarterly data)
| Dec 30, 2023 | Sep 30, 2023 | Jul 1, 2023 | Apr 1, 2023 | Dec 31, 2022 | Oct 1, 2022 | Jul 2, 2022 | Apr 2, 2022 | Jan 1, 2022 | Oct 2, 2021 | Jul 3, 2021 | Apr 3, 2021 | Jan 2, 2021 | Oct 3, 2020 | Jun 27, 2020 | Mar 28, 2020 | Dec 28, 2019 | Sep 28, 2019 | Jun 29, 2019 | Mar 30, 2019 | Dec 29, 2018 | Sep 29, 2018 | Jun 30, 2018 | Mar 31, 2018 | Dec 30, 2017 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||||||
| Receivables turnover | 6.30 | 7.21 | 6.70 | 6.81 | 6.03 | 6.54 | 5.93 | 5.57 | 4.90 | 5.04 | 4.76 | 4.66 | 4.32 | 5.15 | 5.53 | 5.38 | 4.39 | 4.49 | 4.13 | 4.10 | 5.87 | 6.37 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||
| Average receivable collection period1 | 58 | 51 | 55 | 54 | 61 | 56 | 62 | 65 | 74 | 72 | 77 | 78 | 84 | 71 | 66 | 68 | 83 | 81 | 88 | 89 | 62 | 57 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||||||
| Alphabet Inc. | — | 57 | 50 | 49 | 46 | 52 | 45 | 47 | 47 | 56 | 52 | 53 | 52 | 62 | 53 | 47 | 48 | 57 | — | — | — | — | — | — | — | ||||||||
| Comcast Corp. | — | 41 | 39 | 39 | 37 | 38 | 36 | 36 | 37 | 38 | 38 | 37 | 38 | 40 | 36 | 35 | 36 | 38 | — | — | — | — | — | — | — | ||||||||
| Meta Platforms Inc. | — | 44 | 37 | 38 | 34 | 42 | 35 | 35 | 35 | 43 | 39 | 41 | 40 | 48 | 37 | 36 | 36 | 49 | — | — | — | — | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
1 Q1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.30 = 58
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Walt Disney Co. number of days of receivables outstanding improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |
Operating Cycle
Walt Disney Co., operating cycle calculation (quarterly data)
No. days
Based on: 10-Q (reporting date: 2023-12-30), 10-K (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-Q (reporting date: 2022-12-31), 10-K (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-Q (reporting date: 2022-01-01), 10-K (reporting date: 2021-10-02), 10-Q (reporting date: 2021-07-03), 10-Q (reporting date: 2021-04-03), 10-Q (reporting date: 2021-01-02), 10-K (reporting date: 2020-10-03), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-Q (reporting date: 2019-12-28), 10-K (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30), 10-Q (reporting date: 2018-12-29), 10-K (reporting date: 2018-09-29), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-30).
1 Q1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 12 + 58 = 70
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Walt Disney Co. operating cycle improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024. |