Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company'scurrent assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows:Year 1Year 2.Year 3$ 5,109,920Year 4$5,426,160SalesCash$ 4,913,430$ 107,166418,831872,823$ 4,517,760$ 84,222404,401613,759$ 1,302,382$314,605Accounts receivable, net$ 96,378433,712823,556Year 5$ 5,678,400$67,491577,175896,962$ 80,729510,535897,844InventoryTotal current assets$ 1,541,628$ 1,398,820$ 345,031$ 1,353,646$ 329,686$1,489,108$ 334,022current liabilities:$ 394,277Required:1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answersto 1 decimal place (i.e., 0.1234 should be entered as 12.3).)Year 1Year 2Year 3Year 4Year 5Sales%Current assetsCashAccounts receivable, notInventoryTotal current assetsCurrent liabilities%%%%%%%%%%%1%%%%%1%%%%%%%%%%%%

Formula to be used to find the Trend Percentage: Trend Percentage =( Year (any) - Year (base))/Year…

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 2. Year Year 5 Year 4 $5,426,160 Sales $ 5,678,400 Cash Year 1 $4,517,760 $84,222 404,401 813,759 $ 4,913,430 $ 107,166 418,831 872,823 $1,398,820 $ 345,031 $ 5,109,920 $ 96,378 433,712 823,556 Accounts receivable, net Inventory $ 80,729 510,535 897,844 $ 67,491 577,175 896,962 Total current assets $ 1,353,646 $ 1,541,628 $ 1,302,382 $ 314,605 $ 1,489,108 $334,022 Current liabilities $ 394,277 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).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales Current assets Cash Accounts receivable, net Inventory Total current assets Current liabilites % % % % % % % % % % % % % % % % % % % % % % %

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 2. Year Year 5 Year 4 $5,426,160 Sales $ 5,678,400 Cash Year 1 $4,517,760 $84,222 404,401 813,759 $ 4,913,430 $ 107,166 418,831 872,823 $1,398,820 $ 345,031 $ 5,109,920 $ 96,378 433,712 823,556 Accounts receivable, net Inventory $ 80,729 510,535 897,844 $ 67,491 577,175 896,962 Total current assets $ 1,353,646 $ 1,541,628 $ 1,302,382 $ 314,605 $ 1,489,108 $334,022 Current liabilities $ 394,277 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).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales Current assets Cash Accounts receivable, net Inventory Total current assets Current liabilites % % % % % % % % % % % % % % % % % % % % % % %

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 3MAD: Deere Company (DE) manufactures and distributes farm and construction machinery that it sells...

See similar textbooks

Similar questions

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,617,010 $ 4,754,310 $ 5,081,970 $ 5,459,390 $ 5,735,870 Cash $ 92,753 $ 90,069 $ 93,105 $ 80,319 $ 78,860 Accounts receivable, net 404,289 421,258 440,963 511,995 567,286 Inventory 808,517 867,939 816,543 882,341 903,474 Total current assets $ 1,305,559 $ 1,379,266 $ 1,350,611 $ 1,474,655 $ 1,549,620 Current liabilities $ 312,169 $ 333,151 $ 342,274 $ 318,352 $ 403,812 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year.
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,629,850 $ 4,882,820 $ 5,051,360 $ 5,561,430 $ 5,779,850 Cash $ 92,281 $ 100,754 $ 100,089 $ 88,760 $ 74,387 Accounts receivable, net 400,699 434,827 445,236 507,424 568,470 Inventory 805,036 874,663 822,264 897,114 903,388 Total current assets $ 1,298,016 $ 1,410,244 $ 1,367,589 $ 1,493,298 $ 1,546,245 Current liabilities $ 317,424 $ 340,337 $ 332,468 $ 321,672 $ 391,861 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).)
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,546,750 $4,760,520 $5,009,460 $5,429,040 $5,695,160 $ $ 2$ 2$ 87,970 513,073 895,198 $ 73,368 572,803 907,666 Cash 90,291 401,499 815,059 95,951 417,195 869,228 92,001 448,219 832,208 Accounts receivable, net Inventory Total current assets $1,306,849 $1,382,374 $1,372,428 $1,496,241 $1,553,837 Current liabilities $ 318,258 $ 335,298 $ 335,856 $ 325,402 $ 399,778 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).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % % % % % Current assets: Cash Accounts receivable Inventory Total current…
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 $1,800, 000 $1,980,000 $2,070,000 $2,160,000 $2, 250, 000 50,000 300,000 600,000 Cash $4 24 Accounts receivable, net Inventory 65,000 345,000 660,000 48,000 405,000 40,000 510,000 30,000 570,000 750,000 $1,350,000 690,000 720,000 Total current assets $ 950,000 $1,070,000 $1,143,000 $1,270,000 Current liabilities $ 400,000 $ 440,000 $ 520,000 $ 580,000 $ 640,000 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).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % % % % % Current assets: % % % % Cash % % % Accounts receivable, net % % % Inventory % % % % %…
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 2 $ 4,811,010 $ 107,506 434,300 875,188 Year 1 $ 4,566,790 $ 83,177 412,248 808,923 $ 1,304,348 $ 1,416,994 $ 316,105 $ 348,257 Year 3 $ 5,042,090 $ 97,115 444,761 830,890 $ 1,372,766 $ 335,911 Year 4 $ 5,400,030 $ 82,132 512,978 891,938 $ 1,487,048 $ 321,500 Year 5 $ 5,684,250 $ 78,811 573,511 911,368 $ 1,563,690 $ 397,247 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).) Year 1 Year 2 Year 3 Year 4 Year 5 % % % % % Sales Current assets: Cash % % % % % Accounts receivable, net % % % % %…
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 Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 Year 2 $ 4,654,890 $ 98,625 412,539 812,564 $ 4,785,720 $ 91,603 423,536 876,894 $ 1,323,728 $ 1,392,033 $ 339,515 $ 300,175 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).) Year 1 % % % % % % Year 2 % % % % % % Year 3. Year 4 Year 5. $ 5,597,560 $ 5,808,960 $ 4,989,130 $ 103,392 439,311 817,070 $ 1,359,773 $ 1,467,996 $ 1,554,121 $333,288 $ 328,594 $ 409,089 $ 74,976 501,957 891,063 $…
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 Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 $4,593,830 $ 87,529 404,278 801,291 $ 1,293,098 $ 304,544 Year 1 Year 2 $4,780,780 $93,256 426,549 868,050 $ 1,387,855 $ 338,428 % % % % % % % % % % Year 3 $4,986,700 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).) ered as 12 Year 2 Year 3 $ 86,310 433,877 819,354 $ 1,339,541 $ 334,294 % % % % Year 4 $ 5,563,020 Year 4 $ 77,754 496,981 899,709 $1,474,444 $ 322,187 % % % % Year 5 $ 5,640,450…
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumermarket. The company’s current assets, current liabilities, and sales have been reported as follows over thelast five years (Year 5 is the most recent year):Year 5 Year 4 Year 3 Year 2 Year 1Sales ...................................... $NZ2,250,000 $NZ2,160,000 $NZ2,070,000 $NZ1,980,000 $NZ1,800,000Cash ...................................... $NZ 30,000 $NZ 40,000 $NZ 48,000 $NZ 65,000 $NZ 50,000Accounts receivable, net ....... 570,000 510,000 405,000 345,000 300,000Inventory ................................ 750,000 720,000 690,000 660,000 600,000Total current assets ............... $NZ1,350,000 $NZ1,270,000 $NZ1,143,000 $NZ1,070,000 $NZ 950,000Current liabilities .................... $NZ 640,000 $NZ 580,000 $NZ 520,000 $NZ 440,000 $NZ 400,000$NZ stands for New Zealand dollars.Required:1. Express all of the asset, liability, and sales data in trend percentages. (Show percentages for…
Rotorua Products sells agricultural products in the burgeoning Asian 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 Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 100.0 Year 1 $ 4,513,330 $ 86,858 414,137 805,814 $ 1,306,809 100.0 100.0 100.0 100.0 100.0 % Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. Note: Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3). % % Year 2 $ 4,867,400 $ 97,107 423,798 880,974 $ 1,401,879 $ 318,689 $ 335,942 % % % X Answer is not complete. Year 2 Year 3 $ 5,101,490 $ 88,212 447,360 824,047 $ 1,359,619 $ 324,994 % % % % % % Year 3 % % % % Year 5 Year 4 $5,485,330 $ 5,648,040 % % $ 91,910 507,318 894,402 $…
Rotorua Products sells agricultural products in the burgeoning Asian 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 Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 11 Year 2 Year 3 Year 4 Year 5 $4,545,400 $4,737,850 $ 5,126,380 $5,421,900 $5,776,190 Year 1 $ 88,854 418,283 800,380 $ 1,307,517 $ 313,578 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. Note: Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3). % % % % % % Year 2 $ 88,845 $ 77,057 435,833 587,279 $ 90,380 417,076 876,061 $1,383,517 $ 1,350,248 $ 1,466,414 $1,552,502 $ 346,822 $ 336,685 $ 335,107 $ 390,612 825,570 882,078 % % % % % % Year 3 % % % % Year 4 % % $ 80,928 569,984…
Analyze Deere & Company Deere & Company (DE) manufactures and distributes farm and construction machinery that it sells around the world. In addition to its manufacturing operations, Deere's credit division loans money to customers to finance the purchase of their farm and construction equipment. The following information is available for three recent years (in millions except per-share amounts): Year 3 Year 2 Year 1 Net income (loss) $1,523.9 $1,940.0 $3,161.7 Preferred dividends $ 0.00 $ 763.7 $ 680.0 $ 664.0 $ 0.00 $0.00 Interest expense Shares outstanding for computing earnings per share 315 334 363 Cash dividend per share $ 2.40 $ 2.40 $ 2.22 $ 57,965 $ 59,642 $ 60,429 $ 6,644 $ 7,912 $ 9,667 $ 92.03 $ 81.10 $ 85.58 Average total assets Average stockholders' equity Average stock price per share 1. Calculate the following ratios for each year (Round ratios and percentages to one decimal place, except for per-share amounts. Round per-share amounts to two decimal places.): Year 3…
Starship Corporation reported the following geographical segment revenues for a recent and a prior fiscal year: Recent Year(in millions, rounded) Prior Year(in millions, rounded) Americas $10,479 $8,073 EMEA* 1,217 1,295 China/Asia Pacific 2,396 1,130 Channel Development** 1,731 1,546 Other 2,236 1,695 Total $18,059 $13,739 *Europe, Middle East, and Africa **Sells packaged coffee and teas globally a. Prepare a horizontal analysis of the segment data using the prior year as the base year. Round all percents to one decimal place. Enter all amounts in millions. If required, use minus sign to indicate the decreasing values. Starship Corporation Horizontal Analysis Recent Year (in millions) Prior Year (in millions) Increase (Decrease)Amount Increase (Decrease)Percent Americas $10,479 $8,073 $fill in the blank 15396ff9101df9f_1 fill in the blank 15396ff9101df9f_2% EMEA 1,217 1,295 fill in the blank 15396ff9101df9f_3 fill…