Question: PLEASE ANSWER QUICKLY LIBRARY IS ABOUT TO CLOSE 3 4x 7x 15.20 % A firm has been experiencing low profitability in recent years. Perform an



PLEASE ANSWER QUICKLY LIBRARY IS ABOUT TO CLOSE
3 4x 7x 15.20 % 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 $1 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 3x Fixed assets turnover 6 x Debt-to-capital ratio 17% Total assets turnover Times interest earned Profit margin 3.75% EBITDA coverage 8 x Return on total assets 11.25 % Inventory turnover Return on common 15.30 % equity Days sales 30 days Return on invested outstanding capital Calculation is based on a 365-day year. Balance Sheet as of December 31, 2021 (millions of dollars) Cash and equivalents $ 101 Accounts payable $ 42 Accounts receivables 85 Other current liabilities Inventories 201 Notes payable Total current assets $ 387 Total current liabilities $ 116 Long-term debt Total liabilities $ 143 Gross fixed assets 239 Common stock Less depreciation 96 Retained earnings Net fixed assets $ 143 Total stockholders' equity $ 387 Total assets $ 530 Total liabilities and equity $530 21 53 27 133 254 Income Statement for Year Ended December 31, 2021 (millions of dollars) Net sales $ 855.00 Cost of goods sold 700.00 Gross profit $ 155.00 Selling expenses 84.50 EBITDA $ 70.50 Depreciation expense 14.00 Earnings before interest and taxes (EBIT) S 56.50 Interest expense 7.50 Earnings before taxes (EBT) S 49.00 Taxes (25%) 12.25 Net income 36.75 S 4x X a. Calculate the following ratios. Do not round intermediate calculations. Round your answers to two decimal places. Firm Industry Average Current ratio 3 x Debt to total capital % 17% Times interest earned EBITDA coverage 8 x Inventory turnover 7x Days sales outstanding days 30 days Fixed assets turnover 6 x Total assets turnover Profit margin % 3.75 % Return on total assets 11.25% Return on common equity % 15.30% Return on invested capital % 15.20% b. Construct a DuPont equation, and the industry. Do not round intermediate calculations. Round your answers to two decimal places. Firm Industry. Profit margin % 3.75% X 3 x % Total assets turnover X 3x Equity multiplier X
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
