Analyze Comcast Corporation by segment Comcast Corporation (CMCSA) is a global media and entertainment company with...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 %
Expert Answer:
Answer rating: 100% (QA)
a Vertical analysis of segment revenues to total revenues Segment Revenue Total Revenues Percentage ... View the full answer
Related Book For
Forensic And Investigative Accounting
ISBN: 9780808056300
10th Edition
Authors: G. Stevenson Smith D. Larry Crumbley, Edmund D. Fenton
Posted Date:
Students also viewed these accounting questions
-
Sandra signed a power of attorney appointing her daughter, Tiffany, as agent for her finances, including her checking account. Sandy's income taxes are due on April 15, 2021 and she owes $2,500.00 in...
-
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...
-
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,...
-
The bookkeeper of Cinnamon Ltd. who is usually responsible for the bank reconciliation is on holiday. Before she left she asked you to do this task for her. On March 31, you are given the bank...
-
The solubility of MnSO4 ( H2O in water at 20oC is 70 g per 100 mL of water.
-
Stock Dividend Effects If a firm has retained earnings of $23 million, a common shares account of $275 million, and additional paid-in capital of $100 million, how would these accounts change in...
-
Sakai Manufacturing purchased land next to its factory to be used as a parking lot. The expenditures incurred by the company were as follows: purchase price, $300,000; brokers fees, $24,000; title...
-
Mr. I. M. Bezzle works in the purchasing department for Big Time Inc. During the 12 years that he has worked there, he has been a trusted employee and has sole responsibility for the companys...
-
Find possible maximum/minimum points for the following function using calculus arguments. f(2) = 4-2(2+ 3)2 Maximum point: x=-2 Maximum point: x=-3 Minimum point: x=-3 Minimum point: x=-2 Question 2...
-
At Peterson State High School, exam results in both Economics and Legal Studies are known to be normally distributed. The mean Economics exam result is 73 marks and the standard deviation is 8 marks....
-
8 AEFG with E 1 4 F 1 2 G 3 6 is drawn on heavy cardboard and then cut out Find the coordinates of the point from which the triangle can be balanced What is the name of this point of concurrency
-
answer please 1. Philip is retiring and wants to sell his company to his junior partners and is using discounted cash flow analysis to value his common shares. Overall, the company has the following...
-
In the context of health, communication, innovations, discuss the significance of early adopters within a community. How can health professionals leverage these key individuals to accelerate the...
-
do the same for the following Requirement 2. If the market interest rate is 8 % when DCU issues its bonds, will the bonds be priced at face value, at a premium, or at a discount? Explain. The 7 %...
-
Sprints stock is currently trading at $36.00 The stock will pay a dividend of $3.40 and dividends are expected to increase by 7.00% thereafter. What is the cost of equity for Sprint based on the...
-
The ability to learn a new skill or task is crucial to the success of employees in the workplace. Conversely, the ability to teach others a new skill or task is equally important, especially for...
-
Read through the Case Study Wil Fence is a large timber and Christmas tree farmer who is attending a project management class in the spring, his off season. When the class topic came to earned value,...
-
After looking at the resources, explain what a spirit image is. Why might looking at a god and/or a human in terms of their spirit be helpful if you want to eliminate some of the divisions between...
-
Continuation of E9-31: Compute payback and ARR with no residual value (Learning Objective 2) Refer to the Deer Valley Expansion Data Set. Assume that the expansion has zero residual value....
-
Continuation of E9-32, E9-33, E9-34: memo (Learning Objective 5)} Use your results from E9-32, E9-33, and E9-34 to write a memo to Deer Valley's Director of Finance Jim Madsen recommending whether...
-
Calculate NPV with and without residual value (Learning Objective 4) Refer to the Deer Valley Expansion Data Set. 1. What is the project's NPV? Is the investment attractive? Why or why not? 2. Assume...
Study smarter with the SolutionInn App