Comprehensive Ratio Analysis
Data for Lozano Chip Company and its industry averages follow.
Lozano Chip Company: Balance Sheet as of
December 31, 2019 (Thousands of Dollars) |
||||
Cash | $ 220,000 | Accounts payable | $ 600,000 | |
Receivables | 1,575,000 | Notes payable | 100,000 | |
Inventories | 1,140,000 | Other current liabilities | 545,000 | |
Total current assets | $2,935,000 | Total current liabilities | $1,245,000 | |
Net fixed assets | 1,335,000 | Long-term debt | 400,000 | |
Common equity | 2,625,000 | |||
Total assets | $4,270,000 | Total liabilities and equity | $4,270,000 |
Lozano Chip Company: Income Statement for
Year Ended December 31, 2019 (Thousands of Dollars) |
|
Sales | $7,500,000 |
Cost of goods sold | 6,375,000 |
Selling, general, and administrative expenses | 933,000 |
Earnings before interest and taxes (EBIT) | $ 192,000 |
Interest expense | 40,000 |
Earnings before taxes (EBT) | $ 152,000 |
Federal and state income taxes (25%) | 38,000 |
Net income | $ 114,000 |
Calculate the indicated ratios for Lozano. Do not round intermediate calculations. Round your answers to two decimal places.
Ratio | Lozano | Industry Average | |
Current assets/Current liabilities | 2.0 | ||
Days sales outstanding (365-day year) | days | 35.0 | days |
COGS/Inventory | 6.7 | ||
Sales/Fixed assets | 12.1 | ||
Sales/Total assets | 3.0 | ||
Net 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 | % |
For the firm, ROE is %.
For the industry, ROE is %.
Outline Lozano's strengths and weaknesses as revealed by your analysis.
The firm's days sales outstanding is more than twice as long as the 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-abovebelowItem 15 the industry average so sales should be -Select-decreased/increased Item 16 , assets -Select-decreased/increased Item 17 , or both.
While the company's profit margin is -Select-higher/lower Item 18 than the industry average, its other profitability ratios are -Select-high/low Item 19 compared to the industry - net income should be -Select-higher/lower Item 20 given the amount of equity and assets.
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company:...
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 235,000 Accounts payable $ 601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,140,000 Other current liabilities 540,000 Total current assets $2,950,000 Total current liabilities $1,468,500 Net fixed assets 1,345,000 Long-term debt 1,068,750 Common equity 1,757,750 Total assets $4,295,000 Total liabilities and equity $4,295,000 Lozano Chip Company: Income Statement for Year Ended December 31,...
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $ 225,000 Accounts payable $ 600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,130,000 Other current liabilities 515,000 Total current assets $2,930,000 Total current liabilities $1,215,000 Net fixed assets 1,335,000 Long-term debt 400,000 Common equity 2,650,000 Total assets $4,265,000 Total liabilities and equity $4,265,000 Lozano Chip Company: Income Statement for Year Ended December 31,...
Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $ 215,000 Accounts payable Receivables 1,575,000 Notes payable Inventories 1,135,000 Other current liabilities Total current assets $2,925,000 Total current liabilities Net fixed assets 1,345,000 Long-term debt Common equity Total assets $4,270,000 Total liabilities and equity $ 600,000 100,000 520,000 $1,220,000 400,000 2,650,000 $4,270,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of...
Problem 3-13 Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $ 225,000 Accounts payable $601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,125,000 Other current liabilities 525,000 Total current assets $2,925,000 Total current liabilities $1,453,500 Net fixed assets 1,350,000 Long-term debt 1,068,750 Common equity 1,752,750 Total assets $4,275,000 Total liabilities and equity $4,275,000 Lozano Chip Company: Income Statement for Year Ended December...
NEED ANSWER ASAP / ANSWER NEVER USED BEFORE, COMPLETELY NEW ANSWER PLEASE Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) $ 235,000 $ 600,000 Cash Accounts payable Receivables 1,575,000 Notes payable 100,000 Inventories 1,160,000 Other current liabilities 560,000 Total current assets $2,970,000 Total current liabilities $1,260,000 Net fixed assets Long-term debt 1,355,000 400,000 Common equity 2,665,000 Total assets Total liabilities and equity...
Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $ 225,000 Accounts payable $ 600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,125,000 Other current liabilities 535,000 Total current assets $2,925,000 Total current liabilities $1,235,000 Net fixed assets 1,335,000 Long-term debt 400,000 Common equity 2,625,000 Total assets $4,260,000 Total liabilities and equity $4,260,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars) Sales $7,500,000 Cost of goods sold 6,375,000 Selling, general, and administrative...
Ratio Analysis Data for Barry Computer Co. and its industry averages follow Barry Computer Company: Balance Sheet as of December 31, 2014 (In Thousands) Cash Receivables Inventories $52,650 379,080 221,130 $652,860 Accounts payable Other current liabilities Notes payable $136,890 136,890 126,360 $400,140 Total current liabilities Long-term debt Common equity Total liabilities and equity Total current assets $294,840 358,020 $1,053,000 Net fixed assets 400,140 Total assets $1,053,000 Barry Computer Company Income Statement for Year Ended December 31, 2014 (In Thousands) Sales...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2016 (In Thousands) Cash $114,000 Accounts payable $142,500 Receivables 456,000 Other current liabilities 199,500 Inventories 313,500 Notes payable to bank 71,250 Total current assets $883,500 Total current liabilities $413,250 Long-term debt $299,250 Net fixed assets 541,500 Common equity 712,500 Total assets $1,425,000 Total liabilities and equity $1,425,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so the market value of its debt equals its book value. Since dollars are in thousands, number of shares are shown in thousands too. Barry Computer Company: Balance Sheet as of December 31, 2019 (In Thousands) Cash $ 122,760 Accounts payable $ 133,920 Receivables 446,400 Other current liabilities 156,240 Inventories 301,320 Notes payable to bank 55,800 Total current assets $ 870,480 Total current...
Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so the market value of its debt equals its book value. Since dollars are in thousands, number of shares are shown in thousands too. Barry Computer Company: Balance Sheet as of December 31, 2019 (In Thousands) Cash $ 84,000 Accounts payable $ 119,000 Receivables 252,000 Other current liabilities 105,000 Inventories 196,000 Notes payable to bank 84,000 Total current assets $ 532,000 Total current...