Question

In: Accounting

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, 2018 (Thousands of Dollars)

Cash   $ 235,000      Accounts payable   $ 601,866
Receivables   1,575,000      Notes payable   326,634
Inventories   1,125,000      Other current liabilities   535,000
Total current assets   $2,935,000      Total current liabilities   $1,463,500
Net fixed assets   1,335,000      Long-term debt   1,068,750
          Common equity   1,737,750
Total assets   $4,270,000      Total liabilities and equity   $4,270,000
Lozano Chip Company: Income Statement for Year Ended December 31, 2018 (Thousands of Dollars)

Sales   $7,500,000
Cost of goods sold   6,375,000
Selling, general, and administrative expenses   820,000
Earnings before interest and taxes (EBIT)   $ 305,000
Interest expense   111,631
Earnings before taxes (EBT)   $ 193,369
Federal and state income taxes (40%)   77,348
Net income   $ 116,021
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*  
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  
%   30.0%  
Total liabilities/Total assets  
%   60.0%  
*Calculation is based on a 365-day year.

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.

The firm's days sales outstanding is more than twice as long as the industry average, indicating that the firm should
-Select-
credit or enforce a
-Select-
stringent collection policy.

The total assets turnover ratio is well
-Select-
the industry average so sales should be
-Select-
, assets
-Select-
, or both.

While the company's profit margin is
-Select-
than the industry average, its other profitability ratios are
-Select-
compared to the industry - net income should be
-Select-
given the amount of equity and assets.


Icon Key

Previous Question 14 of 25 Next

Solutions

Expert Solution

a)

Ratios formula Lozano Industry
Current Ratio
Current Assets/ Current Liabilities

=$2,935,000/1,459,500

2.01 2
Day sales outstanding
365×Account receivable / sales

= 365 × $1,575,000 / $7,500,000

76.65days 35days
Inventory Turnover Ratio
COGS/ Inventory

= $6,375,000/7,500,000

0.85x 6.7
Fixed Assets Turnover
Sales/ Fixed Assets

= 7,500,000/$1,345,000

5.5 12.1
Total Assets Turnover
Sales/ Total Assets

= $7,500,000/$4,280,000

1.75 3.0
Net income margin
Net Income/ Sales ×100

= $116,021/$7,500,000 × 100

1.5% 1.2%
Return on Total Assets
net Income/ Total Assets

= $116,021/$4,280,000 ×100

2.7% 3.6%
Return on common equity
Net Income/ Common Equity ×100

= $116021/$1,751,750 × 100

6.6% 9.0%
Long term Debt Ratio
Total Debt/ Total Assets × 100

= 1,068,750/$4,280,000 × 100

24.9% 30%
Debt Ratio
Total Liabilities / Total Assets × 100

= ($1,459,500+$1,068,750)/$4,280,00 × 100

=$2,528,250/$4,280,000× 100

59.07% 60%
b) ROE DU Pont equation

Financial leverage(Lozano) = Total Assets / equity

= 1/(1-total liabilities / total Assets)

= 1/(1-(0.59))

=1/(1-0.59)= 1/0.41= 2.439 or 2.44

Financial leverage (Industry)

= 1/(1-total liabilities / total Assets)

=1/(1-60%) = 1/(1-0.60) = 1/0.40 = 2.5

ROE = NET INCOME MARGIN × TOTAL ASSETS TURNOVER × FINANCIAL LEVERAGE.

ROE Net Income/ sales Sales/ Total Assets financial leverage result
Lozano firm 1.5% 1.75 2.44 6.4%
Industry 1.2% 3 2.5 9.0%
for the firm ,ROE is 6.4%

for the Industry, ROE is 9.0%

C)

Select option is not mention

So kindly provide separate option for all the blanks.


Related Solutions

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 $   210,000 Accounts payable $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,130,000 Other current liabilities 535,000   Total current assets $2,915,000   Total current liabilities $1,235,000 Net fixed assets 1,335,000 Long-term debt 400,000 Common equity 2,615,000 Total assets $4,250,000 Total liabilities and equity $4,250,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars) Sales...
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 $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,115,000 Other current liabilities 550,000   Total current assets $2,905,000   Total current liabilities $1,250,000 Net fixed assets 1,360,000 Long-term debt 400,000 Common equity 2,615,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...
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 $   210,000 Accounts payable $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,155,000 Other current liabilities 530,000   Total current assets $2,940,000   Total current liabilities $1,230,000 Net fixed assets 1,320,000 Long-term debt 400,000 Common equity 2,630,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...
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 $   215,000 Accounts payable $   601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,145,000 Other current liabilities 525,000   Total current assets $2,935,000   Total current liabilities $1,453,500 Net fixed assets 1,340,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 31, 2018 (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 $ 215,000 Accounts payable $ 601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,150,000 Other current liabilities 532,000 Total current assets $2,940,000 Total current liabilities $1,460,500 Net fixed assets 1,325,000 Long-term debt 1,068,750 Common equity 1,735,750 Total assets $4,265,000 Total liabilities and equity $4,265,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:...
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 $   225,000 Accounts payable $   601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,130,000 Other current liabilities 527,000   Total current assets $2,930,000   Total current liabilities $1,455,500 Net fixed assets 1,325,000 Long-term debt 1,068,750 Common equity 1,730,750 Total assets $4,255,000 Total liabilities and equity $4,255,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2018 (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, 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 520,000   Total current assets $2,925,000   Total current liabilities $1,220,000 Net fixed assets 1,325,000 Long-term debt 400,000 Common equity 2,630,000 Total assets $4,250,000 Total liabilities and equity $4,250,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, 2019 (Thousands of Dollars) Cash $   220,000 Accounts payable $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,145,000 Other current liabilities 520,000   Total current assets $2,940,000   Total current liabilities $1,220,000 Net fixed assets 1,340,000 Long-term debt 400,000 Common equity 2,660,000 Total assets $4,280,000 Total liabilities and equity $4,280,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 $   230,000 Accounts payable $   601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,125,000 Other current liabilities 539,000   Total current assets $2,930,000   Total current liabilities $1,467,500 Net fixed assets 1,350,000 Long-term debt 1,068,750 Common equity 1,743,750 Total assets $4,280,000 Total liabilities and equity $4,280,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2018 (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 $   225,000 Accounts payable $   601,866 Receivables 1,575,000 Notes payable 326,634 Inventories 1,150,000 Other current liabilities 539,000   Total current assets $2,950,000   Total current liabilities $1,467,500 Net fixed assets 1,325,000 Long-term debt 1,068,750 Common equity 1,738,750 Total assets $4,275,000 Total liabilities and equity $4,275,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2018 (Thousands...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT