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 in the blank 15396ff9101df9f_4 China/Asia Pacific 2,396 1,130 fill in the blank 15396ff9101df9f_5 fill in the blank 15396ff9101df9f_6 Channel Development 1,731 1,546 fill in the blank 15396ff9101df9f_7 fill in the blank 15396ff9101df9f_8 Other 2,236 1,695 fill in the blank 15396ff9101df9f_9 fill in the blank 15396ff9101df9f_10 Total revenues $18,059 $13,739 $fill in the blank 15396ff9101df9f_11 fill in the blank 15396ff9101df9f_12 Feedback a. The prior year is the base year for horizontal analysis. Be sure to round to one decimal place. 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. Starship Corporation Vertical Analysis Recent Year Amount (in millions) Recent Year Percent Prior Year Amount (in millions) Prior Year Percent Americas $10,479 fill in the blank 15b5ca0ab01105e_1% $8,073 fill in the blank 15b5ca0ab01105e_2% EMEA 1,217 fill in the blank 15b5ca0ab01105e_3 1,295 fill in the blank 15b5ca0ab01105e_4 China/Asia Pacific 2,396 fill in the blank 15b5ca0ab01105e_5 1,130 fill in the blank 15b5ca0ab01105e_6 Channel Development 1,731 fill in the blank 15b5ca0ab01105e_7 1,546 fill in the blank 15b5ca0ab01105e_8 Other 2,236 fill in the blank 15b5ca0ab01105e_9 1,695 fill in the blank 15b5ca0ab01105e_10 Total revenues $18,059 fill in the blank 15b5ca0ab01105e_11% $13,739 fill in the blank 15b5ca0ab01105e_12%

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 in the blank 15396ff9101df9f_4 China/Asia Pacific 2,396 1,130 fill in the blank 15396ff9101df9f_5 fill in the blank 15396ff9101df9f_6 Channel Development 1,731 1,546 fill in the blank 15396ff9101df9f_7 fill in the blank 15396ff9101df9f_8 Other 2,236 1,695 fill in the blank 15396ff9101df9f_9 fill in the blank 15396ff9101df9f_10 Total revenues $18,059 $13,739 $fill in the blank 15396ff9101df9f_11 fill in the blank 15396ff9101df9f_12 Feedback a. The prior year is the base year for horizontal analysis. Be sure to round to one decimal place. 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. Starship Corporation Vertical Analysis Recent Year Amount (in millions) Recent Year Percent Prior Year Amount (in millions) Prior Year Percent Americas $10,479 fill in the blank 15b5ca0ab01105e_1% $8,073 fill in the blank 15b5ca0ab01105e_2% EMEA 1,217 fill in the blank 15b5ca0ab01105e_3 1,295 fill in the blank 15b5ca0ab01105e_4 China/Asia Pacific 2,396 fill in the blank 15b5ca0ab01105e_5 1,130 fill in the blank 15b5ca0ab01105e_6 Channel Development 1,731 fill in the blank 15b5ca0ab01105e_7 1,546 fill in the blank 15b5ca0ab01105e_8 Other 2,236 fill in the blank 15b5ca0ab01105e_9 1,695 fill in the blank 15b5ca0ab01105e_10 Total revenues $18,059 fill in the blank 15b5ca0ab01105e_11% $13,739 fill in the blank 15b5ca0ab01105e_12%

Financial Accounting

14th Edition

ISBN:9781305088436

Author:Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:Carl Warren, Jim Reeve, Jonathan Duchac

Chapter5: Accounting Systems

Section: Chapter Questions

Problem 27E

See similar textbooks

Related questions

Question

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 in the blank 15396ff9101df9f_4
China/Asia Pacific	2,396	1,130	fill in the blank 15396ff9101df9f_5	fill in the blank 15396ff9101df9f_6
Channel Development	1,731	1,546	fill in the blank 15396ff9101df9f_7	fill in the blank 15396ff9101df9f_8
Other	2,236	1,695	fill in the blank 15396ff9101df9f_9	fill in the blank 15396ff9101df9f_10
Total revenues	$18,059	$13,739	$fill in the blank 15396ff9101df9f_11	fill in the blank 15396ff9101df9f_12

Feedback

a. The prior year is the base year for horizontal analysis. Be sure to round to one decimal place.

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.


Starship Corporation
Vertical Analysis
	Recent Year Amount (in millions)	Recent Year Percent	Prior Year Amount (in millions)	Prior Year Percent
Americas	$10,479	fill in the blank 15b5ca0ab01105e_1%	$8,073	fill in the blank 15b5ca0ab01105e_2%
EMEA	1,217	fill in the blank 15b5ca0ab01105e_3	1,295	fill in the blank 15b5ca0ab01105e_4
China/Asia Pacific	2,396	fill in the blank 15b5ca0ab01105e_5	1,130	fill in the blank 15b5ca0ab01105e_6
Channel Development	1,731	fill in the blank 15b5ca0ab01105e_7	1,546	fill in the blank 15b5ca0ab01105e_8
Other	2,236	fill in the blank 15b5ca0ab01105e_9	1,695	fill in the blank 15b5ca0ab01105e_10
Total revenues	$18,059	fill in the blank 15b5ca0ab01105e_11%	$13,739	fill in the blank 15b5ca0ab01105e_12%

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

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.