Exercise 14-7 (Algo) Trend Percentages [LO14-1] Rotorua Products, Limited, of New Zealand markets agricultural products for...

Transcribed Image Text:

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,526,990 $ 96,796 414,255 811,279 $ 1,322,330 $ 307,649 Year 2 $ 4,736,140 $ 96,443 426,801 883,233 $ 1,406,477 $ 334,105 Year 3 $ 5,107,370 $87,043 439,208 816,875 $ 1,343,126 $ 336,968 Year 41 $ 5,464,880 $ 80,625 497,458 891,817 $ 1,469,900 $325,051 Year 5 $ 5,679,630 $ 82,130 577,621 898,463 $ 1,558,214 $ 403,338 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 31 Year 4 Year 5 Sales % % % % % Current assets Cash % % % % %6 Accounts receivable, net % % % % % Inventory % % % % % Total current assets % % % % % Current liabilities % % % % % 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,526,990 $ 96,796 414,255 811,279 $ 1,322,330 $ 307,649 Year 2 $ 4,736,140 $ 96,443 426,801 883,233 $ 1,406,477 $ 334,105 Year 3 $ 5,107,370 $87,043 439,208 816,875 $ 1,343,126 $ 336,968 Year 41 $ 5,464,880 $ 80,625 497,458 891,817 $ 1,469,900 $325,051 Year 5 $ 5,679,630 $ 82,130 577,621 898,463 $ 1,558,214 $ 403,338 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 31 Year 4 Year 5 Sales % % % % % Current assets Cash % % % % %6 Accounts receivable, net % % % % % Inventory % % % % % Total current assets % % % % % Current liabilities % % % % %