Question: 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

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.

Starbucks Corporation
Horizontal Analysis
Recent Year (in millions) Prior Year (in millions) Increase (Decrease) Amount Increase (Decrease) Percent
Americas $8,887 $7,648 $ %
China/Asia Pacific 2,396 1,130
Channel Development 1,731 1,546
EMEA 1,217 1,295
Other 1,924 1,606
Total revenues $16,155 $13,225 $

b. Prepare a vertical analysis of the segment data. Round all percents to one decimal place and round the total percentage to 100 if necessary.

Starbucks Corporation
Vertical Analysis
Recent Year Amount (in millions) Recent Year Percent Prior Year Amount (in millions) Prior Year Percent
Americas $8,887 % $7,648 %
China/Asia Pacific 2,396 1,130
Channel Development 1,731 1,546
EMEA 1,217 1,295
Other 1,924 1,606
Total revenues $16,155 % $13,225 %

Feedback

b. For vertical analysis, use the total revenues and show the percentage in a column for that year.

c. Based on the percentages in the vertical analysis, which of Starbucks's operations grew more?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!