a spreedsheet is needed to complete for this question. PR17-04b from Cegage accounting 2 (financial statement analysis) ### Stargel Inc. Financial Overview**Comparative Retained Earnings Statement for the Years Ended December 31, 2012 and 2011**- **2012 Financials**: - Net income: $960,000 - Retained earnings (January 1): $5,375,000 - Total dividends: $45,000 - Preferred stock dividends: $10,000 - Common stock dividends: $35,000 - Retained earnings (December 31): $6,290,000- **2011 Financials**: - Net income: $925,000 - Retained earnings (January 1): $4,945,000 - Total dividends: $50,000 - Preferred stock dividends: $10,000 - Common stock dividends: $40,000 - Retained earnings (December 31): $5,375,000---**Comparative Income Statement for the Years Ended December 31, 2012 and 2011**- **Sales**: - 2012: $10,000,000 - 2011: $9,000,000- **Cost of Goods Sold**: - 2012: $5,350,000 - 2011: $4,950,000- **Gross Profit**: - 2012: $4,650,000 - 2011: $4,050,000- **Operating Expenses**: - Selling expenses: $1,150,000 (2012), $1,200,000 (2011) - Administrative expenses: $1,550,000 (2012), $1,100,000 (2011) - Total operating expenses: $2,700,000 (2012), $2,300,000 (2011)- **Income from Operations**: - 2012: $1,950,000 - 2011: $1,750,000- **Other Revenue**: - 2012: $190,000 - 2011: $180,000- **Other Expense (Interest)**: - 2012: $130,000 - 2011: $150,000- **Income Before Income Tax** ## Financial Statement Analysis### Ratios and Calculations1. **Working Capital** 2. **Current Ratio**3. **Quick Ratio**4. **Accounts Receivable Turnover**5. **Number of Days' Sales in Receivables**6. **Inventory Turnover** 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 Earned**11. **Asset Turnover**12. **Return on Total Assets**13. **Return on Stockholders’ Equity**14. **Return on Common Stockholders’ Equity**15. **Earnings per Share on Common Stock**16. **Price-Earnings Ratio**17. **Dividends per Share of Common Stock**18. **Dividend Yield**### Diagram ExplanationThe image features a table layout with blank spaces to input values for various financial ratios and metrics. Each row corresponds to a specific financial metric listed above, allowing users to organize their financial data systematically for analysis.This table can be utilized to input and calculate key financial indicators, helping users to explore different aspects of financial performance such as liquidity, profitability, and efficiency.

As posted multiple sub parts we are answering only first three sub parts kindly repost the…

877 Stargel Inc. Comparative Income Statement the Years Ended December 31, 20Y2 and 20Y1 20Υ2 20Υ1 Sales...... $10,000,000 $9,400,000 Cost of goods sold. Gross profit Selling expenses. Administrative expenses. 5,350,000 $ 4,650,000 $ 2,000,000 4,950,000 $4,450,000 $1,880,000 Total operating expenses Income from operations Other revenue. 1,500,000 $ 3,500,000 $ 1,150,000 150,000 $ 1,300,000 1,410,000 $3,290,000 $1,160,000 140,000 $1,300,000 Other expense (interest) Income before income tax Income tax expense. Net income. 170,000 $ 1,130,000 150,000 $1,150,000 230,000 225,000 $ 900,000 $ 925,000 Stargel Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 20Υ1 Assets Current assets: Cash $ 500,000 1,010,000 $ 400,000 Marketable securities. 1,000,000 Accounts receivable (net) 740,000 510,000 Inventories... 1,190,000 950,000 Prepaid expenses 250,000 $3,690,000 2,350,000 229,000 Total current assets. $3,089,000 Long-term investments. Property, plant, and equipment (net) Total assets. 2,300,000 3,740,000 $9,780,000 3,366,000 $8,755,000 Liabilities Current liabilities.. $ 900,000 $ 880,000 Long-term liabilities: Mortgage note payable, 10%. Bonds payable, 10%. Total long-term liabilities Total liabilities $ 200,000 1,500,000 1,500,000 $1,700,000 $2,600,000 $1,500,000 $2,380,000 Stockholders' Equity Preferred $0.90 stock, $10 par.. Common stock, $5 par. Retained earnings. Total stockholders' equity.. Total liabilities and stockholders' equity. $ 500,000 $ 500,000 500,000 500,000 6,180,000 $7,180,000 5,375,000 $6,375,000 $8,755,000 $9,780,000 Instructions Determine the following measures for 20Y2, rounding to one decimal place including percentages, except for per-share amounts: 1. Working capital 2. Current ratio 3. Quick ratio 1. Accounts receivable turnover 5. Number of days' sales in receivables (Continued) PR 17-4B Measures of liquidity, solvency and profitability Stargel common stock was $119.70 on December 31, 20Y2. The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1 Retained earnings, January Net income Total Dividends: Preferred stock dividends. Common stock dividends. Total dividends........ Retained earnings, December 31