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 over the last five years (Year 5 is the most recent year) are as follows: Year 2 Year 3 Year 1 Year 4 Year 5 $4,634,910 $4,847,620 $5,061,210 $5,401,510 $5,671,890 Sales 79,826 498,337 890,287 Cash S 87,112 93,265 91,658 80,171 562,470 899,415 Accounts receivable, net Inventory 412,382 813,589 417,036 867,990 $1,378,291 437,130 818,924 $1,313,083 $1,347,712 $1,468,450 $1,542,056 Total current assets 301,621 348,251 324,316 394,131 Current liabilities 327,731 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-1)-

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	4634910	100	4847620	104.6	5061210	109.2	5401510	116.5	5671890	122.4
Cash	87112	100	93265	107.1	91658	105.2	79826	91.6	80171	92.0
Accounts Receivable net	412382	100	417036	101.1	437130	106.0	498337	120.8	562470	136.4
Inventory	813589	100	867990	106.7	818924	100.7	890287	109.4	899415	110.5
Total Current Assets	1313083	100	1378291	105.0	1347712	102.6	1468450	111.8	1542056	117.4
Current Liabilities	301621	100	348251	115.5	327731	108.7	324316	107.5	394131	130.7