Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 3-13 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 3481 2922

image text in transcribedimage text in transcribedimage text in transcribed

Problem 3-13 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 3481 2922 Accounts receivable 6994 5318 Inventory 2573 3220 CURRENT ASSETS $ 13048 $ 11460 $ Fixed assets Gross $ $ Accumulated deprec. 22478 (12366) 10112 24360 (13095) 11265 Net $ $ TOTAL ASSETS $ 23160 $ 22725 $ $ Accounts payable Accruals LIABILITIES 1551 212 1763 1738 386 2124 CURRENT LIABILITIES $ $ $ Long-term debt Equity TOTAL CAPITAL 7112 14285 21397 6002 14599 $ $ 20601 TOTAL CAPITAL # 21397 $ 20601 TOTAL LIABILITIES AND EQUITY $ 23160 $ 22725 Axtel Company Income Statement For the period ended 12/31/X1 ($000) Sales $36152 COGS 20331 Gross margin $ 15821 Expense $ 10462 EBIT $ 5359 Interest EBT 713 $4646 Tax 1605 Net income $ 3041 In addition, Axtel retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $729,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 I da days 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 EBITDA Coverage 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 Accounting questions