Spreadsheet: danny_mccarty__4660__IdleAire 10-2001 Valuation
Sheet: CPA Companies

 | Closing | Shares | Market | Revenues | EBITDA | Earnings | Price to
Period | Price | Outstanding | Capitalization | 4 x ttm | 4 x ttm | 4 x ttm | Sales | EBITDA | Income
 |  | (M) | ($M) | ($M) | ($M) | ($M)
[NAME] (QCOM)
4Q01 | 43.75 | 749.8
3Q01 | 47.54 | 749.8
2Q01 | 58.48 | 749.8
1Q01 | 56.625 | 749.8
4Q00 | 82.1875 | 749.482
3Q00 | 71.25
2Q00 | 60 | 741.735
1Q00 | 149.3125 | 716.818
4Q99 | 176.125 | 664.586
3Q99 | 189.1875
2Q99 | 143.5
1Q99 | 124.375
4Q98 | 51.8125
3Q98 | 47.9375
2Q98 | 56.1875
1Q98 | 53.5
Motorola, Inc. (MOT)
4Q01 | 15.35
3Q01 | 15.6
2Q01 | 16.56
1Q01 | 14.26 | 2180
4Q00 | 20.25 | 2180 |  | 37600 | 4830 | 1320
3Q00 | 28.881875 | 2182.3
2Q00 | 30.2542 | 2165
1Q00 | 48.5725
4Q99 | 48.9875 | 2180
3Q99 | 29.2768 | 2123.8
2Q99 | 31.5225 | 2112
1Q99 | 24.3696
4Q98 | 20.3149
3Q98 | 14.2641
2Q98 | 17.4869
1Q98 | 20.2108
[NAME] (WMB)
4Q01 | 28.32
3Q01 | 27.3
2Q01 | 32.95
1Q01 | 42.85 | 477
4Q00 | 39.9375 | 477 |  | 12600 | 2100 | 651.3
3Q00 | 42.0802 | 450.294
2Q00 | 41.3832
1Q00 | 43.4646 | 442.884
4Q99 | 30.1404
3Q99 | 36.9301 | 442.244
2Q99 | 41.6346 | 441.746
1Q99 | 38.5298 | 432.091
4Q98 | 30.2867
3Q98 | 27.7707 | 428.594
2Q98 | 32.4318 | 426.163
1Q98 | 30.6046 | 417.347
FuelCell Energy, Inc. (FCEL)
4Q01 | 17.16 | 15.8
3Q01 | 14.81 | 15.8
2Q01 | 23.09 | 15.8
1Q01 | 50.5 | 15.8
4Q00 | 68.5625 | 15.8
3Q00 | 96.2344 | 15.73
2Q00 | 69.0625 | 15.37
1Q00 | 78.25
4Q99 | 25.0625
3Q99 | 26.375 | 12.65
2Q99 | 14.25 | 12.55
1Q99 | 8.5 | 12.5
4Q98 | 14
3Q98 | 12.875 |  |  |  | -0.1 | -0.1
2Q98 | 19.75 |  |  |  | -0.1 | -0.1
1Q98 | 26.75 |  |  |  | -0.1 | -0.1
Extended Stay America (ESA)
4Q01 | 15.54
3Q01 | 14.47
2Q01 | 15
1Q01 | 15 | 95.4 |  | 494.6 | 244.6 | 64.8
4Q00 | 12.85 | 95.4
3Q00 | 13.25 | 95.192
2Q00 | 9.25 | 95.232
1Q00 | 7.5 | 95.632
4Q99 | 7.5625
3Q99 | 9 | 96.523
2Q99 | 12 | 96.278
1Q99 | 10.1875 | 95.974
4Q98 | 10.5
3Q98 | 8 | 96.033
2Q98 | 11.25 | 95.897
1Q98 | 14.625 | 95.698
TiVo, Inc. (TIVO)
4Q01 | 3.16
3Q01 | 3.32
2Q01 | 5.5
1Q01 |  | 43.4 |  |  | -209 | -206
4Q00 | 5.375 | 43.4
3Q00 | 19.375 | 36.923633
2Q00 | 35 | 35.742848
1Q00 | 34.625 | 35.353442
4Q99 | 33.75 | 43.4
3Q99 | 29.9375 | 41.738509
2Q99
1Q99 |  | 3.401
4Q98
3Q98
2Q98
1Q98
Emerson ([NAME])
4Q01 | 47.5
3Q01 | 47.06
2Q01 | 60.5
1Q01 | 62 | 428.8
4Q00 | 78.8125
3Q00 | 67
2Q00 | 60.375
1Q00 | 53.125
4Q99 | 57.375
3Q99 | 63.1875
2Q99 | 62.9375
1Q99 | 52.9375
4Q98 | 60.5
3Q98 | 62.25
2Q98 | 60.375
1Q98 | 65.1875
Cox Communications (COX)
4Q01 | 42.08
3Q01 | 41.75
2Q01 | 44.3
1Q01 | 44.49 | 599.8
4Q00 | 46.525 | 599.8
3Q00 | 38.25 | 600.997165
2Q00 | 45.5469 | 603.31667
1Q00 | 48.5 | 599.8
4Q99 | 51.5 | 599.8
3Q99 | 41.75 | 576.103113
2Q99 | 36.8125 | 555.102887
1Q99 | 37.8125
4Q98 | 34.525
3Q98 | 27.3125
2Q98 | 24.2188
1Q98 | 21
Metricom (MCOM)
4Q01
3Q01
2Q01
1Q01 | 4.531 | 30.8 |  | 11.8 | -218.9 | -245.5
4Q00 | 10.0625 | 30.785
3Q00 | 25.75 | 30.747
2Q00 | 27.875 | 30.654
1Q00 | 46.375 | 28.16
4Q99 | 78.625 | 22.398
3Q99 | 22.75 | 20.889
2Q99 | 20 | 19.296
1Q99 | 6.4375 | 18.873
4Q98 | 5.1875
3Q98 | 5 | 18.61
2Q98 | 8.4062 | 18.512
1Q98 | 9.875 | 16.944
Enron (ENE)
4Q01 | 33.5
3Q01 | 27.23
2Q01 | 49.1
1Q01 | 58.1 | 872
4Q00 | 82.9777
3Q00 | 87.3459 | 870
2Q00 | 87.3459 | 862
1Q00 | 74.3803 | 852
4Q99 | 43.9979
3Q99 | 40.5787 | 781
2Q99 | 40.2743 | 771 |  | 40000
1Q99 | 31.5445 | 745
4Q98 | 57.0625
3Q98 | 53.5 | 713
2Q98 | 54.0625
1Q98 | 46.375
Ballard Power Systems (BLDP)
4Q01 | 24.78
3Q01 | 19.56
2Q01 | 53.23
1Q01 | 39.9375 | 89.461981
4Q00 | 63.1562
3Q00 | 109.2656 | 89.1
2Q00 | 89.8125 | 89.1 |  | 75 | -55 | -59
1Q00 | 84.5 |  |  | 70
4Q99 | 28.1875 | 83.988423
3Q99 | 28.875 | 89.1 |  | 65
2Q99 | 32 | 89.1 |  | 60
1Q99 | 30.875 | 89.1 |  | 55
4Q98 | 27.5 | 89.1 |  | 50
3Q98 | 22.5 | 89.1 |  | 45 | -0.1 | -0.1
2Q98 | 32.5625 | 89.1 |  | 40 | -0.1 | -0.1
1Q98 | 37.833 | 89.1 |  | 35 | -0.1 | -0.1
Itron, Inc. (ITRI)
4Q01 | 22
3Q01 | 23.02
2Q01 | 18.97 | 15.518
1Q01 | 11.875 | 15.69
4Q00 | 3.625
3Q00 | 6.125 | 15.237
2Q00 | 8.25 | 15.5
1Q00 | 6.9375 | 15.378
4Q99 | 6.125
3Q99 | 5.875 | 14.885
2Q99 | 8.5625 | 14.806
1Q99 | 9.375 | 15.312
4Q98 | 7.1875
3Q98 | 6.625 | 14.663
2Q98 | 12.75 | 14.686
1Q98 | 19.435 | 14.852