Saturday, January 30, 2010

How Reliable is The January Barometer?

With 2010's first month of trading in the record books, the perennial references to "The January Barometer" are being espoused ad nauseum, and throughout a variety of media outlets. In a January 29th WSJ article - "January Proves Tough for Stocks" - the venerable newspaper makes the following statement:

"History suggests that a weak January performance is a worrisome sign for the rest of the year...In years when the Dow has risen in the first month of the year, the median rise for the rest of the year is 10.4%. In years when the Dow has fallen, the median rise for the next 11 months is just 0.28%" 

Feeling dissatisfied with the statistical methodology (Given January % Return > 0, median return) used above, I set out to apply a regression analysis to the data. I pulled data on the S&P 500 for every year from 1952 to 2009, setting each year's January % Return as the explanatory (X) variable, and the subsequent full year % Return as the response (Y) variable. The results are plotted below to provide a visual:
 
In the event that a strong relationship between X and Y existed, the plot above would display at least some modicum of linearity. This isn't quite the case. In fact, the r-squared value for this data is 0.1012, meaning that only 10.12% of the variation in Y (entire year's stock market return) is explained by X (return in January). However, I realize that regression analysis of this nature is not very resistant to outlying/extreme values; that is, a few extreme observations have the potential to significantly affect the portion of Y's variation that is attributable to X. For this reason, I arranged January's % returns into quartiles, calculated the inter-quartile range (IQR), and deleted any observations that fell greater than 1.5*IQR from either the first or third quartile. Interestingly, only two observations throughout a 57 year period passed the above test for being considered "extreme" - the S&P 500's return during January 2001 and January 2009. I deleted both observations, and recalculated below:
 
 
After removing the two extreme values, the new r-squared value is 0.1544 ( 15.44% of Y explained by X) - a near 50% improvement, but still well below any reasonable threshold which might prove the predictive value of January. 

In conclusion, I will not be using January's stock market decline as a basis for any prediction concerning the full year performance of the S&P 500. That determination is better made - in my opinion - by recognizing that not all recoveries are created equally, via close monitoring of the mortgage market's response to the Federal Reserve's exit from it's mortgage backed security purchase program, and by examining the structural implications of sustained double digit (real) unemployment.

*long several S&P 500 stocks Sphere: Related Content

Saturday, January 23, 2010

Quantitative Assessment of House Price Distributions

This weekend, as I found myself inundated in quantitative finance problem sets, I decided it might be worthwhile to apply some quant methods to real estate. After all, we're in the midst of a recession whose numerous causes - and/or exacerbating factors - include a multi-year decline in median home prices across virtually every geographical market. Furthermore, a larger proportion of Americans own a home than own equity securities. My experiment began with market selection; I wanted to compare two housing markets within relative geographical proximity. I also wanted the comparison to be between markets that have suffered comparably during the recession, and are perceived as good long-term housing bets for reasons such as population and demographic trends, weather etc. After brief deliberation, I decided that tonight's matchup would be between Atlanta and Charlotte.

To begin, I pulled data from the S&P Case-Shiller Home Price Index (monthly) from January 2000 to October 2009. I then converted the index value to a periodic rate of return for each month, using the natural log function. That data was then summarized in histogram format below:

 
The two distributions are somewhat similar at first glance, although Atlanta appears more skewed to the left. Atlanta's most frequently observed interval (bin) of return is also a bit higher than Charlotte's. However, in this instance I'm most interested in providing an investor with a general idea concerning the risk associated with a house purchase in each of these markets. To do so, I computed the mean and standard deviation for each city's returns. Furthermore, I calculated the (theoretical of course) probability that a given month's return would be less than zero for each market:

The Conclusion: Although the monthly return could conceivably be higher for an Atlanta house, there is a 45.75% probability that a given month's return will be less than zero - negative that is. In Charlotte, that figure is only 39.54%. Furthermore, it's important to note that the Atlanta data is characterized by a fatter left tail; that is, Atlanta has experienced multiple months of >2% price declines, while Charlotte's returns all fall above -2%.

Clearly, there are many variables that influence house prices, not all of which are even subject to attempted forecasting. However, I would venture to say that the method above provides a reasonable illustration of the relative risk associated with a real estate investment in the two subject markets.

*no positions in either Charlotte or Atlanta real estate. I am licensed to sell real estate in NC however. Sphere: Related Content

Tuesday, December 29, 2009

Health Insurers and the Medical Loss Ratio

As Washington continues to micro-manage various industries via royal decree, it is becoming increasingly evident that Congress is afflicted by some combination of the following conditions:
  1. Ignorance of industry specific business models
  2. An inability to read financial statements
  3. Willful disregard of #'s 1 and 2
  4. Delusions of grandeur
Now, I will readily admit that the near collapse of the financial system is evidence in and of itself that the pre-crisis regulatory framework was flawed. However, the solution to ineffective regulation is not the passing of more ineffective regulation. In other words, Congress seems to assume that capitalism's regulatory guard rails simply weren't strong enough, as opposed to questioning whether those rails were even in the proper location.



The latest Congressional foray into the ineffective regulation of business is contained within H.R. 3962 (the Health Care bill). Apparently, the likes of Harry Reid and Maxine Waters have secretly been working towards a masters degree in actuarial statistics, and have subsequently determined that the health insurance industry can make coverage more affordable by throwing all actuarial assumptions out the window. This strange brand of ill-informed meddling has culminated in Section 102 of H.R. 3962, in the form of a mandate that health insurer's medical loss ratio never dip below 85%. The medical loss ratio is calculated as medical benefits paid divided by premiums received. Now, all questions regarding the ability of Congress to properly determine a reasonable medical loss ratio aside, I'll turn to an analysis of where this ratio has trended over time. Below is a chart comparing the medical loss ratio's of United HealthCare (UNH), Aetna (AET), Wellpoint (WLP), Humana (HUM) and Coventry Health Care (CVH). Data is based on the 9 most recently reported quarterly results for the above mentioned firms:

The evidence above would suggest that the health insurance industry's major players are already operating at a medical loss ratio of between 80-85%. So why make a point of regulating this metric? I certainly don't purport to know the absolute truth on this one, but one could theorize that Congress intends to start at 85%, and slowly creep up into the 90's. Nevertheless, we can assume that these firms will need to take steps towards putting themselves comfortably within the 85% medical loss ratio mandate. The most likely compliance scenario will involve management's assessment of operating expenses. A little "trimming the fat" analysis if you will. To get an idea of where operating expenses stand relative to premiums at these large firms, I've prepared the analysis below.


As you can see above, medical costs and operating expenses combined have come close to - or in most cases exceeded - premiums received by the major health insurance companies. Therefore, health insurance firms are not able to turn a profit from premium revenue alone. Profitability, it seems, is achieved by two other sources of revenue: fees and investment income. Because investment income is unreliable in many circumstances, and the premiums charged to individuals will henceforth be regulated in arbitrary fashion, I can only see two ways that health insurers will respond:
  1. Reduce operating expense via layoffs and off-shoring where possible
  2. Increasing fees that Congress didn't remember to regulate
If I could make a recommendation to the industry, it would be to arbitrarily "invent" new fees. Maybe introduce another stage to the application process that would require payment of additional fees. To introduce a little bit of irony to the situation, the industry could pretend that it now faces burdensome ratio compliance costs, and must assess a few cents worth of compliance fee upon every claim. Remember: Focus on the Fees.

*no positions
Sphere: Related Content

Wednesday, December 23, 2009

3COM Corporation: Poised to Profitably Emerge From Downturn

Although some companies in the technology sector - especially those firms that benefit from semiconductor demand - appear to be pulling out of the recession, 3COM Corp's (COMS) fiscal second quarter results show that even tech is experiencing a rocky and uneven recovery. Although net income for the period rose 55% from a year ago to $20M , today's report indicates that extraordinary items played an over sized role in the bottom line growth. 3COM, a firm that recently agreed to be acquired by Hewlett-Packard (HPQ), might appear to be suffering from performance declines:


 What I'd point out though, is that from 2004 to the beginning of the recession in December 2007, 3COM fairly consistently operated in the red. Sales appear to have reached a plateau mid-2006. However, one could argue that 3COM is in the midst of a turnaround that has occurred during and despite the global recession. Evidence exists that 3COM has significantly reduced its cost structure and improved efficiency. For example, gross profit margins have consistently improved since 2004:

Furthermore, the company appears to have become substantially more liquid - as measured by a ratio of cash to current liabilities - since the onset of the recession:

It remains to be seen just how HP will choose to integrate 3COM's operations into the existing organization; however, it appears that 3COM is well positioned for strong earnings growth in the coming quarters. With the resources of HP behind it, I look for the Company to successfully secure new sources of revenue, and to continue to streamline operations.


*no positions in any securities mentioned in this article
Sphere: Related Content

Monday, December 21, 2009

XTO Energy: Liquidity and Solvency Analysis

Anyone who has been even remotely cognizant of financial market events over the past week should be aware that Exxon (XOM) has agreed to purchase XTO Energy (XTO) in an all stock deal worth $31B (or $41B, depending upon whether you choose to categorize debt assumption as a direct cost to Exxon). At first glance, the deal looks like a pure-play home run bet on the natural gas industry. After all, XTO's revenue has risen from less than $400M in 1999, to over $8B over the trailing twelve month period. Net Income has risen from $46M to $2B over the same time period. 


The question though, is whether XTO has managed to achieve this level of growth with a debt level that is manageable in the long term. I'll begin an attempt to answer this question by looking at XTO's debt maturity profile, as stated in its most recent 10-Q. All figures are in $MM:
 
 The schedule above lets us know that XTO has several billion dollars worth of debt maturing in the next 6 years; however, it may be more instructive to observe just how this debt has affected the firm's balance sheet. To do so, I prepared a 10 year look at XTO's debt to equity ratio:



The trend displayed by the chart above is encouraging; XTO's debt-to-equity ratio has declined throughout the past decade, and the company is now financed by roughly a 1 to 1 mixture of debt and equity. Yet another way of examining XTO's use of leverage is to take a look at its Times Interest Earned (TIE) ratio, which measures EBIT as a multiple of interest expense:
 
 
In 2006, XTO's TIE ratio peaked at just over 14X, meaning that the company reported earnings before interest and taxes that could have covered its annual interest expense 14 times. That multiple has since decreased to ~6X, as interest has comprised an ever larger share of XTO's EBIT. A possible explanation for this trend lies in TIE's numerator: EBIT. A rapidly growing company like XTO will have large amounts of depletion expense that will adversely affect EBIT, but not cash flow. To see whether this idea holds water, I'll look at operating cash flow as a multiple of interest expense:

Once again, we see this measure trending downwards. Obviously, 3 data points doesn't create an irreversible trend. However, its worth noting from a standpoint of how XTO's financial performance is likely to affect Exxon in the coming years. Of course, Exxon may be able to refinance XTO's debt at a far lower weighted average cost of capital.

Next, I think that XTO's liquidity should be examined using the current and quick ratio's:
 
 
Although you'd generally like to see both of these ratios at a level above 1, its worth noting that over the past decade, XTO's current and quick ratios have stayed within a relatively stable band (1.4-0.8). If you look at XTO's balance sheet, you'll notice a relatively large current asset labeled "Derivative Fair Value". According to XTO management, these derivatives are cash flow hedges used to protect the company from major price swings in the natural gas market. Ultimately, the hedges should be viewed as a prudent move that allows XTO to focus on the acquisition, exploitation etc of new properties, and ignore short term noise in the price of natural gas. 

In the end, XTO has to be considered a pretty remarkable growth story. There's clearly a strong performance oriented culture at the company that has allowed it to expand as rapidly as it has. My feeling is that post-merger, Exxon would do best by allowing the XTO culture to remain in place, at least in its core business operations. Exxon's true contribution to the marriage will be in the economies of scale created by the combined venture; perhaps XOM should handle the financing and hedging activities that XTO requires, and simply place some guard rails on the acquisition strategy. XTO is definitely structured for growth; the problem is, it needs to be managed properly, and with manageable levels of debt.
 
My last comment on the XOM-XTO merger is it represents the potential for a brilliant strategy. Exxon has poured too much money into share buybacks over the past decade, probably because hostile foreign government run oil companies have kept Exxon from exploiting their natural resources. The XTO purchase though, could provide a useful outlet for XOM's excess cash. If XTO's acquisitions can be funded through Exxon's internally generated cash flow, and the debt agglomeration trend can be halted, then Exxon could wind up being the largest owner of natural gas property in the country - and the US has plenty of natural gas.

*no positions
 


Sphere: Related Content

Saturday, December 12, 2009

Basic Principles of Revenue Recognition

Common sense would indicate to most people that the issue of revenue recognition shouldn't even be an issue; after all, a sale has either occurred or it hasn't right? The problem is, due to the multitude and variety of transactions that occur in the modern economy, it isn't always clear when a firm may record a given sales dollar. For instance, when several pieces of software are sold in a bundle, and a right of return exists for any of the individual bundled components, then at what point can the company reasonable assert that the sale is final? To look for guidance on this issue, we have to consult with dual sets of regulatory guidance, originating from the FASB and SEC.

The FASB guidelines for revenue recognition involve two primary criteria, both of which must be met in order for the sale to be legitimate and reportable as revenue:
  1. The revenue must be realized or realizable
  2. The revenue must be earned; that is, the company has performed it's duties under the terms of the sales agreement.
The general picture here is that the FASB has developed a relatively straightforward, common sense set of criteria for assessing when a sale...is a sale. The company must both have the cash - or be reasonably sure that it can collect the cash - and has actually delivered its product or service. The guidance doesn't stop there though; the SEC, via Staff Accounting Bulletin (SAB) 101, has issued four additional pieces of guidance in clarification of the principles of revenue recognition: 
  1. Persuasive evidence that a sales agreement/arrangement exists must be present. The SEC appears to believe that this principle is very important in relation to arrangements that customarily require a written sales agreement between the buyer and seller, specifically as it relates to the timing of product delivery and execution of a sales agreement. If product delivery and sales agreement execution fall in different fiscal periods, revenue can only be recognized in the later accounting period (during which both have been completed).
  2. Delivery has occurred or services have been rendered. The SEC seems to be interested in the passage of title and assumption of risks associated with the delivered product. A consignment store may have received delivery of a product, but it hasn't assumed title, or any of the risk associated with owning the product. As such, revenue can not be recognized until the consignment product has been paid for.
  3. The seller's price to the buyer is fixed or determinable. The SEC's primary focus with regards to this rule has to do with "side agreements" that may have attached themselves to the primary sales arrangement. Sometimes, the practical effect of these side agreements is to transform a sale into a demonstration period or otherwise incomplete sale. In such cases, the associated revenues may not be recognized. The SEC further explains that when the right of return is structured so that the dollar value of returnable product declines according to a fixed schedule over time, the associated revenue must be recognized according to that schedule.
  4. Collectibility is reasonably assured. This requirement is not explicitly addressed in SAB 101, however the general principles outlined in the bulletin can be applied towards its understanding. If the transaction is customary, historic data indicates a reasonable expectation of collectibility, and no external factors which might affect the transaction have significantly changed, then we can probably infer that the requirement has been satisfied. There are some obvious factors that could hinder the assurance of collectibility, such as bankruptcy proceedings or major litigation.
Because the SEC has issued these guidelines, they must be followed in addition to the FASB/GAAP requirements. As business practices evolve, its likely that the issue of revenue recognition will continue to be clarified and revised accordingly. Nevertheless, investors should be aware that not all revenue is created equally, and is subject to restatement, especially during times of economic turmoil. Sphere: Related Content

Sunday, December 6, 2009

Financial Statement Effects of Intercorporate Investments

For a wide variety of reasons, one company will often make an equity investment in another company. We could be simply talking about the parking of excess capital, or there could be strategic reasons such as a bid to gain control of a supplier or other important segment of the supply chain. These investments show up on corporate financial statements in a variety of ways, depending largely upon the size of the investment, and the ability of the investor to control the investee.

In terms of a relatively insignificant, non-controlling (<20%) stake in another firms equity, the financial statement effect will depend largely upon whether management classifies the investment as Available-for-Sale (AFS), or Trading (T) . The difference here really comes down to the intent of management; if management considers the investment a "buy and hold" kind of scenario, and generally won't sell unless the price is right, the investment is AFS. Securities classified as Trading are acquired with the intent to sell in a short period of time. This difference is extremely important due to the way GAAP requires companies to report unrealized gains (losses) from investments in the income statement. Market value changes of AFS securities flow to the Accumulated Other Comprehensive Income (AOCI) section of stockholders equity. Current period income and retained earnings are not affected. Market value fluctuations in Trading securities on the other hand, are counted as investment income (or loss) on the income statement, as well as an increase (decrease) of retained earnings. Dividends received in conjunction with both classifications are treated as other income on the current period income statement. Lastly, in both instances, these marketable securities are reported on the balance sheet at fair market value (FMV).

When the equity investment is such that the investor is able to exert significant control (between 20% and 50% stake) over the investee firm, the rules change just a bit.  Accountants refer to the financial statement treatment of these investments as the Equity Method. First of all, market value fluctuations affect neither the income statement or balance sheet. Dividends received are treated as a reduction in the investment basis. Additionally, the investor recognizes investment income - and concomitant increase in retained earnings - from its stake that is proportional to the stake held in the investee.For example:

On February 2nd, Company A purchases $2,000,000, or a 40% stake, in the equity securities of Company B. Let's say this corresponds to 400,000 of Company B's 1,000,000 outstanding shares. On March 31st, Company B pays a $1/share dividend to all common shareholders. On December 31st, Company B reports $5,000,000 of net income. The accounting for these events, from Company A's perspective, is as follows:

2/2
Investment in Company B                      $2,000,000
              Cash                                                                           $2,000,000

3/31
Cash                                                         $400,000
               Investment in Company B                                 $400,000

12/31
Investment in Company B                         $2,000,000
               Investment Income                                             $2,000,000

At the end of the year, Company A will report it's investment in Company on its balance sheet at $3,600,000 ($2,000,000 - $400,000 + $2,000,000)

Given that investments in marketable securities comprise a significant portion of most firm's balance sheets, and can have a significant impact on stockholders equity and retained earnings, its important to monitor them. You should read up on the footnotes associated with these investments, and monitor the way management changes its AFS or T classifications over time. Also, be wary of the income related to unrealized gains on trading securities; financial market volatility can significantly impact these numbers between each reporting period. Sphere: Related Content