Exercise 14-7 (Algo) Trend Percentages [LO14-1] 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: Inventory Sales Cash Accounts receivable, net Total current assets Current liabilities Required: Year 1 $4,552,410 $ 88,557 412,299 814,405 $ 1,315,261 $305,987 Year 2 $ 4,782,950 $ 96,192 423,876 873,883 $ 1,393,951 $346,939 Year 3 $ 4,954,560 $ 103,309 438,516 820,082 $1,361,907 $324,102 Year 4 $ 5,471,400 $ 73,614 498,760 892,746 $ 1,465,120 $324,247 Year 5 $ 5,671,400 $ 77,490 574,974 913,818 $1,566,282 $ 398,176 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 (l.e., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales 100.0 % % % % Current assets Cash 100.0 % % % % % Accounts receivable, net 100.0 % %6 % % % Inventory 100.0 % % % % % Total current assets 100.0 % % % % % Current liabilities 100.0 % % % % Exercise 14-7 (Algo) Trend Percentages [LO14-1] 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 Required: Year 1 $ 4,552,410 $ 88,557 412,299 814,405 $ 1,315,261 $ 305.987 Year 2 $ 4,782,950 $ 96,192 423,876 873,883 $ 1,393,951 $ 346,939 Year 3 $ 4,954,560 $ 103,309 438,516 820,082 $ 1,361,907 $324,102 Year 4 $ 5,471,400 $ 73,614 498,760 892,746 $1,465,120 $ 324,247 Year 5 $ 5,671,400 $ 77,490 574,974 913,018 $ 1,566,282 $ 398,176 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 100.0% % % % Current assets: Cash 100.0 % % % Accounts receivable, net 100.0 % % % % Inventory 100.0 % % % % % Total current assets 100.0% % % Current liabilities 100.0 % % % %