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

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_2

Step: 3

blur-text-image_3

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

Energy Audits And Improvements For Commercial Buildings

Authors: Ian M. Shapiro

1st Edition

1119084164, 978-1119084167

More Books

Students also viewed these Accounting questions