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: $106,517 432,633 882,900 Year 1 $ 4,672,720 Year 2 $ 4,840,450 $ 80,573 408,745 815,188 $ 1,304,506 $308,424 $ 340,891 $ 1,422,050 Year 3 $ 5,084,920 $ 95,187 439,817 832,115 $ 1,367,119 Year 4 $ 5,486,900 $87,733 506,924 886,371 $ 1,481,028 $339,574 $ 336,449 Year 5 $ 5,777,120 $ 78,538 561,885 906,205 $ 1,546,628 $ 390,656 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 (ie., 0.1234 should be entered as 12.3).) Answer is complete but not entirely correct. Sales Year 1 100.0% Year 2 103.6% Year 3 109.0% Year 4 117.0% Year 5 123.6% Current assets Cash 100.0% 132.0% Accounts receivable, nel 100.0% 105.8% 118.0% 107.6% 108.9% 97.5% 124.0% 137.5% Inventory 100.0% 108.0% 102.1 % 108.7% 111.2% Total current assets 100.0% 109.0% 104.8% 113.5% 116.6 % Current liabilities 100.0 % 110.5% 1300% 109.1 % 100.4 %