29 September 2010

TDW: Look Ahead to September 2010 Quarterly Results

This post describes our model of Tidewater's (NYSE: TDW) Income Statement for the second quarter of fiscal 2011, which will end on 30 September 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results that the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about Tidewater and the business environment in which it is currently operating.

Tidewater owns the world's largest fleet of vessels serving the global offshore energy industry in exploration, field development, and production.  Headquartered in New Orleans for more than 50 years, Tidewater first serviced drillers in the Gulf of Mexico

A Tidewater vessel, the Damon B. Bankston, was on the scene at the Deepwater Horizon when the rig failed with tragic results.  The offshore drilling moratorium following the disaster will affect Tidewater's business in the Gulf of Mexico; however, this region is a relatively small part of Tidewater's worldwide operations.

In fiscal 2010, Tidewater earned $259 million ($5.02 per share) on Revenue of $1.2 billion.  These figures were down from earnings of $407 million ($7.89 per share) on Revenue of $1.4 billion in fiscal 2009.

The company's Market Value is currently around $2.3 billion.

For financial reporting purposes, Tidewater's business is divided in U.S. and International segments.  In fiscal 2010, the International segment provided 92 percent of total vessel revenues and 96 percent of vessel operating profit.

27 September 2010

KG: Look Ahead to September 2010 Quarterly Results

This post describes our model of King Pharmaceuticals' (NYSE: KG) Income Statement for the third quarter of 2010, which will end on 30 September.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about King and the business environment in which it is currently operating.

King Pharmaceuticals, headquartered in Bristol, TN, manufactures and sells various brand-name prescription pharmaceuticals and other products.  The acquisition of Alpharma, in a $1.6 billion deal completed in December 2008, added new painkilling medicines with significant sales potential and animal health products.

King earned $92 million on Revenue of almost $1.8 billion in 2009.  The company lost $342 million in 2008, in large part because of acquisition-related charges.

The company's current market capitalization is now approximately $2.4 billion, down from $5 billion as recently as 2007 and $3 billion earlier this year.

The business is divided for reporting purposes into four segments: Branded prescription pharmaceuticals, Animal health, Meridian Auto-Injector, and Royalties and other.  Branded prescription pharmaceuticals, the largest segment, was responsible for 62.7 percent of Revenue and 76.6 percent of Assets in 2009.

26 September 2010

WPI: Look Ahead to September 2010 Quarterly Results

This post describes our model of Watson Pharmaceuticals' (NYSE: WPI) Income Statement for the third quarter of 2010, which will end on 30 September.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about Watson and the business environment in which it is currently operating.

Watson Pharmaceuticals, Inc., produces and distributes generic and, to a lesser extent, branded pharmaceuticals.  Watson earned $222 million in 2009, down from $238 million in 2009.  Revenue increased from $2.5 billion to $2.8 billion.

The company's market value is currently about $5.5 billion.

The Arrow Group acquisition in December 2009 augmented Watson's portfolio of generic drugs and expanded the company's access to international markets.  Arrow was not Watson's first large acquisition: it purchased Andrx in late 2006.  The company also obtained 15 drugs in 2008 from Teva Pharmaceutical (NASDAQ: TEVA).

22 September 2010

CSCO: Financial Gauge Analysis for the July 2010 Quarter

Cisco Systems (NASDAQ: CSCO) earned $0.33 per diluted share on a GAAP basis in fiscal 2010's fourth quarter, which ended on 31 July 2010.  Earnings per share were nearly 80 percent more than the $0.19 Cisco made in the same quarter of 2009.

Non-GAAP earnings, which exclude certain items, rose from $0.31 to $0.43 per share.

A previous article examined Cisco's Income Statement for the July quarter.  Reported GAAP earnings were $0.05 less than the $0.38 per share we had forecast. 

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for Cisco and the associated financial gauge scores.  The metrics were calculated using data from Cisco's current and historical financial statements, including those in the company's recently published Annual Report for fiscal 2010.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

Cisco Systems, Inc. (NASDAQ: CSCO), the proud plumber of the Internet, has a dominant role in markets for enterprise networking products and services.  Its products are broadly categorized as routers, switches, or advanced technologies. 

In fiscal 2010, which ended in July, Cisco's earnings increased from $6.13 billion to $7.77 billion.  Revenue rose from $36.1 billion to $40.0 billion.

The company's reportable business segments are defined not by product types but by geographic region.  The U.S./Canada segment provided 54.3 percent of fiscal 2010's total Revenue.  The proportion of revenue generated by the U.S./Canada segment increased from 53.6 percent in fiscal 2009.

In a major diversification effort, Cisco began promoting in 2009 the Unified Computing System "to unite computing, network, storage access, and virtualization resources" for large data centers.  Since the UCS platform includes computer servers, storage systems [from EMC (NYSE: EMC)], and networking gear, the UCS puts Cisco into direct competition with heavyweights Hewlett-Packard (NYSE: HPQ), IBM (NYSE: IBM), and others.  HP responded by challenging Cisco on its home turf by acquiring network equipment maker 3Com (NASDAQ: COMS).

Cisco is also investing to become a substantial force in the smart grid market.

Interestingly, Cisco also intends to expand its product line with a tablet computer, called the Cius, for business customers.  The device, which won't be widely available until next year, runs the Android operating system promoted by Google (NASDAQ: GOOG) for mobile devices.  Cisco might be satisfied if the tablet's videoconferencing capabilities merely increases the demand for enterprise network infrastructure.   It's worth remembering that Cisco recently acquired, for $3.3 billion, video-specialist Tandberg.

Additional background information about Cisco and the business environment in which it is currently operating can be found in the look-ahead.

In summary, Cisco's latest quarterly results produced the following changes to the gauge scores:


Current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.

21 September 2010

COP: Look Ahead to September 2010 Quarterly Results

This post describes our model of ConocoPhillips's (NYSE: COP) Income Statement for the third quarter of 2010, which will end on 30 September.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about ConocoPhillips and the business environment in which it is currently operating.


ConocoPhillips is one of the ten biggest Integrated Oil and Gas companies, which produce, refine, transport, and market energy products.  The company's market value is now around $80 billion, a little more than half its high. 

ConocoPhillips has business interests in 26 countries around the world, from Algeria to Vietnam.

The company was formed in 2002 when Conoco, Inc., merged with Phillips Petroleum.  It added Burlington Resources, with its extensive natural gas operations, in March 2006 (when gas prices were high).

In 2009, ConocoPhillips earned $4.86 billion ($3.24 per share) on revenue of $152.8 billion.  In 2008, the roller-coaster rise and fall of crude oil prices resulted in record-high annual revenue of $246.2 billion.  However, charges slashing the carrying value of intangible assets and investments by $33 billion led to a $17 billion loss in 2008.

In October 2009, ConocoPhillips announced it would "improve returns and deliver long-term organic growth from a reduced, but more strategic, asset base."  The company signaled it would sell assets worth approximately $10 billion over the next two years, and it would trim capital expenditures in 2010 to $11 billion, from $12.5 billion in 2009. 

The Wall Street Journal reported that Conoco's "restructuring is mandatory" because of the company's concentration in oil refining and natural gas, which are two of the weakest sectors of the energy industry.

More details about the asset divestitures emerged in March 2010 when Conoco publicized its intent to sell half of its 20 percent stake in Russian oil producer Lukoil (OTC: LUKOY), which it began acquiring in 2004.  The Financial Times quoted Conoco CEO Jim Mulva as saying, "The new opportunities in Russia haven’t developed for us as quickly as we would have thought."  This plan changed in July when Conoco decided to pursue the sale of its entire Lukoil investment by the end of 2011.

ConocoPhillips has also sold equity investments in Syncrude and CFJ Properties.

For financial data reporting, ConocoPhillips has six operating segments:  Exploration & Production, Midstream, Refining & Marketing, Lukoil Investment, Chemicals, and Emerging Businesses.  The Chemical segment consists of a joint venture with Chevron.

The Refining and Marketing segment provided more than 70 percent of ConocoPhillips's Revenue in 2009, and Exploration & Production contributed most of the rest.  However, Exploration & Production and the Lukoil Investment generated much of the year's Net Income.

In 2009, ConocoPhillips's worldwide production, excluding Lukoil, averaged 1.85 million barrel-of-oil equivalents per day, compared with 1.79 million boe/day in 2008.


The price of crude oil in 2010 has generally been around $80 per barrel.  This price has settled above the $40 low in early 2009 when the global economy seemed most fragile, but well below oil's $140 peak in 2008 peak.  Crude's price tends to move up or down based on changing perceptions of how economic conditions will affect the demand for oil, how geopolitical and other forces will affect the supply, the availability of new energy sources, compliance with output quotas, and the value of the dollar.

Natural gas prices also soared and crashed in 2008, but spot prices haven't had much of a rebound.

Investing guru Warren Buffett, of Berkshire Hathaway (NYSE: BRK.A), characterized the purchase of ConocoPhillips shares, when energy prices were soaring, as his biggest mistake in 2008.  Berkshire still owned 29 million COP shares on 30 June 2010.


ConocoPhillips earned $2.77 per diluted share on a GAAP basis in the second quarter of 2010.  If special items related to the sale of equity investments are excluded, the adjusted earnings were $1.67 per share.  Reported and adjusted earnings both dwarfed the $0.57 per share reported by ConocoPhillips in 2009's second quarter.

Readers wanting to take another look at ConocoPhillips's June 2010 quarter might wish to review our Income Statement and Financial Gauge analyses.


We're now ready to look ahead to ConocoPhillips's results for September 2010 quarter.

The press release on 28 July 2010 announcing second quarter results did not include any specific guidance for ConocoPhillips's third quarter or the remainder of 2010.  However, during the ensuing conference call (transcript available from SeekingAlpha), the company's management commented on expectations for production, refinery utilization, and costs.

Production is expected to be "close to" 1.8 million BOE per day, as it was in 2008.  New production should offset declines in mature fields.  Refinery utilization rates are expected to fall slightly in the third quarter. 


Given these production comments, along with current energy prices and margins, our estimate for Revenue in the September 2010 quarter is $45.0 billion, which would be a 12-percent increase relative to the same quarter of 2009.

Of the various costs and expenses reported by Conoco, we group "Purchased crude oil, natural gas and products" and "Production and operating expenses" and call the combination Cost of Goods Sold.  CGS has been close to 76 percent of Revenue, translating into a Gross Margin of 24 percent, in each of the last few quarters.  Energy prices, refining margins, and maintenance activities can affect the Gross Margin.

We are assuming the Gross Margin will contract slightly to 23.8 percent in the September 2010 quarter.  In other words, we're estimating that the Cost of Goods Sold will be (1 - 0.238) * $45 billion = $34.3 billion.

Based on historic data, it seems reasonable to expect a Depreciation expense of $2.3 billion.  Similarly, we'll estimate SG&A expenses (including non-income taxes in our presentation) at 10 percent of Revenue, or $4.5 billion.  We will then add $300 million for Exploration expenses and $200 million for non-recurring operating charges.

These figures would result in an Operating Income of $3.4 billion, up from $2.15 billion in September 2009.

We then need to consider non-operating income and expenses.  The ongoing reduction of the Lukoil stake would presumably result in lower equity in the earnings of affiliates.  However, we don't know the pace of share sales, nor the cost basis for the shares sold.  We are estimating $750 million in equity earnings.

We're not making any provisions for gains or losses on asset sales, as we have no data to make an informed estimate.  Items related to asset sales could have a substantial impact on reported earnings.

For other income less interest expenses, a net loss of $200 million would be typical.  This brings our estimate of pre-tax income to $4.0 billion.

ConocoPhillips' effective income tax rate is quite variable from quarter to quarter, but a rate around 45 percent wouldn't be unusual when special tax matters don't interfere.  This rate would lead to provision for income taxes of $1.8 billion. 

After subtracting $20 million for Noncontrolling Interests, our estimate for Net Income becomes $2.16 billion ($1.44 per share).  In the year-earlier quarter, the company made $1.47 billion ($0.98 per share).


Please click here to see a full-sized, normalized depiction of the projected results next to ConocoPhillips's quarterly Income Statements for the last couple of years.  Please note that our organization of revenues, expenses, gains, and losses, which we use for all analyses, can and often does differ in material respects from company-used formats.  The standardization facilitates cross-company comparisons.







Notes: 

http://futures.tradingcharts.com is the source for the historical price charts for crude oil and natural gas.

Another good source of information was the ConocoPhillips Annual Analyst Meeting Presentation [6 MB pdf] on 24 March 2010.




Full disclosure:  Long COP at time of writing


19 September 2010

ADP: Look Ahead to September 2010 Quarterly Results

This post describes our model of Automatic Data Processing's (NASDAQ: ADP) Income Statement for the first quarter of fiscal 2011, which will end on 30 September 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

First, we present some background information about ADP and the business environment in which it is currently operating.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for well over 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

ADP is one of four remaining of U.S. companies with a AAA bond rating.  It is also an S&P 500 Dividend Aristocrat, having hiked its dividend for 35 consecutive years.

Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry.

According to its latest 10-K, ADP earned $1.2 billion on Revenue of $8.9 billion in fiscal 2010, which ended 30 June.  The company has a market value of about $20 billion.

ADP has three main businesses:  Employer Services, Professional Employer Organization Services, and Dealer Services.  Employer Services processes payrolls, administers benefits, and performs other services to enable firms "to staff, manage, pay and retain their employees."  PEO Services, by establishing co-employment relationships with customers and their employees, enables businesses to outsource various functions.  In this arrangement, an ADP entity becomes the employer of record for the affected employees.  Dealer Services helps dealers of vehicles and machinery manage their business activities.

18 September 2010

PG: Look Ahead to September 2010 Quarterly Results

This post describes our model of Procter & Gamble's (NYSE: PG) Income Statement for the fiscal 2011's first quarter, which will end on 30 September 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about P&G and the business environment in which it is currently operating.

Procter & Gamble creates and markets many well-known Household and Personal products, which are Consumer Staples, to customers around the world.  The company, based in Cincinnati, traces its roots back to 1837.

P&G reported Net Income of $12.7 billion ($10.9 billion from continuing operations) on Net Sales of $78.9 billion in fiscal 2010, which ended in June.   Sales to Wal-Mart Stores (NYSE: WMT) and its affiliates produced about 16 percent of P&G's Revenue.

The company's market capitalization is nearly $200 billion, which makes P&G the sixth-most valuable U.S. corporation.

Having raised its dividend for 54 consecutive years, P&G has certainly earned its place on the list of S&P 500 Dividend Aristocrats.  P&G is also number 6 on Fortune Magazine's 2010 list of the World's Most Admired Companies.

16 September 2010

HD: Financial Gauge Analysis for the July 2010 Quarter

The Home Depot, Inc. (NYSE: HD) earned $0.72 per diluted share on a GAAP basis in fiscal 2010's second quarter, which ended on 1 August 2010.  Earnings per share were 8.6 percent more than the $0.66 Home Depot made in the same quarter of 2009.

A previous article examined Home Depot's Income Statement for the latest quarter in some detail.  Reported earnings were $0.01 better than the $0.71 per share we had forecast. 

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for Home Depot and the associated financial gauge scores.  The metrics were calculated using data from Home Depot's current and historical financial statements, including those in the latest 10-Q report.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

The Home Depot, Inc. (NYSE: HD) is the largest retailer of do-it-yourself merchandise, which includes building materials, home improvement supplies, and lawn and garden products.  The company operated 2,244 retail stores at last count, of which 1,976 (88 percent) were in U.S. states or territories.  Home Depot competes with Lowe's (NYSE: LOW), cooperatives such as Ace and True Value, and a multitude of smaller hardware stores

Additional background information about Home Depot and the business environment in which it is currently operating can be found in the look-ahead.


In summary, Home Depot's latest quarterly results produced the following changes to the gauge scores:




The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.  Caution is suggested when comparing Home Depot's results before and after the company's restructuring in 2007.


Cash Management01 Aug 201002 May 201002 Aug 20095-Yr Avg
Current Ratio1.21.21.31.2
LTD to Equity39.7%39.6%50.4%43.9%
Debt/CFO (years)1.91.82.21.7
Inventory/CGS (days)89.190.592.289.1
Finished Goods/InventoryN/AN/AN/AN/A
Days of Sales Outstanding (days)6.46.67.09.7
Working Capital/Revenue5.0%4.9%4.4%4.4%
Cash Conversion Cycle Time (days)46.646.446.445.3
Gauge Score (0 to 25)7757

The Cash Management gauge score held at 7 points for the third consecutive quarter.  The financial metrics that determine the score barely budged during the latest three-month period.

Home Depot's Long-term Debt has generally been declining for the last few years.  The debt, now $7.7 billion, rose negligibly in the second quarter.  The ratio of Long-term Debt to Equity was steady, and it remains below its five-year average.

Total debt as a percentage of cash flow was almost unchanged.  This parameter hasn't yet fallen below its long-term average.

The 10-Q section on Liquidity and Capital Resources states that Home Depot repaid $1.0 billion in maturing notes after the quarter ended, and the amount will be refinanced in the current quarter.

In the continuation of an encouraging trend, Inventory measured in terms of days of Cost of Goods Sold was three days lower than it was last year.  The reduction in Days of Sales Outstanding is another sign of more efficient use of cash.


Growth01 Aug 201002 May 201002 Aug 20095-Yr Avg
Revenue Growth-0.6%-3.9%-10.4%-4.8%
Revenue/Assets155.3%153.0%151.8%154.5%
Operating Profit Growth-10.1%-11.8%-20.1%-12.6%
CFO Growth-0.2%5.5%4.6%6.3%
Net Income Growth21.9%14.6%-27.8%-10.9%
Gauge Score (0 to 25)7833
Revenue, CFO, and Net Income growth rates compare the last four quarters to the four previous quarters.  The Operating Profit rate is the annualized rate of growth in Operating Profit after Taxes over the last 16 quarters.


The Growth gauge score slipped a point, mostly because of lower Cash Flow from Operations.  However, there were positive signs among the other Growth metrics.

The most favorable number above is the 21.9 percent Net Income growth rate.  The rate benefited from special charges in the prior year that made the last four quarters appear comparatively better.  Excluding the charges, which were tied to store closures and exiting businesses, the growth rate was a much more modest 5 percent.

Revenue growth in the last two quarters has been slightly positive, when compared to the same periods of 2009.  Although this performance certainly improved the trailing-year Revenue growth rate from where it was a year ago, the recent results were not quite enough to turn the rate from negative to positive.

The trailing-year growth rate for Cash Flow from Operations fell into negative territory.  Cash Flow in the latest quarter was $1.32 billion, down from $1.60 billion in last year's second quarter.


Profitability01 Aug 201002 May 201002 Aug 20095-Yr Avg
Operating Expense/Revenue92.0%92.3%92.7%90.9%
ROIC12.7%12.6%11.5%14.3%
Free Cash Flow/Invested Capital15.3%16.6%13.9%11.3%
Accrual Ratio-3.1%-4.0%-4.0%-1.5%
Gauge Score (0 to 25)111299

The Profitability gauge score was little changed, with a small decline in the Free Cash Flow ratio responsible for the loss of a point.

The Operating margin, which excludes special charges, has been relatively stable with a slight improving trend.  Nevertheless, the margin remains below (i.e., the expense remains proportionately above) its long-term average.

The story is similar with the Return on Invested Capital.  The ROIC is more profitable than it was a year ago, but it's below the five-year average.

Free Cash Flow has benefited from reduced Capital Spending.  The ratio of FCF to Invested Capital is nicely above its long-term average, but it gave back a percentage point in the last quarter because of weaker Cash Flow from Operations.

The negative Accrual Ratio is actually a favorable result, but it has a greater effect on the gauge score when it is falling.


Value01 Aug 201002 May 201002 Aug 20095-Yr Avg
P/E16.120.718.814.9
P/E vs. S&P 500 P/E 1.01.20.80.8
PEGN/AN/AN/A1.3
Price/Sales0.70.90.60.8
Enterprise Value/Cash Flow (EV/CFO)10.612.310.110.8
Gauge Score (0 to 25)1088
Share Price ($)$28.51$35.23$25.94-

Home Depot's share price declined 19 percent during the second fiscal quarter, which would normally be enough to lift the Value gauge score substantially.  However, the score was held down by valuation metrics that haven't yet become especially attractive relative to their five-year averages.  A rise in the Value gauge awaits further improvements in sales, cash flow, and earnings.


Overall01 Aug 201002 May 201002 Aug 20095-Yr Avg
Gauge Score (0 to 100)22222830

None of the category gauges changed by more than a point, and what changes there were canceled each other out.  Some positive trends could be seen in the second quarter's results, but further improvements will be needed to boost the Overall gauge.




Full disclosure: Long HD at time of writing.

14 September 2010

MSFT: Look Ahead to the September 2010 Quarter

This post describes our model of Microsoft's (NASDAQ: MSFT) Income Statement for fiscal 2011's first quarter, which will end on 30 September.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.


First, we present some background information about Microsoft and the business environment in which it is currently operating.

Microsoft develops and sells the operating system software that runs on more than 90 percent of personal computers.  It also has dominant application software and server software franchises.   In addition, the company provides various online services, such as the Bing search engine and online advertising.  Microsoft also sells video game consoles, entertainment devices, and computer peripherals.

Net Income in fiscal 2010 was $18.8 billion, up nearly 30 percent from the prior year.  Revenue increased 7 percent, from $58.4 billion in 2008 to $62.5 billion.  Microsoft's  10-K for fiscal 2010 states:

Revenue increased mainly due to strong sales of Windows 7, which was released during fiscal year 2010, and PC market improvement. [...]  Diluted earnings per share increased reflecting increased net income and the repurchase of 380 million shares during fiscal year 2010.

13 September 2010

KG: Financial Gauge Analysis for the June 2010 Quarter

King Pharmaceuticals, Inc., (NYSE: KG) earned $0.07 per diluted share on a GAAP basis in 2010's second quarter, which ended 30 June.  Earnings per share were less than half the $0.15 King made in the same quarter of 2009.

A previous article examined King's Income Statement for the June quarter in some detail.  Reported GAAP earnings were $0.02 less than the $0.09 per share we had forecast.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for King Pharmaceuticals and the associated financial gauge scores.  The metrics were calculated using data from King's current and historical financial statements, including those in the latest 10-Q report.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

King Pharmaceuticals, headquartered in Bristol, TN, manufactures and sells various brand-name prescription pharmaceuticals and other products.  The acquisition of Alpharma, in a $1.6 billion deal completed in December 2008, added new painkilling medicines and animal health products.

In an important January 2009 decision, two King patents related to the muscle relaxant Skelaxin® (metaxalone) were invalidated by a U.S. District Court.  Skelaxin was one of the company's best-selling products at the time.  Generic versions of Skelaxin became available in the April 2010, and sales of King's branded product tumbled.

Pain-killing medications with features that deter abuse may be King's best hope for the future.  The company seems especially optimistic about EMBEDA®, which first became available commercially in September 2009.  King reported prescription growth of 15 percent for Embeda, an opioid for management of moderate to severe pain under certain conditions, during the month of June 2010.

King is also developing Acurox® product with Acura Pharmaceuticals (NASDAQ: ACUR), Remoxy® with Pain Therapeutics, Inc. (NASDAQ: PTIE), and the ALO-02 oxycodone/naltrexone product started by Alpharma.  King management expressed optimism that non-clinical data seen to date will support a Remoxy NDA resubmission by the end of this year.

Additional background information about King and the business environment in which it is currently operating can be found in the look-ahead.



Mergers and acquisitions, such as King's purchase of Alpharma, pose a challenge to us at GCFR because a major deal can lead to both temporary and longer term changes to the company's financial results.  Comparisons with the past, a key element of our approach, can be misleading.  Temporary changes include unusual revenue growth and large restructuring expenses.  In addition, it's not unusual for one transaction to be followed by others, such as asset divestitures that don't conform to the new organization's priorities. 

For these and other reasons, extra caution has to be taken when evaluating a company in the immediate aftermath of a merger or acquisition.   It is often prudent to "let the dust settle" before drawing any far-reaching conclusions.

With this caveat in mind, King's latest quarterly results produced the following changes to the gauge scores:
 

The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.

11 September 2010

NOK: Look Ahead to the September 2010 Quarter

This post describes our model of Nokia's (NYSE: NOK and HEL:NOK1V) Income Statement for the third quarter, which will end on 30 September 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about Nokia and the business environment in which it is currently operating.

A Finnish company with a rich history, Nokia Corporation has been the leading global producer of mobile phones since 1998.  The company also sells the network infrastructure that supports these phones. 

Nokia's sales, earnings, and share price have fallen precipitously in recent years.  Global economic weakness has certainly had a negative effect.  However, the most visible and far-reaching problem has been Nokia's inability to stem the success of Apple's (NASDAQ: AAPL) iPhone, which was first introduced in 2007.  The Blackberry product line sold by Research in Motion (NASDAQ: RIMM) and, more recently, smartphones based on the Android architecture promoted by Google (NASDAQ: GOOG) have also become popular at Nokia's expense. 

In the latest and most dramatic attempt to regain its competitive position, Nokia announced on 10 September 2010 that it would replace its Chief Executive Officer with Mr. Steven Elop, formerly of Microsoft. 

Among other things, the company hopes Mr. Elop, a Canadian citizen, will be able to resolve its long-standing difficulties in North America.  Only 3 percent of the mobile devices Nokia sold in 2009 and only 5 percent of Nokia's net sales in 2009 were in North America.

09 September 2010

WMT: Financial Gauge Analysis for the July 2010 Quarter

Wal-Mart Stores (NYSE: WMT) earned $0.97 per diluted share on a GAAP basis in fiscal 2011's second quarter, which ended on 31 July 2010.  Earnings per share were 9 percent more than the $0.89 Walmart made in the same quarter of the year earlier.

A previous article examined Walmart's Income Statement for the July quarter in some detail.  Reported Net Income of $3.596 billion exactly matched our estimate (a rarity!), but fewer shares outstanding allowed earnings per share to exceed by $0.01 the $0.96 we had forecast.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for Walmart and the associated financial gauge scores.  The metrics were calculated using data from Walmart's current and historical financial statements, including those in the latest 10-Q report.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

A retailing behemoth, Wal-Mart Stores, Inc., earned over $14 billion on net sales of $405 billion in the fiscal year that concluded last January.  The Revenue figure, along with a drop in energy prices, enabled Walmart to regain from Exxon Mobil (NYSE: XOM) the top position on the Fortune 500 list of America's largest corporations. 

Walmart has three reportable business segments: Walmart U.S., International and Sam’s Club.  At last count, Walmart operated 4304 stores in the U.S. (including Sam's Club) and 8416 in other countries.

Net sales by Walmart U.S. grew 1.1 percent last year, but comparable store sales declined 0.7 percent.  Concerned about slow sales at home, Walmart replaced the leader of Walmart U.S.

Additional background information about Walmart and the business environment in which it is currently operating can be found in the look-ahead.

In summary, Walmart's latest quarterly results produced the following changes to the gauge scores:


The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.

08 September 2010

PEP: Look Ahead to September 2010 Quarterly Results

This post describes our model of PepsiCo's (NYSE: PEP) Income Statement for fiscal 2010's 12-week third quarter, which ended on 5 September 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about PepsiCo and the business environment in which it is currently operating.

PepsiCo, Inc., is a leading global purveyor of beverages and snacks.  The company, which has a market value of approximately $100 billion, is well regarded for good management, steady growth, and significant international exposure

Businesses, such as PepsiCo, that sell consumer staples are considered defensive investments because they are relatively less affected by economic slumps.  These firms also tend to pay generous dividends, and this is true for PepsiCo.  The company hiked its annual dividend this year by 7 percent, from $1.80 to $1.92 per share.

While famously locked in a battle with Coca-Cola (NYSE: KO) for the soft-drink market, it is important to recognize the importance of PepsiCo's other product lines.  Frito-Lay North America had Revenue in 2009 of $13.2 billion, which was 30.6 percent of PepsiCo's total revenue.

On 26 February 2010, PepsiCo completed acquisitions of Pepsi Bottling Group, Inc., and PepsiAmericas, Inc., for $7.8 billion in total.  These transactions give PepsiCo, according to statements made during a conference call, "one vertically integrated value chain [for beverages] just like [the] snacks business." PepsiCo will be "making decisions which benefit the total system without concern as to how the cost and benefits are shared between the brand and bottling operations."

The newly combined company would have earned $6.75 billion ($4.09 per diluted share) on a pro forma basis in fiscal 2009 on Revenue of $57.5 billion.  The pro forma results eliminate the transactions that occurred between the three entities.  The acquisitions effectively added $800 million (13.6 percent) to PepsiCo's annual Net Income and $14.2 billion (33 percent) to Revenue.