A.
Segment Analysis
Business can be classified by regions, products or services, types of customers and more; each classification is treated as one segment of the business. Revenues earned from different segments individually are called segment revenue. Segment revenues are determined from the invoiced data entered into the accounting system. Segment analysis is done to analyze the contribution of different segments to the total operating performance of the company. It is done with the help of horizontal and vertical comparisons.
Horizontal Analysis
This analysis is done to show the trend of various components in financial statements over a period of time. The earliest period is used as the base period and components of financial statements of later periods are compared with the components of the base period.
Vertical analysis
Vertical analysis is the method of financial statement analysis, and it is useful for evaluating company’s performance and financial condition. Vertical analysis is helpful for analyzing the changes in the financial statements over the time, and comparing each item on a financial statement with a total amount from the same statement.
To prepare: A vertical analysis of the sales as a percent of total sales for the five segments.
B.
To interpret: The vertical analysis of five segment of Company WD.
C.
To prepare: A horizontal analysis of the sales as a percent of total sales for the five segments.
D.
To interpret: The horizontal segment sales analysis.
Trending nowThis is a popular solution!
Chapter 20 Solutions
Financial and Managerial Accounting - With CengageNow
- Segment Revenue Vertical Analysis Newton Corporation is one of the world's largest entertainment companies that includes Gravity films, Apple Broadcasting, Gravity News, the GR, and various satellite properties. The company provided revenue disclosures by its major product segments in the notes to its financial statements as follows: a. Using the revenue disclosures by major product segment listed below, provide a vertical analysis of the product segment revenues. Round all percents to one decimal place. For a Recent Year Major Product Segments (in millions) Percent (%) Cable Network Programming $23,925 Television 8,338 Filmed Entertainment 5,154 Direct Broadcast Satellite Television 4,483 Total revenues of major segments $41,900 %arrow_forwardhe following information pertains to Sheffield Corp. and its divisions for the year ended December 31, 2021. Sales to unaffiliated customers $3960000 Intersegment sales of products similar to those sold to unaffiliated customers 910000 Interest earned on loans to other operating segments 60000 Sheffield and all of its divisions are engaged solely in manufacturing operations. Sheffield has a reportable segment if that segment's revenue exceeds $487000. $402000. $396000. $493000.arrow_forwardReturn on investment Commodore Entertainment has four profitable business segments, described as follows: • Media Networks: Television and radio • Parks and Resorts: Resorts, including Commodore land • Studio Entertainment: Motion pictures, musical recordings, and stage plays • Consumer Products: Character merchandising, Commodore stores, books, and magazines Commodore Entertainment recently reported sector income from operations, revenue, and invested assets as follows: Media Networks Parks and Resorts Studio Entertainment Consumer Products Income from Invested Operations Revenue Assets $151,434 $676,800 $846,000 61,824 331,200 552,000 9,025 98,518 332,500 408,600 475,000 227,000 a. Use the DuPont formula to determine the return on investment for the four Commodore Entertainment sectors. Round Profit Margin and ROI to one decimal place and Investment Turnover to two decimal places. Media Networks Parks and Resorts Studio Entertainment Consumer Products Profit Margin Investment…arrow_forward
- Return on investment Commodore Entertainment has four profitable business segments, described as follows: • Media Networks: Television and radio• Parks and Resorts: Resorts, including Commodore land• Studio Entertainment: Motion pictures, musical recordings, and stage plays• Consumer Products: Character merchandising, Commodore stores, books, and magazines Commodore Entertainment recently reported sector income from operations, revenue, and invested assets as follows: Income from Operations Revenue Invested Assets Media Networks $193,644 $586,800 $978,000 Parks and Resorts 63,954 392,700 561,000 Studio Entertainment 12,927 333,600 417,000 Consumer Products 118,233 469,800 261,000 a. Use the DuPont formula to determine the return on investment for the four Commodore Entertainment sectors. Round Profit Margin and ROI to one decimal place and Investment Turnover to two decimal places. Profit Margin Investment Turnover ROI…arrow_forwardSegment Analysis for a Service Company Charles Schwab Corporation is one of the more innovative brokerage and financial service companies in the United States. The company recently provided information about its major business segments as follows (in millions): Investor Advisor Services Services Revenues $7,321 $2,811 Income from operations 3,176 1,386 Depreciation 186 120 a. The ____ segment serves the retail customer, you and me. These include brokerage, Internet, and mutual fund services. The ____ segment includes the same services provided for financial institutions, such as banks, mutual fund managers, insurance companies, and pension plan administrators. b. Indicate whether the following costs are a “Variable Cost” or a “Fixed Cost” in the “Investor Services“. 1. Commissions to brokers _____2. Fees paid to exchanges for executing trades_____ 3. Depreciation on brokerage offices _______4. Transaction fees incurred by Schwab mutual funds to…arrow_forwardReturn on investment Commodore Entertainment has four profitable business segments, described as follows: • Media Networks: Television and radio• Parks and Resorts: Resorts, including Commodore land• Studio Entertainment: Motion pictures, musical recordings, and stage plays• Consumer Products: Character merchandising, Commodore stores, books, and magazines Commodore Entertainment recently reported sector income from operations, revenue, and invested assets as follows: Income from Operations Revenue Invested Assets Media Networks $163,582 $735,200 $919,000 Parks and Resorts 73,625 353,400 589,000 Studio Entertainment 16,668 324,100 463,000 Consumer Products 80,164 352,800 196,000 a. Use the DuPont formula to determine the return on investment for the four Commodore Entertainment sectors. Round Profit Margin and ROI to one decimal place and Investment Turnover to two decimal places. Profit Margin Investment Turnover ROI…arrow_forward
- Twenty-First Century Fox, Inc. is one of the world's largest entertainment companies that includes Twentieth Century Fox films, Fox Broadcasting, Fox News, the FX, and various satellite properties. The company provided revenue disclosures by its major product segments in the notes to its financial statements as follows: For a Recent Year Major Product Segments (in millions) Cable Network Programming $13,773 Television 4,895 Filmed Entertainment 9,525 Direct Broadcast Satellite Television 2,112 Total revenues of major segments $30,305 a. Provide a vertical analysis of the product segment revenue. Round whole percents to one decimal place. b. Are the revenues of Twenty-First Century Fox, Inc. diversified or concentrated within a product segment? Explain.arrow_forwardEffect of Industry Characteristics on Financial Statement Relations: A Global Perspective. Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these economic characteristics. Exhibit 1.24 (pages 6667) presents common-size condensed balance sheets and income statements for 12 firms in different industries. These common-size balance sheets and income statements express various items as a percentage of operating revenues. (That is, the statement divides all amounts by operating revenues for the year.) A dash for a particular financial statement item does not necessarily mean the amount is zero. It merely indicates that the amount is not sufficiently large for the firm to disclose it. A list of the 12 companies, the country of their headquarters, and a brief description of their activities follow. A. Accor (France): Worlds largest hotel group, operating hotels under the names of Sofitel, Novotel, Motel 6, and others. Accor has grown in recent years by acquiring established hotel chains. B. Carrefour (France): Operates grocery supermarkets and hypermarkets in Europe, Latin America, and Asia. C. Deutsche Telekom (Germany): Europes largest provider of wired and wireless telecommunication services. The telecommunications industry has experienced increased deregulation in recent years. D. E.ON AG (Germany): One of the major public utility companies in Europe and the worlds largest privately owned energy service provider. E. Fortis (Netherlands): Offers insurance and banking services. Operating revenues include insurance premiums received, investment income, and interest revenue on loans. Operating expenses include amounts actually paid or amounts it expects to pay in the future on insurance coverage outstanding during the year. F. Interpublic Group (U.S.): Creates advertising copy for clients. Interpublic purchases advertising time and space from various media and sells it to clients. Operating revenues represent the commissions or fees earned for creating advertising copy and selling media time and space. Operating expenses include employee compensation. G. Marks Spencer (U.K.): Operates department stores in England and other retail stores in Europe and the United States. Offers its own credit card for customers purchases. H. Nestl (Switzerland): Worlds largest food processor, offering prepared foods, coffees, milk-based products, and mineral waters. I. Roche Holding (Switzerland): Creates, manufactures, and distributes a wide variety of prescription drugs. J. Sumitomo Metal (Japan): Manufacturer and seller of steel sheets and plates and other construction materials. K. Sun Microsystems (U.S.): Designs, manufactures, and sells workstations and servers used to maintain integrated computer networks. Sun outsources the manufacture of many of its computer components. L. Toyota Motor (Japan): Manufactures automobiles and offers financing services to its customers. REQUIRED Use the ratios to match the companies in Exhibit 1.24 with the firms listed above.arrow_forwardEffect of Industry Economics on Balance Sheets. Access the investor relations or corporate information section of the websites of American Airlines (www.aa.com), Intel (www.intel.com), and Disney (http://disney.com). Study the business strategies of each firm. Examine the financial ratios below and indicate which firm is likely to be American Airlines, Intel, and Disney. Explain your reasoning.arrow_forward
- Analyze Yum! Brands by segment Yum! Brands, Inc. (YUM) is a worldwide operator and franchisor of fast-food restaurants, under the familiar brands of KFC, Pizza Hut, and Taco Bell. Segment revenues, operating income, and depreciation and amortization expense for Yum!'s operating segments are provided for a recent year as follows (in millions): Depreciation and Sales Operating Income Segment Amortization Expense $3,232 $874 $173 KFC Pizza Hut 1,111 370 36 Taco Bell 2,025 593 91 a. Prepare a vertical analysis of the sales as a percent of total sales for the three segments. Round percentages to the nearest whole percent. Segment Percentage of Total Revenue КFC Pizza Hut Taco Bell $ Total Which segment has the greatest percentage of total sales?arrow_forwardThree major transportation segments and a major company within each segment are as follows: Segment Company Railroads Company R, Inc. (CORI) Motor carriers Company M, Inc. (COMI) Transportation Arrangement Company T, Inc. (COTI) Company R Company M Company T Sales $5,070,961 $3,748,940 $3,487,549 Average long-term operating assets 1,370,530 720,950 591,110 a. Determine the asset turnover for all three companies. Round to one decimal place. Company R fill in the blank 1 Company M fill in the blank 2 Company T fill in the blank 3 Do not give solution in imagearrow_forwardSegment analysis for a service company Charles Schwab Corporation (SCHW) is one of the more innovative brokerage and financial service companies in the United States. The company recently provided information about its major business segments as follows (in millions): InvestorServices AdvisorServices Revenues $5,411 $2,067 Operating income 2,031 962 Depreciation 180 54 a. The Investor Services segment serves the retail customer, you and me. These are the brokerage, Internet, and mutual fund services used by individual Investors. The Advisor Services segment includes the same services provided for financial institutions, such as banks, mutual fund managers, insurance companies, and pension plan administrators. b. Indicate whether the following costs are a “Variable Cost” or a “Fixed Cost” in the “Investor Services” segment. 1. Commissions to brokers Variable Cost 2. Fees paid to exchanges for executing trades Variable Cost 3. Depreciation on brokerage…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage