Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Comprehensive Ratio Analysis Tuxedo Corporation's condensed comparative income statements and balance sheets follow. All figures are given in thousands of dollars, except earnings per share.

Comprehensive Ratio Analysis

Tuxedo Corporation's condensed comparative income statements and balance sheets follow. All figures are given in thousands of dollars, except earnings per share.

Tuxedo Corporation
Comparative Income Statements
For the Years Ended December 31, 2014 and 2013
2014 2013
Net sales $800,400 $742,600
Cost of goods sold 454,100 396,200
Gross margin $346,300 $346,400
Operating expenses:
Selling expenses $130,100 $104,600
Administrative expenses 140,300 115,500
Total operating expenses $270,400 $220,100
Income from operations $ 75,900 $126,300
Interest expense 25,000 20,000
Income before income taxes $ 50,900 $106,300
Income taxes expense 14,000 35,000
Net income $ 36,900 $ 71,300
Earnings per share $ 2.46 $ 4.76
Tuxedo Corporation
Comparative Balance Sheets
For the Years Ended December 31, 2014 and 2013
2014 2013
Assets
Cash $ 31,100 $ 27,200
Accounts receivable (net) 72,500 42,700
Inventory 122,600 107,800
Property, plant, and equipment (net) 577,700 507,500
Total assets $803,900 $685,200
Liabilities and Stockholders' Equity
Accounts payable $104,700 $ 72,300
Notes payable (short-term) 50,000 50,000
Bonds payable 200,000 110,000
Common stock, $10 par value 300,000 300,000
Retained earnings 149,200 152,900
Total liabilities and stockholders' equity $803,900 $685,200
Additional data for Tuxedo in 2014 and 2013 follow.
2014 2013
Net cash flows from operating activities $64,000 $99,000
Net capital expenditures $119,000 $38,000
Dividends paid $31,400 $35,000
Number of common shares 30,000 30,000
Market price per share $80 $120

Balances of selected accounts at the end of 2012 were accounts receivable (net), $52,700; inventory, $99,400; accounts payable, $64,800; total assets, $647,800; and stockholders' equity, $376,600. All of the bonds payable were long-term liabilities. Assume 365 days in a year.

Note: For all parts below, round percentages and ratios to one decimal place. When determining whether each ratio improved or deteriorated from 2013 to 2014, consider the ratio changes of .1 or less to be neutral and select "Neutral" from the selection box.

1. Prepare an operating asset management analysis by calculating for each year the (a) current ratio, (b) quick ratio, (c) receivable turnover, (d) days' sales uncollected, (e) inventory turnover, (f) days' inventory on hand, (g) payables turnover, (h) days' payable, and (i) financing period. After making the calculations, indicate whether each ratio improved or deteriorated from 2013 to 2014.

Ratio 2014 2013 Favorable or Unfavorable Change
a. Current ratio: times times SelectFavorableUnfavorableNeutralItem 3
b. Quick ratio: times times SelectFavorableUnfavorableNeutralItem 6
c. Receivable turnover: times times SelectFavorableUnfavorableNeutralItem 9
d. Days' sales uncollected: days days SelectFavorableUnfavorableNeutralItem 12
e. Inventory turnover: times times SelectFavorableUnfavorableNeutralItem 15
f. Days' inventory on hand: days days SelectFavorableUnfavorableNeutralItem 18
g. Payables turnover: times times SelectFavorableUnfavorableNeutralItem 21
h. Days' payable: days days SelectFavorableUnfavorableNeutralItem 24
f. Financing period: days days SelectFavorableUnfavorableNeutralItem 27

2. Prepare a profitability and total asset management analysis by calculating for each year the (a) profit margin, (b) asset turnover, and (c) return on assets. After making the calculations, indicate whether each ratio improved or deteriorated from 2013 to 2014.

Ratio 2014 2013 Favorable or Unfavorable Change
a. Profit margin: % % SelectFavorableUnfavorableNeutralItem 30
b. Asset turnover: times times SelectFavorableUnfavorableNeutralItem 33
c. Return on assets: % % SelectFavorableUnfavorableNeutralItem 36

3. Prepare a financial risk analysis by calculating for each year the (a) debt to equity ratio, (b) return on equity, and (c) Interest Coverage Ratio. After making the calculations, indicate whether each ratio improved or deteriorated from 2013 to 2014.

Ratio 2014 2013 Favorable or Unfavorable Change
a. Debt to equity ratio: times times SelectFavorableUnfavorableNeutralItem 39
b. Return on equity: % % SelectFavorableUnfavorableNeutralItem 42
c. Interest coverage ratio: times times SelectFavorableUnfavorableNeutralItem 45

4. Prepare a liquidity analysis by calculating for each year the (a) cash flow yield, (b) cash flows to sales, (c) cash flows to assets, and (d) free cash flow. After making the calculations, indicate whether each ratio improved or deteriorated from 2013 to 2014. If required, use the minus sign to indicate a negative free cash flow.

Ratio 2014 2013 Favorable or Unfavorable Change
a. Cash flow yield: times times SelectFavorableUnfavorableNeutralItem 48
b. Cash flows to sales: % % SelectFavorableUnfavorableNeutralItem 51
c. Cash flows to assets: % % SelectFavorableUnfavorableNeutralItem 54
d. Free cash flow: $ $ SelectFavorableUnfavorableNeutralItem 57

5. Prepare an analysis of market strength by calculating for each year the (a) price/earnings (P/E) ratio and (b) dividends yield. After making the calculations, indicate whether each ratio improved or deteriorated from 2013 to 2014. For dividends yield, round intermediate calculations to the nearest cent.

Ratio 2014 2013 Favorable or Unfavorable Change
a. Price/earnings ratio: times times SelectFavorableUnfavorableNeutralItem 60
b. Dividends yield: % % SelectFavorableUnfavorableNeutralItem 63

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

Financial Accounting

Authors: Michael J. Jones

1st Edition

0470058986, 978-0470058985

More Books

Students also viewed these Accounting questions

Question

a. Where is the person employed?

Answered: 1 week ago