Exercise 14-7 Trend Percentages [LO14-1]

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

	Year 1			Year 2			Year 3			Year 4			Year 5
Sales	$	4,575,510		$	4,730,770		$	5,052,270		$	5,464,880		$	5,750,230
Cash	$	95,598		$	100,473		$	101,383		$	74,814		$	74,218
Accounts receivable, net		413,671			433,198			438,273			503,179			568,646
Inventory		811,674			880,159			817,134			897,447			907,588
Total current assets	$	1,320,943		$	1,413,830		$	1,356,790		$	1,475,440		$	1,550,452
Current liabilities	$	314,950		$	347,937		$	341,318		$	321,700		$	408,279

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		%		%		%		%		%