(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 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 prepare: Vertical analysis of the revenue earned from different geographical segments.
(c)
To draw: The conclusion from the analysis.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Accounting (Text Only)
- 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
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial 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 LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning