Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Greetings, Please I ONLY need the answers for the 3 Fields which are Wrong. Thank you for your support. A firm has been experiencing low

Greetings,

Please I ONLY need the answers for the 3 Fields which are Wrong. Thank you for your support.

image text in transcribedimage text in transcribed

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: 9 X capital Industry Average Ratios Current ratio 2x Fixed assets turnover 6x Debt-to-capital ratio 19% Total assets turnover 3 x Times interest earned 8 x Profit margin 4.75% EBITDA coverage Return on total assets 14.25 % Inventory turnover 7x Return on common 17.20% equity Days sales 22 days Return on invested 14.40% outstandinga Calculation is based on a 365-day year. a Balance Sheet as of December 31, 2021 (millions of dollars) Cash and equivalents $ 103 Accounts payable $ 54 Accounts receivables 76 Other current liabilities 27 Inventories 194 Notes payable 49 Total current assets $ 373 Total current liabilities $ 130 Long-term debt 38 Total liabilities $ 168 Gross fixed assets 259 Common stock 135 Less depreciation 92 Retained earnings 237 Net fixed assets $ 167 Total stockholders' equity $ 372 Total assets $ 540 Total liabilities and equity $ 540 Income Statement for Year Ended December 31, 2021 (millions of dollars) Net sales $ 895.00 Cost of goods sold 720.00 Gross profit $ 175.00 Selling expenses 94.50 EBITDA $ 80.50 Depreciation expense 16.00 Earnings before interest and taxes (EBIT) $ 64.50 Interest expense 5.50 Earnings before taxes (EBT) $ 59.00 Taxes (25%) 14.75 Net income $ 44.25 a. Calculate the following ratios. Do not round intermediate calculations. Round your answers to two decimal places. Firm Industry Average Current ratio 2.87 Debt to total capital 19 % 10.22 % Times interest earned 11.73 EBITDA coverage 9x 14.64 Inventory turnover 7x 3.71 Days sales outstanding 30.99 days 22 days Fixed assets turnover 6 x 5.36 Total assets turnover 1.66 Profit margin 4.94 % 4.75% Return on total assets 8.19 14.25% % Return on common equity 11.90 17.20% % 2x 8x X X 3 x Return on invested capital 19.22 14.40% %

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

More Books

Students also viewed these Finance questions