Question

In: Accounting

Q. Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market....

Q. 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 1 Year 2 Year 3 Year 4 Year 5
Sales $ 4,552,550 $ 4,916,940 $ 5,080,520 $ 5,495,400 $ 5,744,250
Cash $ 91,127 $ 103,071 $ 93,808 $ 88,914 $ 77,726
Accounts receivable, net 400,089 424,346 439,101 501,251 561,062
Inventory 814,007 880,523 821,361 887,034 897,719
Total current assets $ 1,305,223 $ 1,407,940 $ 1,354,270 $ 1,477,199 $ 1,536,507
Current liabilities $ 302,104 $ 330,002 $ 340,898 $ 337,014 $ 398,422

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).)

Solutions

Expert Solution

Year 1 Year 2 Year 3 Year 4 Year 5
Sales 100.0% 108.0% 111.6% 120.7% 126.2%
Current Assets
Cash 100.0% 113.1% 102.9% 97.6% 85.3%
Accounts Receivable 100.0% 106.1% 109.8% 125.3% 140.2%
Inventory 100.0% 108.2% 100.9% 109.0% 110.3%
Total Current Assets 100.0% 107.9% 103.8% 113.2% 117.7%
Current Liability 100.0% 109.2% 112.8% 111.6% 131.9%
Year 1 Year 2 Year 3 Year 4 Year 5
Sales       4,552,550       4,916,940       5,080,520       5,495,400       5,744,250
Current Assets
Cash            91,127          103,071            93,808            88,914            77,726
Accounts Receivable          400,089          424,346          439,101          501,251          561,062
Inventory          814,007          880,523          821,361          887,034          897,719
Total Current Assets       1,305,223       1,407,940       1,354,270       1,477,199       1,536,507
Current Liability          302,104          330,002          340,898          337,014          398,422

Related Solutions

Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,601,270 $ 4,897,930 $ 5,118,700 $ 5,510,220 $ 5,778,750 Cash $ 88,540 $ 97,890 $ 94,214 $ 78,232 $ 77,351 Accounts receivable, net 418,193 419,393 437,761 515,351 576,719 Inventory 801,902...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,519,650 $ 4,743,420 $ 4,986,130 $ 5,404,630 $ 5,644,150 Cash $ 83,903 $ 94,914 $ 91,997 $ 79,973 $ 72,599 Accounts receivable, net 403,668 425,131 432,904 506,860 563,814 Inventory 818,643...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,504,310 $ 4,838,440 $ 5,003,570 $ 5,532,780 $ 5,644,610 Cash $ 87,574 $ 96,953 $ 86,589 $ 88,508 $ 80,997 Accounts receivable, net 418,154 435,330 443,074 510,098 562,711 Inventory 815,081...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,500,090 $ 4,903,310 $ 5,148,110 $ 5,529,910 $ 5,632,260 Cash $ 88,312 $ 103,640 $ 102,980 $ 86,199 $ 83,505 Accounts receivable, net 404,988 431,050 442,486 500,081 567,716 Inventory 804,331...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,500,090 $ 4,903,310 $ 5,148,110 $ 5,529,910 $ 5,632,260 Cash $ 88,312 $ 103,640 $ 102,980 $ 86,199 $ 83,505 Accounts receivable, net 404,988 431,050 442,486 500,081 567,716 Inventory 804,331...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1    Year 2    Year 3    Year 4    Year 5         Sales $ 4,515,380 $ 4,822,420 $ 5,076,200 $ 5,452,070 $ 5,729,200     Cash $ 86,992 $ 95,104 $ 103,580 $ 80,327 $ 75,778     Accounts receivable, net...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,538,620 $ 4,810,420 $ 5,059,140 $ 5,531,590 $ 5,664,970 Cash $ 86,561 $ 90,131 $ 89,470 $ 75,324 $ 77,867 Accounts receivable, net 404,243 422,030 432,018 511,505 573,091 Inventory 818,757...
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,509,210 $ 4,902,100 $ 4,979,250 $ 5,457,960 $ 5,801,230 Cash $ 92,620 $ 92,634 $ 94,024 $ 72,295 $ 72,696 Accounts receivable, net 400,363 425,222 449,526 498,920 563,527 Inventory 817,045...
otorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The...
otorua 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 1 Year 2 Year 3 Year 4 Year 5 Sales $ 1,800,000 $ 1,980,000 $ 2,070,000 $ 2,160,000 $ 2,250,000 Cash $ 50,000 $ 65,000 $ 48,000 $ 40,000 $ 30,000 Accounts receivable, net 300,000 345,000 405,000 510,000 570,000 Inventory 600,000...
ch 13 excersises #7 Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning...
ch 13 excersises #7 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 1    Year 2    Year 3    Year 4    Year 5         Sales $ 4,580,860 $ 4,735,820 $ 5,001,620 $ 5,420,060 $ 5,639,850     Cash $ 81,352 $ 106,124 $ 97,984 $ 79,072 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT