Custom Bundle: Accounting, Loose-leaf Version, 26th + Working Papers, Chapters 1-17, 26th Edition
26th Edition
ISBN: 9781305714731
Author: Warren/Reeve/Duchac
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 5, Problem 5.26EX
(a)
To determine
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.
Vertical analysis:
Vertical analysis is the method of financial statement analysis, and it is useful for evaluating a 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: The vertical analysis statement of the product segment revenue.
(b)
To determine
To analyze: The product segment of N Corporation, and discuss about the diversified or concentrated within the product segment revenue.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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
%
Analyze Comcast Corporation by segment
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):
Segment
Revenue
OperatingIncome
Depreciationand Amortization
Cable Communications
$50,048
$12,439
$7,670
Cable Networks
10,464
2,964
745
Broadcast Television
10,147
1,195
125
Filmed Entertainment
6,360
650
47
Theme Parks
4,946
1,678
512
Total
$81,965
$18,926
$9,099
a. Prepare a vertical analysis of the segment revenues to total revenues. Round to nearest whole percent. Enter amounts in millions.…
Segment Contribution Margin Analysis
The operating revenues of the three largest business segments for Time Warner, Inc., for a recent year follow. Each segment includes a number of businesses, examples of which are indicated in parentheses.
Chapter 5 Solutions
Custom Bundle: Accounting, Loose-leaf Version, 26th + Working Papers, Chapters 1-17, 26th Edition
Ch. 5 - Why would a company maintain separate accounts...Ch. 5 - What are the major advantages of the use of...Ch. 5 - Prob. 3DQCh. 5 - How many postings to Fees Earned for the month...Ch. 5 - During the current month, the following errors...Ch. 5 - Prob. 6DQCh. 5 - What is an electronic form, and how is it used in...Ch. 5 - Prob. 8DQCh. 5 - What happens to the special journal in a...Ch. 5 - Prob. 10DQ
Ch. 5 - Revenue journal The following revenue transactions...Ch. 5 - Revenue journal The following revenue transactions...Ch. 5 - Accounts receivable subsidiary ledger The debits...Ch. 5 - Accounts receivable subsidiary ledger The debits...Ch. 5 - Prob. 5.3BPECh. 5 - Purchases journal The following purchase...Ch. 5 - Accounts payable subsidiary ledger The debits and...Ch. 5 - Accounts payable subsidiary ledger The debits and...Ch. 5 - Segment analysis McHale Company does business in...Ch. 5 - Prob. 5.5BPECh. 5 - Identify postings from revenue journal Using the...Ch. 5 - Accounts receivable ledger Based on the data...Ch. 5 - Identify journals Assuming the use of a two-column...Ch. 5 - Identify journals Assuming the use of a two-column...Ch. 5 - Identify transactions in accounts receivable...Ch. 5 - Prob. 5.6EXCh. 5 - Posting a revenue journal The revenue journal for...Ch. 5 - Accounts receivable subsidiary ledger The revenue...Ch. 5 - Revenue and cash receipts journals Transactions...Ch. 5 - Revenue and cash receipts journals Lasting Summer...Ch. 5 - Identify postings from purchases journal Using the...Ch. 5 - Identify postings from cash payments journal Using...Ch. 5 - Prob. 5.13EXCh. 5 - Prob. 5.14EXCh. 5 - Prob. 5.15EXCh. 5 - Accounts payable subsidiary ledger The cash...Ch. 5 - Prob. 5.17EXCh. 5 - Prob. 5.18EXCh. 5 - Prob. 5.19EXCh. 5 - Prob. 5.20EXCh. 5 - Cash receipts journal The following cash receipts...Ch. 5 - Computerized accounting systems Most computerized...Ch. 5 - Prob. 5.23EXCh. 5 - Prob. 5.24EXCh. 5 - Prob. 5.25EXCh. 5 - Prob. 5.26EXCh. 5 - Prob. 5.27EXCh. 5 - Revenue journal; accounts receivable subsidiary...Ch. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable subsidiary account,...Ch. 5 - Purchases and cash payments journals; accounts...Ch. 5 - All journals and general ledger; trial balance The...Ch. 5 - Prob. 5.1BPRCh. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable account, and accounts...Ch. 5 - Prob. 5.4BPRCh. 5 - All journals and general ledger; trial balance The...Ch. 5 - Ethics in Action Netbooks Inc. provides accounting...Ch. 5 - Manual vs. computerized accounting systems The...Ch. 5 - Accounts receivable and accounts payable A...Ch. 5 - Design of accounting systems For the past few...Ch. 5 - Communication Internet-based accounting software...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Effect of Industry Characteristics on Financial Statement Relations. 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.22 (pages 6061) 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.) Exhibit 1.22 also shows the ratio of cash flow from operations to capital expenditures. 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 enough for the firm to disclose it. Amounts that are not meaningful are shown as n.m. A list of the 12 companies and a brief description of their activities follow. A. Amazon.com: Operates websites to sell a wide variety of products online. The firm operated at a net loss in all years prior to that reported in Exhibit 1.22. B. Carnival Corporation: Owns and operates cruise ships. C. Cisco Systems: Manufactures and sells computer networking and communications products. D. Citigroup: Offers a wide range of financial services in the commercial banking, insurance, and securities business. Operating expenses represent the compensation of employees. E. eBay: Operates an online trading platform for buyers to purchase and sellers to sell a variety of goods. The firm has grown in part by acquiring other companies to enhance or support its online trading platform. F. Goldman Sachs: Offers brokerage and investment banking services. Operating expenses represent the compensation of employees. G. Johnson Johnson: Develops, manufactures, and sells pharmaceutical products, medical equipment, and branded over-the-counter consumer personal care products. H. Kelloggs: Manufactures and distributes cereal and other food products. The firm acquired other branded food companies in recent years. I. MGM Mirage: Owns and operates hotels, casinos, and golf courses. J. Molson Coors: Manufactures and distributes beer. Molson Coors has made minority ownership investments in other beer manufacturers in recent years. K. Verizon: Maintains a telecommunications network and offers telecommunications services. Operating expenses represent the compensation of employees. Verizon has made minority investments in other cellular and wireless providers. L. Yum! Brands: Operates chains of name-brand restaurants, including Taco Bell, KFC, and Pizza Hut. REQUIRED Use the ratios to match the companies in Exhibit 1.22 with the firms listed above.arrow_forwardEffect of Industry Characteristics on Financial Statement Relations. 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.23 (pages 6263) 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.) Exhibit 1.23 also shows the ratio of cash flow from operations to capital expenditures. 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 and a brief description of their activities follow. A. Abercrombie Fitch: Sells retail apparel primarily through stores to the fashionconscious young adult and has established itself as a trendy, popular player in the specialty retailing apparel industry. B. Allstate Insurance: Sells property and casualty insurance, primarily on buildings and automobiles. Operating revenues include insurance premiums from customers and revenues earned from investments made with cash received from customers before Allstate pays customers claims. Operating expenses include amounts actually paid or expected to be paid in the future on insurance coverage outstanding during the year. C. Best Buy: Operates a chain of retail stores selling consumer electronic and entertainment equipment at competitively low prices. D. E. I. du Pont de Nemours: Manufactures chemical and electronics products. E. Hewlett-Packard: Develops, manufactures, and sells computer hardware. The firm outsources manufacturing of many of its computer components. F. HSBC Finance: Lends money to consumers for periods ranging from several months to several years. Operating expenses include provisions for estimated uncollectible loans (bad debts expense). G. Kelly Services: Provides temporary office services to businesses and other firms. Operating revenues represent amounts billed to customers for temporary help services, and operating expenses include amounts paid to the temporary help employees of Kelly. H. McDonalds: Operates fast-food restaurants worldwide. A large percentage of McDonalds restaurants are owned and operated by franchisees. McDonalds frequently owns the restaurant buildings of franchisees and leases them to franchisees under long-term leases. I. Merck: A leading research-driven pharmaceutical products and services company. Merck discovers, develops, manufactures, and markets a broad range of products to improve human and animal health directly and through its joint ventures. J. Omnicom Group: Creates advertising copy for clients and is the largest marketing services firm in the world. Omnicom purchases advertising time and space from various media and sells it to clients. Operating revenues represent commissions and fees earned by creating advertising copy and selling media time and space. Operating expenses includes employee compensation. K. Pacific Gas Electric: Generates and sells power to customers in the western United States. L. Procter Gamble: Manufactures and markets a broad line of branded consumer products. REQUIRED Use the ratios to match the companies in Exhibit 1.23 with the firms listed above.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_forward
- The Walt Disney Company (DIS) has four business segments, described as follows: Media Networks: Television and radio Parks and Resorts: Resorts, including Disneyland Studio Entertainment: Motion pictures, musical recordings, and stage plays Consumer Products Interactive Media: Character merchandising, Disney stores, books, and games Disney recently reported segment operating income, revenue, and invested assets (in millions) as follows: a. Use the DuPont formula to determine the return on investment for the four Disney segments. Round percentages to one decimal place and investment turnover to two decimal places. b. How do the four segments differ in their profit margin, investment turnover, and return on investment?arrow_forwardVertical analysis Income statement information for Einsworth Corporation follows: Prepare a vertical analysis of the income Statement for Einsworth Corporation.arrow_forwardBEAR BEAR CORP. has the following information on its operating segments. Inter- External Total Segments segment Profit Assets revenues revenues revenues A 2,400,000 1,200,000 3,600,000 1,400,000 24,000,000 800,000 200,000 1,000,000 800,000 14,000,000 500,000 500,000 200,000 2,000,000 D 400,000 400,000 160,000 1,600,000 E 300,000 300,000 140,000 1,400,000 F 200,000 200,000 100,000 1,000,000 Totals 4,600,000 1,400,000 6,000,000 2,800,000 44,000,000 BEAR BEAR shall provide disclosure for major customers if revenues from transactions with a single external customer amount to how much? A. P600,000 C. P440,000 В. P140,000 D. P460,000arrow_forward
- DuPont system of analysis Use the following financial information for AT&T and Verizon to conduct a DuPont system of analysis for each company. AT&T Sales $164,000 Earnings available for common stockholders 13,333 Total assets 403,721 Stockholders' equity 124,210 a. Which company has the higher net profit margin? Higher asset turnover? b. Which company has the higher ROA? The higher ROE? c. Which company has the higher financial leverage multiplier? a. Net profit margin (Round to three decimal places.) AT&T Net profit margin Verizon C Verizon $131,868 13.708 244,180 24,032arrow_forwardDuPont system of analysis Use the following financial information for AT&T and Verizon to conduct a DuPont system of analysis for each company. Sales Earnings available for common stockholders Total assets Stockholders' equity a. Which company has the higher net profit margin? Higher asset turnover? b. Which company has the higher ROA? The higher ROE? c. Which company has the higher financial leverage multiplier? a. Net profit margin (Round to three decimal places.) AT&T Net profit margin AT&T $164,000 13,333 403,921 201,934 Verizon Verizon $126,280 13,608 244,280 24,232arrow_forwardAn entity and its divisions reported the following for the year 20xl: Sales to unaffiliated customers 38,000,000 15,000,000 Intersegment sales of products similar to those sold to unaffiliated customers Interest earned on loans to other operating segments 1,600,000 The entity and all of its divisions are engaged solely in manufacturing operations. To qualify as reportable segment, the segment revenue should at least be what amount?arrow_forward
- Divisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue $1,500,000 1,570,000 1,530,000 Operating expenses 807,000 742000 1,158,000 Invested assets 5,500,000 4600000 3,100,000 The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations. Required: 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges. E.F. Lynch Company Divisional Income Statements For the Year Ended June 30, 20Y8 Mutual Fund Division Electronic Brokerage Division Investment Banking Division Fee revenue…arrow_forward(Segmented Reporting) Carlton Company is involved in four separate industries. The following information is available for each of the four industries. Check the below image for information. InstructionsDetermine which of the operating segments are reportable based on the:(a) Revenue test.(b) Operating profit (loss) test.(c) Identifiable assets test.arrow_forwardvertical analysisarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License