In: Finance
The Garvey Company has the following financial statements.
| Garvey Company | ||||||
| Balance Sheet | ||||||
| For the period ended 12/31/X1 ($000) | ||||||
| ASSETS | ||||||
| 12/31/X0 | 12/31/X1 | |||||
| Cash | $ | 3547 | $ | 2855 | ||
| Accounts receivable | 6579 | 5217 | ||||
| Inventory | 2573 | 3220 | ||||
| CURRENT ASSETS | $ | 12699 | $ | 11292 | ||
| Fixed assets | ||||||
| Gross | $ | 22478 | $ | 24360 | ||
| Accumulated deprec. | (12017) | (12927) | ||||
| Net | $ | 10461 | $ | 11433 | ||
| TOTAL ASSETS | $ | 23160 | $ | 22725 | ||
| LIABILITIES | ||||||
| Accounts payable | $ | 1577 | $ | 1710 | ||
| Accruals | 233 | 380 | ||||
| CURRENT LIABILITIES | $ | 1810 | $ | 2090 | ||
| Long-term debt | $ | 7112 | $ | 6002 | ||
| Equity | 14238 | 14633 | ||||
| TOTAL CAPITAL | $ | 21350 | $ | 20635 | ||
| TOTAL LIABILITIES AND EQUITY | $ | 23160 | $ | 22725 | ||
| Garvey Company | |||
| Income Statement | |||
| For the period ended 12/31/X1 | |||
| ($000) | |||
| Sales | $ | 36233 | |
| COGS | 20315 | ||
| Gross margin | $ | 15918 | |
| Expense | $ | 10478 | |
| EBIT | $ | 5440 | |
| Interest | 713 | ||
| EBT | $ | 4727 | |
| Tax | 1605 | ||
| Net income | $ | 3122 | |
In addition, Garvey retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $910,000. Calculate the ratios for the Garvey Company. Assume Garvey had leasing costs of $7,267,000 and amortization of $1,416,000 in 20X1, and had 1268000 shares of stock outstanding that were valued at $28.75 per share at year end. The firm must also make principal repayments of $1,012,000 on its outstanding debt this year. Assume 360 days in a year. Round your answers to two decimal places.
| Current Ratio | |
| Quick Ratio | |
| Average Collection Period (ACP) | days |
| Inventory Turnover (using COGS) | x |
| Inventory Turnover (using sales) | x |
| Fixed Asset Turnover | x |
| Total Asset Turnover | x |
| Debt Ratio | % |
| Debt to Equity Ratio | |
| Times Interest Earned (TIE) | x |
| Cash Coverage | |
| Fixed Charge Coverage | x |
| EBITDA Coverage | x |
| Return on Sales | % |
| Return on Assets | % |
| Return on Equity | % |
| Price Earnings Ratio (P/E) | |
| Market to Book Value Ratio |