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 2\times Fixed assets turnover 6\times
Debt-to-capital ratio 18% Total assets turnover 3\times
Times interest earned 5\times Profit margin 2.75%
EBITDA coverage 6\times Return on total assets 8.25%
Inventory turnover 7\times Return on common equity 14.40%
Days sales outstandinga 22 days Return on invested capital 11.80%
aCalculation is based on a 365-day year.
Balance Sheet as of December 31,2021(millions of dollars)
Cash and equivalents $ 74 Accounts payable $ 54
Accounts receivables 64 Other current liabilities 25
Inventories 196 Notes payable 44
Total current assets $ 334 Total current liabilities $ 123
Long-term debt 29
Total liabilities $ 152
Gross fixed assets 225 Common stock 127
Less depreciation 69 Retained earnings 211
Net fixed assets $ 156 Total stockholders' equity $ 338
Total assets $ 490 Total liabilities and equity $ 490
Income Statement for Year Ended December 31,2021(millions of dollars)
Net sales $ 835.00
Cost of goods sold 720.00
Gross profit $ 115.00
Selling expenses 62.50
EBITDA $ 52.50
Depreciation expense 10.00
Earnings before interest and taxes (EBIT) $ 42.50
Interest expense 4.50
Earnings before taxes (EBT) $ 38.00
Taxes (25%)9.50
Net income $ 28.50
Calculate the following ratios. Do not round intermediate calculations. Round your answers to two decimal places.
Firm Industry Average
Current ratio
2.71
\times 2\times
Debt to total capital
7.9
%18%
Times interest earned
9.44
\times 5\times
EBITDA coverage
7
\times 6\times
Inventory turnover
22
\times 7\times
Days sales outstanding
days 22 days
Fixed assets turnover
\times 6\times
Total assets turnover
\times 3\times
Profit margin
%2.75%
Return on total assets
%8.25%
Return on common equity
%14.40%
Return on invested capital
%11.80%
Construct a DuPont equation, and the industry. Do not round intermediate calculations. Round your answers to two decimal places.
Firm Industry
Profit margin
%2.75%
Total assets turnover
\times 3\times
Equity multiplier
\times
\times

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

Rich Dads Increase Your Financial IQ Get Smarter With Your Money

Authors: Robert T. Kiyosaki

1st Edition

1612680658, 978-1612680651

More Books

Students also viewed these Finance questions

Question

Compare and contrast the two types of WiMAX.

Answered: 1 week ago

Question

a. Describe the encounter. What made it intercultural?

Answered: 1 week ago