Axtel Company
Balance Sheet
For the period ended 12/31/X1 ($000)
				ASSETS
		12/31/X0			12/31/X1
Cash		$	3550		$	2888
Accounts receivable			6614			5157
Inventory			2573			3220
CURRENT ASSETS		$	12737		$	11265
Fixed assets
Gross		$	22478		$	24360
Accumulated deprec.			(12055)			(12900)
Net		$	10423		$	11460
TOTAL ASSETS		$	23160		$	22725
				LIABILITIES
Accounts payable		$	1597		$	1659
Accruals			280			419
CURRENT LIABILITIES		$	1877		$	2078
Long-term debt		$	7112		$	6002
Equity			14171			14645
TOTAL CAPITAL		$	21283		$	20647
TOTAL LIABILITIES AND EQUITY		$	23160		$	22725

Axtel Company
Income Statement
For the period ended 12/31/X1
($000)
Sales		$	36312
COGS			19878
Gross margin		$	16434
Expense		$	10915
EBIT		$	5519
Interest			713
EBT		$	4806
Tax			1605
Net income		$	3201

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

Check My Work