| Financial Statements for Moserk Company |
| Income Statement for year ending December 31st |
| | Year |
| | 20XX |
| Sales (Revenues) | $119,299 |
| Costs and Expenses: |
| Cost of Goods Sold | 93,438 |
| Operating, selling and admin expenses | 9,358 |
| Interest Costs: |
| Debt | 555 |
| Capital leases | 229 |
| Total Costs and Expenses | 103,580 |
| Income Before Income Taxes | 15,719 |
| Taxes | 4,716 |
| Net Income | $11,003 |
| ______________________________________________________________________________ |
| Balance Sheetfor year ending December 31st |
| | 20XX |
| Assets |
| Current Assets: |
| Cash and cash equivalents | $1,447 |
| Receivables | 976 |
| Inventories | 16,497 |
| Prepaid expenses and other | 432 |
| Total Current Assets | 19,352 |
| Property, Plant and Equipment, net | 21,469 |
| Property under Capital Lease, net | 2,137 |
| Other Assets and Deferred Charges | 2,426 |
| Total Assets | $45,384 |
| Liabilities and Shareholders' Equity |
| Current Liabilities: |
| Total Current Liabilities | $14,460 |
| Long-Term Debt | 7,191 |
| Long-Term Obligations Under Capital Leases | 2,483 |
| Deferred Income Taxes and Other | 809 |
| Total Long-term Liabilities | $10,483 |
| Total Liabilities | $24,943 |
| Shareholders' Equity |
| Private Common stock ($.10 par value; 2,241 |
| issued and outstanding) | $224 |
| Capital in excess of par value | 585 |
| Retained earnings | 19,632 |
| Total Shareholders' Equity | 20,441 |
| Total Liabilities and Shareholders' Equity | $45,384 |
| | | Industry |
| | | Average |
| Ratios to be calculated (show work) |
| Current Ratio | | 2.10 |
| Quick Ratio | | 0.75 |
| Gross Profit Margin | | 25.00% |
| Net Profit Margin | | 10.00% |
| Debt Ratio (Debt to assets) | | 0.45 |
| Debt Ratio (Debt to equity) | | 1.20 |
| Times Interest Earned | | 15.00 |
| ROA | | 14.50% |
| ROE | | 28.75% |
helpmepass
FIN375_Week5_Ratio_Analysis_problem_Template.xls
