Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Accounts payable Accruals CURRENT LIABILITIES Long-term debt Equity TOTAL CAPITAL TOTAL LIABILITIES AND EQUITY Axtel Company Income Statement For the period ended 12/31/X1 ($000) Sales

image text in transcribedimage text in transcribedimage text in transcribed

Accounts payable Accruals CURRENT LIABILITIES Long-term debt Equity TOTAL CAPITAL TOTAL LIABILITIES AND EQUITY Axtel Company Income Statement For the period ended 12/31/X1 ($000) Sales COGS Gross margin Expense EBIT Interest EBT Tax Net income $36179 19637 $16542 $ 11156 $5386 713 $ 4673 1605 $3068 $ 1549 255 1804 $ 7112 14244 $ 21356 $ $ 23160 LIABILITIES $ $ 1700 438 2138 $ 6002 14585 20587 $ $ 22725 Axtel Company has the following financial statements. Axtel Company Balance Sheet For the period ended 12/31/X1 ($000) ASSETS Cash Accounts receivable Inventory CURRENT ASSETS Fixed assets Gross Accumulated deprec. Net TOTAL ASSETS 12/31/X0 3507 6917 2573 $ 12997 $ $ $ $ 22478 (12315) 10163 23160 12/31/X1 $ 2948 5470 3220 $ 11638 $ $ $ 24360 (13273) 11087 22725 In addition, Axtel retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $958,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) 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 5.44 3.94 54.43 days 6.10 X 11.24 x X 3.26 X 1.59 X 35.82 % 0.41 7.55 X 8.90 26.41 X x 26.41 X X 8.48% 13.50 % 21.04% 11.88 2.50

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

Clever Girl Finance Learn How Investing Works Grow Your Money

Authors: Bola Sokunbi

1st Edition

1119696739, 978-1119696735

More Books

Students also viewed these Finance questions