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 $23. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) Assets Current assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Property and equipment: Land Buildings and equipment, net Total property and equipment. Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Accrued liabilities: Notes payable, short term Total current liabilities Long-term liabilities Bonds payable Total liabilities Stockholders equity This Year Last Year $1,170 10,200 $1,310 12,700 6,900 12,400 630 640 24,700 21,250 9,400 9,400 40,361 38,522 49,762 47,922 $ 74,461 $69,172 $19,500 $10,000 990 780 100 100 20,590 19,680 9,300 9,300 29,890 28,980 Long-term liabilities: Bonds payable Total abilities Stockholders equity: Common stock Additional paid-in capital Total paid-in capital Retained earnings Total stockholders' equity 9,300 29,890 9,300 28,980 700 700 4,000 4,000 4,700 4,700 39,871 35,492 44,571 40,192 $ 74,461 $ 69,172 Total liabilities and stockholders' equity Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expenses Administrative expenses Total selling and administrative expenses Net operating Income Interest expense Net income before taxes Income taxes Net income Dividends to common stockholders Net income added to retained earnings Beginning retained earnings Ending retained earnings This Year $ 73,530 46,435 Last Year $ 65,000 39,000 27,095 26,000 11,200 10.600 7,200 6,300 18,400 16,900 8,695 9.200 -930 930 7.765 8,170 3,106 3,268 4,659 4,902 200 350 4,379 35,492 4,552 $ 39,071 30,940 835, 492 Required: Compute the following financial data for this year: 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 collection period 3. Inventory tumover 4. Average sale period 5. Operating cycle 6. Total asset turnover 8.60 42.44 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 980,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 $27. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands)) Assets Current assets: Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Property and equipment: Land Buildings and equipment, net Total property and equipment Total assets Liabilities and Stockholders' Equity Current Liabilitiess Accounts payable Accrued liabilities totes payable, short term Total current liabilities Long-term liabilities Bonds payable Total liabilities This Year Last Year $ 4,568 $ 5,440 16,200 9,150. 10,600 8,920 1,900 2,460 33,348 25,970 7,800 7,800 21,000 20,800 28,900 28,600 $ 62,148 $54,570 $ 11,300 $9,200 960 1,600 400 12,740 400 11,200 ,750 21,490 0,750 20,030 Stockholders' equity: Common stock Additional paid-in capital Total paid-in capital Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Weller Corporation 980 15,100, 6,080 34,578 40,658 $ 62,148 Comparative Income Statement and Reconciliation (dollars in thousands) Sales Cost of goods sold Gross margin Selling and administrative expenses: 980 5,100 6,080 28,460 34,540 $ 54,570 This Year Last Year $ 92,000 $ 97,000 61,000 36,000 57,000 35,000 Selling expenses Administrative expenses Total selling and administrative expenses Net operating income Interest expense Net income before taxes Income taxes Net income Dividenda to common stockholders Net income added to retained earnings Beginning retained earnings Ending retained earnings Required: Compute the following financial data for this year: 10,300 9,800 13,800 12,800 24,100 22,600 11,900 12,400 1,050 1,050 10,850 11,350 4,340 4,540 6,510 6,810 392 6,118 28.460 $ 34,578 $28,460 784 6,026 22,434 1. Gross margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 2. Net profit margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) Required: Compute the following financial data for this year: 1. Gross margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 2. Net profit margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 3. Return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 4. Return on equity. (Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage 2. Net profit margin percentage 3. Return on total assets 4. Return on equity 37.1 % 6.7 % % % 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.00. All of the company's sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) Assets Current assets Cash Accounts receivable, not Inventory Prepaid expenses Total current assets Property and equipment Land Buildings and equipment, net Total property and equipment Total assets Liabilities and Stockholders' Equity Current Liabilities) Accounts payable Accrued Liabilities Notes payable, short term Total current liabilities Long-term liabilities This Year Last Year $ 3,012 $3,980 12,500 9,200 9.800 8,280 1,820 2,140 27,932 23,600 6.200 6.200 19,400 25,600 $53,532 19,200 25,400 $ 49,000 5,700 8.400 640 320 10,560 800 320 9,520 00 Notes payable, short term 320 320 Total current liabilities Long-term Liabilities: 10,660 9,520 Bonds payable Total liabilities Stockholders equity: Common stock Additional paid-in capital Total paid-in capital Retained earnings 7,500 7,500 18,160 17,020 820 820 4,300 4,300 5,120 5,120 30,252 Total stockholders equity Total liabilities and stockholders' equity Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) 26,860 35,372 31,980 $ 53,532 $ 49,000 Sales Cost of goods sold Gross margin Selling and administrative expensesi Selling expenses Administrative expenses Total selling and administrative expenses Net operating income Interest expense Net income before taxes Income taxes Net income Dividends to common stockholders Net income added to retained earnings Beginning retained earnings Ending retained earnings This Year 5 81,000 53,000 28,000 8,700 12,200 20:900 7,100 900 6,200 2,480 3,720 328 Last Year $ 76,000 49,000 27,000 8,200 11,200 19,400 7,600 900 6,700 2,680 4,020 3,392 26,860 $ 30,252 656 3,364 23,496 5 26,660 Required: Compute the following financial data for this year: 1. Earnings per share. (Round your answer to 2 decimal places.) 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-earnings ratio 3. Dividend payout ratio 4. Dividend yield ratio 5. Book value per share %