Comcast Corporation (CMCSA) is a global media and entertainment company with operations divided into three major segments:

• Cable Communications: High-speed Internet, video, voice, and wireless services to U.S. customers under the brand Xfinity
• NBCUniversal: Programing for television and cable networks, films for movie theaters, DVDs, and Universal theme parks in Florida, California, and Japan
• Sky: Companies that provide media, entertainment, and communications services in Europe

Revenue, operating income, and depreciation and amortization information for these segments for a recent year are as follows (in millions):

SegmentRevenueOperating IncomeDepreciation and Amortization Cable Communications$60,051$17,517$7,753 NBCUniversal$28,082$3,991$2,278 Sky$18,594(1,080)$3,034 Total$106,727$20,428$13,065

a. Prepare a vertical analysis of the segment revenues to total revenues. Round percentages to 2 decimal places. Enter amounts in millions.

SegmentRevenueRevenues as a Percent of Total Revenues Cable Communications NBCUniversal Sky Total

b. Compute (1) EBITDA and (2) EBITDA as a percent of revenue for each segment. Round to nearest whole percent.

SegmentRevenueOperating IncomeDepreciation and AmortizationEBITDAEBITDA as a Percent of RevenueCable Communications$60,051$17,517$7,753 NBCUniversal$28,082$3,991$2,278 Sky$18,594(1,080)$3,034 Total$106,727$20,428$13,065