Holooly Plus Logo
Holooly Plus Logo

Question 3.5: Take a look at the most recent numbers reported for Cost of ...

Take a look at the most recent numbers reported for Cost of Sales/Inventory and EBIT/ Interest in Table 3.13.

TABLE 3.13 Selected Ratios
Manufacturing—Wineries (NAICS 312130)
COMPARATIVE HISTORICAL DATA CURRENT DATA SORTED BY SALES
Type of Statement
38 33 29 Unqualified 1 2 4 22
40 53 41 Reviewed 2 15 15 9
17 15 12 Compiled 1 2 3 3 2 1
24 25 26 Tax Returns 11 6 4 4 1
100 150 150 Other 24 35 20 18 26 27
4/1/13– 3/31/14 ALL 219 4/1/14– 3/31/15 ALL 276 4/1/15– 3/31/16 ALL 258 NUMBER OF STATEMENTS 31 (4/1–9/30/15) 227 (10/1/15–3/31/16)
0–1MM 37 1–3MM 45 3–5MM 27 5–10MM 42 10–25MM 48 25MM & OVER 59
Ratios
4.0 4.5 4.0 Current 4.1 5.8 5.9 3.8 2.4 3.4
2.1 2.0 2.1 2.7 2.3 3.3 2.3 1.5 1.9
1.4 1.4 1.4 1.4 1.5 1.8 1.8 1.2 1.3
.9 .9 .9 Quick 1.2 1.1 1.9 1.2 .6 .7
.3 .3 .3 .3 .3 .5 .4 .3 .4
.2 .2 .2 .1 .2 .2 .2 .1 .2
16    23.0 15    24.8 15    23.7 Sales/
Receivables		 0     UND 7   49.3 11     32.8 16    22.4 21   17.2 28    13.1
30  12.2 34  10.6 31            11.8 10   35.6 28    12.9 20   18.3 29    12.6 37    9.8 41    8.9
51   7.1 52   7.0 52    7.0 46    7.9 50    7.3 39    9.4 57   6.4 56    6.5 59    6.2
261    1.4 332     1.1 304    1.2 Cost of Sales/
Inventory		 192   1.9 304     1.2 261   1.4 304    1.2 365    1.0 261     1.4
456    .8 521    .7 521    .7 608     .6 608     .6 608     .6 608    .6 521    .7 365    1.0
730    .5 912    .4 730   .5 912    .4 912   .4 730   .5 730   .5 730    .5 608    .6
25    14.4 26   14.0 21    17.3 Cost of Sales/
Payables		 0  UND 10   36.2 21    17.2 23    16.0 36     10.1 23     16.1
55   6.6 59    6.2 51    7.2 48    7.6 53    6.9 35   10.3 47     7.8 69    5.3 51    7.2
101   3.6 122    3.0 107     3.4 166   2.2 146   2.5 70    5.2 122    3.0 122   3.0 76    4.8
1.4 1.3 1.3 Sales/Working
Capital		 1.2 1.2 1.1 1.3 2.0 1.9
2.7 2.4 2.6 2.0 2.8 2.3 2.1 3.7 2.9
6.6 5.1 2.5 7.8 5.8 4.0 2.8 6.7 6.0
9.7 11.4 14.3 EBIT/Interest 4.5 7.9 31.5 12.3 13.0 19.9
(200)  3.9 (252)  4.7 (235)  3.7 (31)  1.0 (36)  3.6 (25)  9.0 (40)  2.3 (46)  4.1 (57)  5.7
1.4 1.7 1.3 -2.1 1.2 2.1 1.1 1.2 2.8
8.0 9.1 9.5 Net Profit +
Depr., Dep,.
Amort./Cur.
Mat. L/T/D		 6.9 17.3
(42)   4.8 (55)  5.0 (45)  5.9 (10)  3.5 (24)  7.7
1.9 2.6 2.6 1.8 4.3
.3 .2 .2 Fixed/Worth .2 .2 .1 .4 .2 .3
.8 .7 .7 .6 .7 .4 1.0 .8 .8
1.6 1.4 1.5 4.5 1.5 1.1 1.5 1.9 1.3
.6 .6 .6 Debt/Worth .5 .5 .4 .6 1.2 .8
1.5 1.4 1.4 2.6 1.0 1.2 1.4 2.1 1.1
4.1 3.0 3.9 24.2 2.7 4.3 2.8 4.3 3.2
32.8 33.9 32.7 % Profit Before
Taxes/Tangible
Net Worth		 34.2 25.0 47.0 20.0 42.2 27.9
(194)  14.8 (253)  15.6 (230)  13.6 (29)  5.5 (41)   11.8 (25)  20.5 (38)  7.4 (43)   19.6 (54)  18.3
2.7 3.3 2.7 -8.9 4.6 3.3 0.4 3.7 10.2

What are the overall median values? What are these ratios?

The "Step-by-Step Explanation" refers to a detailed and sequential breakdown of the solution or reasoning behind the answer. This comprehensive explanation walks through each step of the answer, offering you clarity and understanding.
Our explanations are based on the best information we have, but they may not always be right or fit every situation.
The blue check mark means that this solution has been answered and checked by an expert. This guarantees that the final answer is accurate.
Learn more on how we answer questions.
This Question has been Answered.
Subscribe
Already have an account?
Login

Related Answered Questions

Question: 3.S-TP.1

Sources and Uses of Cash Consider the following balance sheets for the Philippe Corporation. Calculate the changes in the various accounts and, where applicable, identify the change as a source or use of cash. What were the major sources and uses of cash? Did the company become more or less liquid ...

Verified Answer:

We’ve filled in the answers in the following table...
Question: 3.S-TP.3

Financial Ratios Based on the balance sheets and income statement in the previous two problems, calculate the following ratios for 2018: ...

Verified Answer:

We’ve calculated the following ratios based on the...
Question: 3.S-TP.2

Common-Size Statements Here is the most recent income statement for Philippe. Prepare a common-size income statement based on this information. How do you interpret the standardized net income? What percentage of sales goes to cost of goods sold? ...

Verified Answer:

We’ve calculated the common-size income statement ...
Question: 3.S-TP.4

ROE and the DuPont Identity Calculate the 2018 ROE for the Philippe Corporation and then break down your answer into its component parts using the DuPont identity. ...

Verified Answer:

The return on equity is the ratio of net income to...
Question: 3.2

Here is a variation on the receivables collection period. How long, on average, does it take for Prufrock Corporation to pay its bills? To answer, we need to calculate the accounts payable turnover rate using cost of goods sold. We will assume that Prufrock purchases everything on credit. ...

Verified Answer:

The cost of goods sold is $1,344, and accounts pay...
Question: 3.4

Because ROE and ROA are usually intended to measure performance over a prior period, it makes a certain amount of sense to base them on average equity and average assets, respectively. For Prufrock, how would you calculate these? ...

Verified Answer:

We first need to calculate average assets and aver...
Question: 3.3

Suppose you find that a particular company generates $.40 in sales for every dollar in total assets. How often does this company turn over its total assets? ...

Verified Answer:

The total asset turnover here is .40 times per yea...
Question: 3.1

Suppose a firm pays off some of its suppliers and short-term creditors. What happens to the current ratio? Suppose a firm buys some inventory. What happens in this case? What happens if a firm sells some merchandise? ...

Verified Answer:

The first case is a trick question. What happens i...