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

▪ Cable Communications (XFINITY)

▪ Cable Networks (USA Network, Syfy, E!, CNBC, others)

▪ Broadcast Television (NBC)

▪ Filmed Entertainment (Universal Pictures)

▪ Theme Parks (Universal)

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

a. Prepare a vertical analysis of the segment revenues to total revenues. Round to nearest whole percent.

b. Which segment contributes most to total revenues?

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

d. Evaluate segment EBITDA as a percent of revenue.

e. What might management do to increase performance in the segments with the lowest EBITDA?

Transcribed Image Text:

Operating Depreciation Revenue Segment Cable Communications and Amortization $7,670 745 125 47 Income $12,439 $50,048 2,964 1,195 Cable Networks Broadcast Television Filmed Entertainment Theme Parks Total 10,464 10,147 6,360 4,946 650 1,678 $18,926 512 $81,965 $9,099