Question
7-12) Data for Argils Textiles2014 financial statements are given in Tables 7.1 and 7.2 in the chapter. a) Compute the 2014 values of the following
7-12) Data for Argils Textiles2014 financial statements are given in Tables 7.1 and 7.2 in the chapter.
a) Compute the 2014 values of the following ratios:
2014 Values | ||
Ratio | Argile | Industry |
Current ratio | 3.9x | |
Days sales outstanding | 33.5 days | |
Inventory turnover | 7.2x | |
Fixed assets turnover | 4.1x | |
Debt ratio | 43.0% | |
Net profit margin | 4.6% | |
Return on assets | 9.9% |
b) Briefly comment on Argiles 2014 financial position. Can you see any obvious strengths or weaknesses?
c)Compare Argiles 2014 ratios with its 2015 ratios, which are presented in Table 7-6. Comment on whether you believe Argiles fincial position improved or deriorated ruring 2015.
d) What other information would be useful for projecting whether Argiles financial position is expected to improve or deteriorate in the future?
TABLE 1 Argile Textiles: December 31 Comparative Balance Sheet ($million)
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
TABLE 2: Argile Textiles: Income Statement for Years Ending December 31 ($ million, except per-share data) | |||||||||
2015 | 2014 | ||||||||
Amount | Percent of total Assets | Amount | Percent of total assets | ||||||
Net Sales | $750.0 | 100.0% | $700.0 | 100.0% | |||||
Cost of goods sold | (600.0) | 80.0 | (560.0) | 80.0 | |||||
Gross profit | $150.0 | 20.0 | 140.0 | 20.0 | |||||
Fixed operating expenses except depreciation | (55.0)a | 7.3 | (50.0) | 7.1 | |||||
Earnings before interest, taxes, depreciation and amortization (EBITDA) | $95.0 | 12.7 | $90.0 | 12.9 | |||||
Depreciation | (30.0) | 4.0 | (24.0) | 3.4 | |||||
Net operating income (NOI) | |||||||||
=Earnings before interest and taxes (EBIT) | $65.0 | 8.7 | $66.0 | 9.4 | |||||
Interest | (20.0) | 2.7 | (18.0) | 2.6 | |||||
Earnings before taxes (EBT) | $45.0 | 6.0 | 48.0 | 6.9 | |||||
Taxes (40%) | (18.0) | 2.4 | (19.2) | 2.7 | |||||
Net income | $27.0 | 3.6 | $28.8 | 4.1 | |||||
Preferred dividends b | 0.0 | 0.0 | |||||||
Earnings available to common shareholders (EAC) | $27.0 | $28.8 | |||||||
Common dividends | (14.0) | (13.0) | |||||||
Addition to retained earnings | $13.0 | $15.8 | |||||||
Per-Share Data (11 million shares) | |||||||||
Earnings per share (EPS) = (Net income)/Shares | $2.45 | $2.62 | |||||||
Dividends per share (DPS) | $1.27 | $1.18 | |||||||
=(Common dividends/Shares | |||||||||
a Here, and throughout the text, parentheses are used to denote negative numbers.
b Argile has no preferred stock. The amount of preferred dividends, which is $0, is shown here to indicate that preferred dividends are paid before common dividends.
TABLE 6: Argile Textiles: Summary of 2015 Financial Ratios ($ million, except per-share dollars) | |||||||||
Ratio | Formula for Calculation | Computation | Ratio Value | Industry Average | Comment | ||||
Liquity | |||||||||
Current | = Current assets__ Current liabilities | $235.0 $65.0 | = | 3.6x | 4.1x | Low | |||
Quick, or acid test | = Current assets Inventory Current liabilities | $100.0 $65.0 | = | 1.5x | 2.1x | Low | |||
Asset Management Inventory turnover | = Cost of goods sold Inventory | $600.0 $135.0 | = | 4.4x | 7.4x | Low | |||
Days sales out- standing (DSO) | = Accounts receivable | $90.0 $2.08 | = | 43.2 days | 32.1 days | Poor | |||
Fixed assets turnover | = ___Sales_______ Net fixed assets | $750.0 $190.0 | = | 3.9x | 4.0x | OK | |||
Total assets turnover | = Sales Total assets | $750.0 $425.0 | = | 1.8x | 2.1x | Low | |||
Debt Management Debt-to-total-assets | = Total liabilities Total assets | $217.0 $425.0 | = | 51.1% | 42.0% | Poor | |||
Times interest earned (TIE) | = EBIT________ Interest charges | $65.0 $20.0 | = | 3.3x | 6.5x | Low | |||
Fixed charge coverage | = ____EBIT+ Lease payments Interest Lease Sinking fund payments charges + payments + (1 Tax rate) | $70.0 $31.7 | = | 2.2x | 5.8x | Low | |||
Profitability Net profit margin | = Net income Sales | $27.0 $750.0 | = | 3.6% | 4.9% | Poor | |||
Return on total Assets (ROA) | = Net income Total assets | $27.0 $425.0 | = | 6.4% | 11.5% | Poor | |||
Return of equity (ROE) | =Net income available to common stockholders Common equity | $27.0 $208.0 | = | 13.0% | $17.7 | Poor | |||
Market Value Price/Earnings(P/E) | =Market price per share Earnings per share | $20.00 $2.45 | = | 8.2x | 15.0x | Low | |||
Market/Book (M/B) | =Market price per share Book value per share | $20.00 $18.91 | = | 1.1x | 2.2x | Low |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started