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
Textbook Question
Chapter 5, Problem 5.25EX
Segment revenue horizontal analysis
Starbucks 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 | $13,293 | $11,980 |
EMEA* | 1,217 | 1,295 |
China/Asia Pacific | 2,396 | 1,130 |
Channel Development** | 1,731 | 1,546 |
Other | 526 | 497 |
Total | $19,163 | $16,448 |
*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 whole percents to one decimal place.
- b. Prepare a vertical analysis of the segment data. Round whole percents to one decimal place.
- c. What conclusions can be drawn from your analyses?
Expert Solution & Answer
Trending nowThis is a popular 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…
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
%
Vertical 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…
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
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
- 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_forwardPayton 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 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…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 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_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
- Payton 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_forwardAn entity and its divisions reported the following for the current year: Sales to unaffiliated customers 40,000,000 Intersegment sales of product similar to those sold to unaffiliated customers 12,000,000 Interest earned on loans to other operating segments 1,000,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? A. 5,300,000 B. 4,100,000 C. 5,200,000 D. 4,000,000arrow_forwardVertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $4,000,000 $3,600,000 Cost of goods sold 2,280,000 1,872,000 Selling expenses 600,000 648,000 Administrative expenses 520,000 360,000 Income tax expense 240,000 216,000 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current yearAmount Current yearPercent Previous yearAmount Previous yearPercent Sales $4,000,000 % $3,600,000 % Cost of goods sold (2,280,000) % (1,872,000) % $ % $ % Selling expenses $(600,000) % $(648,000) % Administrative expenses (520,000) % (360,000) % $ % $ % $ % $ % Income tax expense (240,000) % (216,000) % $ % $ % b.…arrow_forward
- Preparing Income Statements by Using Net Sales as the Base: Vertical Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer CompanyIncome StatementsYears of Operation Year 1 Year 2 Year 3 Net sales $1,000,000 $1,100,000 $1,300,000 Less: Cost of goods sold (300,000) (315,000) (369,000) Gross margin $700,000 $785,000 $931,000 Less: Operating expenses (431,000) (488,000) (600,500) Income taxes (111,000) (123,000) (135,800) Net income $158,000 $174,000 $194,700 Required: Prepare common-size income statements by using net sales as the base. (Note: Enter all amounts as positive numbers, except for a net loss. Enter net loss as a negative number, if applicable. Round answers to the nearest whole percentage. Percentages may not calculate down.) Scherer Company Common-Size Income Statements Years of Operation Year 1 Year 1 Year 2 Year 2 Year 3 Year 3 Dollars Percentage Dollars Percentage…arrow_forwardVertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $4,000,000 $3,600,000 Cost of goods sold 2,280,000 1,872,000 Selling expenses 600,000 648,000 Administrative expenses 520,000 360,000 Income tax expense 240,000 216,000 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $4,000,000 fill in the blank f86a69fccf96045_1% $3,600,000 fill in the blank f86a69fccf96045_2% Cost of goods sold 2,280,000 fill in the blank f86a69fccf96045_3% 1,872,000 fill in the blank f86a69fccf96045_4% $fill…arrow_forwardRevenue and expense data for Young Technologies Inc. are as follows: Year 2 Year 1 Sales $500,000 $440,000 Cost of goods sold 325,000 242,000 Selling expense 70,000 79,200 Administrative expenses 75,000 70,400 Income tax expense 10,500 16,400 Required: Question Content Area a. Prepare an income statement in comparative form, stating each item for both years as an amount and as a percent of sales. Round percentage amounts to nearest whole percent. Young Technologies Inc.Comparative Income StatementFor the Years Ended December 31, Year 2 and Year 1 Year 2 Amount Year 2 Percent Year 1 Amount Year 1 Percent $- Select - - Select -% $- Select - - Select -% - Select - - Select -% - Select - - Select -% $- Select - - Select -% $- Select - - Select -% - Select - - Select -% - Select - - Select -% - Select - - Select -% - Select - - Select -% Total expenses $fill in the blank 3bd7f90c1fc4f97_26 fill in…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim 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 Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim 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
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License