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'scurrent assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows:SalesCashAccounts receivable, netInventoryTotal current assetsCurrent liabilitiesRequired:Year 1$ 4,680,030$ 82,770403,609800,154$ 1,286,533$ 318,714Year 2$ 4,900,840$ 101,787417,705868,059$ 1,387,551$ 332,732Year 3$ 5,029,390$ 98,893445,314828,216$ 1,372,423$ 339,560Year 4$ 5,504,210$ 88,301509,629885,290$ 1,483,220$ 329,136Year 5$ 5,628,180$ 70,089571,343907,134$ 1,548,566$ 402,8451. 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).)SalesYear 1Year 2Year 3Year 4Year 5100.0%%%%%Current assets:Cash100.0%%%%%Accounts receivable, net100.0 %%%%%Inventory100.0 %%%%%Total current assets100.0 %%%%%Current liabilities100.0 %%%%%

The base year 1 was considered to calculate all the percents for all years. The excel table has been…

Answered: Exercise 14-7 (Algo) Trend Percentages…

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.5.1MBA

See similar textbooks

Similar questions

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, neti Inventory Total current assets Current liabilities Sales Current assets Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 % % % % % % Year 1 $4,596,550 $ 92,892 416,860 813,702 $ 1,323,454 $ 311,407 Year 2 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 16 Year 2 $ 4,903,860 $ 93,237 417,106 872,808 $1,383,151 $ 347,697 Year 3 1% % % % Year 3 $ 5,102,310 $91,810 432,994 819.573 $ 1,344,377 $331,116 Year 4 1% 1% % IN 16 % Year 5 $ 82,050 502,783 892,591…
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 Yeae S Sales $ 4,600, 790e $4,921,690 5 96,916 426, 158 70, 711 $1.393,785 $5,015,37e $ 5,543,20 S 17,60 $5,650,520 Cash Accounts receivable, net Inventory Total current assets $.95,408 407,016 507,300 451,111 833, 392 $1,371,80) 5 78,245 562,006 B4, 150 $1,479,622 $1,311,000 $1,549,3 Current 1labilities 5 302,390 5 327,119 $ 328,044 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 plece (ie., 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 labilities
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 have been reported as follows over the last five years (Year 5 is the most recent year): image $NZ stands for New Zealand dollars. Required: Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year I as the base year and carry computations to one decimal place. Comment on the results of your analysis.
Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…
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: Year 1 Year 2. Year 3 $ 5,109,920 Year 4 $5,426,160 Sales Cash $ 4,913,430 $ 107,166 418,831 872,823 $ 4,517,760 $ 84,222 404,401 613,759 $ 1,302,382 $314,605 Accounts receivable, net $ 96,378 433,712 823,556 Year 5 $ 5,678,400 $67,491 577,175 896,962 $ 80,729 510,535 897,844 Inventory Total current assets $ 1,541,628 $ 1,398,820 $ 345,031 $ 1,353,646 $ 329,686 $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, not Inventory Total current assets Current…
Item 20 of 30 Following are the selected ratios for Petron Corp. (an oil and gas exploration company) and Selecta Co. (a dairy products firm) for the year 2020. Which set of ratios belongs to Petron? Why do you think so? Company A Company B Asset turnover ratio 2.15 40 Profit margin 0.04 47
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,632,090 $ 4,889,470 $ 4,994,970 $ 5,440,450 $ 5,736,120 Cash $ 83,883 $ 107,036 $ 94,610 $ 88,260 $ 66,503 Accounts receivable, net 416,977 435,170 442,184 501,060 565,287 Inventory 805,509 868,062 819,753 892,341 915,826 Total current assets $ 1,306,369 $ 1,410,268 $ 1,356,547 $ 1,481,661 $ 1,547,616 Current liabilities $ 303,521 $ 335,136 $ 338,848 $ 335,371 $ 392,801 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).)
Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…
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…

SEE MORE QUESTIONS

Recommended textbooks for you

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

SEE MORE TEXTBOOKS