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
Vertical 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.
Vertical 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.
Vertical 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…
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
- LVMH: Group segment sales and EBITDA analysis LVMH Group is a French domiciled company known for Dior, Givenchy, Louis Vuitton, and many other fashion brands. LVMH's operating segment revenues, operating income, and depreciation and amortization expenses for a recent year are as follows (in millions of euros): A. Prepare a vertical analysis of the segment sales to total sales. (Round to nearest whole percent.) B. Interpret the vertical analysis in (A). C. Compute (1) EBITDA and (2) EBITDA as a percent of sales (EBITDA margin) for each segment. (Round to nearest whole percent.) D. Prepare a column bar chart of the EBITDA as a percent of sales for the segments in descending order. E. Interpret the chart in (D).arrow_forwardQuestion 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_forwardAnalyze 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_forward
- 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. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $95,600 Home Box Office (pay television) 33,700 Warner Bros. (films, television, and videos) 80,500 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 38% Home Box Office 35% Warner Bros. 50% a Determine the contribution margin and contribution margin ratio for each segment from the information given. Round contribution margin ratio to whole percents for each segment from the information given. Enter all amounts as positive numbers. Turner Home Box Office Warner Bros. Revenues $ $ $ Variable costs Contribution margin $ $ $ Contribution margin ratio (as a percent) % % % b.…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_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) $90,600 Home Box Office (pay television) 74,100 Warner Bros. (films, television, and videos) 13,300 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 27% Home Box Office 42% Warner Bros. 38% a. Determine the contribution margin and contribution margin ratio for each segment from the information given. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to whole percents for each segment from the information given. Turner Home Box Office Warner Bros. Revenues $ $ $ Variable costs Contribution margin $ $ $…arrow_forward
- 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. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $62,900 Home Box Office (pay television) 65,900 Warner Bros. (films, television, and videos) 72,100 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 18% Home Box Office 32% Warner Bros. 52% a. Determine the contribution margin and contribution margin ratio for each segment from the information given. Round contribution margin ratio to whole percents for each segment from the information given. Enter all amounts as positive numbers. Turner Home Box Office Warner Bros. Revenues $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Variable costs fill in the blank…arrow_forwardSegment 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. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $40,300 Home Box Office (pay television) 90,600 Warner Bros. (films, television, and videos) 91,800 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 19% Home Box Office 18% Warner Bros. 50% a. Determine the contribution margin and contribution margin ratio for each segment from the information given. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to whole percents for each segment from the information given. Turner Home Box Office Warner Bros. Revenues $fill in the blank 1 $fill in the blank 2 $fill…arrow_forwardSegment 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. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $23,800 Home Box Office (pay television) 12,200 Warner Bros. (films, television, and videos) 21,300 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 42% Home Box Office 47% Warner Bros. 30% a. Determine the contribution margin and contribution margin ratio for each segment from the information given. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to whole percents for each segment from the information given.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 $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_forwardSegment 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. Time Warner, Inc.Segment Revenues(in millions) Turner (cable networks and digital media) $74,400 Home Box Office (pay television) 82,700 Warner Bros. (films, television, and videos) 16,600 Assume that the variable costs as a percent of sales for each segment are as follows: Turner 36% Home Box Office 53% Warner Bros. 24% a. Determine the contribution margin and contribution margin ratio for each segment from the information given. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to whole percents for each segment from the information given. Turner Home Box Office Warner Bros. Revenues $fill in the blank 1 $fill in the blank 2 $fill…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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
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
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
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