Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data for Lozano Chip Company and its industry averages follow. a. Calculate the indicated ratios for Lozano b. Construct the extended Du Pont equation for

Data for Lozano Chip Company and its industry averages follow.

a. Calculate the indicated ratios for Lozano

b. Construct the extended Du Pont equation for both Lozano and the industry.

c. Outline Lozano strengths and weaknesses as revealed by your analysis.

d. Suppose Lozano had doubled its sales as well as its inventories, accounts receivable, and common equity during 2012. How would that information affect the validity of your ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed).

Lozano Chip Company: Balance Sheet as of December 31, 2012 (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,950,000 Total current liabilities $1,453,500

Long-term debt 1,068,750

Net fixed assets 1,350,000 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, 2012 (Thousands of Dollars)

Sales $7,500,000

Cost of goods sold 6,375,000

Selling, general, and administrative expenses 825,000

Earnings before interest and taxes (EBIT) 300,000

Interest expense 111,631

Earnings before taxes (EBT) 188,369

Federal and state income tax (40%) 75,348

Net income $113,022

Ratio Lozano Industry Average

Current asset/Current liabilities 2.0

Days sales outstanding 35.0 days

Sales/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 liabilities/Total assets 60.0%

*Calculation is based on a 365-day year

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles and Applications

Authors: Sheridan Titman, Arthur J. Keown, John H. Martin

13th edition

134417216, 978-0134417509, 013441750X, 978-0134417219

More Books

Students also viewed these Finance questions

Question

Current Attentio During 2020 the Ap 1 May " 2200000

Answered: 1 week ago