Financial fraud is often uncovered by exploring financial statements. This is easier with a public company than a private one, as we will see by studying the fall of health technology cor- poration Theranos.

This case studys pre-work article takes a close look at the startup Theranos which was founded and run by Elizabeth Holmes. It is a tale of a 19 year old female startup founder that led her company to a $6 billion evaluation by some in Silcon

Valley that turned into a story of lies and corruption. This lesson is designed to help students become more fluent in interpreting financial statement ratios in order to learn more about a company. Using Theranos as a lens, the class activity examines how to construct an income statement and balance sheet. Well dive deeper into these statements and the value they can bring to investors. Youll learn through reading the pre-work article the value of these statements to investors and

what happens when they are largely ignored. The homework Case Study asks students to dissect the finan-

cial statements of The Walt Disney Company and describe its structure and drivers. You will be tasked with using the Bloomberg terminal to answer a set of 3 questions that are meant to prove an understanding of financial statements and how they can impact a persons understanding of a comapny.

FINANCIAL STATEMENTS / BLOOMBERG BUSINESSWEEK CASE STUDY

DISNEYS BUSINESS SUMMARY

The following text is an edited summary from Disneys 2018 annual report (10-K) submitted by the company to the SEC.

The Walt Disney Company, together with its subsidiaries, is a diversified worldwide entertainment company with operations in four business segments:

Media Networks Parks, Experiences & Consumer Products Studio Entertainment Direct-to-Consumer & International (DTCI)

MEDIA NETWORKS

The Media Networks segment includes cable and broadcast tele- vision networks, television production and distribution oper- ations, domestic television stations and radio networks and stations. The Company also has investments in entities that operate programming, distribution and content management services, including television networks, which are accounted for under the equity method of accounting.

The businesses in the Media Networks segment principally generate revenue from the following:

• Fees charged to cable, satellite, telecommunications and digital over-the-top service providers

• The sale to advertisers of time in programs for commer- cial announcements (ad sales)

• Licensing fees for the right to use Disneys programs, productions, and content (program sales)

  Operating expenses primarily consist of programming and pro- duction costs, participations and residuals expense, technical support costs, operating labor and distribution costs.

  PARKS, EXPERIENCES & CONSUMER PRODUCTS

  Parks & Experiences Disney owns and operates the Walt Disney World Resort in Florida; the Disneyland Resort in California; Disneyland Paris; Aulani, a Disney Resort & Spa in Hawaii; the Disney Vacation Club; the Disney Cruise Line; and Adventures by Disney. The Company manages and has effective ownership interests of 47% in Hong Kong Disneyland Resort and 43% in Shanghai Disney Resort, both of which are consolidated in our financial state- ments. Disney also licenses intellectual property to a third party to operate the Tokyo Disney Resort in Japan. The Companys Walt Disney Imagineering unit designs and develops new theme park concepts and attractions as well as resort properties.

  Consumer Prodcuts The Consumer Products sub-segment licenses Disneys trade names, characters and visual and literary properties to vari- ous manufacturers, game developers, publishers and retail- ers throughout the world. The sub-segment is also responsible for the sale of branded merchandise through retail, online and wholesale businesses. Disney also develops and publishes books, magazines, comic books, and games. As of the end of

fiscal 2018, Disney had substantially exited the vertical games development business.

The Parks, Experiences & Consumer Products segment gener- ates revenue primarily from:

Sale of tickets for admission to theme parks Merchandise, food and beverages at theme park resorts

and cruise ships Hotel rooms, cruise vacations, and sales and rentals of

vacation club properties Royalties from IP licensing and sales of merchandise at

The Disney Stores, branded internet shipping sites, and

wholesalers Revenues from sponsorships and co-branding oppor-

tunities, real estate rent and sales, and royalties from Tokyo Disney Resort

Significant costs include labor, costs of goods sold, infrastruc- ture, supplies, commissions, and entertainment offerings.

STUDIO ENTERTAINMENT

The Studio Entertainment segment produces and distributes under the Walt Disney Pictures, Pixar, Marvel, Lucasfilm, and Touchstone banners. The segment is also involved in the devel- opment, production, and licensing of live entertainment events on Broadway and around the world.

The businesses in the Studio Entertainment segment gener- ate revenue from distribution of films in the theatrical distribu- tion, home entertainment, and TV/SVOD markets. This includes rentals from licensing motion pictures to theaters, sale of motion pictures to retailers and distributors, and other revenues col- lected from licensing and ticket sales.

Significant operating expenses include amortization of pro- duction, participations and residuals costs, marketing and sales costs, distribution expenses and costs of sales.

DIRECT-TO-CONSUMER & INTERNATIONAL (DTCI)

The Direct-to-Consumer & International segment includes Disney and ESPN branded international television networks and channels, Direct-to-Consumer (DTC) businesses like ESPN+ Disney+, and Hulu streaming services, and equity investments. The equity investments include a 21% effective ownership in Vice Group Holdings.

The businesses in the DTCI segment generate revenue from fees charged to MVPDs for the right to deliver Disneys International Channels to their customers, ad sales on International Channels, and subscription fees charged to cus- tomers/subscribers for Disneys DTC streaming services.

Operating expenses primarily consist of programming and production costs, technical support costs, operating labor, and distribution costs.

Case Questions

2 Using the Terminal Tutorial at the end of the case study, calculate each business segments contribution to Disneys total revenue and operating income.

Using the Terminal Tutorial at the end of the case study, calculate each business segments contribution to Disneys total revenue and operating income.

X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 1149 : x fic A B C D E F G H Walt Disney Co/The (DIS US) - By Segment I J K L M LA FY 2010 10/02/2010 FY 2011 10/01/2011 FY 2012 0 9/29/2012 FY 2013 09/28/2013 FY 2014 09/27/2014 FY 2015 10/03/2015 FY 2016 10/01/2016 FY 2017 09/30/2017 FY 2018 0 9/29/2018 FY 2019 09/28/2019 L -L - - 24,701.0 6,758.0 4,146.00 2,198.0 6.00 8.00 24,701.0 - - - 4 In Millions of USD except Per Share 5 12 Months Ending 6 Parks, Experiences and Products 7 Revenue 8 Operating Income 9 Capital Expenditures 10 Depreciation 11 Revenue Growth % 12 Operating Income Growth % 13 Revenue Including Intersegment Revenue 14 Reconciliation 15 Revenue 16 Operating Income 17 Studio Entertainment 18 Revenue 19 Operating Income 20 Capital Expenditures 21 Depreciation 22 Revenue Growth % 23 Operating Income Growth % 24 Revenue Including Intersegment Revenue 25 Assets 26 Goodwill 27 Revenue - Supplementary Breakdown 28 Revenue Growth - Supplemental Breakdown 9,468.0 3,258.0 L -990.01 -1,024.0 -1,557.00 -1,636.00 -1,457.0 -766.0 -558.00 -738.0 6,701.01 693.0 -102.01 56.0 9.00 100.00 6,351.00 618.00 -118.00 53.0 -5.00 - 11.00 5,825.0|| 722.0 -79.00 48.0 -8.00 17.00 5,979.01 661.0 -78.01 54.0 3.00 -8.00 7,278.00 1,549.0 -63.00 48.0|| 22.000 100.00 7,366.0 1,973.00 -107.01 55.0 1.00 27.00) 9.441.0|| 2,703.00 -86.0 51.01 28.00 37.00 8,379.0 2,355.0 -85.0 50.0 -11.00 -13.00 9,987.00 2,980.0 -96.0 55.0 19.00 27.00 10,065.0 2,686.0 -88.0 74.0 11.00 52.00 10,065.0 12,742.0 5,268.00 6,701.01 9.00 12,221.0 5,284.0 6,351.00 -5.00 12,928.0 5,680.00 5,825.01 -5.00 14,750.0 6,591.00 5,979.01 3.00l 15,162.0 6,856.00 7,278.0 22.00 15,334.0 6,836.0 7,366.00 1.000 15,359.0 6,830.00 9,441.0 - 11.001 16,307.0 6,817.00 8,379.0 - 11.001 17,154.0 7,164.0 9,987.00 19.000 | By Segment 100% + - @ 1,001 : Egoxo risc 100:bugio 0:1 {1/NE E la a X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 175 x fx 1718 F -137.0 142.0 -275.00 148.0 471.0 182.0 -287.00 220.0|| -252.0 239.00 -269.0 249.00 -253.0 251.0 -178.00 252.0 -179.00 218.0 | 9 II 19 -210.00 167.0 -100.00 -100.00 5,281.00 6,336.00 5.417.00 5,991.0 6,391.00 7,022.01 1,379.00 0.00 6,361.0 0.0 - 8,519.00 3,600.00 6,082.01 0.0 0.0 0.0 0.00 0.00 49 Capital Expenditures 50 Depreciation 51 Revenue Growth % 52 Operating Income Growth % 53 Assets 54 Goodwill 55 Amortization of Intangible Assets 56 Consumer Products and Interactive Media 57 Revenue 58 Operating Income 59 Assets 60 Capital Expenditures 61 Goodwill 62 Depreciation 63 Revenue - Supplementary Breakdown 64 Revenue Growth % 65 Operating Income Growth % 66 Revenue Growth - Supplemental Breakdown 67 Total Operating Expense 68 Amortization of Intangible Assets 69 Parks and Resorts 70 Revenue 71 Operating Income 72 Assets 73 Capital Expenditures 74 Goodwill 75 Depreciation Windows bi 5,673.0 1,884.01 9,678.01 -870 2,966.0 69.00 5,673.01 13.00 29.00 - -L - 5,528.01 1,965.00 9,332.00 -53.0 4,344.00 63.0 5,528.00 -3.00 4.00 -13.00 2,263.00 112.01 4,833.00 1,744.00 8,996.01 30.01 4,393.0 63.00 4,833.0 -13.00 -11.00 -13.00 4,651.0|| 1,632.00 8,793.0 -18.0 4,426.01 69.0|| 4,651.0 4.00 - -6.00] 1,904.0 4.00 1.882.0 123.0 114.0 116.0 2 10,761.0 1,318.0 17,529.00 -1,533.0 171.01 1,139.00 11,797.00 1,553.0| 19,530.01 -2,723.01 172.01 1,165.0 12,920.01 1,902.01 20,951.0 -2,883.0 172.0 1,241.0 14,087.0|| ,220.0 22,056.0|| -2,110.0 253.00 1,368.0 15,099.00 2,663.0 23.297.00 -2,688.00 291.00 1,470.00 16,162.0 3,031.0 25,510.0 -3,604.00 291.0 1,514. 0 16,974.0|| 3,298.01 28,275.00 4,215.00 291.00 ,718.00 18,415.0 3,774.00 29,492.0 -3,191.0 291.00 1,996.0 20,296.0 4,469.0| 30,670.00 -3,883.00 291.00 2,152.00 1 Wint By Segment. 100% - O +- 2.0:11 E1/NE E N 9 a 3A X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) | 1151 : x fic A H K L M A 677.0 4.786.0 -97.00 1,805.0 33.0 2,678.00 10.00 11.00 10.00 -1,236.01 45.0 816.00 4,992.01 -115.0 1,797.00 48.00 3,049.0 14.00 21.00 14.00 1,452.0 57.00 E 937.00 5,016.01 -69.00 1,794.00 55.00 3,252.0 7.00 15.00 14.00 1,384.0 60.00 1,112.00 7,506.00 45.0 2,942.0 57.0 3,555.01 9.00 19.00 9.00 1,566.0 89.00 1,356.01 7,526.0 43.0 2,967.0|| 59.0 3,985.0 12.00 22.00 12.00 1.683.00 109.00 125 Operating Income 126 Assets 127 Capital Expenditures 128 Goodwill 129 Depreciation 130 Revenue - Supplementary Breakdown 131 Revenue Growth % 132 Operating Income Growth % 133 Revenue Growth - Supplemental Breakdown 134 Total Operating Expense 135 Amortization of Intangible Assets 136 Interactive 137 Revenue 138 Operating Income 139 Assets 140 Capital Expenditures 141 Goodwill 142 Depreciation 143 Revenue - Supplementary Breakdown 144 Revenue Growth % 145 Operating Income Growth % 146 Revenue Growth - Supplemental Breakdown 147 Total Operating Expense 148 Amortization of Intangible Assets 149 SOAPnet 150 Number of Subscribers (end of period) 151 Source: Bloomberg Windows bu 1,299.00 116.0 2,199.0| - -5.0 761.00 -234.0 1,756.00 -17.00 1,119.00 19.00 761.0 7.00 21.00 7.000 -581.0 24.0 982.0 -308.0 1,801.00 21.01. 1,164.01 16.01 982.01 29.00 -32.00 7.00 675.0|| 38.0 845.00 -216.00 1,926.0|| 27.01 1,333.0 17.01 845.0 -14.00 30.00 29.00 583.0 32.0 1,064.00 -87.0|| 2,311.0 -13.00 1,467.00 20.01 1,064.0 26.00 60.00 26.00 658.0 24.0 1,389.0 10.0 1299 0 22.00 0.00 22.00 700.00 13.0 - - - 76,000.0 74,000.0 66,000.0 67,000.00 Win By Segment. 100% O +- - NE E 1 ra a O X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 1126 : x fc H EF - K 229,000.0 L M - - 238,000.00 238,000.00 90,000.00 90,000.00 88,000.00 368,000.00 368,000.0 357,000.0 645,000.0 645,000.00 669,000.0 70,000.00 70,000.00 67,000.0 394,000.0 376,000.0 374,000.00 381,000.00 542,000.00 540,000.00 99,000.00 98,000.00 97,000.00 98,000.00 94,000.00 93,000.00 100 Number of Subscribers (end of period) 101 Freeform 102 Number of Subscribers (end of period) 103 ESPN-Domestic 104 Number of Subscribers (end of period) 105 International Channels 106 Number of Subscribers (end of period) 107 Viceland 108 Number of Subscribers (end of period) 109 ESPN 110 Number of Subscribers (end of period) 111 ABC Family 112 Number of Subscribers (end of period) 113 Disney Channels Worldwide 114 Number of Subscribers (end of period) 115 Disney XD - Domestic 116 Number of Subscribers (end of period) 117 Disney XD-International 118 Number of Subscribers (end of period) 119 Disney Junior - Domestic 120 Number of Subscribers (end of period) 121 Disney Junior-International Channels 122 Number of Subscribers (end of period) 123 Consumer Products 124 Revenue 125 Operating Income 126 Assets Windows but 100,000.00 240,000.0 253,000.00 271,000. 0 2 82,000.01 290,000.0 78,000.0 80,000.0| 82,000.00 80,000.00 78,000.0 91,000.00 95,000.00 106,000.00 115,000.00 123,000.0 58,000.00 52,000.00 63,000.0 74,000.00 74,000.00 - 73,000.00 97,000.0 108,000.00 130,000.0|| 2,678.00 677.00 4,786.0 3,049.00 816.01 4.992.0 3,252.00 937.00 5,016.0 3,555.0 1,112.0 7,506.0 3,985.0 1,356.0 7,526.01 Wint By Segment. 100% +- - O N 2.0:1 -&V.N. SE ) la UA X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 151 x fc - A 12,928.01 5,680.00 5,825.0 12,742.0 5,268.0 6,701.00 9.00 3,469.0 33.0 12,221.00 5,284.00 6,351.00 -5.00 3,253.00 79.0 14,750.00 6,591.00 5,979.0 3.00 3,012.01 107.00 15,162.01 6,856.01 7,278.01 22.00 3,137.00 88.00 15,334.0 6,836.00 7,366.0 1.00 3,050.0 84.01 15,359.01 6,830.01 9.441.01 -11.000 3,991.01 16,307.0 6,817.01 8,379.00 -11.00 3,667.0 65.0 K LMA 17,154.0 7,164.00 9,987.00 19.00 4,326.00 64.00 2,908.00 94.0 74.00 - 3,414.0 -1,814.0 468.0 207.0 100.00 -100.00 3,414.0 31,900.0 - - 25 Assets 26 Goodwill 27 Revenue - Supplementary Breakdown 28 Revenue Growth - Supplemental Breakdown 29 Total Operating Expense 30 Amortization of Intangible Assets 31 Direct-to-Consumer & International 32 Revenue 33 Operating Income 34 Capital Expenditures 35 Depreciation 36 Revenue Growth % 37 Operating Income Growth % 38 Revenue Including Intersegment Revenue 39 Number of Subscribers (end of period) - Supple 40 Media Networks 41 Revenue 42 Operating Income 43 Capital Expenditures 44 Depreciation 45 Revenue Growth % 46 Operating Income Growth % 47 Revenue Including Intersegment Revenue 48 Corporate 49 Capital Expenditures 50 Depreciation 51 Revenue Growth % Windows but Wind By Segment bil 100% +- - @ - - - - 21,922.0 7,479.00 -174.00 191.0 13.00 2.00 21,922.01 - - - - - - -253.01 -137.00 142.0 -275.00 148.00 -471.00 182.0 -287.0 220.01 -252.00 239.0 -269.00 249.00 -178.0 252.0 -179.00 218.00 251.00 -210.0 167.0 -100.00 N 2.0:11 E1/NE E 9 a 3A wi e X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 187 X fx 32706 L M _ 1,139.0 10,761.00 234.00 1.00 82.00 -7.00 1.00 -6,787.00 0.00 1,165.00 11,797.01 253.00 10.00 83.000 18.00 10.00 7.383.0 0.01 1,241.0 12,920.00 266.00 10.00 82.00 22.00 10.00 7,928.0 0.0 1,368.00 14,087.01 276.00 9.00 80.00 17.00 9.00 8,537.00 2.0 1,470.00 15,099.00 289.00 7.00 82.00 20.00 7.00 9.106.00 2.00 1.514.00 16,162.0 295.00 7.00 86.00 14.00 7.00 9,730.00 3.0 1.718.0 16,974.00 301.00 5.00 87.00 9.00 8.00 10.039.00 3.0 1,996.01 18,415.01 312.00 8.00 86.00 14.00 8.00 10,667.0 3.0 2,152.00 20,296.00 334.00 10.00 87.00 18.00 10.00 11,590.00 4.0 75 Depreciation 76 Revenue - Supplementary Breakdown 77 Revenue per Available Room 78 Revenue Growth % 79 Occupancy Rate 80 Operating Income Growth % 81 Revenue Growth - Supplemental Breakdown 82 Total Operating Expense 83 Amortization of Intangible Assets 84 Media Networks 85 Revenue 86 Operating Income 87 Assets 88 Capital Expenditures 89 Goodwill 90 Depreciation 91 Revenue - Supplementary Breakdown 92 Revenue Growth % 93 Operating Income Growth % 94 Revenue Growth - Supplemental Breakdown 95 Total Operating Expense 96 Amortization of Intangible Assets 97 A+E 98 Number of Subscribers (end of period) 99 Disney 100 Number of Subscribers (end of period) 101 Freeform Windows b 18,714.01 6,146.0 27,244.0 -307.00 15,728.01 21,152.0 7,321.0 29,566.00 -260.0|| 16,378.0|| 24.500.00 6,494.0 35,899.0 -289.00 19,388.00 229.0 264.0 17,162.00 5,132.0 27,112.0 -224.01 15,737.00 213.01 17,162.0 6.00 8.00 6.00 -9,888.0 9.00 19,436.0 6,619.00 28,660.00 -255.01 16,131.0 241.0 19.436.00 4.00 4.00 9.00 1 0535.0 17.0 20,356.01 6,818.00 28,627.00 -263.0 16,071.00 238.0 20,356.01 5.00 3.00 5.00 11,261.00 13.0 23.264.00 7,793.00 30,638.0 -198.0 16,354.0 245.01 23,264.00 10.00 6.00 10.00 13,150.00 21.01 23,689.00 7,158.0 32,706.01 -166.0|| 16,345.0 237.00 23,689.0 2.000 0.00 -1.001 13,571.00 18.01 23,510.00 6,558.00 32,475.0 -139.0 16,325.00 225.00 23,510.00 -1.00 -11.00 -1.00 14,068.00 12.0 18,714.0 9.00 20.00 9.00 10,282. 0 8.01 21,152.00 4.00 7.00 4.00|| 11,794.0 12.0 24,500.0 4.00 4.00 4.00|| 14,928.01 62.01 517,000.00 526,000.00 446,000.00 453,000.0 507,000.00 504,000. 0 4 05,000.00 405,000.00 387,000.0 238,000.0 238,000.0 229,000.0 Wint By Segment. 100% +- - @ O p +0:11 {1/NE E fa a 3A X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 1149 : x fic A B C D E F G H Walt Disney Co/The (DIS US) - By Segment I J K L M LA FY 2010 10/02/2010 FY 2011 10/01/2011 FY 2012 0 9/29/2012 FY 2013 09/28/2013 FY 2014 09/27/2014 FY 2015 10/03/2015 FY 2016 10/01/2016 FY 2017 09/30/2017 FY 2018 0 9/29/2018 FY 2019 09/28/2019 L -L - - 24,701.0 6,758.0 4,146.00 2,198.0 6.00 8.00 24,701.0 - - - 4 In Millions of USD except Per Share 5 12 Months Ending 6 Parks, Experiences and Products 7 Revenue 8 Operating Income 9 Capital Expenditures 10 Depreciation 11 Revenue Growth % 12 Operating Income Growth % 13 Revenue Including Intersegment Revenue 14 Reconciliation 15 Revenue 16 Operating Income 17 Studio Entertainment 18 Revenue 19 Operating Income 20 Capital Expenditures 21 Depreciation 22 Revenue Growth % 23 Operating Income Growth % 24 Revenue Including Intersegment Revenue 25 Assets 26 Goodwill 27 Revenue - Supplementary Breakdown 28 Revenue Growth - Supplemental Breakdown 9,468.0 3,258.0 L -990.01 -1,024.0 -1,557.00 -1,636.00 -1,457.0 -766.0 -558.00 -738.0 6,701.01 693.0 -102.01 56.0 9.00 100.00 6,351.00 618.00 -118.00 53.0 -5.00 - 11.00 5,825.0|| 722.0 -79.00 48.0 -8.00 17.00 5,979.01 661.0 -78.01 54.0 3.00 -8.00 7,278.00 1,549.0 -63.00 48.0|| 22.000 100.00 7,366.0 1,973.00 -107.01 55.0 1.00 27.00) 9.441.0|| 2,703.00 -86.0 51.01 28.00 37.00 8,379.0 2,355.0 -85.0 50.0 -11.00 -13.00 9,987.00 2,980.0 -96.0 55.0 19.00 27.00 10,065.0 2,686.0 -88.0 74.0 11.00 52.00 10,065.0 12,742.0 5,268.00 6,701.01 9.00 12,221.0 5,284.0 6,351.00 -5.00 12,928.0 5,680.00 5,825.01 -5.00 14,750.0 6,591.00 5,979.01 3.00l 15,162.0 6,856.00 7,278.0 22.00 15,334.0 6,836.0 7,366.00 1.000 15,359.0 6,830.00 9,441.0 - 11.001 16,307.0 6,817.00 8,379.0 - 11.001 17,154.0 7,164.0 9,987.00 19.000 | By Segment 100% + - @ 1,001 : Egoxo risc 100:bugio 0:1 {1/NE E la a X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 175 x fx 1718 F -137.0 142.0 -275.00 148.0 471.0 182.0 -287.00 220.0|| -252.0 239.00 -269.0 249.00 -253.0 251.0 -178.00 252.0 -179.00 218.0 | 9 II 19 -210.00 167.0 -100.00 -100.00 5,281.00 6,336.00 5.417.00 5,991.0 6,391.00 7,022.01 1,379.00 0.00 6,361.0 0.0 - 8,519.00 3,600.00 6,082.01 0.0 0.0 0.0 0.00 0.00 49 Capital Expenditures 50 Depreciation 51 Revenue Growth % 52 Operating Income Growth % 53 Assets 54 Goodwill 55 Amortization of Intangible Assets 56 Consumer Products and Interactive Media 57 Revenue 58 Operating Income 59 Assets 60 Capital Expenditures 61 Goodwill 62 Depreciation 63 Revenue - Supplementary Breakdown 64 Revenue Growth % 65 Operating Income Growth % 66 Revenue Growth - Supplemental Breakdown 67 Total Operating Expense 68 Amortization of Intangible Assets 69 Parks and Resorts 70 Revenue 71 Operating Income 72 Assets 73 Capital Expenditures 74 Goodwill 75 Depreciation Windows bi 5,673.0 1,884.01 9,678.01 -870 2,966.0 69.00 5,673.01 13.00 29.00 - -L - 5,528.01 1,965.00 9,332.00 -53.0 4,344.00 63.0 5,528.00 -3.00 4.00 -13.00 2,263.00 112.01 4,833.00 1,744.00 8,996.01 30.01 4,393.0 63.00 4,833.0 -13.00 -11.00 -13.00 4,651.0|| 1,632.00 8,793.0 -18.0 4,426.01 69.0|| 4,651.0 4.00 - -6.00] 1,904.0 4.00 1.882.0 123.0 114.0 116.0 2 10,761.0 1,318.0 17,529.00 -1,533.0 171.01 1,139.00 11,797.00 1,553.0| 19,530.01 -2,723.01 172.01 1,165.0 12,920.01 1,902.01 20,951.0 -2,883.0 172.0 1,241.0 14,087.0|| ,220.0 22,056.0|| -2,110.0 253.00 1,368.0 15,099.00 2,663.0 23.297.00 -2,688.00 291.00 1,470.00 16,162.0 3,031.0 25,510.0 -3,604.00 291.0 1,514. 0 16,974.0|| 3,298.01 28,275.00 4,215.00 291.00 ,718.00 18,415.0 3,774.00 29,492.0 -3,191.0 291.00 1,996.0 20,296.0 4,469.0| 30,670.00 -3,883.00 291.00 2,152.00 1 Wint By Segment. 100% - O +- 2.0:11 E1/NE E N 9 a 3A X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) | 1151 : x fic A H K L M A 677.0 4.786.0 -97.00 1,805.0 33.0 2,678.00 10.00 11.00 10.00 -1,236.01 45.0 816.00 4,992.01 -115.0 1,797.00 48.00 3,049.0 14.00 21.00 14.00 1,452.0 57.00 E 937.00 5,016.01 -69.00 1,794.00 55.00 3,252.0 7.00 15.00 14.00 1,384.0 60.00 1,112.00 7,506.00 45.0 2,942.0 57.0 3,555.01 9.00 19.00 9.00 1,566.0 89.00 1,356.01 7,526.0 43.0 2,967.0|| 59.0 3,985.0 12.00 22.00 12.00 1.683.00 109.00 125 Operating Income 126 Assets 127 Capital Expenditures 128 Goodwill 129 Depreciation 130 Revenue - Supplementary Breakdown 131 Revenue Growth % 132 Operating Income Growth % 133 Revenue Growth - Supplemental Breakdown 134 Total Operating Expense 135 Amortization of Intangible Assets 136 Interactive 137 Revenue 138 Operating Income 139 Assets 140 Capital Expenditures 141 Goodwill 142 Depreciation 143 Revenue - Supplementary Breakdown 144 Revenue Growth % 145 Operating Income Growth % 146 Revenue Growth - Supplemental Breakdown 147 Total Operating Expense 148 Amortization of Intangible Assets 149 SOAPnet 150 Number of Subscribers (end of period) 151 Source: Bloomberg Windows bu 1,299.00 116.0 2,199.0| - -5.0 761.00 -234.0 1,756.00 -17.00 1,119.00 19.00 761.0 7.00 21.00 7.000 -581.0 24.0 982.0 -308.0 1,801.00 21.01. 1,164.01 16.01 982.01 29.00 -32.00 7.00 675.0|| 38.0 845.00 -216.00 1,926.0|| 27.01 1,333.0 17.01 845.0 -14.00 30.00 29.00 583.0 32.0 1,064.00 -87.0|| 2,311.0 -13.00 1,467.00 20.01 1,064.0 26.00 60.00 26.00 658.0 24.0 1,389.0 10.0 1299 0 22.00 0.00 22.00 700.00 13.0 - - - 76,000.0 74,000.0 66,000.0 67,000.00 Win By Segment. 100% O +- - NE E 1 ra a O X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 1126 : x fc H EF - K 229,000.0 L M - - 238,000.00 238,000.00 90,000.00 90,000.00 88,000.00 368,000.00 368,000.0 357,000.0 645,000.0 645,000.00 669,000.0 70,000.00 70,000.00 67,000.0 394,000.0 376,000.0 374,000.00 381,000.00 542,000.00 540,000.00 99,000.00 98,000.00 97,000.00 98,000.00 94,000.00 93,000.00 100 Number of Subscribers (end of period) 101 Freeform 102 Number of Subscribers (end of period) 103 ESPN-Domestic 104 Number of Subscribers (end of period) 105 International Channels 106 Number of Subscribers (end of period) 107 Viceland 108 Number of Subscribers (end of period) 109 ESPN 110 Number of Subscribers (end of period) 111 ABC Family 112 Number of Subscribers (end of period) 113 Disney Channels Worldwide 114 Number of Subscribers (end of period) 115 Disney XD - Domestic 116 Number of Subscribers (end of period) 117 Disney XD-International 118 Number of Subscribers (end of period) 119 Disney Junior - Domestic 120 Number of Subscribers (end of period) 121 Disney Junior-International Channels 122 Number of Subscribers (end of period) 123 Consumer Products 124 Revenue 125 Operating Income 126 Assets Windows but 100,000.00 240,000.0 253,000.00 271,000. 0 2 82,000.01 290,000.0 78,000.0 80,000.0| 82,000.00 80,000.00 78,000.0 91,000.00 95,000.00 106,000.00 115,000.00 123,000.0 58,000.00 52,000.00 63,000.0 74,000.00 74,000.00 - 73,000.00 97,000.0 108,000.00 130,000.0|| 2,678.00 677.00 4,786.0 3,049.00 816.01 4.992.0 3,252.00 937.00 5,016.0 3,555.0 1,112.0 7,506.0 3,985.0 1,356.0 7,526.01 Wint By Segment. 100% +- - O N 2.0:1 -&V.N. SE ) la UA X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 151 x fc - A 12,928.01 5,680.00 5,825.0 12,742.0 5,268.0 6,701.00 9.00 3,469.0 33.0 12,221.00 5,284.00 6,351.00 -5.00 3,253.00 79.0 14,750.00 6,591.00 5,979.0 3.00 3,012.01 107.00 15,162.01 6,856.01 7,278.01 22.00 3,137.00 88.00 15,334.0 6,836.00 7,366.0 1.00 3,050.0 84.01 15,359.01 6,830.01 9.441.01 -11.000 3,991.01 16,307.0 6,817.01 8,379.00 -11.00 3,667.0 65.0 K LMA 17,154.0 7,164.00 9,987.00 19.00 4,326.00 64.00 2,908.00 94.0 74.00 - 3,414.0 -1,814.0 468.0 207.0 100.00 -100.00 3,414.0 31,900.0 - - 25 Assets 26 Goodwill 27 Revenue - Supplementary Breakdown 28 Revenue Growth - Supplemental Breakdown 29 Total Operating Expense 30 Amortization of Intangible Assets 31 Direct-to-Consumer & International 32 Revenue 33 Operating Income 34 Capital Expenditures 35 Depreciation 36 Revenue Growth % 37 Operating Income Growth % 38 Revenue Including Intersegment Revenue 39 Number of Subscribers (end of period) - Supple 40 Media Networks 41 Revenue 42 Operating Income 43 Capital Expenditures 44 Depreciation 45 Revenue Growth % 46 Operating Income Growth % 47 Revenue Including Intersegment Revenue 48 Corporate 49 Capital Expenditures 50 Depreciation 51 Revenue Growth % Windows but Wind By Segment bil 100% +- - @ - - - - 21,922.0 7,479.00 -174.00 191.0 13.00 2.00 21,922.01 - - - - - - -253.01 -137.00 142.0 -275.00 148.00 -471.00 182.0 -287.0 220.01 -252.00 239.0 -269.00 249.00 -178.0 252.0 -179.00 218.00 251.00 -210.0 167.0 -100.00 N 2.0:11 E1/NE E 9 a 3A wi e X - 9 (cajl by Jis) Disney data.xlsx - Excel = -5- X) 187 X fx 32706 L M _ 1,139.0 10,761.00 234.00 1.00 82.00 -7.00 1.00 -6,787.00 0.00 1,165.00 11,797.01 253.00 10.00 83.000 18.00 10.00 7.383.0 0.01 1,241.0 12,920.00 266.00 10.00 82.00 22.00 10.00 7,928.0 0.0 1,368.00 14,087.01 276.00 9.00 80.00 17.00 9.00 8,537.00 2.0 1,470.00 15,099.00 289.00 7.00 82.00 20.00 7.00 9.106.00 2.00 1.514.00 16,162.0 295.00 7.00 86.00 14.00 7.00 9,730.00 3.0 1.718.0 16,974.00 301.00 5.00 87.00 9.00 8.00 10.039.00 3.0 1,996.01 18,415.01 312.00 8.00 86.00 14.00 8.00 10,667.0 3.0 2,152.00 20,296.00 334.00 10.00 87.00 18.00 10.00 11,590.00 4.0 75 Depreciation 76 Revenue - Supplementary Breakdown 77 Revenue per Available Room 78 Revenue Growth % 79 Occupancy Rate 80 Operating Income Growth % 81 Revenue Growth - Supplemental Breakdown 82 Total Operating Expense 83 Amortization of Intangible Assets 84 Media Networks 85 Revenue 86 Operating Income 87 Assets 88 Capital Expenditures 89 Goodwill 90 Depreciation 91 Revenue - Supplementary Breakdown 92 Revenue Growth % 93 Operating Income Growth % 94 Revenue Growth - Supplemental Breakdown 95 Total Operating Expense 96 Amortization of Intangible Assets 97 A+E 98 Number of Subscribers (end of period) 99 Disney 100 Number of Subscribers (end of period) 101 Freeform Windows b 18,714.01 6,146.0 27,244.0 -307.00 15,728.01 21,152.0 7,321.0 29,566.00 -260.0|| 16,378.0|| 24.500.00 6,494.0 35,899.0 -289.00 19,388.00 229.0 264.0 17,162.00 5,132.0 27,112.0 -224.01 15,737.00 213.01 17,162.0 6.00 8.00 6.00 -9,888.0 9.00 19,436.0 6,619.00 28,660.00 -255.01 16,131.0 241.0 19.436.00 4.00 4.00 9.00 1 0535.0 17.0 20,356.01 6,818.00 28,627.00 -263.0 16,071.00 238.0 20,356.01 5.00 3.00 5.00 11,261.00 13.0 23.264.00 7,793.00 30,638.0 -198.0 16,354.0 245.01 23,264.00 10.00 6.00 10.00 13,150.00 21.01 23,689.00 7,158.0 32,706.01 -166.0|| 16,345.0 237.00 23,689.0 2.000 0.00 -1.001 13,571.00 18.01 23,510.00 6,558.00 32,475.0 -139.0 16,325.00 225.00 23,510.00 -1.00 -11.00 -1.00 14,068.00 12.0 18,714.0 9.00 20.00 9.00 10,282. 0 8.01 21,152.00 4.00 7.00 4.00|| 11,794.0 12.0 24,500.0 4.00 4.00 4.00|| 14,928.01 62.01 517,000.00 526,000.00 446,000.00 453,000.0 507,000.00 504,000. 0 4 05,000.00 405,000.00 387,000.0 238,000.0 238,000.0 229,000.0 Wint By Segment. 100% +- - @ O p +0:11 {1/NE E fa a 3A