Calculate Disney’s liquidity ratios (2 ratios) for each of the last 5 years and access how Disney’s liquidity position has changed over time.

Calculate Disney’s asset management ratios (4 ratios) for each of the last 5 years and access how Disney’s asset management position has changed over time.

Calculate Disney’s debt management ratios (3 ratios including the liabilites to assets ratio) for each of the last 5 years and access how Disney’s debt management position has changed over time.

Calculate Disney’s profitability ratios for each of the last 5 years and access how Disney’s profitability position has changed over time.

What is Disney’s biggest strength and weakness based on this trend analysis.

Transcribed Image Text:

4 5 The Walt Disney Company (NYSE:DIS) > Financials > Income Statement 6 Period Type: Currency: Units: Source: Standard Annual Reported Currency S&P Capital IQ (De Capital IQ & Propri Restatement: Order: Conversion: Decimals: Latest Filings Latest on Right Historical Capital IQ (Default) 7 In Millions of the reported currency, except per share items. Template: 8 9 10 11 12 13 14 Income Statement 15 For the Fiscal Period Ending 16 Currency 17 18 Revenue 19 Other Revenue 12 months Sep-29-2018 Reclassified 12 months Sep-28-2019 USD USD 12 months Oct-03-2020 USD 12 months 12 months Oct-02-2021 USD Oct-01-2022 USD 59,434.0 69,607.0 65,388.0 67,418.0 82,722.0 20 Total Revenue 59,434.0 69,607.0 65,388.0 67,418.0 82,722.0 21 22 Cost Of Goods Sold 32,726.0 42,061.0 43,880.0 45,131.0 54,401.0 23 Gross Profit 26,708.0 27,546.0 21,508.0 22,287.0 28,321.0 24 25 Selling General & Admin Exp. 8,860.0 11,349.0 12,382.0 13,684.0 16,326.0 26 R & D Exp. 27 Depreciation & Amort. 3,011.0 4,167.0 5,345.0 5,111.0 5,163.0 28 Other Operating Expense/(Income) 29 30 Other Operating Exp., Total 11,871.0 15,516.0 17,727.0 18,795.0 21,489.0 31 32 Operating Income 14,837.0 12,030.0 3,781.0 3,492.0 6,832.0 33 34 Interest Expense (682.0) (1,246.0) (1,647.0) 35 Interest and Invest. Income 108.0 368.0 36 Net Interest Exp. (574.0) (878.0) 169.0 (1,478.0) (1,546.0) 307.0 (1,239.0) (1,549.0) 90.0 (1,459.0) 37 38 Income/(Loss) from Affiliates (102.0) (103.0) 651.0 761.0 816.0 39 Currency Exchange Gains (Loss) 0 0 0 40 Other Non-Operating Inc. (Exp.) (4.0) 41 EBT Excl. Unusual Items 14,161.0 11,049.0 2,954.0 3,014.0 6,185.0 42 43 Restructuring Charges (33.0) (735.0) (354.0) (237.0) 44 Merger & Related Restruct. Charges (1,483.0) (300.0) 45 Impairment of Goodwill (3,100.0) 46 Gain (Loss) On Sale Of Invest. 4,794.0 1,038.0 201.0 (663.0) 47 Gain (Loss) On Sale Of Assets 563.0 28.0 48 Asset Writedown 49 Insurance Settlements 50 Other Unusual Items (1,900.0) 38.0 46.0 (511.0) 51 EBT Incl. Unusual Items 52 53 Income Tax Expense 54 Earnings from Cont. Ops. 55 56 Earnings of Discontinued Ops. 57 Extraord. Item & Account. Change 58 Net Income to Company 59 60 Minority Int. in Earnings 61 Net Income 62 14,729.0 13,923.0 (1,743.0) 2,561.0 5,285.0 1,663.0 3,026.0 13,066.0 10,897.0 699.0 (2,442.0) 25.0 1,732.0 2,536.0 3,553.0 629.0 (32.0) (29.0) (48.0) 13,066.0 11,526.0 (2,474.0) 2,507.0 3,505.0 (468.0) (472.0) (390,0) (512.0) (360.0) 12,598.0 11,054.0 (2,864.0) 1,995.0 3,145.0 DISNEY NETFLIX Select destination and press ENTER or choose Paste 4 5 The Walt Disney Company (NYSE:DIS) > Financials > Income Statement 6 Period Type: Currency: Units: Source: Standard Annual Reported Currency S&P Capital IQ (De Capital IQ & Propri Restatement: Order: Conversion: Decimals: Latest Filings Latest on Right Historical Capital IQ (Default) 7 In Millions of the reported currency, except per share items. Template: 8 9 10 11 12 13 14 Income Statement 15 For the Fiscal Period Ending 16 Currency 17 18 Revenue 19 Other Revenue 12 months Sep-29-2018 Reclassified 12 months Sep-28-2019 USD USD 12 months Oct-03-2020 USD 12 months 12 months Oct-02-2021 USD Oct-01-2022 USD 59,434.0 69,607.0 65,388.0 67,418.0 82,722.0 20 Total Revenue 59,434.0 69,607.0 65,388.0 67,418.0 82,722.0 21 22 Cost Of Goods Sold 32,726.0 42,061.0 43,880.0 45,131.0 54,401.0 23 Gross Profit 26,708.0 27,546.0 21,508.0 22,287.0 28,321.0 24 25 Selling General & Admin Exp. 8,860.0 11,349.0 12,382.0 13,684.0 16,326.0 26 R & D Exp. 27 Depreciation & Amort. 3,011.0 4,167.0 5,345.0 5,111.0 5,163.0 28 Other Operating Expense/(Income) 29 30 Other Operating Exp., Total 11,871.0 15,516.0 17,727.0 18,795.0 21,489.0 31 32 Operating Income 14,837.0 12,030.0 3,781.0 3,492.0 6,832.0 33 34 Interest Expense (682.0) (1,246.0) (1,647.0) 35 Interest and Invest. Income 108.0 368.0 36 Net Interest Exp. (574.0) (878.0) 169.0 (1,478.0) (1,546.0) 307.0 (1,239.0) (1,549.0) 90.0 (1,459.0) 37 38 Income/(Loss) from Affiliates (102.0) (103.0) 651.0 761.0 816.0 39 Currency Exchange Gains (Loss) 0 0 0 40 Other Non-Operating Inc. (Exp.) (4.0) 41 EBT Excl. Unusual Items 14,161.0 11,049.0 2,954.0 3,014.0 6,185.0 42 43 Restructuring Charges (33.0) (735.0) (354.0) (237.0) 44 Merger & Related Restruct. Charges (1,483.0) (300.0) 45 Impairment of Goodwill (3,100.0) 46 Gain (Loss) On Sale Of Invest. 4,794.0 1,038.0 201.0 (663.0) 47 Gain (Loss) On Sale Of Assets 563.0 28.0 48 Asset Writedown 49 Insurance Settlements 50 Other Unusual Items (1,900.0) 38.0 46.0 (511.0) 51 EBT Incl. Unusual Items 52 53 Income Tax Expense 54 Earnings from Cont. Ops. 55 56 Earnings of Discontinued Ops. 57 Extraord. Item & Account. Change 58 Net Income to Company 59 60 Minority Int. in Earnings 61 Net Income 62 14,729.0 13,923.0 (1,743.0) 2,561.0 5,285.0 1,663.0 3,026.0 13,066.0 10,897.0 699.0 (2,442.0) 25.0 1,732.0 2,536.0 3,553.0 629.0 (32.0) (29.0) (48.0) 13,066.0 11,526.0 (2,474.0) 2,507.0 3,505.0 (468.0) (472.0) (390,0) (512.0) (360.0) 12,598.0 11,054.0 (2,864.0) 1,995.0 3,145.0 DISNEY NETFLIX Select destination and press ENTER or choose Paste