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		$	3,458		$	2,943
Accounts receivable			6,548			5,234
Inventory			2,573			3,220
CURRENT ASSETS		$	12,579		$	11,397
Fixed assets
Gross		$	22,478		$	24,360
Accumulated deprec.			(11,897)			(13,032)
Net		$	10,581		$	11,328
TOTAL ASSETS		$	23,160		$	22,725
				LIABILITIES
Accounts payable		$	1,543		$	1,698
Accruals			271			408
CURRENT LIABILITIES		$	1,814		$	2,106
Long-term debt		$	7,112		$	6,002
Equity			14,234			14,617
TOTAL CAPITAL		$	21,346		$	20,619
TOTAL LIABILITIES AND EQUITY		$	23,160		$	22,725

Axtel Company
Income Statement
For the period ended 12/31/X1
($000)
Sales		$	36,221
COGS			20,446
Gross margin		$	15,775
Expense		$	10,347
EBIT		$	5,428
Interest			713
EBT		$	4,715
Tax			1,605
Net income		$	3,110

In addition, Axtel retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $1,135,000. Calculate the ratios for the Axtel Company. Assume Axtel had leasing costs of $7,267,000 in 20X1, and had 1,268,000 shares of stock outstanding that were valued at $28.75 per share at year end. Assume 360 days in a year. Round your answers to two decimal places.

Current Ratio
Quick Ratio
Average Collection Period (ACP)
Inventory Turnover (using COGS)
Inventory Turnover (using sales)
Fixed Asset Turnover
Total Asset Turnover
Debt Ratio
Debt to Equity Ratio
Times Interest Earned (TIE)
Cash Coverage
Fixed Charge Coverage
Return on Sales
Return on Assets
Return on Equity
Price Earnings Ratio (P/E)
Market to Book Value Ratio

Answer 1

a. Current Ratio
Detail
Current Asset - inventory	$11,397.00
Current liability	$2,106.00
Current ratio	5.41
( Current Asset/ Current Liability)
b. Acid test ratio
Detail
Liquid Asset=Total Current Asset - inventory ( 11397-3220)	$8,177.00
Current liability	$2,106.00
Acid test ratio	3.88
( Liquid Asset/ Current Liability)
c.. Avergae Collection Period
Detail
Inventory Turnover Ratio (using Sales)	12.50
No. of days in a year	360
No. of days sales in receivable	28.80
(No. of days in a year/ Inventory Turnover ratio)
d. Inventory Turnover Ratio ( Using COGS)
Detail
Average Inventory ( Opening Inventory+ Closing Inventory)/2	$2,896.50
( 2573+3220)/2
COGS	$20,446.00
Inventory Turnover ratio ( COGS/ Inventory)	7.1
d. Inventory Turnover Ratio ( Using Sales )
Detail
Average Inventory ( Opening Inventory+ Closing Inventory)/2	$2,896.50
( 2573+3220)/2
Sales	$36,221.00
Inventory Turnover ratio ( Sales Inventory)	12.5
e. Fixed Asset Turnover
Detail
Avergae Fixed Asset	$10,954.50
(11328+10581)/2
Sales	$36,221.00
Fixed Asset Turnover Ratio( Sales/ Average Fixed Asset)	3.3
f. Total Asset Turnover
Detail
Avergae Total Asset	$22,942.50
(22725+23160)/2
Sales	$36,221.00
Total Asset Turnover Ratio( Sales/ Average Total Asset)	1.6
g. Debt Ratio
Detail
Total Liabilities (2106+6002)	$8,108.00
Total Asset	$22,725.00
Debt Ratio( Liabilities/ Asset)	2.8
h. Debt Ratio
Detail
Total Liabilities (2106+6002)	$8,108.00
Total Equity	$14,617.00
Debt Equity Ratio ( Total Liabilities/ Equity)	1.8
i.. Time Interest earned
Detail
Operating Income ( EBIT- Tax)( 5428-1605)	$3,823.00
Interest Expense	$713.00
Times Interst Earned	5.36
( Operating Income/ Interest Expense