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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started