Question: Compare Disney's profitability to its peers

this is sheet 1

this is sheet 2

this is sheet 3

this is sheet 4

this is sheet 5

used the information is sheet 1, which has Companies listed A-R and ita corresponding data on sheet nunber 4 and 5. Compare those campanies to Disney and its financial data in sheets 2 and 3 to answer the question.

Name Group Conner Alpin, Nayalli Cisneros, Christine Novak, Justin Santos COMPANY RATIOS SECTOR COMMUNICATIONS CONSUMER DISCRETIONARY CONSUMER STAPLES ENERGY HEALTHCARE A Netflix B ATAT AutoZone D Home Depot E Costco F The Kinger to G Peabody SmPower 1 TO J Bristol Rayna Sul K Dewe L Boeing Mos N Heidelberg O Facebook & Apple QA teard R Centrica Price to Earnings D Emily Pixe ook we Fived Asset Tour Days Soles cuestanding 1 Days Inventay outstanding Days Payable outstanding Cash Converse Cycle 9 Tentory Twover Payable Twarover Defensive Interval Carne Esity 044-to-Astels Cres Margin Debt-to-capital Financial Lovense operating Margin Return an Acts leturn on Talal Capital I Cash conversion Cycle Days Inventory Outstanding 2 Days Sales outsending Debt-to-Equity Inkort Caverge Prie A. Book Value DebtEwy Facial Lawase Days Irindey ontstonday cash conversion Cycle 0 Inventory Twnome Payable Turnover 9 Days Inventory autoto.ding Days Payable outstanding Cash Conversion Cycle Inwery www days Twenty Outstanding Debt-to-Epily Debt-to-capital rett to Amets operatly Murgh Inventory Twnwer Peyukle Twaw Days payable Outstanding Net Mersin INDUSTRIALS MATERIALS M TECHNOLOGY UTILITIES BLR The Walt Disney Company How Trend Aw FY 2004 FY3602 FY1001 FY 3000 PY 2008 FY2001 COSA: PY 2003 PY 2005 FY2010 FY 2011 FY FY 2013 FY 2014 FY 2015 FY 2016 DIO AL Liquids Creo GURK 119 1.16 100 06 0.00 0-87 EVO OM 0 081 OM 070 16 191 1.14 678 +1! 077 0.72 116 09 TO HO 0.37 216 GED 00 0411 Aast Management Ratio Fedtumas Demon nyumowe . 0.67 200 03 034 2.15 6.00 71 2 6 2.05 00 20 11 23 2.10 2.18 17 3.26 34.31 100 114 1 10:01 10 RS 47 BE 14 1974 EST M 7545 1310 14 18 WA 191 220 23.00 N0 13 133 Del Management Rutie Detto Art Dette Marie TER OC LE NO WE WO 45 ET 2014 ON 0 CP 10 DO 022 M54 ON ON 134 014 3:57 2.1 D W PE 16 0.12 - 720 017 165 54 10 12 Pro Halles Gros Open 3.50 12 18 15 18 11. 1767 73 340 1125 10.6 16 15 15 Y 10 SN 18.00 46 253 HIN 215 IN 134 14 30 4 200 SM 763 31 NE IP To se Runon RE OT 4.06 100 PE 140 BT 180 1001 11.12 Value reale Preuth HE 110 HE 19 12.4 STO 140 144 11 160 7 810 13 11 11 257 10 1 2419 73 - N The Walt Disney Company Peer Comparison Ratlos Entertainment Content Facties DIS Equity TWX Equity CBS Equity VIAD Equity VN FP Equily DISCA Equity NFLX Index SIX Equity SEAS Equity MERLLN Equil CBS Disney Time Warner Viacom Vivend Martin Discovery Scripps Six Flags Sea World FUN EQuy Cedar Fair Liquidity Ratios Current Ratio Quick Rato 1.32 11 1.00 0.85 1:32 0.87 0.78 061 1.38 1.06 1.61 1.29 0.90 0.80 1.11 0.83 0.42 0.22 091 0.76 0.62 035 Asset Management to Asset Tumoverrato Fixed Asset Turnover Raso Days Sales Outstanding Inventory Tumover Halo 02a 2.05 72.54 29.70 0.47 12.00 108.92 8.90 0.68 8.70 7502 8.34 0.54 13.95 11.55 8.10 040 700 118.30 3120 052 920 8823 PNIA NA 0.60 11.13 8.23 ONIANIA 0.17 0.34 8803 114 023 0.31 24 25 132 037 0.84 6.30 0.16 0.2R 4902 0.91 Debt Management Ratio Deblo Aislado Debelo Equity to Market Debt Rate Interest Coverage Ratio 20.00 6012 022 2.30 3430 83.80 INIANIA 6.52 42.25 15742 TNIANIA 4.44 3601 00.74 NANIA 5.03 22:45 3.114 02 12 20 03.02 ANANA 40.53 130.12 0.00 444 48.10 21595 000 410 85.82 INANA 1.02 3.70 7302 700 e 1.0 253 31.30 WNIANA ONIAN 240 121 2.00 Profitability Ratios Groos Margin Operating Margin Net Margin 44 36 5.80 5.60 14.30 4357 2533 16.70 38 07 1530 1189 48.74 19.18 12.00 866 65.73 27.00 18.57 38.28 12.92 1.26 9124 20.10 12.04 9221 15.25 6.40 81.7 192 701 9144 20 38 1160 9.96 Financial Ratio Comparison 0 3 T FI A 369 E 330 1319 340 710 316 156 832 14 PROFITADUTY RANO Gros Merge Ogerta Mala 392 145 21 (49.29 119 22.7 141 10.5 446 27 274 28 16.6 122 146 13 440 (87) a. 112.71 (3.30 11 12 285 100 ILS BREIRO 77 114 86 22 15 21 49 110 (470) 25.4 4.0 144 127 85 52 83 144 35 24 165 Nagin Return on Return on Tt Capt Reborn on oury 54 127 410 243 979 330 163 544 247 BB & B 44 eles LEGGE 264 0.6 277 BR 67 56 76 275 119 295.3 268 382 1040 47 278 484 03 19.3 B E F 0 K L M 0 15 08 09 10 15 10 16 0.7 12 BBS316 818 10 LIQUIDITY RATIOS Current Ratio Quick Ratio Cash Rate Deventer 12 03 08 01 06 05 04 07 0.5 13 04 0.8 0.4 03 01 Seles Naas alalal 02 04 00 04 00 01 02 01 04 02 0.6 982 0.6 1772 215 240 63 721 1124 1465 2936 1134 541 70.2 1036 446 A B C D E G K L M N O Q SOLVENCY RATIOS Debt-to- Debt-to-Capit 1978 010 1830 F 225.8 603 3738 1A58. 949 1018 496 331 306 2014 520 342 3377 971 42.7 209 545 301 1183 54.2 664 477 1430 1200 00 647 476 1008 517 313 789 603 569 3:57 332 541 607 419 38.2 184 210 118 00 51 151 33 2A 27 65 7151 3.1 54 43 71 16.8 (7.01 SZERSZEG Beeg 2.4 11 59 2,7661 Interest Coverage 100 118) 280 219 38 24 A B C D E H N o F 140 G 1 1 K 55 R 62 13 55 L 14 28 2a 1 2.2 2.9 53 501 M 42 12.9 7.7 372 129 79 418 507 913 M7 01 24 144 50 12 BABWEB sel 25 2.0 21 31 12 --34 19 156 3.1 433 164 25.4 5.4 505 802 668 563 1507 ACTIVITY RATIOS Inventory Turnover Receive Turner Payable Turnover Days by Outstanding Das Outstanding Days Payable Outstanding Cash Conversion Cycle Worong Capital Turnover Fixed Assat Turnov Total Asset Tumor 501 2714 62 2961 72 40 50 727 13.6 282 389 239 281 460 1982 430 169 38.8 305 226 1149 568 1014 23.4 24 1249 ma 179.31 13.91 674 322 112 72 238 2267 1024 005 YO 03 20 6.4 126 2232 20 26 0.3 428 48 75 13 45 RO 14 03 13 03 5. 33 17 05 0.7 12 23 37 07 0.7 00 alala a la C E F VALLATION RATIOS Price to Book Valur H P D 15.0 R 223 J 50 K 18 L 500 M 1 N 02 0 44 BO 27 10.0 TOD 2.5 400 LO TO 9. 13:4 320 215 15.2 H2 22 28.0 20.3 173 Price to Cash Flow 180 122 10.0 170 3.0 7.7 -25 143 236 544 144 46 71 Bloomberg LP Common Size Income Statement & Balance Sheet Pod Year 2018 USD Comune Consumer Die Consumer Sta EY Indie Malwa Tech D O M 1000 P 1000 1000 1000 1000 100D 00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 531 468 0.0 870 780 1072 361 580 200 684 806 844 16.B 817 BAS 39 555 592 340 130 220 440 710 316 137 643 COME STATEMENT Rece Cool of Reven Grow Prom Operating Expert Operating income Interest Expense Net Non Operating PeTexto 1072 320 27 2 371 al 19.0 174 78 59 B2.0 16 103 102 15.3 161 14.5 32 21 (87 227 TO 97 10.5 445 26 4 27 47 16 LO OS 53 27 0.8 3.2 05 23 18 00 12 OB 10:31 190 101 100 04 01 00 10.3) (20) 04 152 (46) 26.5 HEBBS Blue 10.0 115 2 148 (3. 100 Bala Na 27A 50 Income Tax 01 29 27 50 09 10.30 03 OB Beleggel 45 46 1 26 8 BGB 114 8.6 115 15 (470) (127) 63 216 GEBOB 39,6 64 103 0.1 Income Before Extraordinary Minority interest Net income NI 57 00 00 3.4 58 00 04 75 0.0 27 188 113 RE 147.00 014) 216 103 396 22.4 B A D E F G 1 H . K M L P N 72 146 10 23 148 81 09 29 132 2018 56 65 6.2 103 319 00 400 00 00 00 56 07 08 00 00 0.3 0.2 0.0 0.0 41 44 0.6 2.8 422 44 47 0.0 75 131 96 133 71 37 99 54 BALANCE SHEET Cash and Noor Cash Short-Term investments Accounts Receivable Inwentones Other Current Assets NetFlad Assets Total 78 50 0.0 BBB 00 286 270 76 22 515 105 SEB ECE 37 227 17 14 08 70 43 24 70 14 26 104 LB 233 16 451 703 482 144 108 584 201 36.2 254 113 247 100.0 406 1000 566 1000 357 100.0 113 1000 601 1000 100.0 1000 1000 1000 1000 100.0 1000 1000 1000 1000 1000 100.0 51 672 16.3 275 31 23 5.4 35 00 ya 157 06 62 Accounts Payable Short-Term Borrowing Other Short Term 12 05 37 49 214 0.2 37 57 22 00 228 300 lella 00 0.4 53 61 Sala 139 219 13.8 169 20.2 65 111 10.7 14 365 313 536 323 179 213 380 00 545 967 205 530 Tots 635 79.8 1163 07 14 1064 535 70 50,6 473 R30 36 707 BOB 06.00 365 404 181 465 470 03 52.7 293 564 192 Bloomberg LP Name Group Conner Alpin, Nayalli Cisneros, Christine Novak, Justin Santos COMPANY RATIOS SECTOR COMMUNICATIONS CONSUMER DISCRETIONARY CONSUMER STAPLES ENERGY HEALTHCARE A Netflix B ATAT AutoZone D Home Depot E Costco F The Kinger to G Peabody SmPower 1 TO J Bristol Rayna Sul K Dewe L Boeing Mos N Heidelberg O Facebook & Apple QA teard R Centrica Price to Earnings D Emily Pixe ook we Fived Asset Tour Days Soles cuestanding 1 Days Inventay outstanding Days Payable outstanding Cash Converse Cycle 9 Tentory Twover Payable Twarover Defensive Interval Carne Esity 044-to-Astels Cres Margin Debt-to-capital Financial Lovense operating Margin Return an Acts leturn on Talal Capital I Cash conversion Cycle Days Inventory Outstanding 2 Days Sales outsending Debt-to-Equity Inkort Caverge Prie A. Book Value DebtEwy Facial Lawase Days Irindey ontstonday cash conversion Cycle 0 Inventory Twnome Payable Turnover 9 Days Inventory autoto.ding Days Payable outstanding Cash Conversion Cycle Inwery www days Twenty Outstanding Debt-to-Epily Debt-to-capital rett to Amets operatly Murgh Inventory Twnwer Peyukle Twaw Days payable Outstanding Net Mersin INDUSTRIALS MATERIALS M TECHNOLOGY UTILITIES BLR The Walt Disney Company How Trend Aw FY 2004 FY3602 FY1001 FY 3000 PY 2008 FY2001 COSA: PY 2003 PY 2005 FY2010 FY 2011 FY FY 2013 FY 2014 FY 2015 FY 2016 DIO AL Liquids Creo GURK 119 1.16 100 06 0.00 0-87 EVO OM 0 081 OM 070 16 191 1.14 678 +1! 077 0.72 116 09 TO HO 0.37 216 GED 00 0411 Aast Management Ratio Fedtumas Demon nyumowe . 0.67 200 03 034 2.15 6.00 71 2 6 2.05 00 20 11 23 2.10 2.18 17 3.26 34.31 100 114 1 10:01 10 RS 47 BE 14 1974 EST M 7545 1310 14 18 WA 191 220 23.00 N0 13 133 Del Management Rutie Detto Art Dette Marie TER OC LE NO WE WO 45 ET 2014 ON 0 CP 10 DO 022 M54 ON ON 134 014 3:57 2.1 D W PE 16 0.12 - 720 017 165 54 10 12 Pro Halles Gros Open 3.50 12 18 15 18 11. 1767 73 340 1125 10.6 16 15 15 Y 10 SN 18.00 46 253 HIN 215 IN 134 14 30 4 200 SM 763 31 NE IP To se Runon RE OT 4.06 100 PE 140 BT 180 1001 11.12 Value reale Preuth HE 110 HE 19 12.4 STO 140 144 11 160 7 810 13 11 11 257 10 1 2419 73 - N The Walt Disney Company Peer Comparison Ratlos Entertainment Content Facties DIS Equity TWX Equity CBS Equity VIAD Equity VN FP Equily DISCA Equity NFLX Index SIX Equity SEAS Equity MERLLN Equil CBS Disney Time Warner Viacom Vivend Martin Discovery Scripps Six Flags Sea World FUN EQuy Cedar Fair Liquidity Ratios Current Ratio Quick Rato 1.32 11 1.00 0.85 1:32 0.87 0.78 061 1.38 1.06 1.61 1.29 0.90 0.80 1.11 0.83 0.42 0.22 091 0.76 0.62 035 Asset Management to Asset Tumoverrato Fixed Asset Turnover Raso Days Sales Outstanding Inventory Tumover Halo 02a 2.05 72.54 29.70 0.47 12.00 108.92 8.90 0.68 8.70 7502 8.34 0.54 13.95 11.55 8.10 040 700 118.30 3120 052 920 8823 PNIA NA 0.60 11.13 8.23 ONIANIA 0.17 0.34 8803 114 023 0.31 24 25 132 037 0.84 6.30 0.16 0.2R 4902 0.91 Debt Management Ratio Deblo Aislado Debelo Equity to Market Debt Rate Interest Coverage Ratio 20.00 6012 022 2.30 3430 83.80 INIANIA 6.52 42.25 15742 TNIANIA 4.44 3601 00.74 NANIA 5.03 22:45 3.114 02 12 20 03.02 ANANA 40.53 130.12 0.00 444 48.10 21595 000 410 85.82 INANA 1.02 3.70 7302 700 e 1.0 253 31.30 WNIANA ONIAN 240 121 2.00 Profitability Ratios Groos Margin Operating Margin Net Margin 44 36 5.80 5.60 14.30 4357 2533 16.70 38 07 1530 1189 48.74 19.18 12.00 866 65.73 27.00 18.57 38.28 12.92 1.26 9124 20.10 12.04 9221 15.25 6.40 81.7 192 701 9144 20 38 1160 9.96 Financial Ratio Comparison 0 3 T FI A 369 E 330 1319 340 710 316 156 832 14 PROFITADUTY RANO Gros Merge Ogerta Mala 392 145 21 (49.29 119 22.7 141 10.5 446 27 274 28 16.6 122 146 13 440 (87) a. 112.71 (3.30 11 12 285 100 ILS BREIRO 77 114 86 22 15 21 49 110 (470) 25.4 4.0 144 127 85 52 83 144 35 24 165 Nagin Return on Return on Tt Capt Reborn on oury 54 127 410 243 979 330 163 544 247 BB & B 44 eles LEGGE 264 0.6 277 BR 67 56 76 275 119 295.3 268 382 1040 47 278 484 03 19.3 B E F 0 K L M 0 15 08 09 10 15 10 16 0.7 12 BBS316 818 10 LIQUIDITY RATIOS Current Ratio Quick Ratio Cash Rate Deventer 12 03 08 01 06 05 04 07 0.5 13 04 0.8 0.4 03 01 Seles Naas alalal 02 04 00 04 00 01 02 01 04 02 0.6 982 0.6 1772 215 240 63 721 1124 1465 2936 1134 541 70.2 1036 446 A B C D E G K L M N O Q SOLVENCY RATIOS Debt-to- Debt-to-Capit 1978 010 1830 F 225.8 603 3738 1A58. 949 1018 496 331 306 2014 520 342 3377 971 42.7 209 545 301 1183 54.2 664 477 1430 1200 00 647 476 1008 517 313 789 603 569 3:57 332 541 607 419 38.2 184 210 118 00 51 151 33 2A 27 65 7151 3.1 54 43 71 16.8 (7.01 SZERSZEG Beeg 2.4 11 59 2,7661 Interest Coverage 100 118) 280 219 38 24 A B C D E H N o F 140 G 1 1 K 55 R 62 13 55 L 14 28 2a 1 2.2 2.9 53 501 M 42 12.9 7.7 372 129 79 418 507 913 M7 01 24 144 50 12 BABWEB sel 25 2.0 21 31 12 --34 19 156 3.1 433 164 25.4 5.4 505 802 668 563 1507 ACTIVITY RATIOS Inventory Turnover Receive Turner Payable Turnover Days by Outstanding Das Outstanding Days Payable Outstanding Cash Conversion Cycle Worong Capital Turnover Fixed Assat Turnov Total Asset Tumor 501 2714 62 2961 72 40 50 727 13.6 282 389 239 281 460 1982 430 169 38.8 305 226 1149 568 1014 23.4 24 1249 ma 179.31 13.91 674 322 112 72 238 2267 1024 005 YO 03 20 6.4 126 2232 20 26 0.3 428 48 75 13 45 RO 14 03 13 03 5. 33 17 05 0.7 12 23 37 07 0.7 00 alala a la C E F VALLATION RATIOS Price to Book Valur H P D 15.0 R 223 J 50 K 18 L 500 M 1 N 02 0 44 BO 27 10.0 TOD 2.5 400 LO TO 9. 13:4 320 215 15.2 H2 22 28.0 20.3 173 Price to Cash Flow 180 122 10.0 170 3.0 7.7 -25 143 236 544 144 46 71 Bloomberg LP Common Size Income Statement & Balance Sheet Pod Year 2018 USD Comune Consumer Die Consumer Sta EY Indie Malwa Tech D O M 1000 P 1000 1000 1000 1000 100D 00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 531 468 0.0 870 780 1072 361 580 200 684 806 844 16.B 817 BAS 39 555 592 340 130 220 440 710 316 137 643 COME STATEMENT Rece Cool of Reven Grow Prom Operating Expert Operating income Interest Expense Net Non Operating PeTexto 1072 320 27 2 371 al 19.0 174 78 59 B2.0 16 103 102 15.3 161 14.5 32 21 (87 227 TO 97 10.5 445 26 4 27 47 16 LO OS 53 27 0.8 3.2 05 23 18 00 12 OB 10:31 190 101 100 04 01 00 10.3) (20) 04 152 (46) 26.5 HEBBS Blue 10.0 115 2 148 (3. 100 Bala Na 27A 50 Income Tax 01 29 27 50 09 10.30 03 OB Beleggel 45 46 1 26 8 BGB 114 8.6 115 15 (470) (127) 63 216 GEBOB 39,6 64 103 0.1 Income Before Extraordinary Minority interest Net income NI 57 00 00 3.4 58 00 04 75 0.0 27 188 113 RE 147.00 014) 216 103 396 22.4 B A D E F G 1 H . K M L P N 72 146 10 23 148 81 09 29 132 2018 56 65 6.2 103 319 00 400 00 00 00 56 07 08 00 00 0.3 0.2 0.0 0.0 41 44 0.6 2.8 422 44 47 0.0 75 131 96 133 71 37 99 54 BALANCE SHEET Cash and Noor Cash Short-Term investments Accounts Receivable Inwentones Other Current Assets NetFlad Assets Total 78 50 0.0 BBB 00 286 270 76 22 515 105 SEB ECE 37 227 17 14 08 70 43 24 70 14 26 104 LB 233 16 451 703 482 144 108 584 201 36.2 254 113 247 100.0 406 1000 566 1000 357 100.0 113 1000 601 1000 100.0 1000 1000 1000 1000 100.0 1000 1000 1000 1000 1000 100.0 51 672 16.3 275 31 23 5.4 35 00 ya 157 06 62 Accounts Payable Short-Term Borrowing Other Short Term 12 05 37 49 214 0.2 37 57 22 00 228 300 lella 00 0.4 53 61 Sala 139 219 13.8 169 20.2 65 111 10.7 14 365 313 536 323 179 213 380 00 545 967 205 530 Tots 635 79.8 1163 07 14 1064 535 70 50,6 473 R30 36 707 BOB 06.00 365 404 181 465 470 03 52.7 293 564 192 Bloomberg LP