Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 $ 3463 $ 2909

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 $ 3463 $ 2909
Accounts receivable 6548 5906
Inventory 2573 3220
CURRENT ASSETS $ 12584 $ 12035
Fixed assets
Gross $ 22478 $ 24360
Accumulated deprec. (11902) (13670)
Net $ 10576 $ 10690
TOTAL ASSETS $ 23160 $ 22725
LIABILITIES
Accounts payable $ 1581 $ 1692
Accruals 260 393
CURRENT LIABILITIES $ 1841 $ 2085
Long-term debt $ 7112 $ 6002
Equity 14207 14638
TOTAL CAPITAL $ 21319 $ 20640
TOTAL LIABILITIES AND EQUITY $ 23160 $ 22725

Axtel Company
Income Statement
For the period ended 12/31/X1
($000)
Sales $ 36269
COGS 19717
Gross margin $ 16552
Expense $ 11076
EBIT $ 5476
Interest 713
EBT $ 4763
Tax 1605
Net income $ 3158

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

2. Identify the call to adventure in Rocky.

Answered: 1 week ago

Question

6. Have you used solid reasoning in your argument?

Answered: 1 week ago