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, 2019 (Thousands of Dollars) Sales $7,500,000
Cost of goods sold 6,375,000
Selling, general, and administrative expenses 927,000
Earnings before interest and taxes (EBIT) $ 198,000
Interest expense 40,000
Earnings before taxes (EBT) $ 158,000 Federal and state income taxes (25%) 39,500
Net income $ 118,500
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
Days sales outstanding (365-day year) days
COGS/Inventory
Sales/Fixed assets
Sales/Total assets
Net income/Sales % 1.2 %
Net income/Total assets %
Net income/Common equity %
Total debt/Total assets %
Total liabilities/Total assets %
Use the extended DuPont equation to calculate ROE for both Lozano 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 %.
As per rules I am answering the first 4 subparts of the question
1: Current assets/Current liabilities= 2930000/1215000
= 2.41
2: Days sales outstanding (365-day year) days
= 365* Accounts receivable /Sales
= 365* 1,575,000/ 7,500,000
= 76.65 days
3: COGS/Inventory= 6,375,000/1130000
= 5.64
4: Sales/Fixed assets= 7500000/ 1,335,000
=5.62
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, 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...
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,...
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...
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...
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...
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...
Cash Receivables Inventories Total current assets Net fixed assets $ 230,000 1,575,000 1,160,000 $2,965,000 1,320,000 Accounts payable Notes payable Other current liabilities Total current liabilities Long-term debt Common equity Total liabilities and equity $ 600,000 100,000 545,000 $1,245,000 400,000 2,640,000 $4,285,000 Total assets $4,285,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 929,000 Earnings before interest and taxes (EBIT) $ 196,000 Interest...
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...
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 $ 95,760 Accounts payable Receivables 340,480 Other current liabilities Inventories 297,920 Notes payable to bank Total current assets $ 734,160 Total current liabilities Long-term debt Net...
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 $ 68,640 Accounts payable $ 145,860 Receivables 231,660 Other current liabilities 68,640 Inventories 205,920 Notes payable to bank 77,220 Total current assets $ 506,220 Total current...