Question

Axtel Company has the following financial statements.

Axtel Company
Balance Sheet
For the period ended 12/31/X1 ($000)
				ASSETS
		12/31/X0			12/31/X1
Cash		$	3492		$	2855
Accounts receivable			6984			5617
Inventory			2573			3220
CURRENT ASSETS		$	13049		$	11692
Fixed assets
Gross		$	22478		$	24360
Accumulated deprec.			(12367)			(13327)
Net		$	10111		$	11033
TOTAL ASSETS		$	23160		$	22725
				LIABILITIES
Accounts payable		$	1503		$	1690
Accruals			215			424
CURRENT LIABILITIES		$	1718		$	2114
Long-term debt		$	7112		$	6002
Equity			14330			14609
TOTAL CAPITAL		$	21442		$	20611
TOTAL LIABILITIES AND EQUITY		$	23160		$	22725

Axtel Company
Income Statement
For the period ended 12/31/X1
($000)
Sales		$	36117
COGS			19506
Gross margin		$	16611
Expense		$	11287
EBIT		$	5324
Interest			713
EBT		$	4611
Tax			1605
Net income		$	3006

In addition, Axtel retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $960,000. Calculate the ratios for the Axtel Company. Assume Axtel 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

Answer 1