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

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 $ 3511 $ 2938 Accounts receivable 6744 5384 Inventory 2573 3220 CURRENT ASSETS $ 12828 $ 11542 Fixed assets Gross $ 22478 $ 24360 Accumulated deprec. (12146) (13177) Net $ 10332 $ 11183 TOTAL ASSETS $ 23160 $ 22725 LIABILITIES Accounts payable $ 1595 $ 1719 Accruals 275 438 CURRENT LIABILITIES $ 1870 $ 2157 Long-term debt $ 7112 $ 6002 Equity 14178 14566 TOTAL CAPITAL $ 21290 $ 20568 TOTAL LIABILITIES AND EQUITY $ 23160 $ 22725 Axtel Company Income Statement For the period ended 12/31/X1 ($000) Sales $ 36226 COGS 19721 Gross margin $ 16505 Expense $ 11072 EBIT $ 5433 Interest 713 EBT $ 4720 Tax 1605 Net income $ 3115 In addition, Axtel retired stock for $1,000,000 and paid a dividend of $1,727,000. Depreciation for the year was $1,031,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 fill in the blank 1 Quick Ratio fill in the blank 2 Average Collection Period (ACP) fill in the blank 3 days Inventory Turnover (using COGS) fill in the blank 4 x Inventory Turnover (using sales) fill in the blank 5 x Fixed Asset Turnover fill in the blank 6 x Total Asset Turnover fill in the blank 7 x Debt Ratio fill in the blank 8 % Debt to Equity Ratio fill in the blank 9 Times Interest Earned (TIE) fill in the blank 10 x Cash Coverage fill in the blank 11 Fixed Charge Coverage fill in the blank 12 x EBITDA Coverage fill in the blank 13 x Return on Sales fill in the blank 14 % Return on Assets fill in the blank 15 % Return on Equity fill in the blank 16 % Price Earnings Ratio (P/E) fill in the blank 17 Market to Book Value Ratio fill in the blank 18

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

Ethics In Finance Case Studies From A Womans Life On Wall Street

Authors: Kara Tan Bhala

1st Edition

3030737535, 978-3030737535

More Books

Students also viewed these Finance questions