Question

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 $ 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 %.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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:...

    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 Co...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT