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
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
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

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Segment Reporting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education