Question

08). Starbucks Corporation reported the following geographical segment revenues for a recent ter 5 Accounting Systems 5-25 revenue horizontal analysis and a prior fiscal year: Prior Year Recent Year (in millions, rounded) (in millions, rounded) $16,732 $15,620 Americas 3,240 4,474 China/Asia Pacific 2.257 Channel Development 2,297 959 EMEA 1,048 311 Other 168 Total $24,719 $22,387 *Sells packaged coffee and teas globally **Europe, Middle East and Africa a. Prepare a horizontal analysis of the segment data using the prior year as the base Round whole percents to one decimal place. b. Prepare a vertical analysis of the segment data. Round whole percents to one decimal place. c. What conclusions can be drawn from your analyses? year. EX 5-26 Segment revenue vertical analysis OBJ.5 Twenty-First Century Fox, Inc. is one of the world's largest entertainment companies that includes Twentieth Century Fox films, Fox Broadcasting, Fox News, the FX, and various satellite properties. The company provided revenue disclosures by its major product segments in the notes to its financial statements as follows: Major Product Segments Cable Network Programming Television Filmed Entertainment Total revenues of major segments For a Recent Year (in millions) $17.946 5,162 8,747 $31,855 a. Provide a vertical analysis of the product segment revenue. Round whole percents to one decimal place. b. Are the revenues of Twenty-First Century Fox, Inc. diversified or concentrated within a product segment? Explain. EX 5-27 Segment revenue horizontal and vertical analyses OBJ.5 Tha omani rouronner for Yuml Brands

Answer 1

Answer to the above Question is given below:

DATE SOLUTION :- (EX 5-25) (a) HORIZONTAL ANALYSIS of STARBUCKS CORPORATION :- AMOUNTS IN DOLLAR ($) PARTICULARS RECENT YEAR PRIOR YEAR INCREASE /(DECREASE) IN MILLIONS) (IN MILLIONS) AMOUNT PER CENT Americas 16,732 15,620 1,112 7017 china / Asia Pacific 4,474 3,240 1,234 384 Channel Development 2,297 2.257 yo 1,87 EMEA 1,048 959 89 9.3% athen (45.9%) 168 311 (143) TOTAL 24,719 22.387 2,332 10.4% Increase / (Decrease) iu Amount = Amount in Recent year Amount in perion year Increase I (Decrease) in percent 100 Increase I (Decuase) in Amount Amount in Priou year X

DATE OF STARBUCKS (b) VERTICAL ANALYSIS CORPORATION :- CAMOUNTS IN $) PARTICULARS RECENT YEAR PRIOR YEAR AMOUNT PERCENT AMOUNT PERCENT Americas . 16.732 67.7% 15,620 69.8% china I Asia Pacific 4,474 18.1% 3,240 14.5% 9.3% 2.257 10.1% channel Development 2,297 EMEA 1,048 4.2% 959 u 3% other 168 0.77 311 1.3% TOTAL 24,719 100% 22.387 100% working Note :- calculation of Percentage Recent year Puciou year Americas 16,732 15,620 100 24,719 22,387 267.7% z 69.8 100 100 china I Asia Pacific X 100 4,UFU Х 24,719 18.1% 3,240 22.387 14.5% z Z Same 6 fou channel development and athen. EMEA 2

DATE (c) © CONCLUSIONS- о 2 Tike chorizontal analysis indicates that the total revenues of star licks increased dy ШОУ 10. ( 10. Ч% ) и сил the priau фаи йсан to the recent year. Фишь чаѕеd increased dry, 38% 138.08%) шл China I Asia Pacific Venus 7. 12. им Americas. The vertical analysis indicates that the ipercent of Americ as revenues to total 005 ощaked (чи 64.8 7. Ши the ipuciau year to 67.7% in the recent Чеси . In this same period, the percentage ob ha / Asia' Расціс шиш to tatal revenues increased Чи ми 14. 5. м фіц Ясау tо 18. 1. in the decent чаи. Both analysis indicate that star tricks Саралаtаѕ а мали и сила / Asia Російс «ми as Copad to « Americas during the two year period.