Question

In: Finance

Clorox and General Mills 2020 Ratios and DuPont Analysis. Company Clorox General Mills Profit Margin 13.97%...

Clorox and General Mills 2020 Ratios and DuPont Analysis.

Company

Clorox

General Mills

Profit Margin

13.97%

12.37%

Days Sales Outstanding

35.19

33.44

Inventory Turnover

14.80

12.36

Fixed Assets Turnover

6.09

4.92

Total Assets Turnover

1.08

0.57

Return on Equity (@ Market Value)

3.56%

5.74%

1.

Which of the following statements about equity multiplier (EM) is INCORRECT?

a.Clorox’s EM indicates that it has more financial leverage than General Mills

b.Adding debt can increase a company’s ROE but will also increase its risk

c.General Mills has a higher proportion of debt than Clorox

d.General Mills’ EM is 0.81

e.The higher a company’s equity multiplier is, the more debt the company has relative to its equity

2.Referring to the DuPont analysis you completed, which of the following statements is INCORRECT?

a.TATO can be increased by increasing fixed assets turnover (FATO) and inventory turnover

b.General Mills has lower return on assets (ROA) than Clorox

c.General Mills has a better ROE than Clorox

d.General Mills’ DuPont analysis indicates that is better than Clorox on every ratio: ROE, PM, TATO and EM

e.Clorox has a slightly higher DSO than General Mills and could lower this by collecting its receivables faster.

3.Which of the following statements about cash flows is INCORRECT?

a.An increase in liabilities will increase cash flow

b.If positive, Free Cash Flow represents the amount of cash that could be withdrawn from a firm without harming its ability to operate and to produce future cash flows

c.The Statement of Cash Flows includes dividends and other financing activities, whereas Free Cash Flow does not

d.The cash flow from “Plant, Property and Equipment” on the Statement of Cash Flows is the same value as CapEx in the free cash flow calculation

e.An increase in CapEx will increase free cash flow

4.Other things held constant, which of the following alternatives would DECREASE a company's cash flow for the current year?

a.Accrue taxes payable

b.Decrease DSO, without affecting sales

c.Issue common stock

d.Decrease long-term debt

e.Increase inventory turnover, without affecting sales

5.If you were an investor in a firm, which of the following would you view NEGATIVELY? In all cases, assume that other things are held constant.

a.The firm’s Profit Margin is 10.5%, whereas the industry average is 10.0%

b.The company’s Times Interest Earned (TIE) is 2x, whereas the industry average is 4x

c.The firm’s DSO (days sales outstanding) is 40 days, whereas the industry average is 45 days

d.The firm’s Return on Equity is 13.0%, whereas the industry average is 12.0%

e.The firm’s FATO is 2.5x, whereas the industry average is 2.0x

6.If a business sells merchandise on credit, what is the impact on current assets and current ratio at the time the sale occurs if the sale is profitable? Assume that the current ratio is 2.0 before the sale.

a.Current assets increase and current ratio increases

b.Current assets increase and current ratio stays the same

c.Current assets increase and current ratio decreases

d.Current assets stay the same and current ratio decreases

e.Current assets stay the same and current ratio stays the same

Solutions

Expert Solution

1. Return on equity=net profit margin*total asset turnover ratio*equity multiplier

General Mills, Equity multiplier=5.74%/(12.37%*0.57)=0.81

Clorox, equity multiplier=3.56%/(13.97%*1.08)=0.23

Option a is incorrect

General Mills have more financial leverage than clorox

2. Option d is incorrect

General Mills profit margin and total asset turnover ratio are worse than clorox

3. Option e is incorrect

An increase in the capex will decrease the cashflow.

4. Option d

Decreasing the long term debt means, you are payment the repayment obligation which means the cash outflow. This cash outflow decreases cash in the cashflow statement

5. Option b is correct

Times interest earned should be positive if it is higher than industry average. But here it is lower than industry average, hence it is negative

6. Option a is correct

Both current assets and current ratio will increase

Accounts receivables are reported at selling price where as suppliers at cost in current liabilities. Hence both current assets and current ratio will increase


Related Solutions

based on the ratios completed above) Industry Lululime Ltd. Ratios 2020 2020 2019 2018 Profit margin...
based on the ratios completed above) Industry Lululime Ltd. Ratios 2020 2020 2019 2018 Profit margin 5.81% 5.5% 5.62% 6.25% Return on assets 8.48% 6.34% 7.79% 9.38% Return on equity 10.10% 14.24% 15.72% 17.05% Receivable turnover 9.31 × 6.54x 7.8x 10x Average collection period 35.6 days 55.8 days 46.7 days 36.5 days Inventory turnover 5.84 × 4x 3.9x 3.8x Capital asset turnover 2.20 × 1.84x 2.5x 2.72x Total asset turnover 1.46 × 1.14x 2.5x 1.5x Current ratio 2.15 × 1.45x...
DuPONT ANALYSIS Henderson's Hardware has an ROA of 7%, a 6% profit margin, and an ROE...
DuPONT ANALYSIS Henderson's Hardware has an ROA of 7%, a 6% profit margin, and an ROE of 16%. What is its total assets turnover? Round your answer to two decimal places. What is its equity multiplier? Round your answer to two decimal places.
DuPont Analysis a) Bate Industries has a quick ratio of 1.3, net profit margin of 6%,...
DuPont Analysis a) Bate Industries has a quick ratio of 1.3, net profit margin of 6%, inventory turnover of 2.8, total asset turnover of 1.5, accounts receivable turnover of 2.2, a debt-to-equity ratio of 1.1, and its PE ratio is 18. (1) Find the firm’s equity multiplier (2) Compute ROE b) Bate Industries has net income of $192 million on sales of $960 million. Bate has $320 million in Debt with $1.6 Billion in Assets. The firm has a beta...
-Ratio Analysis Describe profit margin and gross profit ratios. (In detail) Explain the importance of each...
-Ratio Analysis Describe profit margin and gross profit ratios. (In detail) Explain the importance of each ratio and how each ratio assists the investor in evaluating a company's performance.
Explain the importance of each component of the DuPont Identity (return on equity, profit margin, total...
Explain the importance of each component of the DuPont Identity (return on equity, profit margin, total asset turnover, equity multiplier).
Question 1 The following ratios have been computed for Cola Company for 2017.                   Profit margin          
Question 1 The following ratios have been computed for Cola Company for 2017.                   Profit margin                                               12.5%                   Times interest earned                                 8 times                   Receivables turnover                                 4 times                   Acid-test ratio                                                2 : 1                   Current ratio                                                   3 : 1                   Debt to assets ratio                                        20% Mason Company’s 2017 financial statements with missing information follow: MASON COMPANY Comparative Balance Sheet December 31, ——————————————————————————————————————————— Assets                                                                                                   2017                      2016   Cash.............................................................................................    $ 30,000               $ 45,000 Short-term Investments...............................................................        10,000                   25,000...
Analyze the following ratios. What does the NET PROFIT MARGIN RATIO tell about this company? Are...
Analyze the following ratios. What does the NET PROFIT MARGIN RATIO tell about this company? Are the trends getting better or worse? Why or why not? Would you recommend purchase of this stock? Why or why not? Please explain your answers. Net Profit 2016 2017 2018 Margin Ratio 10.91 8.97 8.71 What does the RETURN ON TOTAL ASSETS RATIO tell about this company? Are the trends getting better or worse? Why or why not? Would you recommend purchase of this...
Ratios 2016 2015 2014 2013 Profit margin 19% 17.8% 17.3% 19.9% Gross Profit Margin 41.4% 38.5%...
Ratios 2016 2015 2014 2013 Profit margin 19% 17.8% 17.3% 19.9% Gross Profit Margin 41.4% 38.5% 38.1% 38.8% Current Ratio 1.4 : 1 3.3 : 1 1.5 : 1 1.6 : 1 Quick Ration 0.8 : 1 3 : 1 1.2 : 1 1.3 : 1 Working Capital (in millions) $1,380.3 $6,692.6 $1,437.6 $1,880.1 Accounts Receivable Turnover (times per year) 17.8 20.1 21.7 20.9 Accounts Receivable Days Outstanding (days) 21.9 18.7 16.2 17.1 Inventory Turnover (times per year) 181.3 148.8...
2) Compute the EBIT margin and its components – the gross profit margin and selling, general,...
2) Compute the EBIT margin and its components – the gross profit margin and selling, general, and administrative expenses to revenue in 2018 and 2019. What caused the change in EBIT margin? [You do not have to use the average method – i.e. you can use year-end numbers in computing the ratios.] ATC Company Balance Sheet on December31 ($ millions) 2018 2019 Inventory 20 28 Accounts Receivable 36 26 Other 29 36 Cash 410 473 Total Current Assets 495 562...
Question 2: DuPont method In year 2016, Apple Inc. had profit margin of 27.8% (i.e., it...
Question 2: DuPont method In year 2016, Apple Inc. had profit margin of 27.8% (i.e., it generated 27.8 cents of profit per dollar of sales) and asset turnover of 0.670 (i.e., it generated 67.0 cents of annual sales per dollar of assets). a) The profit margin indicates that Apple has low pricing power -- it cannot charge high prices relative to costs high pricing power -- it can charge high prices relative to costs     high production efficiency -- it has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT