Stock Analysis on Net

Walt Disney Co. (NYSE:DIS)

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Walt Disney Co., liquidity ratios (quarterly data)

Microsoft Excel
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
Current ratio 0.84 1.05 1.07 1.01 0.99 1.00 1.02 1.06 1.10 1.08 1.24 1.23 1.31 1.32 1.34 0.94 0.80 0.90 0.70 0.77 1.00 0.94 0.88 0.85 0.87
Quick ratio 0.69 0.85 0.87 0.83 0.83 0.83 0.87 0.91 0.98 0.94 1.07 1.07 1.17 1.15 1.16 0.81 0.69 0.67 0.50 0.56 0.83 0.75 0.71 0.70 0.73
Cash ratio 0.23 0.46 0.41 0.37 0.31 0.40 0.42 0.45 0.48 0.51 0.59 0.60 0.64 0.67 0.75 0.40 0.20 0.17 0.15 0.23 0.25 0.23 0.21 0.21 0.24

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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walt Disney Co. current ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Walt Disney Co. quick ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Walt Disney Co. cash ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024.

Current Ratio

Walt Disney Co., current ratio calculation (quarterly data)

Microsoft Excel
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
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
Liquidity Ratio
Current ratio1 0.84 1.05 1.07 1.01 0.99 1.00 1.02 1.06 1.10 1.08 1.24 1.23 1.31 1.32 1.34 0.94 0.80 0.90 0.70 0.77 1.00 0.94 0.88 0.85 0.87
Benchmarks
Current Ratio, Competitors2
Alphabet Inc. 2.10 2.04 2.17 2.35 2.38 2.52 2.81 2.87 2.93 2.98 3.15 3.10 3.07 3.41 3.41 3.66 3.37 3.78 3.98 3.96
Comcast Corp. 0.60 0.70 0.76 0.69 0.78 0.84 0.88 0.86 0.85 1.03 0.92 0.96 0.93 0.93 0.97 0.87 0.84 0.86 0.69 0.73
Meta Platforms Inc. 2.67 2.57 2.32 2.07 2.20 2.57 2.52 2.81 3.15 4.23 5.43 6.08 5.05 5.51 6.02 4.60 4.40 4.66 4.47 5.38
Netflix Inc. 1.12 1.29 1.33 1.26 1.17 1.14 1.05 1.05 0.95 1.17 1.23 1.27 1.25 1.24 1.12 0.82 0.90 0.73 0.85 0.61

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
Current ratio = Current assets ÷ Current liabilities
= 25,971 ÷ 31,033 = 0.84

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Walt Disney Co. current ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Quick Ratio

Walt Disney Co., quick ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and cash equivalents 7,192 14,182 11,458 10,399 8,470 11,615 12,959 13,272 14,444 15,959 16,070 15,890 17,068 17,914 23,115 14,339 6,833 5,418 6,728 10,108 4,455 4,150 4,326 4,179 4,677
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
Total quick assets 21,307 26,512 24,570 23,169 22,463 24,267 26,644 27,018 29,326 29,326 29,425 28,423 31,119 30,622 35,737 28,871 23,933 20,899 22,401 24,701 14,578 13,484 14,397 13,857 14,563
 
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
Liquidity Ratio
Quick ratio1 0.69 0.85 0.87 0.83 0.83 0.83 0.87 0.91 0.98 0.94 1.07 1.07 1.17 1.15 1.16 0.81 0.69 0.67 0.50 0.56 0.83 0.75 0.71 0.70 0.73
Benchmarks
Quick Ratio, Competitors2
Alphabet Inc. 1.94 1.87 2.02 2.20 2.22 2.29 2.62 2.72 2.79 2.85 3.01 2.94 2.95 3.27 3.26 3.46 3.21 3.62 3.84 3.80
Comcast Corp. 0.50 0.56 0.61 0.55 0.62 0.63 0.68 0.71 0.71 0.89 0.80 0.84 0.81 0.81 0.85 0.70 0.55 0.55 0.48 0.51
Meta Platforms Inc. 2.55 2.43 2.20 1.91 2.01 2.34 2.34 2.62 2.94 3.94 5.09 5.86 4.89 5.33 5.81 4.48 4.28 4.50 4.32 5.22
Netflix Inc. 0.81 0.94 0.99 0.94 0.76 0.79 0.78 0.78 0.71 0.94 0.99 1.06 1.05 1.06 0.94 0.66 0.73 0.61 0.72 0.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
Quick ratio = Total quick assets ÷ Current liabilities
= 21,307 ÷ 31,033 = 0.69

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Walt Disney Co. quick ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Cash Ratio

Walt Disney Co., cash ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and cash equivalents 7,192 14,182 11,458 10,399 8,470 11,615 12,959 13,272 14,444 15,959 16,070 15,890 17,068 17,914 23,115 14,339 6,833 5,418 6,728 10,108 4,455 4,150 4,326 4,179 4,677
Total cash assets 7,192 14,182 11,458 10,399 8,470 11,615 12,959 13,272 14,444 15,959 16,070 15,890 17,068 17,914 23,115 14,339 6,833 5,418 6,728 10,108 4,455 4,150 4,326 4,179 4,677
 
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
Liquidity Ratio
Cash ratio1 0.23 0.46 0.41 0.37 0.31 0.40 0.42 0.45 0.48 0.51 0.59 0.60 0.64 0.67 0.75 0.40 0.20 0.17 0.15 0.23 0.25 0.23 0.21 0.21 0.24
Benchmarks
Cash Ratio, Competitors2
Alphabet Inc. 1.36 1.39 1.52 1.67 1.64 1.76 2.04 2.16 2.17 2.30 2.44 2.44 2.41 2.75 2.77 2.92 2.65 3.09 3.27 3.25
Comcast Corp. 0.15 0.19 0.22 0.17 0.17 0.20 0.25 0.30 0.30 0.44 0.42 0.49 0.41 0.46 0.49 0.31 0.18 0.13 0.13 0.13
Meta Platforms Inc. 2.05 2.00 1.79 1.48 1.51 1.84 1.82 2.08 2.27 3.26 4.31 5.05 4.14 4.66 5.15 4.00 3.64 3.92 3.74 4.57
Netflix Inc. 0.81 0.94 0.99 0.94 0.76 0.79 0.78 0.78 0.71 0.94 0.99 1.06 1.05 1.06 0.94 0.66 0.73 0.61 0.72 0.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
Cash ratio = Total cash assets ÷ Current liabilities
= 7,192 ÷ 31,033 = 0.23

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Walt Disney Co. cash ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024.