Question

arship 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 $6,529 $5,514 EMEA 1,217 1,295 China/Asia Pacific 2,396 1,130 Channel Development** 1,731 1,546 Other 1,348 1,158 Total $13,221 $10,643 *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.

Answer 1

Horizantal analysis of Segment data :- Increase! (Decrease) Increase (Decrease) Particulars Recent Year (In Millions) 6,529 Americas EMEA 1,217 Previous Year (In Millions) 5,514 1,295 1,130 1,546 1,158 10,643 2,396 1,015 (78) 1,266 185 190 2,578 China/Asia Pacific Channel development Other Total Revenues 18.4% -6.0% 112.0% 12.0% 16.4% 24.2% 1,731 1,348 13,221 Vertical analysis of Segment data :- Recent Year Recent Year Particulars (In Millions) Previous Year % Americas 6,529 1,217 EMEA China/Asia Pacific Channel development Other Total Revenues Previous Year (In Millions) 5,514 1,295 1,130 1,546 1,158 10,643 49.4% 9.2% 18.1% 13.1% 10.2% 100.0% 2,396 1,731 51.8% 12.2% 10.6% 14.5% 10.9% 1,348 13,221 100.0% China/Asia paicific grows more than all others