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 $   235,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,935,000     Total current liabilities $1,235,000 Net fixed assets 1,320,000   Long-term debt 400,000       Common equity 2,620,000 Total assets $4,255,000   Total liabilities and equity $4,255,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 expense 40,000   Earnings before taxes (EBT) $   156,000 Federal and state income taxes (25%) 39,000 Net income $   117,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 %   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   %. Outline Lozano's strengths and weaknesses as revealed by your analysis.

Financial Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter3: Analysis Of Financial Statements
Section: Chapter Questions
Problem 13P: Data for Lozano Chip Company and its industry averages follow. Calculate the indicated ratios for...
icon
Related questions
Question

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 $   235,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,935,000     Total current liabilities $1,235,000
Net fixed assets 1,320,000   Long-term debt 400,000
      Common equity 2,620,000
Total assets $4,255,000   Total liabilities and equity $4,255,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 expense 40,000
  Earnings before taxes (EBT) $   156,000
Federal and state income taxes (25%) 39,000
Net income $   117,000

 

 

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

     

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

  3. Outline Lozano's strengths and weaknesses as revealed by your analysis. 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning