Exercise 14-7 Trend Percentages [LO14-1] 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 5 $5,696,050 Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 11 $4,553,570 Year 2 $4,735,860 Year 3 $4,982,070 Year 4 $5,416,440 $ 94,025 418,309 $ 88,250 $ 97,487 $ 72,808 $ 72,594 431,768 449,135 496,166 579,719 812,943 $1,325,277 882,851 $1,402,869 824,547 $1,371,169 885,456 $1,454,430 911,671 $1,563,984 $ 301,346 $ 341,525 $ 333,010 $ 326,491 $ 394,647 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year (Round your percentage ans to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Answer is complete but not entirely correct. Sales Year 1 100.0 Year 2 Year 3 % 106.0 % 109.3% Year 4 121.7% Year 5 127.4% Current assets Cash 100.0 % 109.0 % Accounts 100.0 % 104.8% 111.7 86.6 % % 87.8% 126.8% 80.7% 142.6 % receivable Inventory 100.0% Total current assets 100.0 % 109.1 % 107.7% 102.7% 104.2 ( % 110.9% 114 1% Current liabilities 100.0 % 110.8 % 109.5 % 103.9% 113.5% 120.0% 127.9 %