Showing posts with label Balance Sheet. Show all posts
Showing posts with label Balance Sheet. Show all posts

Friday, November 27, 2009

Vertical Analysis of Financial Statements: Coca-Cola v Pepsi

Due to the complexity of corporate financial statements, the prospect of deciphering meaningful insight can be a daunting task. Furthermore, the ratios deployed by professional analysts are numerous, effectively creating a thousand piece jigsaw puzzle whose composition perpetually and frequently fluctuates. Luckily, for those of you who lack either the time or mental stamina to perform calculations such as the disaggregation of the components of return on net operating assets (RNOA), a relatively effective process exists known as Vertical Analysis. The premise of Vertical Analysis is to create common-size financial statements, where all balance sheet and income statement items are converted into percentage terms for purposes of comparison.Using vertical analysis, comparisons can be made between firms regardless of size. This approach is especially useful when determining the relative financial health of competing firms within the same industry. Financial metrics display a large degree of variability across industries; however, within a given industry, competitors should be fairly aligned in terms of funding sources (debt v equity), liquidity, asset turnovers etc. Below is a vertical analysis I prepared using the FY '08 balance sheets from Pepsico (PEP) and Coca-Cola (KO).
Vertical Analysis of Financial Statements - Pepsi v Coke

From here, it's fairly easy to scan through Coke and Pepsi's relative balance sheet percentages(page 2 of pdf) , making some fairly useful generalizations. The first thing I noticed from this comparison is that Pepsi and Coca-Cola have a nearly identical composition of current v long term assets (30/70). However, Cash/Cash Equivalents represents 11.7% of Coke's assets, but only 5.7% of Pepsi's. It appears that Pepsi makes up the difference in it's proportion of (net) receivables to assets (13% v 7.6%); this could just be a timing issue, but it could also mean that Pepsi has become more aggressive in terms of the conditions by which it will offer credit to customers. The next observation I'd make has to do with differences between the two company's capital structures. Pepsi's debt/equity split percentage is 66.2/33.8, whereas Coca-Cola's capital structure is comprised of 49.5% debt and 50.5% equity. Interestingly though, Pepsi's short term debt only represents 1% of the right side of the balance sheet, whereas Coca-Cola comes in at 16.1%. This could just be an indication that Coke relies more heavily on commercial paper to fund it's short term operations; it could also mean that Coke has a significant amount of long term debt coming due in the months ahead. Coca-Cola's 2008 10-K should contain footnote disclosures describing the nature of these short term obligations. In this sense, the vertical analysis above serves as an informative starting point from which to diagnose any potential issues the firm might have down the road. Additionally, vertical analysis can expedite the analysis process by narrowing down which footnotes you, as an investor, should be concerned with.

*no positions  Sphere: Related Content

Friday, October 9, 2009

How to Interpret Goodwill On the Balance Sheet

Imagine that you purchased a home with the knowledge that you were paying $50,000 more than its true market value. Now imagine that as part of your personal financial planning, you decide create a personal balance sheet, and you list that $50,000 as an asset. This would make absolutely no sense right? The answer is, it depends upon whether you are an individual, or a publicly traded corporation. For the individual, that $50,000 on your balance sheet is nothing more than proof that you are an idiot. A corporation however, would be well within their rights under generally accepted accounting principals (GAAP) to record that $50,000 as an asset on its balance sheet, and label it "goodwill".

Technically, the above example is not entirely representative of the concept of Goodwill. Goodwill refers to the amount paid, when acquiring a company, that is in excess of fair value of the firm's net assets. Let's say the fair value of Company A's net assets are $7B, and Company B purchases Company A for an amount which corresponds to $10B. After the transaction, Company B will be left with $3B worth of Goodwill on its balance sheet. Supposedly, this amount represents some sort of intangible value that Company B believes will exist in the combined company. The problem as I see it is that Goodwill has the potential to inflate the perceived level of Shareholder's Equity in a corporation. Let's say Company X has $10B worth of assets, $9B worth of liabilities, and $1B worth of shareholder's equity. Now, assume that Company X has $3B worth of Goodwill recorded as assets. If this amount is a non-cash asset, and furthermore is unlikely to ever be converted into anything of value to the company, then couldn't the argument be made that Company X actually has -$2B worth of equity?

These cases do exist in real life. Take URS Corporation (URS) for instance. URS "provides engineering, construction, and technical services to the power, infrastructure, Federal, and industrial and commercial market sectors in the United States and internationally." As of January 2nd, 2009, URS reported $7B in assets, $3.15B of which is classified as goodwill. A little investigation indicates that that a substantial portion of this goodwill is attributable to the company's 2007 acquisition of Washington Group International. Given that none of this goodwill has been written down since 2007, one might ask: why? Well, my bet is that URS is benefiting from one of the luckiest acquisitions that any company could have made in 2007. The reason being, Washington Group - as the name might suggest - specializes in contracts through the Department of Energy, most notably nuclear waste management and disposal contracts. With the cyclical resurgence of new nuclear construction in the United States, and Uncle Sam's status as a profligate spender, it appears that URS acquired a company that will be uniquely resistant to recessions over the next couple decades. So, for now at least, we can say that the goodwill on URS's balance sheet is reasonably justified. This isn't always the case.

In 2008, Sprint (S) admitted that it's 2004 acquisition of Nextel was one of the poorest decisions ever made by a US corporation. Sprint didn't actually say that, but their balance sheet did; the company wrote down all of the Nextel related goodwill on it's balance sheet - all $29.5B worth. Way to go.

The moral of this story is that not all goodwill is created equal; it all depends on whether or not the acquisition which created the goodwill will ultimately be judged as a successful venture for the company. Such a determination is of course exceedingly difficult to make, as things like cultural incompatibility between the acquirer and the acquired can potentially ruin a deal that might have otherwise looked great on paper. Because of the obvious uncertainty in these situations, I personally tend to shun any stocks where the ratio of goodwill to total assets gets too high. How to define too high? I wouldn't issue a bright line rule on this one, but would just say that there is a 100% positive correlation between the goodwill-to-total assets ratio, and my level of discomfort with the company's fundamentals.

*Update: I realized that I neglected to mention a critical - and curious - component of goodwill. Unlike many other intangible assets whose "life" is fairly well defined, goodwill on the balance sheet is not amortized in any systematic way over time. Rather, it is subjected to an annual impairment test whereby the market value of the lingering goodwill is determined, and in the event that market is lower than book value, the goodwill must be written down to reflect this reality. Sphere: Related Content