Question

Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year):

	Year 1			Year 2			Year 3			Year 4			Year 5
Sales	$	4,544,470		$	4,831,880		$	5,034,840		$	5,499,960		$	5,699,730
Cash	$	96,652		$	93,504		$	84,735		$	83,859		$	69,168
Accounts receivable, net		417,039			417,133			432,723			502,678			568,052
Inventory		803,701			870,681			824,172			884,514			906,231
Total current assets	$	1,317,392		$	1,381,318		$	1,341,630		$	1,471,051		$	1,543,451
Current liabilities	$	316,879		$	342,224		$	324,554		$	337,969		$	402,907

Required:
1.	Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)

	Year 1		Year 2		Year 3		Year 4		Year 5
Sales		%		%		%		%		%
Current assets:
Cash
Accounts receivable
Inventory
Total current assets
Current liabilities

Answer 1

Answer-

ROTORUA PRODUCTS LTD.
TREND ANALSIS
PARTICULARS	YEAR 1 (a)	%	YEAR 2 (b)	%	YEAR 3 (d)	%	YEAR 4 (f)	%	YEAR 5 (h)	%
	$		$	(c=b/a)*100	$	(e=d/a)*100	$	(g=f/a)*100	$	(i=h/a)*100
Sales	4544470	100	4831880	106.3	5034840	110.8	5499960	121.0	5699730	125.4
Cash	96552	100	93504	96.8	84735	87.8	83859	86.9	69168	71.6
Accounts Receivable net	417039	100	417133	100.0	432723	103.8	502678	120.5	568052	136.2
Inventory	803701	100	870681	108.3	824172	102.5	884514	110.1	906231	112.8
Total Current Assets	1317292	100	1381318	104.9	1341630	101.8	1471051	111.7	1543451	117.2
Current Liabilities	316879	100	342224	108.0	324554	102.4	337969	106.7	402907	127.1