Transcribed Image Text
A firm has been experiencing low profitability in recent years.Perform an analysis of the firm's financial position using theDuPont equation. The firm has no lease payments but has a $3million sinking fund payment on its debt. The most recent industryaverage ratios and the firm's financial statements are asfollows:Industry Average RatiosCurrent ratio3.62xFixed assets turnover5.36xDebt-to-capital ratio16.99%Total assets turnover3.02xTimes interest earned28.62xProfit margin8.80%EBITDA coverage18.64xReturn on total assets26.00%Inventory turnover9.28xReturn on common equity38.44%Days sales outstandinga23.12 daysReturn on invested capital30.63%aCalculation is based on a 365-day year.Balance Sheet as of December 31, 2016(Millions of Dollars)Cash and equivalents$59Accounts payable$31Accounts receivables45Other current liabilities10Inventories125Notes payable35 Total current assets$229 Total current liabilities$76Long-term debt17 Total liabilities$93Gross fixed assets157Common stock97 Less depreciation38Retained earnings158Net fixed assets$119 Total stockholders' equity$255Total assets$348Total liabilities and equity$348Income Statement for Year Ended December31, 2016 (Millions of Dollars)Net sales$580.0Cost of goods sold411.8 Gross profit$168.2Selling expenses52.2EBITDA$116.0Depreciation expense16.8 Earnings before interest and taxes (EBIT)$99.2Interest expense2.6 Earnings before taxes (EBT)$96.6Taxes (40%)38.6Net income$58.0Calculate the following ratios. Do not round intermediatesteps. Round your answers to two decimal places.FirmIndustry AverageCurrent ratiox3.62xDebt to total capital%16.99%Times interest earnedx28.62xEBITDA coveragex18.64xInventory turnoverx9.28xDays sales outstandingdays23.12daysFixed assets turnoverx5.36xTotal assets turnoverx3.02xProfit margin%8.80%Return on total assets%26.00%Return on common equity%38.44%
Other questions asked by students
form 2 points each 3 co 5 12 46 4 Find the missing values Leave...
regulation OA Both control whether RNA polymerase can bind to and transcribe genes B Both...
MXXXTINE Diology ou a hidden heterozygote A PCR ana scientists load a Molecular Weight ma...
Q1 A manager surveys his employees to find out how they travel to work Number...
Dance Company Students The number of students who belong to the dance company at each...
The demand equation for a certain product is given by p 132 0 06x where...
Write the function whose graph is the graph of y x but is shifted to...
Q3: Give an example of Depositing Cash transaction and record it the books of bank?...
For each of the following independent cases, fill in the missing amounts in the table:...