Showing posts with label Bonds. Show all posts
Showing posts with label Bonds. Show all posts

Tuesday, July 1, 2008

Probit and Interest rates

I'm curious how the historical shape of the yield curve can assist in the prediction of returns for holding government bonds. This is a preliminary post that plans to detail some of the basic lines of thought I am pursuing. I am heading to DC for the 4th, so I would like to perform an out-of-sample test to look into how this line of thought actually performs when I get back. I have some skepticism and doubts about this method that can only be confirmed upon more research (more on this later).

I began by collecting total return series for 1, 2, 3, 5, 10, and 30 year government bonds along with interest data that's available for bills, bonds, and corporate debt. Some of the series are active in some time periods and not in others, so I just stuck with 3 month t-bill and 1, 3, 5, and 10 year bonds, along with BAA corporate interest rates.

I first looked at the returns for the different bonds. In general, I am interested in holding for several months, so I took the geometric average three month returns and created holding 10 year (5 years back, five years forward) windows to evaluate each time period. The evaluation was simply which (not decile or quartile, but) quintile or 20% range the return would fall into. So if a time period is ranked a five, it would perform in the top 80% relative to the performance five years prior or forward. This way the select periods of time where bonds dominate don't outweigh the whole dataset and there are still runs where it makes sense to be in bonds. The only reason I don't do the whole series is that I believe doing so would result in too much trading.


The chart above is the average monthly (not 3 month) return for each of the bonds I looked at and each decile. Below that is the same chart except if given a 4 or a 5 above, the left-most column is a 1 and 0 otherwise. Since we expect that bonds with longer maturities should have longer durations it makes sense that the 30 year has the largest spread and the greatest opportunity to profit or lose. I also looked into the correlation of the returns to the 6 bonds. For the most part correlations like 3 year vs. 5 year are very high, but as you get larger differences, there are larger differences. However, what is striking is that the correlation between many bonds, even like the 10 year vs. 2 year, are higher than 80%. That suggests that for the most part if you can build a good model for one of them, the idea should work for all (with the 10 and 30 relative to the 1 year having lowest correlations).

I think it is interesting to look at conditional means (or categories) for different statistics. For example, what are the returns like on average over the next three months when the yield curve inverts (or steepens). The only problem with that is that I have so much data and so many different yield curves to compare. I didn't want to specify one way that would work best (ie. do I only look at when the 10 year inverts relative to the 1 year, or do I look at 2 and 5, do some outperform in different central bank regimes?). To give myself as much flexibility without doing something crazy like a neural network, I decided that it would be best (at least in a preliminary sense) to look into using a probit model to categorize the returns.

I described what probit models are and how to use them to look into the probability of a crisis or recession previously. Essentially, I have the series of 0s and 1s and the goal is to use the independent variables to estimate the probability that an event will occur (in this case, the event is that it is worthwhile to invest in bonds for at least three months). I estimated the model for each bond series using two methods, in the first I focused on the interest rates mentioned above without reference to their past values, in the second I used the interest rates and each of the past 12 lags. The first method is less successful than the second, but it also avoids a lot more curve-fitting problems than the first method. The first method classifies 63% to 72% (from 30 year to 1 year) correctly whereas the second method is up to 73% to 80% (from 30 year to 1 year). For comparison, using the binary decision of greater than the 10 month MA or less, classifies at about 60% for each bond (and including it in the decision-making doesn't help). Note that I consider classifying correctly to mean a probability greater than 50%.

What will be interesting is to look at the false positive rate and the returns in situations when there is a false positive. In other words, I think the value of the probit model is identifying risk/return better than other models. If I can identify situations with good average wins relative to average losses, then I can control my risk better. Using the model incorporating 12 lags (which I am worried about), I calculated the times where there are false positives for the 10 year bond and found a 2% annual return with 3% volatility compared to a 18% return with 9% volatility for the normal (note that this is just what the returns are and ignores the fact that it will be in cash for significant periods of time, just want to get an idea of the conditional means). As expected, the periods when the model says to get out of the market, there are negative annualized returns(-10% with 7% volatility). However, I am a little worried about false negatives, but after looking at how often the model invests (since it invests for three months), it appears that the problem goes away. Obviously the problem with this is that I use the whole series to develop the probit model rather than going with information available to develop the coefficients. I would suspect that these good returns would get slightly reduced by using the actual trading model (which is what I intend to test when I am back from DC). In comparison, the 10 month MA rule, returns 8.5% with 8.5% standard deviation (ignoring interest) though it is invested more often. Incorporating commercial paper yield into the second model would reduce its return (though risk/reward stays high) though also reduce volatility by more in this model than in the 10 month MA rule.

Nevertheless, it appears to be an interesting development, I am worried that the coefficients are a bit difficult to interpret (too black boxy) and that they won't be stable enough to generate significant returns. I also don't doubt there are problems with autocorrelation, but fixing that in probit models can be a pain.

Friday, February 8, 2008

Dow 100^100

During the 90s there were two books predicting the Dow would go to insane levels of valuation. Dow 36000 and Dow 40000. While there certainly is much to criticize in these books, I was thinking about when inflation would make their dreams come true. The Dow Jones Industrial Average closed at 12650 in the end of January. According to Global Financial Data, the DJIA earnings were 260.86 at the end of January implying a PE of roughly 48.49. I suppose this number isn't exactly fair since the number jumped up in July (a nice signal to get out of the market) when GFD has earnings going from like 800 to like 200 or so. It looks like the data is quarterly and they just have the numbers in the months spots multiple times. So, I'll just use the PE and earnings data from before the ratio goes from 20 to 50 since 20 is closer to the historical average. For that quarter GFD has earnings at 824.65 and with 13409.3 as the number for the DJIA. I'll average those two with the most current numbers so that I don't totally throw off my estimates of the growth rate (giving 542.76 and 13029.65). That gives a PE estimate at 24 that I'll assume could be a long-term number.

I'll split the difference of 36k and 40k (38k) and use that a future price target. Since PE=P/E, That leaves 24 on the left side and 38000 in the denominator. The earnings value I want to use is 542.76*(1+r)^n where r is the rate of growth for earnings and n is number of years to achieve 38k in the Dow (what I want to solve for). GFD has the June 2005 earnings number at 571 which would give a 44% increase in earnings to June and a similar negative decrease to use January's number. It would probably be more appropriate to run a Monte Carlo simulation using all of the data and put together a complicated model (since I am at a library with limited user rights I can't do that right now). Another long-term estimate would look at the average growth rate over the paste twenty years (the 1976 number is 95.81) which gives a number of about 9% growth a year. This number includes inflation (which is important) so you could consider the real number at about 5 or 6% a year depending on your estimate of inflation.

Plugging in the numbers and solving for n (ln 2.912/ln 1.09) gives 12.42 years. This would seem like a few number of years. I agree. This number is incredibly sensitive to the PE ratio or the growth rate. A one point change in the PE ratio would change n by (-1/24)/(ln 1.09) or roughly 6 months (granted the effect changes as you change the start date and decreasing the PE means lengthesns the time it takes to reach 36k). However, a one point change in the growth rate has an even larger effect, -ln(2.912)*(1/1.09)/(ln 1.09)^2 or (-132.3/100) or decreasing by 1.3 years for each percentage point increase in the growth rate. Certainly there are huge uncertainties with this analysis and calibrating the proper numbers. If actual earnings growth is comes in at 6% (3% inflation, 3% real GDP growth) with a long-term PE of 15 (not historically uncommon), then it might take (4.5+3.9) or 8.4 longer than originally planned at almost 21 years.

The Dow may reach 36000 (or 38000 or more) with a sound valuation over the next 10-20 years by pretty reasonable assumptions and 20-30 years from when the author's book was published. However, this does not imply anything about what the Dow will do tomorrow, next month, or next year (or even the next five years). It is a simple estimation that anyone who has taken high school math and introductory finance could figure out. I suppose the author's main flaw was not looking at a longer-trend of earnings growth and PE ratios. Saying the Dow will go to whatever 20 years from now doesn't save you from a Standard deviation that's twice as large as the yearly expected return if you're retiring in five years.

Furthermore, when the earnings growth for the Dow is a number as low as 6% or 9%, inflation will destroy half of the increase in value. If you only looked at real earnings, real Dow Prices, and the real PE, it would be unlikely to see real Dow going to 36000 by the end of the 21st century and it is mathematical impossibility with positive inflation for it to double in value when the nominal Dow doubles in value. For the average long-term investor, country and sector analysis combined with tactical rotation can provide much stronger returns in an inflationary environment.