Accounting (Text Only)
26th Edition
ISBN: 9781285743615
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.25EX
(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 earn from different segments individually, are called segment revenue. Segment revenues are determined from the invoiced data entered in 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 to 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 the each item on a financial statement with a total amount from the same statement.
To prepare: Horizontal analysis of the revenue earned from different geographical segments.
(b)
To determine
To prepare: Vertical analysis of the revenue earned from different geographical segments.
(c)
To determine
To draw: The conclusion from the analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
Segment Analysis
Verity Company does business in two customer segments: Retail and Wholesale. The following annual revenue information was determined from the accounting system's invoice information:
20Y5
20Y4
Retail
$145,400
$138,500
Wholesale
173,100
189,300
Total revenue
$318,500
$327,800
Prepare a horizontal analysis of the segments. Round percentages to one decimal place. Enter negative values as negative numbers.
Verity Company
Horizontal Analysis
For the Years 20Y4 and 20Y5
20Y5
20Y4
Difference - Amount
Difference - Percent
Retail
$145,400
$138,500
$fill in the blank
fill in the blank %
Wholesale
173,100
189,300
fill in the blank
fill in the blank %
Total revenue
$318,500
$327,800
$fill in the blank
fill in the blank %
Prepare a vertical analysis of the segments. If required, round percentages to one decimal place.
Verity Company
Vertical Analysis
For the Years 20Y4 and 20Y5
20Y5 Amount
20Y5 Percent
20Y4…
Payton Company has the following segment revenues for the two most recent fiscal years.
Segment
Current Year (in millions)
Prior Year (in millions)
China
$790
$640
Canada
330
242
Other countries
213
167
Total revenues
$1,333
$1,049
Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. For percentages, do not enter the percent sign.
Payton Company
Vertical Analysis
Segment
Current Year Amount (in millions)
Current Year Percent
Prior Year Amount (in millions)
Prior Year Percent
China
$790
%
$640
%
Canada
330
242
Other countries
213
167
Total revenues
$1333
%
$1049
%
Chapter 5 Solutions
Accounting (Text Only)
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
Similar questions
- Apple 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_forwardLVMH: 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_forwardAnalyze Amazon.com Amazon.com, Inc. (AMZN) is the largest Internet retailer in the United States. Amazons income statements through operating income for two recent years are as follows (in millions): a. Prepare a vertical analysis of the two income statements. Round percentages to one decimal place. b. Use the vertical analysis to explain the increase in operating income.arrow_forward
- Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forwardRevenue per professional staff The accounting firm of Deloitte Touche is the largest international accounting firm in the world as ranked by total revenues. For two recent years, Deloitte Touche reported the following for its U.S. operations: a. For the current and previous years, determine the revenue per professional staff. b. Interpret the trend between the two years.arrow_forwardVertical analysis income statement Revenue expense data for Innovation quarter Inc for two recent years as follows. Sales Cost of goods. Selling expenses Administrative expenses Income tax expense Current year. 4,000,000 2,280,000 600,000 520,000 240,000 Previous year 3,600,000 1,872,000 648,000 360,000 216,000 A. Prepare an income statement in comparative form, stating to each item for both of years as a percent of sales. Round to the nearest whole percentage. Innovation quarter Inc comparative income tax for the years ended December 31st Sales Cost of goods Selling expenses Administrative expenses Income tax expense $ % $ % $ % $ % $ % $ % $ % $ % B. The vertical analysis indicates that the cost of the goods sold as a percent of sales by 5 percentage points, while selling expenses by 3% percentage and administrative expenses by 3% percentage points. Thus net income as…arrow_forward
- Payton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $775.00 $650.00 Canada 325.50 245.50 Other countries 215.50 168.50 Total revenues $1,316.00 $1,064.00 Required: Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place.arrow_forwardSegment analysis McHale company does business in two customer segments, Retail and wholesale. The following annual revenue information was determined from the accounting system's invoice information: prepare horizontal and vertical analyses of the segment. Round to one decimal place.arrow_forwardPayton Company has the following segment revenues for the two most recent years. Segment Current Year (in millions) Prior Year (in millions) United States $820.00 $605.00 Canada 331.00 345.00 Other countries 215.50 173.50 Total revenues $1,366.50 $1,123.50 Required: Prepare a horizontal analysis of the segment data. Negative amount should be indicated by the minus sign. Calculate the percentage to four decimal places, then round your answer to one decimal place.arrow_forward
- 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.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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781337272124Author: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 AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
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
Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning