Question

In: Accounting

Prepare a horizontal analysis of the segment data using the prior year as the base year....

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?

Solutions

Expert Solution

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 as a base.
Exercise 9-5 Suppose the comparative balance sheets of Nike, Inc. are presented here. Prepare a horizontal analysis of the balance sheet data for Nike, using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.2%)
Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base....
Prepare a horizontal analysis of the balance sheet data for Nike, using 2019 as a base. (Show the amount of increase or decrease as well.) b. Prepare a vertical analysis of the balance sheet data for Nike for 2020. Prepare horizontal and vertical analyses. E13.6 (LO 2) Here are the comparative income statements of Delaney Corporation. Delaney Corporation Comparative Income Statements For the Years Ended December 31      2020      2019 Net sales      $598,000      $500,000 Cost of goods...
Prepare a horizontal analysis of the income statement data for Delaney Corporation, using 2016 as a base.
*Exercise 9-6 Here are the comparative income statements of Delaney Corporation, DELANEY CORPORATION Comparative Income Statements For the Years Ended December 31 20172016Net sales   $598,000$500,000Cost of goods sold  477,000420,000Gross Profit  121,00080,000Operating expenses  80,00044,000Net income  $ 41,000$36,000   Prepare a horizontal analysis of the income statement data for Delaney Corporation, using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55, 000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.) Prepare a vertical analysis of the income statement...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a...
1 HORIZONTAL ANALYSIS INSTRUCTIONS: Prepare a horizontal analysis of the income statement using 2018 as a base. Neiman Corp. Comparative Balance Sheet For the years ended December 31 2019 2018 Assets Current Assets 360 300 Plant Assets 640 500 Total Assets 1,000 800 Liabilities & Stockholders' Equity Current liabilities 150 120 Long-term debt 240 160 Common stock 350 320 Retained earnings 260 200 Total liabilities & stockholders' equity 1,000 800 2 VERTICAL ANALYSIS INSTRUCTIONS: Prepare a vertical analysis of the...
Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year...
Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year (meaning each line item for 2017 is 100%). Also include a horizontal analysis of sales and net income. Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700 $1,120 $1,544    Plant and equipment (net) 8,110 7,830 5,404    Other assets   1,004    695    772    Total assets $10,814 $9,645 $7,720 Liabilities and Stockholders' Equity:    Current liabilities $   950 $  880 $  772    Long-term liabilities...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) ADAMS COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $16,700 $12,100 % Marketable securities 20,200 7,400 Accounts receivable (net) 54,900 47,600 Inventories 135,200 144,500 Prepaid items 25,000 10,500 Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) BAIRD COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $17,600 $12,200 % Marketable securities 21,000 6,200 Accounts receivable (net) 54,700 46,800 Inventories 136,500 143,300 Prepaid items 26,500 11,800 Total current assets...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis...
Prepare a horizontal analysis of both the balance sheet and income statement. Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) THORNTON COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change Assets Current assets Cash $16,700 $12,200 % Marketable securities 21,300 7,500 Accounts receivable (net) 54,100 46,500 Inventories 136,100 144,600 Prepaid items 26,300 10,400 Total current assets...
Based on the inputs below prepare a capital budget analysis for this Base Case using the...
Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Use your Investment Return Analysis as an example for this capital budget analysis. PLEASE show formulas Project Inputs: WACC – Debt is 70% and Equity is 30%...
Based on the inputs below prepare a capital budget analysis for this Base Case using the...
Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Project Inputs: WACC – Debt is 70% and Equity is 30% of this firm’s capital structure. Interest rate on the debt is 7.5%, firm’s tax rate is...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT