Selected financial data for Squid Company are as follows:
|
|
2007
|
|
2006
|
|
2005
|
|
Summary of operations:
|
|
|
|
|
|
|
Net sales
|
$1,002,100
|
|
$980,500
|
|
$900,000
|
|
Cost of products sold
|
520,500
|
|
514,762
|
|
477,000
|
|
Selling, administrative, and general expenses
|
170,200
|
|
167,665
|
|
155,700
|
|
Nonoperating income
|
9,192
|
|
8,860
|
|
6,500
|
2007 2006 2005
|
Interest expense
|
14,620
|
|
12,100
|
|
11,250
|
|
Earnings before income taxes
|
287,588
|
|
277,113
|
|
249,550
|
|
Provision for income taxes
|
116,473
|
|
113,616
|
|
105,560
|
|
Net earnings
|
171,115
|
|
163,497
|
|
143,990
|
|
Financial information: Working capital
|
$190,400
|
|
$189,000
|
|
$180,000
|
|
Average property, plant, and equipment
|
302,500
|
|
281,000
|
|
173,000
|
|
Average total assets
|
839,000
|
|
770,000
|
|
765,000
|
|
Average long-term debt
|
120,000
|
|
112,000
|
|
101,000
|
|
Average stockholders' equity
|
406,000
|
|
369,500
|
|
342,000
|
Required:
a. Compute the following for 2007, 2006, and 2005:
1. Net profit margin
2. Return on assets
3. Total asset turnover
4. DuPont analysis
5. Return on investment
6. Return on total equity
7. Sales to fixed assets
b. Discuss your findings in (a).