eco forecasting 2
Instructions attached below
ECO 309
Economic Forecasting
Project Part 2
This paper requires content knowledge in Chapters 2 5. Please listen to the lectures and read your chapters before starting the work. Follow the step by step directions to prepare an executive summary of your macroeconomic (X) variables (do NOT include the numbers while answering the questions). Please ONLY use the X variables that have significant statistical correlation to your company revenue.
1. Plot your X variables and decide if you have an additive or a multiplicative model as explained in decomposition part of your book.
2. Plot ACF of your X variables and identify trend/seasonality if any. Make sure to do your hypothesis testing for significance of autocorrelation. Do you have trend and/or seasonality?
3. For each X variable, run all three smoothing methods and pick the best one for your data.
4. Go to Time Series>Trend Analysis and try all 4 trend models. Pick the best one and tell me why it is the best one. Copy and paste ONLY the best trend model.
5. Go to Time Series>Decomposition, run both SEASONALY ONLY and SEASONAL + TREND. Also run both the additive and multiplicative models to confirm what you find in question 1. Which one is the best model, why?
6. For each X variable you are using, make a summary table of each model and the resulting error term. Pick the best overall model and generate 3 out-of-sample forecasts using the BEST overall model.
7. Rerun the best model, STORE your RESIDUALS and run ACF on your residuals and explain what you see.
8. Summarize what you learned for each X variable in 2 sentences. Introduction
Note about the Data UPDATED 12/28/2018
These company data were originally obtained from Bloomberg and were captured from
company quarterly 10-K reports filed with the SEC. They have been updated using Ycharts
See https://ycharts.com/companies/(company symbol)/revenues
Ycharts can provide company information based on the stock symbol that you have beside the company name.
Each of the data observations are expressed in millions of U.S. dollars.
Some of the company Revenue information do no have corresponding Sales
General and Administrative Expenses (SG&A). If they do not appear they were not reported.
Keep in mind, that you should inspect the data relative to continuity and outliers or values
that seem unusually high or low. If you find any missing data or outliers go the the company’s
filed 10-K report for the quarter in question to determine the cause.
You should have at least 35 recent data observations to derive a forecast. 50 observations or more
is preferred for a good forecast model. If the quarterly revenue is seasonal
you will need at least 50 revenue observations to capture data seasonality.
Note about using SG&A
The most active or volatile element in SG&A is selling, advertising and promotional expense.
The exception to this is due to acquisition, merger or divestiture that also changes SG&S dramatically.
The best way to use this variable in a forecast model as a determinant of sales and marketing
activity is to use a one period lag of the data that expresses a delayed causal change in the revenue data series.
For promotional and pricing campaigns look for revenue data uplifts following the campaign introductions.
Using a one quarter lag of SG&A may provide better information relative
to the effects of implementation of marketing, advertising, pricing and promotional plans by the company.
Remember with a one period lag you will lose an observation. In addition,
The one period lag is simply shifting the SG&A expense down (back one quarter) one period
relative to revenue listed from older to more recent values.
Companies Listed (126)
Primarily Internet Retailers
Amazon (AMZN)
eBay (EBAY)
Overstock.Com (OSTK)
Facebook (FB)
Alphabet (GOOGL)
Clothing and Retail
JC Penny (JCP)
GAP (GPS)
Sears (SHLD)
Best Buy (BBY)
Costco (COST)
WalMart (WMT)
Nordstrom (JWN)
Target (TGT)
Office Depot (ODP)
Bed Bath Beyond (BBBY)
Nike (NKE)
Macy’s (M)
Entertainment
Dish (DISH)
Disney (DIS)
NetFlix (NFLX)
TIVO (TIVO)
Comcast (CMCSA)
Charter Comm. (CHTR)
Insurance
Geico (BRK)
Aflac (AFL)
United Health Group (UNH)
Metlife (MET)
Prudential (PRU)
Humana (HUM)
AIG (AIG)
Centene (CNC)
Travelers (TRV)
Computers and High Tech
Apple (AAPL)
Microsoft (MSFT)
AMD (AMD)
Intel (INTC)
IBM (IBM)
Oracle (ORCL)
Hewlett Packard (HPQ)
Texas Instruments (TXN)
Cisco Systems (CSCO)
Honeywell (HON)
Auto Parts & Care
Oreillys Auto Parts (ORLY)
WD-40 (WDFC)
Auto Zone (AZO)
Genuine Parts Company (GPC)
Telecommunications
AT&T (T)
Verizon (VZ)
Sprint (S)
Comcast (CMCSA)
T-Mobile (TMUS)
Auto Companies
Ford Motor Company (F)
GM (GM)
Chrysler (FCAU)
Toyota (TOY)
Tesla (TSLA)
Harley Davidson (HOG)
Sporting Goods
Hibbett Sports (HIBB)
Dicks Sporting Goods (DKS)
Home Improvement
Home Depot (HD)
Lowes (LOW)
Airlines
JetBlue Airlines (JBLU)
American Airlines (AAL)
Southwest Arilines (LUV)
United Continental (UAL)
Hawaii Air (HA)
Alaska Air (ALK)
SkyWest US (SKYW)
Shipping
FedEx (FDX)
UPS (UPS)
JB Hunt (JBHT)
Union Pacific (UNP)
Food & Home
Hershey (HSY)
Kelloggs (K)
Proctor & Gamble (PG)
General Mills (GIS)
ConAgra CAG)
Coca Cola (KO)
Hormel Foods (HRL)
Campbell Soup (CPB)
Starbucks (SBUX)
McDonalds (MCD)
Pilgrim’s Pride (PPC)
PepsiCo (PEP)
Kroger (KR)
Archer Daniel Midland (ADM)
Sysco (SYY)
Home Builders
Pulte Homes (PHM)
KB Home (KBH)
Lennar (LEN)
Banking
JP Morgan Chase (JPM)
Citi Group
CoAmerica (CMA)
Wells Fargo (WFC)
Bank of America (BAC)
Goldman Sachs (GS)
Morgan Stanley (MS)
Capital One (COF)
Oil, Gas & Energy
Exxon Mobile (XOM)
Conoco Phillips (COP)
Chevron (CVX)
Marathon Oil (MRO)
Valero Energy (VLO)
Exelon (EXC)
AeroSpace
Boeing (BA)
Northrup Grumman (NOC)
Lockheed Martin (LMT)
Raytheon (RTN)
General Dynamics (GD)
Heavy Equipment
John Deere (DE)
Catepillar (CAT)
Industry and Chemicals
General Electric (GE)
Dow Chemical (DWDP)
3 M (MMM)
United Technologies (UTX)
Healthcare & Pharma
Johnson & Johnson JNJ)
Pfizer (PFE)
Merck (MRK)
McKesson (MCK)
CVS Health (CVS)
Amerisource Bergan (ABC)
Cardinal Health (CAH)
Express Scripts (ESRX)
Hotels and Leisure
Wyndham Destinations (Wynd)
Hyatt (H)
Marriott MAR)
Primarily Internet Retailers
Amazon (AMZN) eBay (EBAY) Overstock.com (OSTK) Alphabet (GOOGL) Facebook (FB)
Date Revenue Sales &Mkt Date Revenue Sales &Mkt Date Revenue Sales& Mkt Date Revenue Date Revnue
3/31/96 0.9 3/31/98 6.0 3/31/02 12.1 6/30/03 311.2 3/31/11 731.0
6/30/96 2.2 6/30/98 19.5 6/30/02 14.4 3/31/04 651.6 6/30/11 895.0
9/30/96 4.2 9/30/98 21.7 9/30/02 23.8 6/30/04 700.2 9/30/11 954.0
12/31/96 8.4 12/31/98 30.9 12/31/02 41.5 9/30/04 805.9 12/31/11 574.0
3/31/97 16.0 3/31/99 42.8 3/31/03 29.2 12/31/04 1031.5 3/31/12 872.0
6/30/97 27.9 6/30/99 49.5 6/30/03 28.8 3/31/05 1256.5 6/30/12 992.0
9/30/97 37.9 9/30/99 58.5 9/30/03 57.8 6/30/05 1384.5 9/30/12 1086.0
12/31/97 66.1 12/31/99 73.9 12/31/03 123.2 9/30/05 1578.5 12/31/12 1329.0
3/31/98 87.4 3/31/00 85.9 3/31/04 82.1 12/31/05 1919.1 3/31/13 1245.0
6/30/98 116.0 6/30/00 98.2 6/30/04 87.8 3/31/06 2253.8 6/30/13 1599.0
9/30/98 153.6 9/30/00 113.4 9/30/04 103.4 6/30/06 2456.0 9/30/13 1798.0
12/31/98 252.8 12/31/00 134.0 12/31/04 221.3 9/30/06 2689.7 12/31/13 2345.0
3/31/99 293.6 3/31/01 154.1 3/31/05 165.9 12/31/06 3205.5 3/31/14 2265.0
6/30/99 314.4 6/30/01 180.9 6/30/05 150.6 3/31/07 3664.0 6/30/14 2676.0
9/30/99 355.8 9/30/01 194.4 9/30/05 169.3 6/30/07 3872.0 9/30/14 2957.0
12/31/99 676.0 12/31/01 219.4 12/31/05 313.5 9/30/07 4231.4 12/31/14 3594.0
3/31/00 573.9 3/31/02 245.1 3/31/06 178.0 12/31/07 4826.7 3/31/15 3317.0
6/30/00 577.9 6/30/02 266.3 6/30/06 159.2 3/31/08 5186.0 6/30/15 3827.0
9/30/00 637.9 9/30/02 288.8 9/30/06 156.9 6/30/08 5367.2 9/30/15 4299.0
12/31/00 972.4 12/31/02 413.9 12/31/06 294.0 9/30/08 5541.4 12/31/15 5637.0
3/31/01 700.4 3/31/03 476.5 3/31/07 157.9 12/31/08 5700.9 3/31/16 5201.0
6/30/01 667.6 6/30/03 509.3 6/30/07 149.0 3/31/09 5509.0 6/30/16 6239.0
9/30/01 639.3 9/30/03 530.9 9/30/07 160.1 6/30/09 5523.0 9/30/16 6816.0
12/31/01 1115.0 12/31/03 648.4 12/31/07 288.8 9/30/09 5945.0 12/31/16 8629.0
3/31/02 847.4 3/31/04 756.2 3/31/08 200.7 12/31/09 6674.0 3/31/17 7857.0
6/30/02 805.6 6/30/04 773.4 6/30/08 188.8 14.2 3/31/10 6775.0 6/30/17 9164.0
9/30/02 851.3 9/30/04 805.9 9/30/08 186.9 14.5 6/30/10 6820.0 9/30/17 10142.0
12/31/02 1429.0 12/31/04 935.8 12/31/08 251.3 14.2 9/30/10 7286.0 12/31/17 12779.0
3/31/03 1084.0 3/31/05 1032.0 3/31/09 185.7 13.6 12/31/10 7355.0 3/31/18 11795.0
6/30/03 1100.0 6/30/05 1086.0 6/30/09 174.9 11.2 3/31/11 8575.0 6/30/18 13038.0
9/30/03 1134.0 9/30/05 1106.0 9/30/09 193.8 12.2 6/30/11 9026.0 9/30/18 13539.0
12/31/03 1946.0 12/31/05 1329.0 12/31/09 322.4 18.6 9/30/11 9720.0 12/31/18 16910.0
3/31/04 1530.0 3/31/06 1390.0 3/31/10 264.3 14.3 12/31/11 9209.0
6/30/04 1387.0 6/30/06 1411.0 6/30/10 231.3 14.2 3/31/12 10225.0
9/30/04 1463.0 9/30/06 1449.0 9/30/10 245.4 15.6 6/30/12 11368.0
12/31/04 2541.0 12/31/06 1720.0 12/31/10 348.9 17.3 9/30/12 12638.0
3/31/05 1902.0 3/31/07 1768.0 3/31/11 265.5 15.4 12/31/12 9455.0
6/30/05 1753.0 6/30/07 1834.0 6/30/11 235.0 13.7 3/31/13 11902.0
9/30/05 1858.0 9/30/07 1889.0 9/30/11 239.7 13.8 6/30/13 12061.0
12/31/05 2977.0 12/31/07 2181.0 12/31/11 314.1 18.9 9/30/13 12524.0
3/31/06 2279.0 3/31/08 2192.0 514.6 3/31/12 262.4 14.5 12/31/13 14585.0
6/30/06 2139.0 6/30/08 2196.0 483.2 6/30/12 239.5 13.5 3/31/14 13997.0
9/30/06 2307.0 9/30/08 2118.0 451.8 9/30/12 255.4 14.9 6/30/14 14498.0
12/31/06 3986.0 12/31/08 2036.0 418.4 12/31/12 342.0 20.6 9/30/14 14820.0
3/31/07 3015.0 3/31/09 2021.0 403.3 3/31/13 312.0 18.7 12/31/14 16309.0
6/30/07 2886.0 6/30/09 2098.0 464.5 6/30/13 293.2 19.2 3/31/15 15508.0
9/30/07 3262.0 9/30/09 2238.0 491.5 9/30/13 301.4 22.5 6/30/15 16023.0
12/31/07 5672.0 12/31/09 2371.0 526.4 12/31/13 397.6 31.2 9/30/15 18534.0
3/31/08 4135.0 3/31/10 2196.0 4446.2 3/31/14 341.2 23.4 12/31/15 14025.0
6/30/08 4063.0 6/30/10 2215.0 478.2 6/30/14 332.5 23.5 3/31/16 20092.0
9/30/08 4264.0 108.0 9/30/10 2249.0 483.7 9/30/14 353.0 25.4 6/30/16 19143.0
12/31/08 6703.0 169.0 12/31/10 2495.0 538.0 12/31/14 470.4 37.1 9/30/16 19821.0
3/31/09 4889.0 128.0 3/31/11 2546.0 533.0 3/31/15 398.3 28.0 12/31/16 22399.0
6/30/09 4651.0 129.0 6/30/11 2760.0 608.0 6/30/15 388.0 28.1 3/31/17 24618.0
9/30/09 5449.0 149.0 9/30/11 2966.0 623.0 9/30/15 391.2 30.1 6/30/17 25913.0
12/31/09 9520.0 274.0 12/31/11 3380.0 672.0 12/31/15 480.3 38.3 9/30/17 24065.0
3/31/10 7131.0 201.0 3/31/12 3277.0 677.0 3/31/16 413.7 31.5 12/31/17 27227.0
6/30/10 6566.0 311.0 6/30/12 3398.0 717.0 6/30/16 418.5 33.4 3/31/18 30996.0
9/30/10 7560.0 241.0 9/30/12 3404.0 726.0 9/30/16 441.6 34.7 6/30/18 32512.0
12/31/10 12950.0 376.0 12/31/12 3993.0 793.0 12/31/16 526.2 48.4 9/30/18 28954.0
3/31/11 9857.0 327.0 3/31/13 3748.0 697.0 3/31/17 432.4 37.6 12/30/08 39280.0
6/30/11 9913.0 341.0 6/30/13 3877.0 771.0 6/30/17 432.0 43.3
9/30/11 10880.0 370.0 9/30/13 3892.0 755.0 9/30/17 424.0 45.2
12/31/11 17430.0 593.0 12/31/13 3260.0 -79.0 12/31/17 456.3 54.5
3/31/12 13180.0 480.0 3/31/14 4262.0 805.0 3/31/18 445.3 77.2
6/30/12 12830.0 537.0 6/30/14 4103.0 885.0 6/30/18 483.1 94.3
9/30/12 13810.0 540.0 9/30/14 2150.0 624.0 9/30/18 440.6 55.3
12/31/12 21270.0 851.0 12/31/14 2323.0 627.0 12/30/08 452.6
3/31/13 16070.0 632.0 3/31/15 2061.0 519.0
6/30/13 15700.0 675.0 6/30/15 2110.0 588.0
9/30/13 17090.0 694.0 9/30/15 2099.0 565.0
12/31/13 25590.0 1132.0 12/31/15 2322.0 595.0
3/31/14 19740.0 870.0 3/31/16 2137.0 538.0
6/30/14 19340.0 943.0 6/30/16 2230.0 622.0
9/30/14 20580.0 993.0 9/30/16 2217.0 600.0
12/31/14 29330.0 1526.0 12/31/16 2395.0 608.0
3/31/15 22720.0 1083.0 3/31/17 2217.0 648.0
6/30/15 23180.0 1150.0 6/30/17 2328.0 637.0
9/30/15 25360.0 1264.0 9/30/17 2409.0 627.0
12/31/15 35750.0 1758.0 12/31/17 2613.0 689.0
3/31/16 29130.0 1436.0 3/31/18 2580.0 756.0
6/30/16 30400.0 1546.0 6/30/18 2640.0 838.0
9/30/16 32710.0 1738.0 9/30/18 2649.0 852.0
12/31/16 43740.0 2513.0 12/31/18 2877.0
3/31/17 35710.0 1920.0
6/30/17 37960.0 2229.0
9/30/17 43740.0 2479.0
12/31/17 60450.0 3440.0
3/31/18 51049.0 2699.0
6/30/18 52890.0 2901.0
9/30/18 56580.0 3303.0
12/31/18 72380.0
Clothing & Retail
J.C.Penny (JCP) GAP (GPS) Sears (SHLD) Best Buy (BBY) Costco (C0ST) Walmart (WMT) Target (TGT) Nordstrom (JWN) Office Depot (ODP) Bed Bath & Beyod (BBBY) Nike (NKE) Macys Inc.(M)
Date Revenue SG&A Date Revenue Date Revenue SG&A Date Revenue SG&A Date Revenue SG&A Date Revenue SG&A Date Revenue SG&A Date Revenue SG&A Date Revenue Date Revenue Date Revenue Sales & Mkt Date Revenue SG&A
3/30/90 3530.0 1149.0 3/30/90 402.4 3/31/95 7443.0 3/30/90 198.3 33.4 6/29/90 1177.0 90.6 3/30/90 6768.0 1103.0 3/30/90 3007.0 544.0 6/30/92 951.6 242.2 3/31/87 8.4 9/30/91 42.8 2/29/84 224.0 4/30/92 1571.700 382.4
6/29/90 3580.0 1175.0 6/29/90 405.0 6/30/95 8440.0 6/29/90 126.1 28.3 9/28/90 1200.0 93.5 6/29/90 7544.0 1227.0 6/29/90 3242.0 563.0 9/30/92 737.3 213.4 6/30/87 8.4 12/31/91 45.6 5/31/84 256.7 7/31/92 1457.200 557.8
9/28/90 3995.0 1276.0 9/28/90 501.7 9/29/95 7975.0 9/28/90 152.2 31.6 12/31/90 2162.0 160.4 9/28/90 7931.0 1310.0 9/28/90 3625.0 647.0 12/31/92 1069.0 257.7 9/30/87 8.4 3/31/92 46.8 8/31/84 284.6 10/31/92 1789.000 614.8
12/31/90 5260.0 1708.0 12/31/90 624.7 12/29/95 7855.0 12/31/90 170.8 33.1 3/29/91 1362.0 113.9 12/31/90 10360.0 1512.0 12/31/90 4865.0 724.0 3/31/93 695.6 208.2 12/31/87 8.3 6/30/92 41.7 11/30/84 183.9 1/31/93 2262.000 686.0
3/29/91 3433.0 1161.0 3/29/91 490.3 3/29/96 6975.0 3/29/91 215.7 37.7 6/28/91 1504.0 122.0 3/29/91 9281.0 1485.0 3/29/91 3349.0 607.0 6/30/93 1018.0 248.3 3/31/88 27.8 9/30/92 54.0 2/28/85 220.7 4/30/93 1590.300 555.6
6/28/91 3456.0 1160.0 6/28/91 523.1 6/28/96 7566.0 6/28/91 165.6 34.2 9/30/91 1570.0 132.6 6/28/91 10340.0 1616.0 6/28/91 3562.0 639.0 9/30/93 769.4 216.3 6/30/88 27.8 12/31/92 56.5 5/31/85 257.2 7/31/93 1502.300 540.2
9/30/91 3937.0 1225.0 9/30/91 702.1 9/30/96 7212.0 9/30/91 193.6 36.7 12/31/91 2454.0 193.7 9/30/91 10630.0 1697.0 9/30/91 3955.0 711.0 12/31/93 1107.0 267.7 9/30/88 27.8 3/31/93 64.5 8/31/85 327.7 10/31/93 1789.300 604.6
12/31/91 5375.0 1737.0 12/31/91 803.5 12/31/96 9684.0 12/31/91 230.6 39.6 3/31/92 1519.0 139.0 12/31/91 13640.0 1887.0 12/31/91 5249.0 844.0 3/31/94 762.1 214.9 12/31/88 48.6 6/30/93 57.7 11/30/85 237.9 1/31/94 2347.500 623.1
3/31/92 3793.0 1195.0 3/31/92 588.9 3/31/97 7263.0 3/31/92 339.9 51.7 6/30/92 1658.0 144.8 3/31/92 11650.0 1808.0 3/31/92 3719.0 656.0 6/30/94 1080.0 267.6 3/31/89 63.5 9/30/93 79.1 2/28/86 258.7 4/30/94 1653.600 542.1
6/30/92 3789.0 1208.0 6/30/92 614.1 6/30/97 7846.0 6/30/92 246.5 46.8 9/30/92 1689.0 152.0 6/30/92 13030.0 1996.0 6/30/92 3967.0 704.0 9/30/94 862.0 246.3 6/30/89 63.8 12/31/93 81.1 5/31/86 244.9 7/31/94 1596.100 534.8
9/30/92 4342.0 1261.0 9/30/92 827.2 9/30/97 7315.0 9/30/92 285.4 49.5 12/31/92 2590.0 223.8 9/30/92 13680.0 2143.0 9/30/92 4340.0 756.0 12/30/94 1191.0 294.5 9/30/89 83.4 3/31/94 87.8 8/31/86 257.2 10/31/94 1926.800 611.6
12/31/92 6085.0 1496.0 12/31/92 930.2 12/31/97 9759.0 12/31/92 474.4 68.0 3/31/93 1634.0 159.7 12/31/92 17120.0 2374.0 12/31/92 5901.0 862.0 3/31/95 815.6 239.8 12/31/89 103.9 6/30/94 85.9 11/30/86 183.1 1/31/95 3139.400 860.7
3/31/93 3964.0 1187.0 3/31/93 643.6 3/31/98 7515.0 3/31/93 613.6 83.8 6/30/93 1729.0 162.6 3/31/93 13920.0 2246.0 3/31/93 4040.0 698.0 6/30/95 1149.0 299.8 3/31/90 142.6 9/30/94 111.5 2/28/87 199.4 4/30/95 2988.000 1070.0
6/30/93 3963.0 1192.0 6/30/93 693.2 6/30/98 8116.0 6/30/93 441.9 70.8 9/30/93 9202.0 821.2 6/30/93 16240.0 2520.0 6/30/93 4287.0 748.0 9/29/95 906.8 267.6 6/30/90 136.8 12/31/94 115.0 5/31/87 237.7 7/31/95 3047.200 1067.9
9/30/93 4735.0 1315.0 9/30/93 898.7 9/30/98 7642.0 9/30/93 563.0 81.1 12/31/93 3688.0 321.7 9/30/93 16830.0 2719.0 9/30/93 4625.0 809.0 12/29/95 1242.0 314 9/30/90 165.3 3/31/95 127.9 8/31/87 282.8 10/31/95 3748.400 1275.7
12/31/93 6321.0 814.0 12/31/93 1060.0 12/31/98 10401.0 12/31/93 808.5 100.3 3/31/94 4101.0 352.6 12/31/93 20360.0 2848.0 12/31/93 6281.0 920.0 3/31/96 906.0 268.8 12/31/90 181.1 6/30/95 113.5 11/30/87 234.4 1/31/96 5264.900 1334.8
3/31/94 4350.0 1092.0 3/31/94 751.7 3/31/99 8078.0 3/31/94 1193.0 127.5 6/30/94 3620.0 335.8 3/31/94 17690.0 2846.0 3/31/94 4465.0 820.0 6/30/96 1242.0 328.8 3/31/91 226.2 9/30/95 150.1 2/29/88 331.8 4/30/96 3300.700 1230.8
6/30/94 4242.0 1079.0 6/30/94 773.1 6/30/99 8780.0 6/30/94 849.4 107.3 9/30/94 5072.0 404.3 6/30/94 19940.0 3169.0 6/30/94 4802.0 874.0 9/30/96 984.4 288.6 6/30/91 302.7 12/31/95 161.8 5/31/88 354.4 7/31/96 3284.200 1183.8
9/30/94 5149.0 1204.0 9/30/94 988.3 9/30/99 7962.0 9/30/94 933.2 114.5 12/30/94 4030.0 350.2 9/30/94 20420.0 3340.0 9/30/94 5046.0 910.0 12/31/96 1321.0 331.3 9/30/91 331.8 3/31/96 175.9 8/31/88 510.7 10/31/96 3609.100 1231.9
12/30/94 6639.0 1408.0 12/30/94 1210.0 12/31/99 11104.0 12/30/94 1350.0 145.7 3/31/95 4307.0 358.4 12/30/94 24450.0 3502.0 12/30/94 6998.0 1027.0 3/31/97 953.7 274.3 12/31/91 341.0 6/30/96 159.7 11/30/88 322.0 1/31/97 5035.000 1306.4
3/31/95 4564.0 1148.0 3/31/95 848.7 3/31/00 8195.0 3/31/95 1947.0 201.0 6/30/95 3896.0 345.2 3/31/95 20440.0 3377.0 3/31/95 4757.0 893.0 6/30/97 1353.0 350.4 3/31/92 433.3 9/30/96 203.5 2/28/89 464.7 4/30/97 3409.100 1174.2
6/30/95 4643.0 1107.0 6/30/95 868.5 6/30/00 8998.0 6/30/95 1275.0 165.9 9/29/95 5672.0 501.7 6/30/95 22720.0 3693.0 6/30/95 5236.0 941.0 9/30/97 1090.0 326.2 6/30/92 386.8 12/31/96 214.8 5/31/89 413.4 7/31/97 3452.800 1142.3
9/29/95 5352.0 1201.0 9/29/95 1156.0 9/29/00 8199.0 9/29/95 1438.0 177.4 12/29/95 4384.0 395.5 9/29/95 22910.0 3801.0 9/29/95 5573.0 1027.0 12/31/97 1455.0 372.1 9/30/92 434.8 3/31/97 245.2 8/31/89 602.6 10/31/97 3746.300 1191.4
12/29/95 6003.0 1467.0 12/29/95 1522.0 12/29/00 11636.0 12/29/95 1929.0 200.3 3/31/96 4689.0 397.9 12/29/95 27550.0 4080.0 12/29/95 7950.0 1182.0 3/31/98 1040.0 309.3 12/31/92 478.1 6/30/97 213.7 11/30/89 445.7 1/31/98 4612.000 1171.1
3/31/96 4688.0 1154.0 3/31/96 1113.0 3/30/01 8337.0 3/31/96 2576.0 270.4 6/30/96 4312.0 394.1 3/31/96 22770.0 3810.0 3/31/96 5380.0 983.0 6/30/98 1447.0 379.5 3/31/93 582.1 9/30/97 266.9 2/28/90 577.9 4/30/98 3456.000 1169.0
6/30/96 4753.0 1150.0 6/30/96 1120.0 6/29/01 8917.0 6/30/96 1637.0 219.7 9/30/96 6183.0 542.9 6/30/96 25590.0 4130.0 6/30/96 5751.0 1009.0 9/30/98 1094.0 328.2 6/30/93 527.9 12/31/97 281.0 5/31/90 609.0 7/31/98 3523.000 1155.0
9/30/96 5788.0 1281.0 9/30/96 1383.0 9/28/01 8019.0 9/30/96 1779.0 232.0 12/31/96 4883.0 436.3 9/30/96 25640.0 4329.0 9/30/96 6073.0 1041.0 12/31/98 1467.0 412.84 9/30/93 659.9 3/31/98 305.1 8/31/90 833.6 10/31/98 3647.000 1161.0
12/31/96 8238.0 1697.0 12/31/96 1668.0 12/31/01 10878.0 12/31/96 2007.0 251.9 3/31/97 5239.0 442.1 12/31/96 30860.0 4677.0 12/31/96 8167.0 1256.0 3/31/99 1039.0 314.4 12/31/93 809.6 6/30/98 269.6 11/30/90 648.8 1/31/99 4739.000 1207.0
3/31/97 6705.0 1516.0 3/31/97 1231.0 3/28/02 7181.0 3/31/97 2348.0 302.1 6/30/97 4836.0 429.4 3/31/97 25410.0 4333.0 3/31/97 5889.0 1034.0 6/30/99 1443.0 393.4 3/31/94 994.8 9/30/98 344.9 2/28/91 802.2 4/30/99 3600.000 1201.0
6/30/97 6649.0 1496.0 6/30/97 1345.0 6/28/02 7183.0 6/30/97 1607.0 242.7 9/30/97 6916.0 671.3 6/30/97 28390.0 4767.0 6/30/97 6293.0 1080.0 9/30/99 1110.0 351.2 6/30/94 905.2 12/31/98 363.4 5/31/91 719.0 7/31/99 4006.000 1369.0
9/30/97 7441.0 1554.0 9/30/97 1766.0 9/30/02 6459.0 9/30/97 1793.0 269.0 12/31/97 5430.0 478.1 9/30/97 28780.0 4958.0 9/30/97 6622.0 1111.0 12/31/99 1557.0 464.84 9/30/94 1044.8 3/31/99 404.4 8/31/91 947.2 10/31/99 4137.000 1381.0
12/31/97 9615.0 1810.0 12/31/97 2166.0 12/31/02 8529.0 12/31/97 2106.0 285.0 3/31/98 5795.0 482.8 12/31/97 35390.0 5300.0 12/31/97 8953.0 1307.0 3/31/00 1153.0 371.9 12/31/94 1255.3 6/30/99 359.4 11/30/91 743.4 1/31/00 4286.000 809.0
3/31/98 7052.0 1548.0 3/31/98 1720.0 6/30/03 6181.0 1421.0 3/31/98 2832.0 348.7 6/30/98 5338.0 477.4 3/31/98 29820.0 5073.0 3/31/98 6468.0 1074.0 6/30/00 1457.0 436.42 3/31/95 1351.2 9/30/99 457.6 2/29/92 867.0 4/30/00 4032.000 1384.0
6/30/98 6761.0 1488.0 6/30/98 1905.0 9/30/03 5092.0 1178.0 6/30/98 1944.0 326.2 9/30/98 7707.0 662.7 6/30/98 33520.0 5577.0 6/30/98 7056.0 1214.0 9/30/00 1262.0 444.39 6/30/95 1200.4 12/31/99 486.5 5/31/92 847.6 7/31/00 4065.000 1466.0
9/30/98 7549.0 1812.0 9/30/98 2400.0 12/31/03 6446.0 1063.0 9/30/98 2182.0 337.6 12/31/98 5998.0 531.7 9/30/98 33510.0 5691.0 9/30/98 7288.0 1228.0 12/31/00 1656.0 494.34 9/30/95 1337.1 3/31/00 554.1 8/31/92 1099.9 10/31/00 4195.000 1476.0
12/31/98 8399.0 2718.0 12/31/98 3030.0 3/31/04 4627.0 945.0 12/31/98 2492.0 354.0 3/31/99 6592.0 550.6 12/31/98 40780.0 6022.0 12/31/98 9850.0 3327.0 3/31/01 1218.0 396.71 12/31/95 1424.5 6/30/00 462.7 11/30/92 875.8 1/31/01 4346.000 586.0
3/31/99 7532.0 1692.0 3/31/99 2278.0 6/30/04 4797.0 983.0 3/31/99 3456.0 445.6 6/30/99 6054.0 535.8 3/31/99 34720.0 5888.0 3/31/99 7158.0 1690.0 6/30/01 1546.0 457.44 3/31/96 1633.0 9/30/00 589.4 2/28/93 972.0 4/30/01 3556.000 1175.0
6/30/99 7310.0 1660.0 6/30/99 2453.0 9/30/04 4426.0 994.0 6/30/99 2385.0 390.3 9/30/99 8812.0 807.7 6/30/99 38470.0 6573.0 6/30/99 7687.0 1810.0 9/30/01 1239.0 399.57 6/30/96 1381.4 12/31/00 609.5 5/31/93 983.3 7/31/01 3732.000 1235.0
9/30/99 7834.0 1808.0 9/30/99 3045.0 12/31/04 5950.0 1078.0 9/30/99 2687.0 440.9 12/31/99 6944.0 608.1 9/30/99 40430.0 6907.0 9/30/99 7927.0 1855.0 12/31/01 1631.0 468.92 9/30/96 1509.7 3/31/01 727.4 8/31/93 1107.9 10/31/01 3775.000 1329.0
12/31/99 9067.0 3423.0 12/31/99 3859.0 3/31/05 7626.0 1716.0 12/31/99 3107.0 467.8 3/31/00 7737.0 646.3 12/31/99 51390.0 7672.0 12/31/99 10930.0 2135.0 3/31/02 1246.0 384.88 12/31/96 2726.9 6/30/01 575.8 11/30/93 805.8 1/31/02 4322.000 945.0
3/31/00 7528.0 2087.0 3/31/00 2732.0 6/30/05 13190.0 3000.0 3/31/00 4315.0 555.2 6/30/00 6895.0 613.2 3/31/00 42980.0 7318.0 3/31/00 7746.0 1834.0 6/30/02 1656.0 496.68 3/31/97 1772.4 9/30/01 713.6 2/28/94 871.8 4/30/02 3453.000 1154.0
6/30/00 7207.0 2024.0 6/30/00 2948.0 9/30/05 12200.0 2981.0 6/30/00 2964.0 497.1 9/30/00 10590.0 937.1 6/30/00 46110.0 7625.0 6/30/00 8251.0 1910.0 9/30/02 1323.0 433.23 6/30/97 1531.8 12/31/01 759.4 5/31/94 1004.2 7/31/02 3486.000 1135.0
9/30/00 7538.0 2151.0 9/30/00 3415.0 12/31/05 16420.0 3174.0 9/30/00 3169.0 533.4 12/31/00 7637.0 711.8 9/30/00 45680.0 7918.0 9/30/00 8582.0 2024.0 12/31/02 1720.0 468.42 9/30/97 2030.5 3/31/02 879.1 8/31/94 1170.4 10/31/02 3479.000 1179.0
12/31/00 9573.0 2375.0 12/31/00 4579.0 3/31/06 12000.0 2721.0 12/31/00 3732.0 604.0 3/31/01 8306.0 743.0 12/31/00 56560.0 8688.0 12/31/00 12320.0 2422.0 3/31/03 1335.0 420.33 12/31/97 2086.2 6/30/02 776.8 11/30/94 1053.7 1/31/03 5017.000 1369.0
3/31/01 7522.0 2045.0 3/31/01 3180.0 6/30/06 12780.0 2827.0 3/31/01 5324.0 766.5 6/30/01 7719.0 718.6 3/31/01 48050.0 8143.0 3/31/01 8345.0 1951.0 6/30/03 1785.0 492.3 3/31/98 2398.7 9/30/02 903.0 2/28/95 1124.7 4/30/03 3291.000 1143.0
6/30/01 7211.0 1990.0 6/30/01 3245.0 9/30/06 11940.0 2834.0 6/30/01 3697.0 756.0 9/30/01 11130.0 1035.0 6/30/01 52800.0 8893.0 6/30/01 8952.0 2045.0 9/30/03 1409.0 439.01 6/30/98 2068.6 12/31/02 936.0 5/31/95 1412.0 7/31/03 3434.000 1145.0
9/30/01 7729.0 2105.0 9/30/01 3333.0 12/31/06 16290.0 3192.0 9/30/01 4164.0 800.0 12/31/01 8467.0 816.8 9/30/01 52740.0 9114.0 9/30/01 9331.0 2293.0 12/31/03 1919.0 547.5 9/30/98 2234.9 3/31/03 1049.3 8/31/95 1614.6 10/31/03 3486.000 1222.0
12/31/01 -4370.0 -611.0 12/31/01 4090.0 3/31/07 11750.0 2644.0 12/31/01 4756.0 899.0 3/31/02 9383.0 848.6 12/31/01 52240.0 8998.0 12/31/01 13220.0 2620.0 3/31/04 1535.0 452.73 12/31/98 2305.0 6/30/03 893.9 11/30/95 1443.0 1/31/04 5053.000 1314.0
3/31/02 7728.0 2096.0 3/31/02 2891.0 6/30/07 12240.0 2799.0 3/31/02 5094.0 407.0 6/30/02 8617.0 812.7 3/31/02 52130.0 9201.0 3/31/02 9594.0 2292.0 6/30/04 1953.0 536.23 3/31/99 2622.9 9/30/03 1111.4 2/29/96 1491.6 4/30/04 3550.000 1210.0
6/30/02 7198.0 2040.0 6/30/02 3268.0 9/30/07 11620.0 2884.0 6/30/02 4586.0 950.0 9/30/02 12300.0 1178.0 6/30/02 56780.0 9914.0 6/30/02 10070.0 2420.0 9/30/04 1542.0 465.77 6/30/99 2343.0 12/31/03 1174.7 5/31/96 1921.3 7/31/04 3581.000 1225.0
9/30/02 7872.0 2157.0 9/30/02 3645.0 12/31/07 15070.0 3138.0 9/30/02 5008.0 1026.0 12/31/02 9199.0 911.9 9/30/02 59330.0 10330.0 9/30/02 10190.0 2560.0 12/31/04 2100.0 565.5 9/30/99 2578.5 3/31/04 1297.9 8/31/96 2281.9 10/31/04 3525.000 1229.0
12/31/02 -5165.0 -674.0 12/31/02 4651.0 3/31/08 11070.0 2815.0 12/31/02 5131.0 1110.0 3/31/03 10110.0 974.2 12/31/02 56640.0 10050.0 12/31/02 7554.0 862.0 3/31/05 1654.0 465.42 12/31/99 2727.7 6/30/04 1100.9 11/30/96 2107.0 1/31/05 5120.000 1330.0
3/31/03 3711.0 1372.0 3/31/03 3353.0 6/30/08 11760.0 2694.0 3/31/03 6986.0 850.0 6/30/03 9543.0 929.2 3/31/03 57220.0 10220.0 3/31/03 10320.0 2536.0 6/30/05 2106.0 551.2 3/31/00 3065.7 9/30/04 1274.0 2/28/97 2423.6 4/30/05 3641.000 1213.0
6/30/03 3645.0 1257.0 6/30/03 3685.0 9/30/08 10660.0 2731.0 6/30/03 4668.0 1071.0 9/30/03 13690.0 1343.0 6/30/03 63230.0 11140.0 6/30/03 9594.0 2185.0 9/30/05 1666.0 481.77 6/30/00 2632.9 12/31/04 1305.2 5/31/97 2373.9 7/31/05 3623.000 1206.0
9/30/03 4332.0 1458.0 9/30/03 3929.0 12/31/08 13280.0 2820.0 9/30/03 5396.0 1143.0 12/31/03 10520.0 1047.0 9/30/03 63040.0 11340.0 9/30/03 9827.0 2344.0 12/31/05 2296.0 602.28 9/30/00 2823.0 3/31/05 1467.6 8/31/97 2766.1 10/31/05 5555.000 1973.0
12/31/03 6098.0 1743.0 12/31/03 4886.0 3/31/09 10060.0 2573.0 12/31/03 6032.0 1284.0 3/31/04 11550.0 1089.0 12/31/03 75190.0 12200.0 12/31/03 13680.0 2798.0 3/31/06 1787.0 494.22 12/31/00 2974.0 6/30/05 1244.4 11/30/97 2255.3 1/31/06 9571.000 2588.0
3/31/04 4033.0 1386.0 3/31/04 3668.0 6/30/09 10550.0 2630.0 3/31/04 8449.0 1072.0 6/30/04 10900.0 1055.0 3/31/04 65440.0 11870.0 3/31/04 10180.0 2346.0 6/30/06 2270.0 579.55 3/31/01 3017.9 9/30/05 1431.2 2/28/98 2224.0 4/30/06 5930.000 2154.0
6/30/04 3778.0 1258.0 6/30/04 3721.0 9/30/09 10190.0 2664.0 6/30/04 5475.0 1205.0 9/30/04 15140.0 1445.0 6/30/04 70460.0 12520.0 6/30/04 10560.0 2289.0 9/30/06 1872.0 538.21 6/30/01 2553.5 12/31/05 1448.7 5/31/98 2307.7 7/31/06 5995.000 2117.0
9/30/04 4391.0 1447.0 9/30/04 3980.0 12/31/09 13250.0 2787.0 9/30/04 6080.0 1310.0 12/31/04 11580.0 1145.0 9/30/04 69280.0 12930.0 9/30/04 10910.0 2633.0 12/31/06 2631.0 685.02 9/30/01 2763.3 3/31/06 1685.3 8/31/98 2504.8 10/31/06 5886.000 2094.0
12/31/04 5955.0 1079.0 12/31/04 4898.0 3/31/10 10050.0 2555.0 12/31/04 6647.0 1310.0 3/31/05 12660.0 1208.0 12/31/04 79080.0 12810.0 12/31/04 15190.0 3093.0 3/31/07 1954.0 534 12/31/01 2782.4 6/30/06 1396.0 11/30/98 1913.0 1/31/07 9159.000 2313.0
3/31/05 4118.0 1399.0 3/31/05 3626.0 6/30/10 10460.0 2606.0 3/31/05 9227.0 1388.0 6/30/05 12000.0 1174.0 3/31/05 70910.0 13170.0 3/31/05 11480.0 2674.0 6/30/07 2390.0 636 3/31/02 3021.9 9/30/06 1607.2 2/28/99 2176.8 4/30/07 5921.000 2113.0
6/30/05 3981.0 1303.0 6/30/05 3716.0 9/30/10 9678.0 2630.0 6/30/05 6118.0 1319.0 9/30/05 16720.0 1590.0 6/30/05 75930.0 13880.0 6/30/05 11990.0 2650.0 9/30/07 1970.0 552.63 6/30/02 2622.3 12/31/06 1619.2 5/31/99 2182.3 7/31/07 5892.000 2038.0
9/30/05 4479.0 1473.0 9/30/05 3860.0 12/31/10 12480.0 2634.0 9/30/05 6702.0 1450.0 12/31/05 12930.0 1276.0 9/30/05 75400.0 13970.0 9/30/05 12210.0 2786.0 12/31/07 2514.0 637.22 9/30/02 2870.8 3/31/07 1995.0 8/31/99 2501.1 10/31/07 5906.000 2121.0
12/31/05 6203.0 1637.0 12/31/05 4817.0 3/31/11 9540.0 2507.0 12/31/05 7335.0 1599.0 3/31/06 14060.0 1322.0 12/31/05 89250.0 14980.0 12/31/05 16950.0 3254.0 3/31/08 1949.0 543 12/31/02 2841.7 6/30/07 1553.3 11/30/99 2059.7 1/31/08 8594.000 2282.0
3/31/06 4220.0 1265.0 3/31/06 3441.0 6/30/11 10140.0 2601.0 3/31/06 10690.0 1714.0 6/30/06 13280.0 1293.0 3/31/06 79680.0 14940.0 3/31/06 12860.0 2879.0 6/30/08 2359.0 602 3/31/03 3055.9 9/30/07 1767.7 2/29/00 2161.6 4/30/08 5747.000 2103.0
6/30/06 4238.0 1224.0 6/30/06 3714.0 9/30/11 9405.0 2635.0 6/30/06 6959.0 1428.0 9/30/06 19880.0 1883.0 6/30/06 84520.0 15740.0 6/30/06 13350.0 2987.0 9/30/08 1879.0 567 6/30/03 2815.7 12/31/07 1794.7 5/31/00 2272.7 7/31/08 5718.000 2037.0
9/30/06 4781.0 1391.0 9/30/06 3851.0 12/31/11 12480.0 2921.0 9/30/06 7603.0 1572.0 12/31/06 14150.0 1405.0 9/30/06 84470.0 16240.0 9/30/06 13570.0 3151.0 12/31/08 2386.0 665 9/30/03 3235.6 3/31/08 1933.2 8/31/00 2636.7 10/31/08 5493.000 2085.0
12/31/06 6664.0 1668.0 12/31/06 4919.0 3/31/12 9270.0 2445.0 12/31/06 8473.0 1799.0 3/31/07 15110.0 1495.0 12/31/06 98800.0 16970.0 12/31/06 19710.0 3803.0 3/31/09 1792.0 539 12/31/03 3251.4 6/30/08 1648.5 11/30/00 2198.7 1/31/09 7934.000 2256.0
3/31/07 4350.0 1297.0 3/31/07 3549.0 6/30/12 9467.0 2437.0 3/31/07 12900.0 1971.0 6/30/07 14660.0 1442.0 3/31/07 86410.0 16250.0 3/31/07 14040.0 3093.0 6/30/09 2232.0 608 3/31/04 3605.2 9/30/08 1853.9 2/28/01 2170.1 4/30/09 5199.000 1956.0
6/30/07 4391.0 1258.0 6/30/07 3685.0 9/30/12 8857.0 2496.0 6/30/07 7927.0 1626.0 9/30/07 20480.0 1986.0 6/30/07 93000.0 17130.0 6/30/07 14620.0 3253.0 9/30/09 1963.0 581 6/30/04 3162.3 12/31/08 1782.7 5/31/01 2483.3 7/31/09 5164.000 1861.0
9/30/07 4729.0 1367.0 9/30/07 3854.0 12/31/12 12260.0 3282.0 9/30/07 8750.0 1738.0 12/31/07 15810.0 1591.0 9/30/07 91860.0 17650.0 9/30/07 14840.0 3455.0 12/31/09 2640.0 737 9/30/04 3327.8 3/31/09 1923.3 8/31/01 2613.7 10/31/09 5277.000 2033.0
12/31/07 6390.0 1481.0 12/31/07 4675.0 3/31/13 8452.0 2218.0 12/31/07 9928.0 1986.0 3/31/08 16960.0 1625.0 12/31/07 107340.0 19190.0 12/31/07 19870.0 3829.0 3/31/10 2087.0 625 12/31/04 3469.4 6/30/09 1694.3 11/30/01 2336.8 1/31/10 7849.000 2212.0
3/31/08 4127.0 1301.0 3/31/08 3384.0 6/30/13 8871.0 2291.0 3/31/08 13420.0 2035.0 6/30/08 16610.0 1591.0 3/31/08 94940.0 18250.0 3/31/08 14800.0 3311.0 6/30/10 2515.0 678 3/31/05 3702.9 9/30/09 1914.9 2/28/02 2260.3 4/30/10 5574.000 1993.0
6/30/08 4282.0 1257.0 6/30/08 3499.0 9/30/13 8272.0 2262.0 6/30/08 8990.0 1856.0 9/30/08 23100.0 2204.0 6/30/08 102340.0 19410.0 6/30/08 15470.0 3500.0 9/30/10 2182.0 630 6/30/05 3364.1 12/31/09 1975.5 5/31/02 2682.2 7/31/10 5537.000 1953.0
9/30/08 4318.0 1309.0 9/30/08 3561.0 12/31/13 10590.0 2613.0 9/30/08 9801.0 2042.0 12/31/08 16400.0 1690.0 9/30/08 98340.0 19430.0 9/30/08 15110.0 3648.0 12/31/10 2916.0 752 9/30/05 3492.9 3/31/10 2244.1 8/31/02 2796.3 10/31/10 5623.000 2069.0
12/31/08 5759.0 1469.0 12/31/08 4082.0 3/31/14 7879.0 2089.0 12/31/08 11500.0 2587.0 3/31/09 16840.0 1673.0 12/31/08 108750.0 20420.0 12/31/08 19560.0 2495.0 3/31/11 2323.0 666 12/31/05 3719.1 6/30/10 1923.1 11/30/02 2514.7 1/31/11 8269.000 2245.0
3/31/09 3884.0 1354.0 3/31/09 3127.0 6/30/14 8013.0 2118.0 3/31/09 14720.0 2499.0 6/30/09 15810.0 1664.0 3/31/09 94240.0 18640.0 3/31/09 14830.0 3015.0 6/30/11 2810.0 767 3/31/06 3815.7 9/30/
