Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is all that is provided:) this is all that is given to me is an excel chart, does this help. Current Labilities Current Assets
this is all that is provided:) this is all that is given to me is an excel chart, does this help. Current Labilities Current Assets = Calculated Value 1. Working capital: Ratio Numerator Denomirtier Calculated Value 2. Current ratio 3. Quick ratio 4. Accounts receivable tumover 5. Number of days sales in receivables 6. Inventory tumover 7. Number of days' sales in inventory DITUTUL LIITTO MALL DIN 8. Ratio of Fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders' equity 10. Times interest eamed 11. Asset tumover 12. Retum on total assets 10. Times interest eamed 11. Asset tumover 12 Retum on total assets 13. Retum on stockholders! equity 14. Retum on common stockholders' equity HITTOO LINE UNUTTON + 15. Eamings per share on common stock 16. Price-eamings ratio 17. Dividends per share of common stock 18. Dividend yield instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. Current Uabilities Current Assets Calculated Value 1. Working capital Ratio Numerator Denominator Calculated Value 2. Current ratio 3. Quick ratio 4. Accounts receivable tumover 5. Number of days' sales in receivables 6. Inventory tumover ITUTT 7. Number of days' sales in inventory MATI TUNNUD 8 Ratio of Fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders' equity 10. Times interest oamed 11. Asset tumover 6. Inventory tumover 7. Number of days' sales in inventory 8. Ratio of Fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders' equity 10. Times interest eamed 11. Asset tumover 12. Return on total assets IN ULTTULIT TIL TUDNI TI | | | DIII II II DI 13 Retum on stockholders' equity 14. Retum on common stockholders' equity 15. Eamings per share on common stock 16. Price-eamings ratio 17. Dividends per share of common stock 18. Dividend yield Stargel Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2012 and 2041 20Y2 Retained earnings, January 1. Net income $5,375,000 900,000 $6,275,000 20Y1 $4,545,000 925,000 $5,470,000 Total Dividends: On preferred stock On common stock. Total dividends. Retained earnings, December 31 S 45,000 50,000 $ 95,000 $6,180,000 45,000 50,000 $ 95.000 $5,375,000 Sales Cost of goods sold. Gross profit Selling expenses Administrative expenses Total operating expenses Income from operations Other income Stargel Inc. Comparative Income Statement For the Years Ended December 31, 2012 and 2041 20Y2 $10,000,000 5,350,000 $14,650.000 $ 2,000,000 1,500,000 $ 3,500,000 5 1.150.000 150,000 $ 1,300,000 170,000 $ 1.130,000 230,000 $ 900,000 2011 $9,400.000 4,950,000 $4.450.000 $1,880,000 1410,000 $3.290,000 $1,160,000 140,000 $1,300,000 150,000 $1,150,000 225,000 $925.000 Other expense interest) Income before income tax Income tax expense. Net income Stargel Inc. Comparative Balance Sheet December 31, 20Y2 and 2041 20Y2 20Y1 $ 500,000 1,010,000 740,000 1,190,000 250,000 $3,690,000 2.350,000 3.740,000 $9,780,000 $ 400,000 1,000,000 510,000 950,000 229,000 $3,089.000 2,300,000 3,366,000 $8.755,000 Assets Current assets: Cash Marketable securities Accounts receivable (net) Inventories Prepaid expenses Total current assets. Long-term investments Property, plant, and equipment (net) Total assets Liabilities Current liabilities. Long-term liabilities: Mortgage note payable, 10%. Bonds payable, 10% Total long-term liabilities Total Habilities Stockholders' Equity Preferred $0.90 stock. $10 par Common stock. $5 par Retained earnings. Total stockholders' equity. Total liabilities and stockholders' equity.... $ 900,000 S880,000 $ 200,000 1,500,000 $1,700,000 $2.600,000 s 1.500.000 $1.500,000 $2,380,000 . . S 500,000 500,000 6,180,000 $7,180,000 $9.780,000 S 500,000 500,000 5,375,000 $6,375,000 $8.755.000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started