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 i Current liabilities Required: $ 90,393 416,360 Year 1 $4,592,320 Year 2 $ 4,823,900 $105,871 420,041 Year 3 $ 5,029,940 $91,423 439,631 815,800 868,573 821,163 $308,369 $1,394,485 $344,132 $1,322,553 $1,352,217 $324,525 Year 4 $ 5,513,500 $ 81,849 497,250 886,631 $ 1,465,730 $325,654 Year 5 $5,774,830 $ 64,504 565,356 898,030 $1,527,890 $405,970 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).) Sales Year 1 Year 2 Year 3 Year 4 Year 5 % % % Current assets Cash % % % % % Accounts receivable, net N % % % % Inventory % % % % % Total current assets % % % % % Current liabilities % % % % % A comparative income statement is given below for McKenzie Sales, Limited, of Toronto: McKenzie Sales, Limited Comparative Income Statement Sales This Year $ 7,390,000 Last Year $5,616,400 Cost of goods sold 4,760,000 3,506,500 Gross margin 2,630,000 2,109,900 Selling and administrative expenses: 1,399,000 1,073,500 Administrative expenses 704,500 616,500 2,103,500 1,690,000 Interest expense 526,500 98,000 419,900 $ 428,500 Selling expenses Total expenses Net operating income Net income before taxes 90,000 $ 329,900 Members of the company's board of directors are surprised to see that net income increased by only $98,600 when sales increased by $1,773,600. Required: 1. Express each year's income statement in common-size percentages. (Round your percentage answers to 1 decimal place (i.e.. 0.1234 should be entered as 12.3).) Sales Cost of goods sold This Year Last Year % Gross margin % % % Selling and administrative expenses: Selling expenses % % Administrative expenses % % Total selling and administrative expenses % % Net operating income % % Interest expense % % Net income before taxes % % Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 500,000 shares of common stock were outstanding. The Interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company's common stock at the end of this year was $26. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Lest Test Assets Current assets Cash Accounts receivable, nat Inventory Prepaid expenses Total current assets Property and equipment Land Buildings and equipment, net Total property and equipment Total assets Current liabilities Accounts payable Liabilities and Stockholders' Equity Accrued liabilities Notes payable, short term Total current liabilities Long-term liabilities: Boods payable Total liabilities Stockholders equity Connon stock Additional paid-in capital Total paid-in capital Retained earnings $1,240 $1,340 10,200 13,900 790 7,900 11,900 590 26,130 21,730 10,200 10,200 41,927 35,446 52,117 45,666 78,247 $ 67,396 $19,100 950 $1,300 730 260 260 20,318 19,290 3,900 8,900 29,210 20.190 500 500 4,000 4,000 4,500 4.500 44,537 34,706 Total stockholders equity 49,037 39,206 Total liabilities and stockholders equity 78,247 $47,396 Veller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year Sales $72,000 65,000 Cost of goods sold 36,000 41,000 Cross margin 36,000 24,006 Selling and administrative expenses 11,000 10,400 Administrative expenses 7,300 4,100 Total selling and administrative expens IW,100 14,500 Bet operating income 17,900 Interest expense Het incone before thes 90 17,010 Income taxOS Net Incon Dividends to common stockholders 10,206 375 Set income added to retained earnings 3,831 34,706 $44,537 7,500 6,630 3,444 3,995 200 3,766 30.940 $34,706 beginning retained earnings Ending retained earnings Required: Compute the following financial data and ratios for this year 1. Working capital (Enter your answer in thousands) 2. Current ratio (Round your answer to 2 decimal places) 3. Acid-test ratio (Round your answer to 2 decimal places) 1. Working capital 2. Current rado 3. Acid-estrato Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below The company did not issue any new common stock during the year. A total of 700,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company's common stock at the end of this year was $21. All of the company's sales are on account Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Last Tour Asset Current assets Cash Accounts receivable, set Inventory Prepaid expenses Total current assets $1,090 3,900 13,000 $1,240 6.700 11,000 790 530 24,400 19,490 Property and equipment Land 3,500 9,500 Buildings and equipment, set 48.676 40,592 Total property and equipment 14,176 59-992 Total assets 882,456 8.65,582 Liabilities and Stockholders' Equity Current liabilities Accounts payable Aceroed liabilities 19,900 $19,000 910 710 otes payable, short ter Total current liabilities 110 19,920 9,900 30,630 9,900 29-420 Common stock Additional Total paid-in capital 700 700 paid-in capital Batained earning Total stockholders' equity Total liabilities and stockholder equity Weller Corporation Comparative Tacone Statement and Reconciliati (dallars in thesande) 4,000 4,700 4,700 47,314 35,362 52,016 39,943 82,656 Cost of goods sold Gross margin Selling expens Total selling and administrative expenses Net operating inc Interest expense Net Income before the Bet Income Dividends to common stockholders Set income added to retained earnings Beginning retained earning Ending retained earnings Required Compute the following financial data for this year This Year 77,550 $64,000 38,040 31,476 24,000 11,000 $300 17,900 16,900 21,570 9,100 8.334 13,314 3,348 4,873 240 358 12,014 31,242 47,336 4.532 30,740 35,242 1 Accounts receivable turnover (Assume that all sales are on account) (Round your answer to 2 decimal places) 2. Average collection period (Use 365 days in a year. Round your intermediate calculations and final answer to 2 decimal places.) 3. Inventory turnover (Round your answer to 2 decimal places) 4. Average sale period (Use 365 days in a year. Round your intermediate calculations and final answer to 2 decimal places.) 5. Operating cycle. (Round your Intermediate calculations and final answer to 2 decimal places) 6. Total asset turnover (Round your answer to 2 decimal places) 1. Accounts receivable turnover 2. Average colection period 3.ventory tumover Average sale period 5. Operating cycle Total asset turmover days days days Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below The company did not issue any new common stock during the year. A total of 820,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company's common stock at the end of this year was $19. All of the company's sales are on account. Weller Corporation Comparative balance Sheet (dollars in thousands) This Year Last Year Assets Current assetas Cash Accounts receivable, set Inventory Prepaid expens Total current assets $3,912 3,900 12,500 9,200 3,800 9,290 3,930 3,340 27,933 23,400 Property and equipments Land 6,200 6,200 buildings and equipment, net 19,400 19,200 Total property and equipment 25,400 25,400 Total assets $53,532 49,000 Liabilities and Stockholders' Equity Current Liabilities Accounts payable 9,700 Accrued Liabilities $ 8,400 640 900 Notes payable, short ters Total current liabilities Long-term liabilities bends payable Total liabilities Stockholders' equity Common stock Additional paid-in capital Total paid-in capital Betained earnings 320 320 18,660 9,520 7,500 7,500 10,160 17,430 920 820 4,300 4,300 5,130 5,120 30,252 Total stockholders' equity Total liabilities and stockholders' equity Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousand 26,950 35,372 31,900 $53,532 49,000 Sales Cost of goods sold Grees margin selling and administrative expens Selling expens Administrative expenses Total selling and administrative expenses Net operating income Interest expense Net Income before thes Income taxes Net Incone Dividends to common stockholder Net income added to retained earnings Beginning retained earnings Ending retained earnings Required: Compute the following financial data for this year This Year $1,000 $3,000 29,000 Last Year $76,000 49,000 27,900 8,700 13,300 ,200 11,200 20,900 19,400 7,300 7,400 900 5,200 6,700 2,400 2,600 3,720 4,020 654 3.392 3,364 26,960 23,496 $30,252 24,860 1 Gross margin percentage. (Round your percentage answer to 1 decimal place (e. 01234 should be entered as 12.3) 2. Net profit margin percentage (Round your percentage answer to 1 decimal place (e, 0.1234 should be entered as 12.3)) 3. Return on total assets. (Round your percentage answer to 1 decimal place (ie, 0.1234 should be entered as 12.3) 4. Return on equity (Round your percentage answer to 2 decimal places fe, 01234 should be entered as 12.34) 1. Groes margin percentage 2. Net profit margin percentage 3. Return on total assets 4. Retum on equity Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below The company did not issue any new common stock during the year. A total of 840,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company's common stock at the end of this year was $20.00. All of the company's sales are on account. Valler Corporation Comparative Balance Sheet (dollars in thousands) This Year Assata Current essetal Chah Accounts receivable, net Inventory Prepaid expenses Total current assets Property and wipment Land 3.9,344 4,400 12,700 9.300 3,900 8,360 30-704 24,240 6,400 6,400 19,600 29,400 Total property and equipment 26,006 25,000 Total $56,704 3.53,040 Liabilities and Stockholders' Equity Current Liabilities Accounts payable $9,900 $4,500 Acerved Liabilities 600 900 Motes payable, short term 340 340 Total murrent liabilitie Long-term liabilities Total liabilities Stockholders equity Common stock Additional paid-in capital Total paid-in capital Retained earnings 10,920 3,740 10,000 10,000 30,930 19,740 840 843 4,400 4,400 3,240 5,240 30,624 27,140 Total stockholders' equity Total liabilities and stockholders' equity Vellar Corporation Comparative Income Statenest and Reconciliation (dollars is thousands) 35,944 32,308 $56,784 53,048 Sales Cost of goods sold Cross margin falling and administrative expense Total selling and administrative expenses Bet operating incone Interest expense Net Incone before thes Income taxes Dividends to common stockholders Net income added to retained earnings Beginning retained earnings Ending retained Required: ning Compute the following financial data for this year 1. Earnings per share. (Round your answer to 2 decimal places.) This Year $63,000 Last Year 78,000 $4,000 29,000 50,000 20,000 8,900 13,400 11,400 21,300 19,900 3,300 $,500 7,000 3,400 3,400 4,200 334 3,544 3,530 27,949 30,424 21,533 27,048 2. Price-earnings ratio. (Round your intermediate calculations and final answer to 2 decimal places.) 3. Dividend payout ratio. (Round your intermediate calculations and final answer to 2 decimal places) 4. Dividend yield ratio. (Round your intermediate calculations and final answer to 2 decimal places) 5. Book value per share. (Round your answer to 2 decimal places.) 1. Eamings per share 2. Price-eamings ratio 3. Dividend payout ratio 4 Dividend yield ro 5. Book value per share