Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...

Transcribed Image Text:

Rotorua Products, Limited, 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: Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 $ 4,601,440 $ 98,218 407,459 800,265 $ 1,305,942 $308,501 Year 2 $ 4,876,740 $91,026 419,185 866,457 $1,376,668 $ 337,069 Year 3 $ 5,017,900 $ 85,555 432,452 824,224 $ 1,342,231 $ 342,676 Year 4 $ 5,441,980 $ 80,624 497,475 899,497 $1,477,596 $ 320,502 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).) Sales Year 1 Year 2 Year 3 Year 4 Year 5 % % % % Current assets Cash % % % % % Accounts receivable, net % % % % % Inventory % % % % % Total current assets: % 96 % % 26 Curront liabilities % %6 % % Rotorua Products, Limited, 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: Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 $ 4,601,440 $ 98,218 407,459 800,265 $ 1,305,942 $308,501 Year 2 $ 4,876,740 $91,026 419,185 866,457 $1,376,668 $ 337,069 Year 3 $ 5,017,900 $ 85,555 432,452 824,224 $ 1,342,231 $ 342,676 Year 4 $ 5,441,980 $ 80,624 497,475 899,497 $1,477,596 $ 320,502 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).) Sales Year 1 Year 2 Year 3 Year 4 Year 5 % % % % Current assets Cash % % % % % Accounts receivable, net % % % % % Inventory % % % % % Total current assets: % 96 % % 26 Curront liabilities % %6 % %