Analyze Comcast Corporation by segment Comcast Corporation (CMCSA) is a global media and entertainment company with...

Transcribed Image Text:

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 Cable Communications NBCUniversal Sky Total Revenue Income Operating Depreciation and Amortization $60,051 $17,517 $7,753 28,082 3,991 2,278 18,594 $106,727 (1,080) $20,428 3,034 $13,065 a. Prepare a vertical analysis of the segment revenues to total revenues. Round percentages to 2 decimal places. Enter amounts in millions. Segment Cable Communications NBCUniversal Revenues as a Percent of Revenue Total Revenues % Segment Revenue Total Revenues Cable Communications % NBCUniversal Sky Total 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. EBITDA as a Percent of Segment Revenue Operating Income Depreciation and Amortization EBITDA Cable Communications $60,051 $17,517 NBCUniversal 28,082 3,991 $7,753 2,278 Sky 18,594 (1,080) 3,034 Total $106,727 $20,428 $13,065 d. Which segment provides the greatest EBITDA as a percent of revenue? Revenue % 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 Cable Communications NBCUniversal Sky Total Revenue Income Operating Depreciation and Amortization $60,051 $17,517 $7,753 28,082 3,991 2,278 18,594 $106,727 (1,080) $20,428 3,034 $13,065 a. Prepare a vertical analysis of the segment revenues to total revenues. Round percentages to 2 decimal places. Enter amounts in millions. Segment Cable Communications NBCUniversal Revenues as a Percent of Revenue Total Revenues % Segment Revenue Total Revenues Cable Communications % NBCUniversal Sky Total 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. EBITDA as a Percent of Segment Revenue Operating Income Depreciation and Amortization EBITDA Cable Communications $60,051 $17,517 NBCUniversal 28,082 3,991 $7,753 2,278 Sky 18,594 (1,080) 3,034 Total $106,727 $20,428 $13,065 d. Which segment provides the greatest EBITDA as a percent of revenue? Revenue %

Answer rating: 100% (QA)

a Vertical analysis of segment revenues to total revenues Segment Revenue Total Revenues Percentage ... View the full answer