Go Back To FINN 3120 Term Project
|
Exhibit 1 Balance Sheet - [IBM] |
||||||||
|
(In Millions) |
1993 |
1994 |
1995 |
1996 |
1997 |
|||
|
Assets |
||||||||
|
Cash & cash equivalent |
5,861 |
7,922 |
7,259 |
7,687 |
7,106 |
|||
|
Marketable securities |
1,272 |
2,632 |
442 |
450 |
447 |
|||
|
Notes & accounts receivable |
11,676 |
14,018 |
16,450 |
16,515 |
16,850 |
|||
|
Sales-type leases receivable |
6,428 |
6,351 |
5,961 |
5,721 |
5,720 |
|||
|
Other accounts receivable |
1,308 |
1,164 |
991 |
931 |
1,256 |
|||
|
Inventories |
7,565 |
6,334 |
6,323 |
5,870 |
5,139 |
|||
|
Prepaid expenses & other c/a |
5,092 |
2,917 |
3,265 |
3,521 |
3,900 |
|||
|
Total current assets |
39,202 |
41,338 |
40,691 |
40,695 |
40,418 |
|||
|
Prop, plant & equip |
47,504 |
44,820 |
43,981 |
41,893 |
42,133 |
|||
|
Accumulated depreciation |
29,983 |
28,156 |
27,402 |
24,486 |
23,786 |
|||
|
Net prop, plant & equip |
17,521 |
16,664 |
16,579 |
17,407 |
18,347 |
|||
|
Software, less accu amort |
3,703 |
2,963 |
2,419 |
1,435 |
819 |
|||
|
Investments & sundry assets |
20,687 |
20,126 |
20,603 |
21,595 |
21,915 |
|||
|
Total Assets |
81,113 |
81,091 |
80,292 |
81,132 |
81,499 |
|||
|
Liabilities & Equity |
||||||||
|
Taxes |
1,589 |
1,771 |
2,634 |
3,029 |
2,381 |
|||
|
Short-term debt |
12,097 |
9,570 |
11,569 |
12,957 |
13,230 |
|||
|
Accounts payable |
3,400 |
3,778 |
4,511 |
4,767 |
5,215 |
|||
|
Compensation & benefits |
2,053 |
2,702 |
2,914 |
2,950 |
3,043 |
|||
|
Deferred income |
3,575 |
3,475 |
3,469 |
3,640 |
3,445 |
|||
|
Other accrued exp & liab |
10,436 |
7,930 |
6,551 |
6,657 |
6,193 |
|||
|
Total current liabilities |
33,150 |
29,226 |
31,648 |
34,000 |
33,507 |
|||
|
Long-term debt |
15,245 |
12,548 |
10,060 |
9,872 |
13,696 |
|||
|
Other liabilities |
11,177 |
14,023 |
14,354 |
14,005 |
12,993 |
|||
|
Deferred income taxes |
1,803 |
1,881 |
1,807 |
1,627 |
1,487 |
|||
|
Total liabilities |
61,375 |
57,678 |
57,869 |
59,504 |
61,683 |
|||
|
Preferred stock |
1,091 |
1,081 |
253 |
253 |
252 |
|||
|
Common stock net |
6,980 |
7,342 |
7,488 |
7,752 |
8,601 |
|||
|
Retained earnings |
10,009 |
12,352 |
11,630 |
11,189 |
11,010 |
|||
|
Translation adjustments |
1,658 |
2,672 |
3,036 |
2,401 |
791 |
|||
|
Treasury stock & other equities |
(34) |
(41) |
(135) |
(946) |
||||
|
Net unrealized gain on m/s |
57 |
168 |
108 |
|||||
|
Total stockholders' equity |
19,738 |
23,413 |
22,423 |
21,628 |
19,816 |
|||
|
Total Liabilities & Equity |
81,113 |
81,091 |
80,292 |
81,132 |
81,499 |
|||
|
Exhibit 2 Income Statement - [IBM] |
||||||||
|
(In Millions) |
1993 |
1994 |
1995 |
1996 |
1997 |
|||
|
Hardware sales |
30,591 |
32,344 |
35,600 |
36,316 |
36,229 |
|||
|
Services |
10,953 |
9,715 |
12,714 |
15,873 |
19,302 |
|||
|
Software |
9,711 |
11,346 |
12,657 |
13,052 |
12,844 |
|||
|
Maintenance |
7,295 |
7,222 |
7,409 |
6,981 |
6,402 |
|||
|
Rentals and financing |
4,166 |
3,425 |
3,560 |
3,725 |
3,731 |
|||
|
Total revenue |
62,716 |
64,052 |
71,940 |
75,947 |
78,508 |
|||
|
Hardware sales |
20,696 |
21,300 |
21,862 |
23,396 |
23,538 |
|||
|
Services |
4,310 |
7,769 |
10,042 |
12,647 |
15,281 |
|||
|
Software |
8,279 |
4,680 |
4,428 |
4,082 |
3,784 |
|||
|
Maintenance |
3,545 |
3,635 |
3,651 |
3,659 |
3,394 |
|||
|
Rentals and financing |
1,738 |
1,384 |
1,590 |
1,624 |
1,902 |
|||
|
Total cost |
38,568 |
38,768 |
41,573 |
45,408 |
47,899 |
|||
|
Gross profit |
24,148 |
25,284 |
30,367 |
30,539 |
30,609 |
|||
|
Sell gen & admin exp |
18,282 |
15,916 |
16,766 |
16,854 |
16,634 |
|||
|
R&D expenditures |
5,558 |
4,363 |
4,170 |
4,654 |
4,877 |
|||
|
Purchased in-process R&D |
8,945 |
- |
1,840 |
435 |
- |
|||
|
Total operating expenses |
32,785 |
20,279 |
22,776 |
21,943 |
21,511 |
|||
|
Operating income |
(8,637) |
5,005 |
7,591 |
8,596 |
9,098 |
|||
|
Other income |
1,113 |
1,377 |
947 |
707 |
657 |
|||
|
Interest expense |
1,273 |
1,227 |
725 |
716 |
728 |
|||
|
Earnings before income tax |
(8,797) |
5,155 |
7,813 |
8,587 |
9,027 |
|||
|
Provision for income taxes |
(810) |
2,134 |
3,635 |
3,158 |
2,934 |
|||
|
Net earnings before changes |
||||||||
|
in accounting principles |
(7,987) |
3,021 |
4,178 |
5,429 |
6,093 |
|||
|
Effect of changes |
(114) |
- |
- |
- |
- |
|||
|
Net earnings |
(8,101) |
3,021 |
4,178 |
5,429 |
6,093 |
|||
|
Preferred stock dividends |
47 |
84 |
62 |
20 |
20 |
|||
|
Net earnings applicable |
||||||||
|
to common shareholders |
(8,148) |
2,937 |
4,116 |
5,409 |
6,073 |
|||
|
Outstanding Shares |
1,146 |
1,169 |
1,139 |
1,057 |
983 |
|||
|
Net earnings per share |
(7.11) |
2.51 |
3.61 |
5.12 |
6.18 |
|||
|
Exibit 3 Vertical Common-size Balance Sheet - [IBM] |
||||||||
|
1993 |
1994 |
1995 |
1996 |
1997 |
||||
|
Assets |
||||||||
|
Cash & cash equivalent |
7.2% |
9.8% |
9.0% |
9.5% |
8.7% |
|||
|
Marketable securities |
1.6% |
3.2% |
0.6% |
0.6% |
0.5% |
|||
|
Notes & accounts receivable |
14.4% |
17.3% |
20.5% |
20.4% |
20.7% |
|||
|
Sales-type leases receivable |
7.9% |
7.8% |
7.4% |
7.1% |
7.0% |
|||
|
Other accounts receivable |
1.6% |
1.4% |
1.2% |
1.1% |
1.5% |
|||
|
Inventories |
9.3% |
7.8% |
7.9% |
7.2% |
6.3% |
|||
|
Prepaid expenses & other c/a |
6.3% |
3.6% |
4.1% |
4.3% |
4.8% |
|||
|
Total current assets |
48.3% |
51.0% |
50.7% |
50.2% |
49.6% |
|||
|
Prop, plant & equip |
58.6% |
55.3% |
54.8% |
51.6% |
51.7% |
|||
|
Accumulated depreciation |
37.0% |
34.7% |
34.1% |
30.2% |
29.2% |
|||
|
Net prop, plant & equip |
21.6% |
20.5% |
20.6% |
21.5% |
22.5% |
|||
|
Software, less accu amort |
4.6% |
3.7% |
3.0% |
1.8% |
1.0% |
|||
|
Investments & sundry assets |
25.5% |
24.8% |
25.7% |
26.6% |
26.9% |
|||
|
Total Assets |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
|||
|
Liabilities & Equity |
||||||||
|
Taxes |
2.0% |
2.2% |
3.3% |
3.7% |
2.9% |
|||
|
Short-term debt |
14.9% |
11.8% |
14.4% |
16.0% |
16.2% |
|||
|
Accounts payable |
4.2% |
4.7% |
5.6% |
5.9% |
6.4% |
|||
|
Compensation & benefits |
2.5% |
3.3% |
3.6% |
3.6% |
3.7% |
|||
|
Deferred income |
4.4% |
4.3% |
4.3% |
4.5% |
4.2% |
|||
|
Other accrued exp & liab |
12.9% |
9.8% |
8.2% |
8.2% |
7.6% |
|||
|
Total current liabilities |
75.7% |
71.1% |
72.1% |
73.3% |
75.7% |
|||
|
Long-term debt |
18.8% |
15.5% |
12.5% |
12.2% |
16.8% |
|||
|
Other liabilities |
13.8% |
17.3% |
17.9% |
17.3% |
15.9% |
|||
|
Deferred income taxes |
2.2% |
2.3% |
2.3% |
2.0% |
1.8% |
|||
|
Total liabilities |
75.7% |
71.1% |
72.1% |
73.3% |
75.7% |
|||
|
Preferred stock |
1.3% |
1.3% |
0.3% |
0.3% |
0.3% |
|||
|
Common stock net |
8.6% |
9.1% |
9.3% |
9.6% |
10.6% |
|||
|
Retained earnings |
12.3% |
15.2% |
14.5% |
13.8% |
13.5% |
|||
|
Translation adjustments |
2.0% |
3.3% |
3.8% |
3.0% |
1.0% |
|||
|
Treasury stick, at cost |
0.0% |
-0.1% |
-0.2% |
-1.2% |
||||
|
Net unrealized gain on m/s |
0.1% |
0.2% |
0.1% |
|||||
|
Total stockholders' equity |
24.3% |
28.9% |
27.9% |
26.7% |
24.3% |
|||
|
Total Liabilities & Equity |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
|||
|
Exibit 4 Vertical Common-size Income Statement -[IBM] |
||||||||
|
1993 |
1994 |
1995 |
1996 |
1997 |
||||
|
Hardware sales |
48.8% |
50.5% |
49.5% |
47.8% |
46.1% |
|||
|
Services |
17.5% |
15.2% |
17.7% |
20.9% |
24.6% |
|||
|
Software |
15.5% |
17.7% |
17.6% |
17.2% |
16.4% |
|||
|
Maintenance |
11.6% |
11.3% |
10.3% |
9.2% |
8.2% |
|||
|
Rentals and financing |
6.6% |
5.3% |
4.9% |
4.9% |
4.8% |
|||
|
Total revenue |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
|||
|
Hardware sales |
33.0% |
33.3% |
30.4% |
30.8% |
30.0% |
|||
|
Services |
6.9% |
12.1% |
14.0% |
16.7% |
19.5% |
|||
|
Software |
13.2% |
7.3% |
6.2% |
5.4% |
4.8% |
|||
|
Maintenance |
5.7% |
5.7% |
5.1% |
4.8% |
4.3% |
|||
|
Rentals and financing |
2.8% |
2.2% |
2.2% |
2.1% |
2.4% |
|||
|
Total cost |
61.5% |
60.5% |
57.8% |
59.8% |
61.0% |
|||
|
Gross profit |
38.5% |
39.5% |
42.2% |
40.2% |
39.0% |
|||
|
Sell gen & admin exp |
29.2% |
24.8% |
23.3% |
22.2% |
21.2% |
|||
|
R&D expenditures |
8.9% |
6.8% |
5.8% |
6.1% |
6.2% |
|||
|
Purchased in-process R&D |
14.3% |
- |
2.6% |
0.6% |
- |
|||
|
Total operating expenses |
52.3% |
31.7% |
31.7% |
28.9% |
27.4% |
|||
|
Operating income |
-13.8% |
7.8% |
10.6% |
11.3% |
11.6% |
|||
|
Other income |
1.8% |
2.1% |
1.3% |
0.9% |
0.8% |
|||
|
Interest expense |
2.0% |
1.9% |
1.0% |
0.9% |
0.9% |
|||
|
Earnings before income tax |
-14.0% |
8.0% |
10.9% |
11.3% |
11.5% |
|||
|
Provision for income taxes |
-1.3% |
3.3% |
5.1% |
4.2% |
3.7% |
|||
|
Net earnings before changes |
||||||||
|
in accounting principles |
-12.7% |
4.7% |
5.8% |
7.1% |
7.8% |
|||
|
Effect of changes |
-0.2% |
- |
- |
- |
- |
|||
|
Net earnings |
-12.9% |
4.7% |
5.8% |
7.1% |
7.8% |
|||
|
Preferred stock dividends |
0.1% |
0.1% |
0.1% |
0.0% |
0.0% |
|||
|
Net earnings applicable |
||||||||
|
to common shareholders |
-13.0% |
4.6% |
5.7% |
7.1% |
7.7% |
|||
|
Exibit 5 Horizontal Common-size Balance Sheet - [IBM] |
||||||||
|
1993 |
1994 |
1995 |
1996 |
1997 |
||||
|
Assets |
||||||||
|
Cash & cash equivalent |
100.0% |
135.2% |
123.9% |
131.2% |
121.2% |
|||
|
Marketable securities |
100.0% |
206.9% |
34.7% |
35.4% |
35.1% |
|||
|
Notes & accounts receivable |
100.0% |
120.1% |
140.9% |
141.4% |
144.3% |
|||
|
Sales-type leases receivable |
100.0% |
120.1% |
92.7% |
89.0% |
89.0% |
|||
|
Other accounts receivable |
100.0% |
89.0% |
75.8% |
71.2% |
96.0% |
|||
|
Inventories |
100.0% |
83.7% |
83.6% |
77.6% |
67.9% |
|||
|
Prepaid expenses & other c/a |
100.0% |
57.3% |
64.1% |
69.1% |
76.6% |
|||
|
Total current assets |
100.0% |
105.4% |
103.8% |
103.8% |
103.1% |
|||
|
Prop, plant & equip |
100.0% |
94.3% |
92.6% |
88.2% |
88.7% |
|||
|
Accumulated depreciation |
100.0% |
93.9% |
91.4% |
81.7% |
79.3% |
|||
|
Net prop, plant & equip |
100.0% |
95.1% |
94.6% |
99.3% |
104.7% |
|||
|
Software, less accu amort |
100.0% |
80.0% |
65.3% |
38.8% |
22.1% |
|||
|
Investments & sundry assets |
100.0% |
97.3% |
99.6% |
104.4% |
105.9% |
|||
|
Total Assets |
100.0% |
100.0% |
99.0% |
100.0% |
100.5% |
|||
|
Liabilities & Equity |
||||||||
|
Taxes |
100.0% |
111.5% |
165.8% |
190.6% |
149.8% |
|||
|
Short-term debt |
100.0% |
79.1% |
95.6% |
107.1% |
109.4% |
|||
|
Accounts payable |
100.0% |
111.1% |
132.7% |
140.2% |
153.4% |
|||
|
Compensation & benefits |
100.0% |
131.6% |
141.9% |
143.7% |
148.2% |
|||
|
Deferred income |
100.0% |
104.3% |
97.0% |
101.8% |
96.4% |
|||
|
Other accrued exp & liab |
100.0% |
76.0% |
62.8% |
63.8% |
59.3% |
|||
|
Total current liabilities |
100.0% |
88.2% |
95.5% |
102.6% |
101.1% |
|||
|
Long-term debt |
100.0% |
82.3% |
66.0% |
64.8% |
89.8% |
|||
|
Other liabilities |
100.0% |
125.5% |
128.4% |
125.3% |
116.2% |
|||
|
Deferred income taxes |
100.0% |
104.3% |
100.2% |
90.2% |
82.5% |
|||
|
Total liabilities |
100.0% |
94.0% |
94.3% |
97.0% |
100.5% |
|||
|
Preferred stock |
100.0% |
99.1% |
23.2% |
23.2% |
23.1% |
|||
|
Common stock net |
100.0% |
105.2% |
107.3% |
111.1% |
123.2% |
|||
|
Retained earnings |
100.0% |
123.4% |
116.2% |
111.8% |
110.0% |
|||
|
Translation adjustments |
100.0% |
161.2% |
183.1% |
144.8% |
47.7% |
|||
|
Treasury stick, at cost |
100.0% |
120.6% |
397.1% |
2782.4% |
||||
|
Net unrealized gain on m/s |
100.0% |
294.7% |
189.5% |
|||||
|
Total stockholders' equity |
100.0% |
118.6% |
113.6% |
109.6% |
100.4% |
|||
|
Total Liabilities & Equity |
100.0% |
100.0% |
99.0% |
100.0% |
100.5% |
|||
|
Exibit 6 Horizontal Commom-size Income Statement - [IBM] |
||||||||
|
1993 |
1994 |
1995 |
1996 |
1997 |
||||
|
Hardware sales |
100.0% |
105.7% |
116.4% |
118.7% |
118.4% |
|||
|
Services |
100.0% |
88.7% |
116.1% |
144.9% |
176.2% |
|||
|
Software |
100.0% |
116.8% |
130.3% |
134.4% |
132.3% |
|||
|
Maintenance |
100.0% |
99.0% |
101.6% |
95.7% |
87.8% |
|||
|
Rentals and financing |
100.0% |
82.2% |
85.5% |
89.4% |
89.6% |
|||
|
Total revenue |
100.0% |
102.1% |
114.7% |
121.1% |
125.2% |
|||
|
Hardware sales |
100.0% |
102.9% |
105.6% |
113.0% |
113.7% |
|||
|
Services |
100.0% |
180.3% |
233.0% |
293.4% |
354.5% |
|||
|
Software |
100.0% |
56.5% |
53.5% |
49.3% |
45.7% |
|||
|
Maintenance |
100.0% |
99.0% |
103.0% |
103.2% |
95.7% |
|||
|
Rentals and financing |
100.0% |
79.6% |
91.5% |
93.4% |
109.4% |
|||
|
Total cost |
100.0% |
100.5% |
107.8% |
117.7% |
124.2% |
|||
|
Gross profit |
100.0% |
104.7% |
125.8% |
126.5% |
126.8% |
|||
|
Sell gen & admin exp |
100.0% |
87.1% |
91.7% |
92.2% |
91.0% |
|||
|
R&D expenditures |
100.0% |
78.5% |
75.0% |
83.7% |
87.7% |
|||
|
Purchased in-process R&D |
100.0% |
- |
20.6% |
4.9% |
- |
|||
|
Total operating expenses |
100.0% |
61.9% |
69.5% |
66.9% |
65.6% |
|||
|
Operating income |
100.0% |
-57.9% |
-87.9% |
-99.5% |
-105.3% |
|||
|
Other income |
100.0% |
123.7% |
85.1% |
63.5% |
59.0% |
|||
|
Interest expense |
100.0% |
96.4% |
57.0% |
56.2% |
57.2% |
|||
|
Earnings before income tax |
100.0% |
-58.6% |
-88.8% |
-97.6% |
-102.6% |
|||
|
Provision for income taxes |
100.0% |
-263.5% |
-448.8% |
-389.9% |
-362.2% |
|||
|
Net earnings before changes |
||||||||
|
in accounting principles |
100.0% |
-37.8% |
-52.3% |
-68.0% |
-76.3% |
|||
|
Effect of changes |
100.0% |
- |
- |
- |
- |
|||
|
Net earnings |
100.0% |
-37.3% |
-51.6% |
-67.0% |
-75.2% |
|||
|
Preferred stock dividends |
100.0% |
178.7% |
131.9% |
42.6% |
42.6% |
|||
|
Net earnings applicable |
||||||||
|
to common shareholders |
100.0% |
-36.0% |
-50.5% |
-66.4% |
-74.5% |
|||
|
Outstanding Shares |
100.0% |
100.7% |
97.9% |
90.9% |
169.2% |
|||
|
Net earnings per share |
100.0% |
-35.8% |
-51.6% |
-73.0% |
-44.1% |
|||
|
Exibit 7 Ratio Analysis - [IBM] |
||||||||
|
1993 |
1994 |
1995 |
1996 |
1997 |
||||
|
1. LIQUIDITY |
||||||||
|
Current Ratio |
1.2 |
1.4 |
1.3 |
1.2 |
1.2 |
|||
|
Quick Ratio |
1.0 |
1.2 |
1.1 |
1.0 |
1.1 |
|||
|
2. LEVERAGE |
||||||||
|
Debt Ratio |
0.76 |
0.71 |
0.72 |
0.73 |
0.76 |
|||
|
Long Term Debt To Assets |
0.19 |
0.15 |
0.13 |
0.12 |
0.17 |
|||
|
Times Interest Earned |
(5.91) |
5.20 |
11.78 |
12.99 |
13.40 |
|||
|
3. ACTIVITY |
||||||||
|
Average Collection Period |
111.4 |
121.0 |
117.1 |
109.8 |
109.3 |
|||
|
Inventory Turnover |
5.1 |
6.1 |
6.6 |
7.7 |
9.3 |
|||
|
Fixed Asset Turnover |
1.5 |
1.6 |
1.8 |
1.9 |
1.9 |
|||
|
Total Asset Turnover |
0.8 |
0.8 |
0.9 |
0.9 |
1.0 |
|||
|
4. PROFITABILITY |
||||||||
|
Gross Margin |
38.5% |
39.5% |
42.2% |
40.2% |
39.0% |
|||
|
Operating Margin |
-12.0% |
10.0% |
11.9% |
12.2% |
12.4% |
|||
|
Net Profit Margin |
-12.9% |
4.7% |
5.8% |
7.1% |
7.8% |
|||
|
Return On Assets |
-10.0% |
3.7% |
5.2% |
6.7% |
7.5% |
|||
|
Return On Equity |
-41.0% |
12.9% |
18.6% |
25.1% |
30.7% |
|||
|
Equity Multiplier |
4.1 |
3.5 |
3.6 |
3.8 |
4.1 |
|||
|
5. MARKET VALUE |
||||||||
|
Share price at the year end |
28.25 |
36.75 |
45.69 |
75.75 |
104.63 |
|||
|
Earning Per Share |
(7.11) |
2.51 |
3.61 |
5.12 |
6.18 |
|||
|
Price To Earnings Ratio |
(3.97) |
14.63 |
12.64 |
14.80 |
16.94 |
|||
|
Book Value Per Share |
17.22 |
20.03 |
19.69 |
20.46 |
20.16 |
|||
|
Market To Book Value Ratio |
1.64 |
1.83 |
2.32 |
3.70 |
5.19 |
|||
|
Cash Flow Per Share |
(2.96) |
6.17 |
7.14 |
8.61 |
10.29 |
|||
|
6. PRODUCTIVITY |
||||||||
|
Number of Employee |
256,500 |
219,839 |
225,347 |
240,615 |
262,000 |
|||
|
Cash Flow Per Employee |
(13,220) |
32,833 |
36,091 |
37,841 |
38,592 |
|||
|
Sales Revenue Per Employee |
244,507 |
291,359 |
319,241 |
315,637 |
299,649 |
|||
|
Profit Per Employee |
(31,583) |
13,742 |
18,540 |
22,563 |
23,256 |
|||
|
R&D Expense To Sales |
8.9% |
6.8% |
5.8% |
6.1% |
6.2% |
|||
|
7. GROWTH RATE |
||||||||
|
Sales |
- |
2.1% |
12.3% |
5.6% |
3.4% |
|||
|
Gross Profit |
- |
4.7% |
20.1% |
0.6% |
0.2% |
|||
|
Operating Profit |
- |
-184.8% |
33.8% |
9.0% |
4.9% |
|||
|
Net Profit |
- |
-137.3% |
38.3% |
29.9% |
12.2% |
|||
|
Common Dividends |
- |
-29.0% |
-10.7% |
19.5% |
10.9% |
|||