Rotorua Products Ltd of New Zealand markets agricultural pro

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):

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):

Required . 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 (.e., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales 100.01% Current assets: 100.0 100.0 Cash Inventory Total current assets Current liabilities 110.0 100.0 100.0 110.0

Solution

Answer:Statement showing Asset, Liability and sales data in trend percentages.

Year 1

(A)

Year 2

(B)

Year 3

(C)

Year 4

(D)

Year 5

(E)

Purticulers	Year 1 (A)	%	Year 2 (B)	%	Year 3 (C)	%	Year 4 (D)	%	Year 5 (E)	%
Formula		Base Year		(B/A)*100		(C/A)*100		(D/A)*100		(E/A)*100
Sales	$4,661,330.00	100%	$4,808,170.00	103.2%	$5,095,150.00	109.3%	$5,599,840.00	120.1%	$5,762,760.00	123.6%
Current Assets
1.Cash	$     87,576.00	100%	$     98,854.00	112.9%	$     92,221.00	105.3%	$     83,855.00	95.8%	$     73,510.00	83.9%
2.Accounts receivable	$   412,908.00	100%	$   417,559.00	101.1%	$   451,812.00	109.4%	$   507,226.00	122.8%	$   576,450.00	139.6%
3.Inventory	$   812,152.00	100%	$   880,562.00	108.4%	$   835,457.00	102.9%	$   893,657.00	110.0%	$   912,187.00	112.3%
TOTAL	$1,312,636.00	100%	$1,396,975.00	106.4%	$1,379,490.00	105.1%	$1,484,738.00	113.1%	$1,562,147.00	119.0%
Current Liabilities	$   309,171.00	100%	$   340,038.00	110.0%	$   343,064.00	111.0%	$   329,442.00	106.6%	$   399,116.00	129.1%