A45

***Please help with number 12 with showing formula***

Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $82.60 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2012 and 2041 20Y2 2011 Retained earnings, January 1 $3,264,000 $3,704,000 600,000 Net income 550,000 Dividends: On preferred stock (10,000) (10,000) (100,000) On common stock (100,000) Retained earnings, December 31 $4,194,000 $3,704,000 Marshall Inc. Comparative Income Statement For the Years Ended December 31, 2012 and 2041 20Y2 2011 Sales $10,850,000 $10,000,000 5,450,000 Cost of merchandise sold 6,000,000 Gross profit $4,850,000 $4,550,000 $2,000,000 Selling expenses Administrative expenses $2,170,000 1,627,500 1,500,000 Total operating expenses Income from operations $3,797,500 $1,052,500 $3,500,000 $1,050,000 Other revenue and expense: Other revenue 99,500 (132,000) Other expense (interest) 20,000 (120,000) $950,000 Income before income tax expense $1,020,000 420,000 Income tax expense 400,000 Net income $600,000 $550,000 Marshall Inc. Comparative Balance Sheet December 31, 2012 and 2041 20Y2 2011 Assets Current assets! Cash $1,050,000 301,000 $ 950,000 420,000 Marketable securities 585,000 500,000 Accounts receivable (net) Inventories 420,000 108,000 Prepaid expenses Total current assets 380,000 20,000 $2,270,000 800,000 $2,464,000 800,000 Long-term investments Property, plant, and equipment (net) 5,760,000 5,184,000 $8,254,000 Total assets $9,024,000 Liabilities $ $880,000 $800,000 $0 $200,000 3,000,000 Current liabilities Long-term liabilities: Mortgage note payable, 6% Bonds payable, 4% Total long-term liabilities Total liabilities Stockholders' Equity Preferred 4% stock, $5 par $3,000,000 $3,000,000 $3,200,000 $4,080,000 $3,800,000 $250,000 500,000 $250,000 500,000 Common stock, $5 par Retained earnings Total stockholders' equity 4,194,000 $4,944,000 $9,024,000 3,704,000 $4,454,000 $8,254,000 Total liabilities and stockholders' equity Required: Determine the following measures for 20Y2, rounding to one decimal place, except dollar amounts which should be rounded to the nearest cent. Use the rounded answer of the requirement for subsequent requirement, if required. Assume 365 days a year. 1. Working capital 1,584,000 2. Current ratio 2.8 3. Quick ratio 2.2 4. Accounts receivable turnover 20.0 18.3 days 5. Number of days' sales in receivables 6. Inventory turnover 7. Number of days' sales in inventory 15.0 24.3 days 8. Ratio of fixed assets to long-term liabilities 1.8 1.87 9. Ratio of liabilities to stockholders' equity 0.8 10. Times interest earned 8.7 11. Asset turnover 1.3 12. Return on total assets 6.9 X % 12.8 % 13. Return on stockholders' equity 14. Return on common stockholders' equity 13.3 % 15. Earnings per share on common stock $ 5.9 16. Price-eamings ratio 14 17. Dividends per share of common stock $ 1 18. Dividend yield 1.2 Feedback Check My Work 1. Subtract current liabilities from current assets. 2. Divide current assets by current liabilities. 3. Divide quick assets by current liabilities. Quick assets are cash, temporary investments, and receivables. 4. Divide sales by average accounts receivable. Average Accounts receivable = (Beginning Net Accounts Receivable + Ending Net Accounts Receivable) = 2. 5. Divide average accounts receivable by average daily sales. Average Accounts receivable = (Beginning Net Accounts Receivable + Ending Net Accounts Receivable) = 2. Average daily sales are sales divided by 365 days. 6. Divide cost of merchandise sold by average merchandise inventory. Average Inventory = (Beginning Inventories + Ending Inventories) = 2. 7. Divide average inventory by average daily cost of merchandise sold. Average Inventory = (Beginning Inventories + Ending Inventories) = 2. Average daily cost of merchandise sold is cost of merchandise sold divided by 365 days. 8. Divide property, plant, and equipment (net) by long-term liabilities. 9. Divide total liabilities by total stockholders' quity. 10. Divide the sum of income before income tax and interest expense by interest expense. 11. Divide sales by average total assets, excluding long-term investments. Average Total Assets = (Beginning Total Assets + Ending Total Assets) = 2 12. Divide the sum of net income plus interest expense by average total assets. Average Total Assets = (Beginning Total Assets + Ending Total Assets) = 2 13. Divide net income by average total stockholders' equity. Average Total Stockholders' Equity = (Beginning Total Stockholders' Equity + Ending Total Stockholders' Equity) : 2 14. Divide net income minus preferred dividends from the retained earnings statement by average common stockholders' equity. Common Stockholders' Equity = Common Stock + Retained Earnings. Average common stockholders' equity = (Beginning Common Stockholders' Equity + Ending Common Stockholders' Equity) = 2 15. Divide net income minus preferred dividends from the retained earnings statement by common shares outstanding (common stock = par value). 16. Divide common market share price by common earnings per share (use answer from requirement 15). 17. Divide common dividends (from Retained Earnings Statement) by common shares outstanding common stock - par value). 18. Divide common dividends per share (use answer from requirement 17) by market share price