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 1 year 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...

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...

15. Using the following information from an annual report, prepare a Comparative (horizontal) analysis of the...

15. Using the following information from an annual report, prepare a Comparative (horizontal) analysis of the consolidated statements of earnings. (Round percentage answers to one decimal place.) 3 pts (In millions except per share data) June 30, 2010 June 30, 2009 Net sales $12,862 $11,170 Cost of sales 8,321 8,191 Gross margin $ 4,541 $ 2,979 Operating expenses: Selling expenses General and Administrative expenses $2,043 978 $2,000 955 Total operating expenses $ 3,021 $ 2,955...

Subjects