4/9/14

Predicting stock prices: JPMorgan Chase has growth potential


We have been trying to build a pricing model for JPMorgan Chase (NYSE: JPM) since 2008. JPM is a company from Financial sector which “provides various financial services worldwide”. Lately, we presented on Seeking Alpha similar models for the following financial companies: Bank of America (BAC), Franklin Resources (BEN), Morgan Stanley (MS), Lincoln National (LNC), Invesco Ltd. (IVZ), Goldman Sachs (GS), and ACE Limited (ACE).  

Our concept of stock pricing assumes the possibility to decompose a share price into a weighted sum of two consumer price indices (CPIs). The background idea is simple: there is a potential trade-off between a given share price and goods and services the company produces/provides. For example, the energy consumer price should influence the price of energy companies. In this post, we assume that some set of consumer prices (or the relevant consumer price index, CPI) drives JPM stock price. The change in these consumer prices is transferred into the share price. Our first task is to find this driving CPI. Obviously, the influence of this driving CPI depends on the overall market evolution. For example, a market rally makes almost all companies to grow together with the market and market crashes hit all companies as well. Our model expresses the net market change by one reference CPI, which should best represent the overall dynamics of the changing price environment for the modeled company. One can use the market indices (S&P 500, Dow Jones, NASDAQ 100, etc.) instead of the reference CPI. In some cases, these indices may provide a better reference than any CPI. The market indices have no predictive power since they define the contemporary market movements. We use them only for facultative studies. 

Thus, each pricing model should include the price driver and the dynamic reference. A company can be a price taker or price setter.  Then, the company share should follow the changes in prices of goods and services related to the company or vice versa. Time delays are possible between action and reaction - some time is needed for any price changes to pass through. In our model, the defining CPIs may lead the modeled price or lag behind by a few months.
 
JPMorgan Chase was included in our study of bankruptcy cases in the USA. In March and November 2012, we presented an updated model based on the CPI of food (F) and owner’s equivalent rent of residence (ORPR):

JPM(t) = -1.99F(t-3) + 1.15ORPR(t-2) + 6.81(t-1990) + 39.30, February 2012
JPM(t) = -1.86F(t-4) + 0.99ORPR(t-2) + 7.04(t-2000) + 116.91, October 2012          (1)
 

In December 2012, we published a paper comparing the evolution of JPM stock to four financial companies. Here we update the model using new data between December 2012 and March 2014. The 2012 model has slightly changed: the index of food is replaced by the index of food away from home (SEFV) and ORPR is replaced by the index of rent of primary residence (RPR):
 
JPM(t) = -5.02SEFV(t-0) +2.46RPR(t-3) + 17.89(t-2000) + 373.10, February 2014    (2)    

Figure 1 depicts the overall evolution of both involved consumer price indices: SEVF and RPR (the previous CPIs, F and ORPR, also shown). In March 2014, we revised the JPM and GS comparison and found that they are still similar in stock price evolution.

 

One can guess that the changes in the RPR index can directly influence JPMorgan Chase through house prices and mortgages. Then, the SEFV index should provide a dynamic reference. To illustrate the overall market evolution we use the S&P 500 index. Figure 2 displays the evolution of dSEFV (the first difference of SEFV) and dSP500, both normalized to their respective absolute maximums between July 2003 and March 2014. The similarity between the dSEFV/dSEFVmax and dSP500/dSP500max (term 0.37 is needed to equalize the peaks) is best visible in 12-month moving averages. In that sense, the SEFV index is able to represent major market movements in statistical terms. There is no other interpretation of this reference CPI except the statistical one.

According to (2), the predicted curve in Figure 3 is contemporary to the observed one. The residual error is of $3.28 for the period between July 2003 and March 2014. The price of a JPM share is relatively well defined by the behaviour of the two defining CPI components. Figure 3 also depicts the high and low monthly prices for the same period, which illustrate the intermonth variation of the share price. These prices might be considered as natural limits of the monthly price uncertainty associated with the quantitative model. Figure 4 displays the residual error. 

The model cannot predict the future of JPM price from the defining CPIs. However, there are some medium-term trends in the defining CPIs. Figure 5 depicts the dRPR and dSEFV curves together with their 12-month moving averages. The rate of dSEFV growth decreases (together with the S&P 500 return) and its influence on JPM price is getting smaller. In case the growth in dRPR extends into 2014 the price of JPM will be growing along the same linear trend. For Goldman Sachs, we have found a larger growth potential. 
 

Figure 1. Comparison of SEFV/RPR and F/ORPR. 


Figure 2. First differences dSEFV and dSP500 normalized to their respective absolute maximum values between July 2003 and February 2014. 12-month moving averages of these differences are similar, i.e. dSEFV is a good approximation of dSP500 at a medium-term horizon.

Figure 3. Observed and predicted JPM share prices.


Figure 4. Model residuals, standard error of the model $3.28. 



Figure 5. First differences of monthly estimates: dSEFV and dRPR. Moving averages of these differences show their medium-term trends. 

4/7/14

Predicting stock prices: ACE Limited may continue growth


In this post, we model the evolution of ACE Limited (NYSE: ACE) stock price. ACE is a company from Financial sector which “provides a range of insurance and reinsurance products to insureds worldwide”. Lately, we presented similar models for the following financial companies: Bank of America (BAC), Franklin Resources (BEN), Morgan Stanley (MS), Lincoln National (LNC), Invesco Ltd. (IVZ), and Goldman Sachs (GS). 

All models have been obtained using our concept of stock pricing as a decomposition of a share price into a weighted sum of two consumer price indices (CPIs). The background idea is simple: there is a potential trade-off between a given share price and goods and services the company produces/provides. For example, the energy consumer price should influence the price of energy companies. Here, we assume that some set of consumer prices (as expressed by consumer price index, CPI) drives ACE stock price.  The change in these consumer prices is directly transferred into the share price. Our first task is to find the driving CPI.

Each company has to compete with all other companies on the market. Therefore, the influence of the driving CPI depends on the overall market evolution. We express the net change in the whole variety of market prices by one reference CPI, which should best represent the overall dynamics of the changing price environment. As a result, our pricing model includes two defining CPIs: the driver and the reference. A company can be a price taker or price setter.  Then, the company share should follow the changes in prices of goods and services related to the company or vice versa. Time delays are possible between action and reaction - some time is needed for any price changes to pass through. In our model, the defining CPIs may lead the modeled price or lag behind by a few months. 

We have borrowed the time series of monthly closing prices of ACE from Yahoo.com and the relevant (seasonally not adjusted) CPI estimates through February 2014 are published by the BLS.  We have found that the evolution of ACE share price is defined by the consumer price index of medical professional services (MPRS) and the index of pets, pet products and services (PETS) from Recreation CPI category. We assume that the index of medical professional services is the price driver (accident and health insurance is likely related.  The defining time lags are as follows: the MPRS index is contemporary to the price and the PETS index has a 4 months lead. The relevant best-fit model for ACE(t) is as follows:  

ACE(t) =  -1.96PETS(t-4) - 1.46MPRS(t-0)  + 28.62(t-2000) + 531.20,  February 2014    (1) 

where ACE(t) is the ACE share price in U.S. dollars,  t is calendar time. Figure 1 displays the evolution of both defining indices since 2002.  

It is important to understand why the index of pets, pet products and service in the above model “define” the evolution of ACE price. Actually, the model implies that PETS index does not affect the share price. Instead, PETS provides a dynamic reference rather than the driving force. To illustrate the overall market evolution we use the S&P 500 index. Figure 2 displays the evolution of dPETS (the first difference of PETS) and dSP500, both normalized to their respective absolute maximums between July 2003 and February 2014. The similarity between the dPETS/dPETSmax and dSP500/dSP500max (term 0.22 is needed to equalize the peaks) is best visible in 12-month moving averages. In that sense, the PETS index is able to represent the market in statistical terms. There is no other interpretation of this reference CPI except the statistical one.  

Figure 3 depicts the high and low monthly prices for ACE share together with the predicted and measured monthly closing prices (adjusted for dividends and splits). The model is stable over time. Table 1 lists the best fit models, i.e. slopes, b1 and b2, defining CPIs, time lags, the slope of time trend, c, and free term, d, for a few models for the period between November 2011 and February 2014. These models all have the same defining CPIs, similar coefficients and time lags – they are practically identical. Therefore, the estimated ACE model is reliable over time. The model residual error is shown in Figure 4. The standard deviation between July 2003 and February 2014 is $2.90. 

The model cannot predict the future of ACE price from the defining CPIs since MPRS has no lead. However, there are some medium-term trends in the defining CPIs. Figure 5 depicts the dMPRS and dPETS curves together with their 12-month moving averages. The rate of dPETS growth decreases (together with the S&P 500 return) and its influence on ACE price is getting negligible. In case the fall in dMPRS extends into 2014 the price of ACE will be growing along the same linear trend. 

Table 1. Selected best fit models for the period between November 2011 and February 2014

Month
b1
CPI1
lag1
b2
CPI2
lag2
c
d
Feb-14
-1.460
MPRS
0
-1.964
PETS
4
28.621
531.202
Jan
-1.457
MPRS
0
-1.964
PETS
4
28.596
530.614
Dec-13
-1.482
MPRS
0
-1.972
PETS
4
28.880
537.091
Nov
-1.428
MPRS
0
-1.956
PETS
4
28.276
523.139
Oct
-1.400
MPRS
0
-1.911
PETS
4
27.781
511.361
Sep
-1.375
MPRS
0
-1.899
PETS
4
27.469
504.530
Aug
-1.338
MPRS
0
-1.888
PETS
4
27.059
495.294
Jul
-1.325
MPRS
0
-1.886
PETS
4
26.926
492.172
Nov-12
-1.013
MPRS
0
-1.831
PETS
4
23.674
417.587
Oct
-0.991
MPRS
0
-1.838
PETS
4
23.479
414.261
Sep
-0.954
MPRS
0
-1.833
PETS
4
23.089
405.356
Aug
-0.941
MPRS
0
-1.829
PETS
4
22.940
402.066
Jul
-0.943
MPRS
0
-1.828
PETS
4
22.947
402.404
Jun
-0.933
MPRS
0
-1.825
PETS
4
22.835
399.977
May
-0.916
MPRS
0
-1.822
PETS
4
22.651
395.843
Apr
-0.915
MPRS
0
-1.822
PETS
4
22.647
395.605
Dec-11
-0.886
MPRS
0
-1.856
PETS
4
22.631
166.439
Nov
-0.851
MPRS
0
-1.854
PETS
4
22.292
159.911

 

Figure 1. The evolution of PETS and MPRS indices  


Figure 2. First differences dPETS and dSP500 normalized to their respective absolute maximum values between July 2003 and February 2014. 12-month moving averages of these differences are similar, i.e. dPETS is a good approximation of dSP500 at a medium-term horizon.
 

Figure 3. Observed and predicted ACE share prices. 

Figure 4. The model residual error: stdev=$2.90. 


Figure 5. First differences of monthly estimates: dPETS and dMPRS. Moving averages of these differences show their medium-term trends.