Question

123 Kids TV operates in five major international segments. Prior Year (in millions) $8,528 Segment United States Canada England Current Year (in millions) $9,132 8,248 4,734 11,700 6,391 4,141 China 13,299 Brazil 5,645 6,391 Total revenues $39,459 $18.750 Prepare a horizontal analysis of the segment data. Round percentages to two decimal places. Do not enter the percent sign. For amount or percentage decreases, enter a minus sign.

Answer 1

123 Kids TV Company
Historical Analysis
Segment	Current Year ( in millions)	Prior Year ( in millions)	Amount Increase (Decrease)( Current year - Prior year)	Percent Increase ( Decrease) ( Net Change/Prior year)
United States	9,132	8,528	(9,132-8,528) = 604	(604/8,528) = 7.08%
Canada	8,248	6,391	8,248-6,391) = 1,857	(1,857/6,391) = 29.06%
England	4,734	4,141	(4,734-4,141) = 593	(593/4,141) = 14.32%
China	11,700	13,299	(11,700-13,299) = -1,599	(-1,599/13,299) = -12.02%
Brazil	5,645	6,391	(5,645-6,391) = -746	(-746/6,391) = -11.67%
Total	$      39,459	$   38,750	$                               709	(709/138,750) = 1.83%

Kindly comment if you need further assistance.

Thanks‼!