## 1/26/12

### Wal-Mart share in 2012

We estimated our price model for Wal-Mart Stores (NYSE: WMT) nine months ago. The model is based on the decomposition of a share price into a sum of two selected consumer price indices. This is a new model defined by the (seasonally not adjusted) index of hospital and related services (HOSP) and the price index of miscellaneous personal services (MISS), as reported by the US BLS. The former CPI component leads the share price by 10 months and the latter one evolves in sync with the price. Figure 1 depicts the overall evolution of both involved indices through December 2011. A very specific feature of both indices is their linearity over time: they are close to straight lines.
In this post, we re-estimate the WMT share price using new data through December 2011. This allows validating the initial model and demonstrating its reliability. The previously obtained defining components are the same and provide the best fit model between June 2010 and March 2010 with only one month change in the lag for the HOST index.  All coefficients in (1) are only slightly different for the new model (see below).  The slope of the time trend is negative. The best-fit 2-C model for WMT(t) is as follows:
WMT(t) =  0.50HOSP(t-10) + 1.42MISS(t)  - 28.39(t-1990) – 158.12 (January 2011)  (1)
WMT(t) =  0.46HOSP(t-9) + 1.49MISS(t)  - 28.03(t-1990) – 165.50 (March 2011)
WMT(t) =  0.46HOSP(t-9) + 1.30MISS(t)  - 26.06(t-1990) – 141.92 (December 2011)
where t is calendar time. The predicted curve in Figure 2 evolves in sync with the observed price. The residual error is \$2.13 for the period between June 2003 and December 2011. With both indices growing along their respective trends one can expect a slight increase to the level of \$60 to \$65 per share in 2012Q1. Figure 3 presents the residual model error.
Figure 1. Evolution of the price of HOSP and MISS.
Figure 2. Observed and predicted WMT share prices.
Figure 3. Residual error of the model.