Transcribed Image Text
Comprehensive Ratio AnalysisData for Lozano Chip Company and its industry averagesfollow.Lozano Chip Company: Balance Sheet as ofDecember 31, 2019(Thousands of Dollars)Cash$ 235,000Accounts payable$ 600,000Receivables1,575,000Notes payable100,000Inventories1,130,000Other current liabilities545,000 Total current assets$2,940,000 Total current liabilities$1,245,000Net fixed assets1,315,000Long-term debt400,000Common equity2,610,000Total assets$4,255,000Total liabilities and equity$4,255,000Lozano Chip Company: Income Statement forYear Ended December 31, 2019(Thousands of Dollars)Sales$7,500,000Cost of goods sold6,375,000Selling, general, and administrative expenses937,000 Earnings before interest and taxes (EBIT)$ 188,000Interest expense40,000 Earnings before taxes (EBT)$ 148,000Federal and state income taxes (25%)37,000Net income$ 111,000Calculate the indicated ratios for Lozano. Do not roundintermediate calculations. Round your answers to two decimalplaces.RatioLozanoIndustry AverageCurrent assets/Current liabilities2.0Days sales outstanding (365-day year) days35.0daysCOGS/Inventory6.7Sales/Fixed assets12.1Sales/Total assets3.0Net income/Sales %1.2%Net income/Total assets %3.6%Net income/Common equity %9.0%Total debt/Total assets %10.0%Total liabilities/Total assets %60.0%Use the extended DuPont equation to calculate ROE for bothLozano and the industry. Do not round intermediate calculations.Round your answers to two decimal places.For the firm, ROE is %.For the industry, ROE is %.Outline Lozano's strengths and weaknesses as revealed by youranalysis.The firm's days sales outstanding is more than twice as long asthe industry average, indicating that the firm should-Select-slackentightenItem 13 credit or enforce a-Select-morelessItem 14 stringent collection policy.The total assets turnover ratio is well -Select-abovebelowItem15 the industry average so sales should be-Select-decreasedincreasedItem 16 , assets-Select-decreasedincreasedItem 17 , or both.While the company's profit margin is -Select-higherlowerItem 18than the industry average, its other profitability ratios are-Select-highlowItem 19 compared to the industry - net income shouldbe -Select-higherlowerItem 20 given the amount of equity andassets.