Exercise $14-7($Algo$)$ Trend Percentages $[$LO$14-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:

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

Sales $ $4,607,460$ $ $4,794,680$ $ $5,133,720$ $ $5,408,000$ $ $5,627,630$

Cash $ $93,572$ $ $96,084$ $ $100,442$ $ $73,324$ $ $79,371$

Accounts receivable, net $414,456432,546439,973514,631569,241$

Inventory $819,655874,505816,089898,257905,776$

Total current assets $ $1,327,683$ $ $1,403,135$ $ $1,356,504$ $ $1,486,212$ $ $1,554,388$

Current liabilities $ $315,221$ $ $338,741$ $ $336,541$ $ $326,276$ $ $402,264$

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\mathrm{.}1234$ should be entered as $12\mathrm{.}3).)$

Year $1$ Year $2$ Year $3$ Year $4$ Year $5$

Sales $\%\%\%\%\%$

Current assets:

Cash $\%\%\%\%\%$

Accounts receivable, net $\%\%\%\%\%$

Inventory $\%\%\%\%\%$

Total current assets $\%\%\%\%\%$

Current liabilities $\%\%\%\%\%$