Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet...

70.2K

Verified Solution

Question

Finance

Comprehensive Ratio Analysis

Data 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,000
Receivables1,575,000Notes payable100,000
Inventories1,130,000Other current liabilities545,000
  Total current assets$2,940,000  Total current liabilities$1,245,000
Net fixed assets1,315,000Long-term debt400,000
Common equity2,610,000
Total assets$4,255,000Total liabilities and equity$4,255,000
Lozano Chip Company: Income Statement forYear Ended December 31, 2019
(Thousands of Dollars)
Sales$7,500,000
Cost of goods sold6,375,000
Selling, general, and administrative expenses937,000
  Earnings before interest and taxes (EBIT)$   188,000
Interest expense40,000
  Earnings before taxes (EBT)$   148,000
Federal and state income taxes (25%)37,000
Net income$   111,000
  1. Calculate the indicated ratios for Lozano. Do not roundintermediate calculations. Round your answers to two decimalplaces.
    RatioLozanoIndustry Average
    Current assets/Current liabilities2.0
    Days sales outstanding (365-day year)  days35.0days
    COGS/Inventory6.7
    Sales/Fixed assets12.1
    Sales/Total assets3.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 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   %.

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

Answer & Explanation Solved by verified expert
4.0 Ratings (788 Votes)
a Ratio CALCULATIONS Lozano Industry Average Current assetsCurrent liabilities 29400001245000 236 2 Days sales outstanding 365day year 15750007500000365 7665 35 days COGSInventory 63750001130000 564 67 SalesFixed assets 75000001315000 570 121 SalesTotal assets 75000004255000 176 3 Net incomeSales 1110007500000100 148 12 Net incomeTotal assets 1110004255000100 261    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

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.

Other questions asked by students