Accounting
27th Edition
ISBN: 9781337272094
Author: WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
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 TCF Incorporation, and discuss about the diversified or concentrated within the product segment revenue.
Expert Solution & Answer
Trending nowThis is a popular 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
%
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.
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?
Chapter 5 Solutions
Accounting
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 - When are transactions posted in a computerized...Ch. 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 - Purchases journal The following purchase...Ch. 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 - Segment analysis Back Country Life, Inc., does...Ch. 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 - Prepare journal entries in a revenue journal...Ch. 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 - Prob. 5.11EXCh. 5 - Prob. 5.12EXCh. 5 - Identify transactions in accounts payable...Ch. 5 - Prepare journal entries in a purchases journal...Ch. 5 - Posting a purchases journal The purchases journal...Ch. 5 - Accounts payable subsidiary ledger The cash...Ch. 5 - Purchases and cash payments journals Transactions...Ch. 5 - Purchases and cash payments journals Happy Tails...Ch. 5 - Error in accounts payable subsidiary ledger After...Ch. 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 - Segment revenue horizontal analysis Starbucks...Ch. 5 - Prob. 5.26EXCh. 5 - Segment revenue horizontal and vertical analyses...Ch. 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 - Revenue journal; accounts receivable subsidiary...Ch. 5 - Revenue and cash receipts journals; accounts...Ch. 5 - Purchases, accounts payable account, and accounts...Ch. 5 - Purchases and cash payments journals; accounts...Ch. 5 - All journals and general ledger; trial balance The...Ch. 5 - Ethics in Action Netbooks Inc. provides accounting...Ch. 5 - Communication Internet-based accounting software...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...
Knowledge Booster
Similar questions
- 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.…arrow_forwardVertical analysis Amazon.com, Inc. is the largest Internet retailer in the United States. Amazon’s income statements through income from operations for two recent years are as follows (in millions): Amazon.com, Inc. Operating Income Statements For the Years Ended December 31 (in millions) Year 2 Year 1 Product sales $70,080 $60,903 Service sales 18,908 13,549 Total sales $88,988 $74,452 Cost of sales $62,752 $54,181 Fulfillment 10,766 8,585 Marketing 4,332 3,133 Technology and content 9,275 6,565 General and administrative 1,552 1,129 Other operating expense (income), net 133 114 Total operating expenses $88,810 $73,707 Income from operations $178 $745 Required: a. Prepare a vertical analysis of the two operating income statements. Round percentages to one decimal place.arrow_forwardVertical analysis Amazon.com, Inc. is the largest Internet retailer in the United States. Amazon’s income statements through income from operations for two recent years are as follows (in millions): Amazon.com, Inc. Operating Income Statements For the Years Ended December 31 (in millions) Year 2 Year 1 Product sales $70,080 $60,903 Service sales 18,908 13,549 Total sales $88,988 $74,452 Cost of sales $62,752 $54,181 Fulfillment 10,766 8,585 Marketing 4,332 3,133 Technology and content 9,275 6,565 General and administrative 1,552 1,129 Other operating expense (income), net 133 114 Total operating expenses $88,810 $73,707 Income from operations $178 $745 Required: a. Prepare a vertical analysis of the two operating income statements. Round percentages to one decimal place. Amazon.com, Inc. Operating Income Statements For the Years Ended December 31 (in millions) Year 2 Year 1 Amount Percent Amount Percent Product sales…arrow_forward
- Starship Corporation reported the following geographical segment revenues for a recent and a prior fiscal year: Recent Year(in millions, rounded) Prior Year(in millions, rounded) Americas $10,479 $8,073 EMEA* 1,217 1,295 China/Asia Pacific 2,396 1,130 Channel Development** 1,731 1,546 Other 2,236 1,695 Total $18,059 $13,739 *Europe, Middle East, and Africa **Sells packaged coffee and teas globally a. Prepare a horizontal analysis of the segment data using the prior year as the base year. Round all percents to one decimal place. Enter all amounts in millions. If required, use minus sign to indicate the decreasing values. Starship Corporation Horizontal Analysis Recent Year (in millions) Prior Year (in millions) Increase (Decrease)Amount Increase (Decrease)Percent Americas $10,479 $8,073 $fill in the blank 15396ff9101df9f_1 fill in the blank 15396ff9101df9f_2% EMEA 1,217 1,295 fill in the blank 15396ff9101df9f_3 fill…arrow_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_forwardVertical analysis Amazon.com, Inc.is the largest Internet retailer in the United States. Amazon's income statements through income from operations for two recent years are as follows (in mH!ions): Amazon.com,Inc. Operating Income Statements For the Years Ended December 31 (in millions) Year 2 Year 1 Product sales $70,080 $60,903 Service sales 18,908 13,549 Total sales $88,988 $74,452 Cost of sales $62,752 $54,181 Fulfillment 10,766 8,585 Marketing 4,332 3,133 Technology and content 9,275 6,565 General and administrative 1,552 1,129 Other operating expense (income), net 133 114 Total operating expenses $88,810 $73,707 Income from operations $ 178 $ 745 1.Prepare a vertical analysis of the two operating income statements.Round percentages to one decimal pl 2.Use the vertical analysis to explain the decrease in income from operations.arrow_forward
- Return on Investment, Residual Income for a Service Company H&R Block Inc. provides tax preparation services throughout the United States and other parts of the world. These services are provided through two segments: company-owned offices and franchised operations. Recent financial information provided by H&R Block for its company-owned and franchised operations is as follows (in millions): Company-Owned Franchised Operations Revenues $2,651 $ 335 Income from operations 617 86 Total assets 3,930 586 a. Use the DuPont formula to determine the return on investment for each business divisions. Round whole percents to one decimal place and investment turnover to two decimal places. Division Return on Investment Company-Owned fill in the blank 1% Franchised Operations fill in the blank 2% b. Determine the residual income for each division, assuming a minimum acceptable income of 15% of total assets. Round minimal acceptable return to the…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_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
- Question Content Area Macon Mills is a division of Bolin Products, Inc. During the most recent year, Macon had a net income of $39 million. Included in the income was interest expense of $3,300,000. The company's tax rate was 40%. Total assets were $475 million, current liabilities were $107,000,000, and $70,000,000 of the current liabilities are noninterest bearing. What are the invested capital and ROI for Macon? Enter your answer in whole dollar. Round "ROI" answer to two decimal places. Invested Capital $fill in the blank 1 ROI fill in the blank 2%arrow_forwardThe 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. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $10,596 Home Box Office (pay television) 5,615 Warner Bros. (films, television, and videos) 12,993 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 40% Home Box Office 35% Warner Bros. 25% a. Determine the contribution margin and contribution margin ratio. Enter amounts in millions. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to the nearest whole percent for each segment from the information given. Enter all amounts as positive numbers. Turner Home Box Office Warner Bros. Revenues $ $ $ Variable costs Contribution…arrow_forwardApple Inc.: Segment revenue analysis Segment disclosure by Apple Inc. provides sales information for its major product lines for three recent years as follows (in millions): A. Which product had the greatest percentage of Year 3 sales? Which product had the least percentage of Year 3 sales? (Round to nearest whole percent.) B. Which product grew the most in sales, in percentage terms, using Year 1 as the base year? (Round to nearest whole percent.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub