Rotorua Products Ltd of New Zealand markets agricultural pro

Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company\'s current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year) Year 1Year 2Year 3 ear ear Sales $4,612,660 $4,854,070 $5,109,300 $5,417,310 $5,756,270 $ 94,676 $ 107,943 86,414 84,625 $ 65,429 Accounts receivable, net 401,906 418,602433,452 515,581 562,774 818,559 871,471 835,653 887,537910,634 Cash Inventory Total current assets $1.315,141 $1,398,016 $1,355,519 $1,487,743 $1,538,837 Current liabilities $ 307,679 336,910 $ 337,767 $ 326,992 S 406,225 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).) 1 Year 2 Year 3 Year 4 Year 5 Year Sales Current assets: Cash Accounts receivable Inventory Total current assets Current liabilities

Solution

Year 1 Year 2 Year 3 Year 4 year 5 Sales 100.0% 105.2% 110.8% 117.4% 124.8% Current assets Cash 100.0% 114.0% 91.3% 89.4% 69.1% Account receivable 100.0% 104.2% 107.8% 128.3% 140.0% inventory 100.0% 106.5% 102.1% 108.4% 111.2% total current assets 100.0% 106.3% 103.1% 113.1% 117.0% Current liabilities 100.0% 109.5% 109.8% 106.3% 132.0%