Starbucks Corporation reported the following geographical segment revenues for a recentand a prior fiscal year:Recent YearPrior Year(in millions, rounded)(in millions, rounded)Americas$13,293$11,980EMEA*1,2171,295China/Asia Pacific2,3961,130Channel Development**1,7311,546Other526497$19,163$16448Total*Europe, Middle East, and Africa**Sells packaged coffee and teas globallya. 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 decimalplace.c. What conclusions can be drawn from your analyses?

Horizontal analysis of segment revenue uses one year as the base year and then the change in…

Answered: Starbucks Corporation reported the…

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter5: Accounting Systems

Section: Chapter Questions

Problem 25E

See similar textbooks

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 $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.
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 %
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.
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year): image $NZ stands for New Zealand dollars. Required: Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year I as the base year and carry computations to one decimal place. Comment on the results of your analysis.
The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): 2017 (in millions) Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments Outside sales $7,332 $3,956 $8,651 $4,767 $10,524 Intersegment sales 42 73 1,986 409 81 Total sales $7,374 $4,029 $10,637 $5,176 $10,605 2016 (in millions) Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments Outside sales $7,014 $3,746 $6,437 $4,788 $19,751 Intersegment sales 264 73 3,773 506 134 Total sales $7,278 $3,819 $10,210 $5,294 $19,885 For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Round your answers to one decimal place. Intersegment Sales as a % of Total Sales Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments 2017 ? ? ? ? ?…
The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): 2017 (in millions) Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments Outside sales $7,332 $3,956 $8,651 $4,767 $10,524 Intersegment sales 42 73 1,986 409 81 Total sales $7,374 $4,029 $10,637 $5,176 $10,605 2016 (in millions) Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments Outside sales $7,014 $3,746 $6,437 $4,788 $19,751 Intersegment sales 264 73 3,773 506 134 Total sales $7,278 $3,819 $10,210 $5,294 $19,885 For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Round your answers to one decimal place. Intersegment Sales as a % of Total Sales Europe,Middle East,Africa LatinAmerica NorthAmerica AsiaPacific BottleInvestments 2017 fill in…
Compare Income Statements and Balance Sheets of Competitorsa. Following are selected income statement data from two European grocery chain companies: Tesco PLC (UK) and Ahold (the Netherlands). Prepare a common‑size income statement. To do this, express each income statement amount as a percent of sales.Note: Round percentage to one decimal point (for example, round 18.566% to 18.6%). Income Statements Tesco Carrefour Group For Fiscal Year Ended February 24, 2019 December 31, 2018 (£ millions) (€ millions) Sales £57,520 Answer €70,125 Answer Cost of goods sold 53,790 Answer 54,765 Answer Gross profit 3,730 Answer 15,360 Answer Total expenses 2,542 Answer 15,670 Answer Net income £1,188 Answer €(310) Answer b. Following are selected balance sheet data from two European grocery chain companies: Tesco PLC (UK) and Ahold (the Netherlands). Prepare a common‑size balance sheet. To do this, express each…
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumermarket. The company’s current assets, current liabilities, and sales have been reported as follows over thelast five years (Year 5 is the most recent year):Year 5 Year 4 Year 3 Year 2 Year 1Sales ...................................... $NZ2,250,000 $NZ2,160,000 $NZ2,070,000 $NZ1,980,000 $NZ1,800,000Cash ...................................... $NZ 30,000 $NZ 40,000 $NZ 48,000 $NZ 65,000 $NZ 50,000Accounts receivable, net ....... 570,000 510,000 405,000 345,000 300,000Inventory ................................ 750,000 720,000 690,000 660,000 600,000Total current assets ............... $NZ1,350,000 $NZ1,270,000 $NZ1,143,000 $NZ1,070,000 $NZ 950,000Current liabilities .................... $NZ 640,000 $NZ 580,000 $NZ 520,000 $NZ 440,000 $NZ 400,000$NZ stands for New Zealand dollars.Required:1. Express all of the asset, liability, and sales data in trend percentages. (Show percentages for…
Selected data from the year-end financial statements of World Cup Corp. are presented below. The difference between average and ending inventories is immaterial Current ratio 2.0 Quick ratio 1.5 Current liabilities P600,000 Inventory turnover (based on cost of sales) 8 times Gross profit margin 40% World Cup’s net sales for the year were: a. P2.4 million b. P4.0 million c. P1.2 million d. P6.0 million
Revenue 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.
Effect of Industry Characteristics on Financial Statement Relations: A Global Perspective. Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these economic characteristics. Exhibit 1.24 (pages 6667) presents common-size condensed balance sheets and income statements for 12 firms in different industries. These common-size balance sheets and income statements express various items as a percentage of operating revenues. (That is, the statement divides all amounts by operating revenues for the year.) A dash for a particular financial statement item does not necessarily mean the amount is zero. It merely indicates that the amount is not sufficiently large for the firm to disclose it. A list of the 12 companies, the country of their headquarters, and a brief description of their activities follow. A. Accor (France): Worlds largest hotel group, operating hotels under the names of Sofitel, Novotel, Motel 6, and others. Accor has grown in recent years by acquiring established hotel chains. B. Carrefour (France): Operates grocery supermarkets and hypermarkets in Europe, Latin America, and Asia. C. Deutsche Telekom (Germany): Europes largest provider of wired and wireless telecommunication services. The telecommunications industry has experienced increased deregulation in recent years. D. E.ON AG (Germany): One of the major public utility companies in Europe and the worlds largest privately owned energy service provider. E. Fortis (Netherlands): Offers insurance and banking services. Operating revenues include insurance premiums received, investment income, and interest revenue on loans. Operating expenses include amounts actually paid or amounts it expects to pay in the future on insurance coverage outstanding during the year. F. Interpublic Group (U.S.): Creates advertising copy for clients. Interpublic purchases advertising time and space from various media and sells it to clients. Operating revenues represent the commissions or fees earned for creating advertising copy and selling media time and space. Operating expenses include employee compensation. G. Marks Spencer (U.K.): Operates department stores in England and other retail stores in Europe and the United States. Offers its own credit card for customers purchases. H. Nestl (Switzerland): Worlds largest food processor, offering prepared foods, coffees, milk-based products, and mineral waters. I. Roche Holding (Switzerland): Creates, manufactures, and distributes a wide variety of prescription drugs. J. Sumitomo Metal (Japan): Manufacturer and seller of steel sheets and plates and other construction materials. K. Sun Microsystems (U.S.): Designs, manufactures, and sells workstations and servers used to maintain integrated computer networks. Sun outsources the manufacture of many of its computer components. L. Toyota Motor (Japan): Manufactures automobiles and offers financing services to its customers. REQUIRED Use the ratios to match the companies in Exhibit 1.24 with the firms listed above.

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

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,

Financial Accounting

Accounting

ISBN:

9781337272124

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

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

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS