Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has

A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $3 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows:

Industry Average Ratios
Current ratio 5.17x Fixed assets turnover 7.52x
Debt-to-capital ratio 14.74% Total assets turnover 3.54x
Times interest earned 19.06x Profit margin 4.68%
EBITDA coverage 11.01x Return on total assets 17.76%
Inventory turnover 11.06x Return on common equity 23.75%
Days sales outstandinga 14.84 days Return on invested capital 20.49%

aCalculation is based on a 365-day year.

Balance Sheet as of December 31, 2016 (Millions of Dollars)
Cash and equivalents $47 Accounts payable $19
Accounts receivables 28 Other current liabilities 5
Inventories 85 Notes payable 19
Total current assets $160 Total current liabilities $43
Long-term debt 12
Total liabilities $55
Gross fixed assets 125 Common stock 52
Less depreciation 50 Retained earnings 128
Net fixed assets $75 Total stockholders' equity $180
Total assets $235 Total liabilities and equity $235

Income Statement for Year Ended December 31, 2016 (Millions of Dollars)
Net sales $470.0
Cost of goods sold 371.3
Gross profit $98.7
Selling expenses 47.0
EBITDA $51.7
Depreciation expense 7.5
Earnings before interest and taxes (EBIT) $44.2
Interest expense 1.6
Earnings before taxes (EBT) $42.6
Taxes (40%) 17.0
Net income $25.6

Calculate the following ratios. Do not round intermediate steps. Round your answers to two decimal places.

Firm Industry Average
Current ratio x 5.17x
Debt to total capital % 14.74%
Times interest earned x 19.06x
EBITDA coverage x 11.01x
Inventory turnover x 11.06x
Days sales outstanding days 14.84days
Fixed assets turnover x 7.52x
Total assets turnover x 3.54x
Profit margin % 4.68%
Return on total assets % 17.76%
Return on common equity % 23.75%
Return on invested capital % 20.49%

Construct a DuPont equation for the firm and the industry. Do not round intermediate steps. Round your answers to two decimal places.

Firm Industry
Profit margin % 4.68%
Total assets turnover x 3.54x
Equity multiplier x x

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_2

Step: 3

blur-text-image_3

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

Forecasting Principles And Practice

Authors: Rob J Hyndman, George Athanasopoulos

3rd Edition

0987507133, 978-0987507136

More Books

Students also viewed these Finance questions

Question

What does this key public know about this issue?

Answered: 1 week ago

Question

What is the nature and type of each key public?

Answered: 1 week ago

Question

What does this public need on this issue?

Answered: 1 week ago