Share price modeling: Computer Science Corporation

Four years ago, we first presented a share price (monthly closing price adjusted for splits and dividends) model for Computer Science Corporation (NYCE: CSC). All predictions were based on our concept of share pricing as decomposition into a weighted sum of two CPI components.  The intuition behind our concept is simple; a faster growth in the CPI directly related to the share price (e.g. energy consumer price for energy companies) relative to some independent and dynamic reference (e.g. some goods and services which price does not depend on energy) should be manifested in a higher pricing power for the company. Our model selects (using the LSQ method) a defining CPI and the best reference index from a set of 92 CPI with estimates started before 2000. This set is fixed - it is important for model stability. Both CPIs for a given model must define the studied price for at least 8 months in a row, i.e. the model has to be the same for a relatively long time: the longer – the better.

 Approximately three years ago we revisited the original CSC model using all data available through March 2011.  The defining indices were estimated five years ago (in 2008): the consumer price index of motor vehicle parts (MVP) and the index of sporting goods (SPO). (All details are provided by the Bureau of Labor Statistics.) It is crucial for the model that the defining CPI components are leading by 0 and 5 months, respectively. Figure 1 depicts the evolution of both defining indices which provide the best fit model, i.e. the lowermost RMS residual error, between July 2008 and March 2011:  

CSC(t) = -3.83MVP(t-0) + 3.16SPO(t-5) +16.31(t-1990) – 137.20, March 2011

      

where CSC(t) is the share price in US dollars, t is calendar time. In April 2011, we predicted the curve in the upper panel of Figure 2 which is synchronized with the observed one. The residual error was of $3.28 for the period between July 2003 and March 2011.  Since the MVP index has been growing since 2002 and the SPO index had a slight negative trend, we predicted that the share price would not be growing in 2011. We revisited the CSC pricing model in 2012 and obtained the same defining indices as in 2008: 

CSC(t) = -3.81MVP(t-1) + 3.35SPO(t-7) +15.97(t-1990) – 158.37, January 2012 

with slightly increased time delays of 1 month and 7 months, respectively. In the middle panel of Figure 2 the predicted and observed prices are depicted.  

Here, we revisit the original model with the data available on March 18, 2014. The best fit model is the same: 

CSC(t) = -3.13MVP(t-1) + 3.30SPO(t-7) +12.51(t-2000) – 51.97, March 2014

 

Slight drift in coefficients expresses the time trend in indices and observed for all pricing model from the very beginning. The functional dependence and time delays for both indices are the same. The lower panel of Figure 2 depicts the current model together with the high and low monthly prices expressing the intermonth price uncertainty. Thus, the pricing model for CSC is valid since 2008. The error term is presented in Figure 3. The standard deviation is $3.56 since July 2003.

One cannot excluded that the  MVP will suffer some further decrease  and the SPO will retain its long-term level. Then the positive price trend defined by the linear time term and negative MVP coefficient will result in further CSC share increase. 

Figure 1. Evolution of the price indices MVP and SPO.

 

Figure 2. Observed and predicted CSC share prices for three revisions: 2011 (upper panel), 2012 and 2014 (lower panel). 

Figure 3. The model error, i.e. the difference between the observed and predicted price; stdev = $3.56 for the period between July 2003 and March 2014.