Analyze Comcast Corporation by segment

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

Segment	Revenue	Operating Income	Depreciation 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

Question Content Area

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

Segment	Revenue	Revenues as a Percent of Total Revenues
Cable Communications	fill in the blank 1 of 8$	fill in the blank 2 of 8%
NBCUniversal	fill in the blank 3 of 8	fill in the blank 4 of 8
Sky	fill in the blank 5 of 8	fill in the blank 6 of 8
Total	fill in the blank 7 of 8$	fill in the blank 8 of 8%

Feedback Area

Feedback

Vertical analysis is a proportional analysis of a financial statement, where each line item on a financial statement is listed as a percentage of another item. The total should equal 100%.

Question Content Area

b. Which segment contributes most to total revenues?

Cable CommunicationsNBCUniversal SkyCable Communications

Feedback Area

Feedback

Vertical analysis is a proportional analysis of a financial statement, where each line item on a financial statement is listed as a percentage of another item. The total should equal 100%.

Question Content Area

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

Segment	Revenue	Operating Income	Depreciation and Amortization	EBITDA	EBITDA as a Percent of Revenue
Cable Communications	$60,051	$17,517	$7,753	fill in the blank 1 of 7$	fill in the blank 2 of 7%
NBCUniversal	28,082	3,991	2,278	fill in the blank 3 of 7	fill in the blank 4 of 7
Sky	18,594	(1,080)	3,034	fill in the blank 5 of 7	fill in the blank 6 of 7
Total	$106,727	$20,428	$13,065	fill in the blank 7 of 7