Axtel Company has the following financial statements. Axtel Company Balance...

80.2K

Verified Solution

Question

Accounting

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 & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students