09 August 2008

KG: Financial Analysis through June 2008

We have analyzed King Pharmaceuticals, Inc.,'s 10-Q financial statements for the second quarter of 2008, which ended on 30 June.

King Pharmaceuticals, Inc. (NYSE: KG) sells various brand-name prescription pharmaceutical products. The company experienced a substantial setback last year when the U.S. Court of Appeals invalidated King's patent for Altace® (Ramipril). This ACE inhibitor, used to treat patients with cardiovascular risks, had accounted for roughly 1/3 of King's net sales. As a result of the Court's action, King incurred asset impairment charges (covering intangible assets and inventory) totaling $250 million.

King, as explained on the Orange Book Blog, tried unsuccessfully to delay the availability of generic Ramipril from firms other than Cobalt Laboratories. Additional sources for this product became available in June 2008.

At about $10 each, the current price of King's common shares is about 75 percent below the all-time high set back in 2001.

When we analyzed King's first quarter results, the Overall Gauge score was 74 (after an adjustment), on a scale of 0 to 100. This superlative (and, alas, misleading) score highlighted a limitation of the GCFR methodology: by focusing on past performance, the approach will produce specious results when the business of the company being analyzed changes significantly and abruptly. The price of King shares plunged immediately after the Altace decision, but the company's sales and earnings were slower to suffer the effects of the patent invalidation. Our number-crunching gauges were blind to the weaker figures that are now emerging.

With the data from the June 2008 quarter, our gauges are displaying the following scores:
  • Overall: 53 of 100 (down from 74)

Before we examine the factors that affected each gauge, we will review the latest quarterly Income Statement and compare it to our previously communicated expectations.

Please note that the table format below, which we use for all analyses, can and often does differ in material respects from company-used formats. A common difference is the classification of income and expenses as Operating and Non-Operating. The standardization is simply for convenience and to facilitate cross-company comparisons.

($ M)

June 2008
(actual)
June 2008
(predicted)
June 2007
(actual)
Revenue

397
407
543
Op expenses





CGS (102)
(102)
(126)

Depreciation
(32)
(31)
(49)

R&D (49)
(50)
(37)

SG&A (112)
(165) (173)

Other
(44)
(0)
(78)
Operating Income
58
59
88
Other income





Investments
0
0
0

Interest, etc.
7
10
7
Pretax income

65
69
95
Income tax

(22)
(24)
(30)
Net Income
43
46
65


$0.18/sh
$0.19/sh
$0.27/sh
Shares outstanding

245
245
245
1. Total revenues. Net Sales plus royalty revenues.

2. Cost of revenues, exclusive of depreciation, amortization and some impairments.

3. Depreciation and amortization, plus accelerated depreciation

4. SG&A, plus special legal and professional fees, plus co-promotion fees.

5. Excess purchase commitment, plus Excess inventory reserve, plus Arbitration settlement, plus In-process R&D, Asset impairment charges, plus Restructuring charges.



Revenue in the recent quarter was 26.9 percent below that in the year-earlier period. We had expected Revenue to decline by 25 percent. Generic competition for Altace, some of which didn't become available until the end of the quarter, took a 72.8 percent bite out of sales. Revenue in the trailing four quarters was 7.6 percent less than in the previous four quarters.

We had expected, based on company-provided guidance, that King would achieve a 75 percent Gross Margin in the quarter. The actual margin was a still-remarkable 74.3 percent. This latter value translates into a Cost of Goods Sold (CGS) of 25.7 percent of Revenue.

Depreciation expenses were just $1 million more than company guidance suggested.

On the other hand, Research and Development (R&D) expenses were $1 million less than anticipated.

We over-estimated Sales, General, and Administrative (SG&A) expenses by a huge $53 million, but this miscalculation was almost canceled out by the $44 million of unanticipated special operating expenses. SG&A expenses decreased primarily due to a $37.5 million reduction in in co-promotion expenses related to Altace.

King's Operating Income, which rolls up all the sales and operating expense, just about matched our forecast.

Interest income was $3 million less than forecast. The income tax rate was 34.0 percent, equaling the guidance. As a result, Net Income was within $3 million of our projection. However, Net Income was 33.7 percent less than in the June 2007 quarter.


Cash Management. This gauge decreased from 18 points in March to 17 points now.


June
2008
3 months
ago
12 months
ago
Current Ratio4.4
5.0
3.6
LTD/Equity
15.2%
15.5%16.1%
Debt/CFO
0.6 yrs
0.6 yrs
0.7 yrs
Inventory/CGS
106 days
111 days
156 days
Finished Goods/Inventory
63.8%
62.4%35.4%
Days of Sales Outstanding (DSO)41.2 days
40.0 days
46.3 days
Working Capital/Market Capitalization 41.8%
58.6%
20.2%
Cash Conversion Cycle Time88.2 days
96.9 days
143.9 days

King had over $1 billion in Cash or equivalents on 30 June. The amount is far more than needed to meet current obligations. The company could be planning to reduce its debt or getting ready to make a large investment. However, it might also be due to the company holding $466 million in auction rate securities that the company cannot reasonably liquidate. The Current Ratio and Working Capital-to-Market Capitalization ratios are very high, but they have retreated from even greater values in the first quarter. The other ratios in this category indicate improved efficiency. The one exception involves the large proportion of Finished Goods in the Inventory. It's a potential indicator of slower than anticipated sales.


Growth. This gauge increased from 3 points in March to 4 points now.


June
2008
3 months
ago
12 months
ago
Revenue growth-7.6%
1.6%
7.2%
Revenue/Assets 55.2%
60.0%
61.1%
CFO growth
20.1%
14.8%
46.8%
Net Income growth -56.8%
-56.2%
61.9%
Growth rates are trailing four quarters compared to four previous quarters.

With rapidly declining sales and earnings, Growth isn't a big part of the current landscape at King. However, the fact that Cash Flow from Operations in the last four quarters was 20 percent greater than the four previous quarters is very encouraging.


Profitability. This gauge decreased from 18 points in March to 17 points now.


June
2008
3 months
ago
12 months
ago
Operating Expenses/Revenue 75.4%
74.1%69.9%
ROIC 18.0%
18.3%15.0%
FCF/Equity
22.5%
23.5%20.3%
Accrual Ratio
-26.3%
-17.7%8.3%

The loss of Altace exclusivity has, to no one's surprise, cut into King's Gross Margin. Nevertheless, the ROIC and FCF/Equity values remain quite appealing. The oddly low Accrual Ratio is a result of strong Cash Flow in the face of declining Net Income.


Value. King's stock price rose over the course of the quarter from $8.70 to $10.47. This increase was one reason the Value gauge dropped from 23 points in March to 11 points now.


June
2008
3 months
ago
12 months
ago
P/E 19.3
13.8
16.3
P/E to S&P 500 average P/E 108.7%
79.8%98.9%
Price/Revenue 1.3
1.0
2.4
Enterprise Value/Cash Flow (EV/CFO)
2.7
1.78.2
King's valuation ratios can be compared with other Drug Manufacturers.

The earnings-based metrics aren't presently appealing, but ones involving Cash Flow may attract the attention of value investors.


The full effects of the Altace patent situation are being realized. Our rearward-looking gauges painted a too rosy view of King Pharmaceuticals during the initial transition, but the Overall Gauge fell a dramatic 21 points in the second quarter. A further contraction may be on the horizon. Nevertheless, the situation isn't entirely bleak. The company appears to be well capitalized, with little debt, and strong cash flow.

07 August 2008

WPI: Financial Analysis through June 2008

We have analyzed Watson Pharmaceuticals' 10-Q financial statements for the quarter that ended on 30 June 2008.

Watson Pharmaceuticals, Inc. (WPI) develops, manufactures, and sells generic and, to a lesser extent, branded pharmaceutical products. Watson had been expanding beyond generic drugs into higher-margin branded products. However, Watson's acquisition of Andrx in late 2006 reversed this strategy, and generics are now responsible for three times as much Revenue as branded products. Watson's management may have deliberately increased their generic drug exposure to take advantage of the large number of branded pharmaceutical products that have, or will soon, lose their patent protection.

When we earlier analyzed Watson's first quarter results, the Overall Gauge score decreased to 48 of 100 possible points from a more robust 56 points three months earlier. Of the four individual gauges that fed into March's composite result, Profitability was strongest at 15 of 25 points, and Cash Management was weakest at 10 points. The Cash Management score was negatively impacted by rising Inventory levels.

Now, with this available data for the June quarter, our gauges display the following scores:
Before we examine the factors that affected each gauge, we will compare the latest quarterly Income Statement to our previously announced expectations.

Please note that the table format below, which we use for all analyses, can and often does differ in material respects from company-used formats. A common difference is the classification of income and expenses as Operating and Non-Operating. The standardization is simply for convenience and to facilitate cross-company comparisons.

($ M)

June 2008
(actual)
June 2008
(predicted)
June 2007
(actual)
Revenue

623
630
603
Op expenses





CGS (360)
(375)
(360)

Depreciation
(20)
(20)
(44)

R&D (39)
(40)
(36)

SG&A (104)
(110) (97)

Other
(0)
(0)
(0)
Operating Income
99
85
66
Other income





Investments
0
0
0

Interest, etc.
(3)
(4)
(8)
Pretax income

96
81
57
Income tax

(36)
(30)
(21)
Net Income
60
51
36


$0.51
$0.44/sh
$0.31/sh
Shares outstanding

117.7
117.4
117.1


Revenue in the quarter was 3.3 percent more than in the year-earlier quarter, which fell below our projection of a 4.5 percent increase. Watson's guidance for year had been (and remains) that Revenue in 2008 will be approximately $2.5 billion. We figured they might do a little better than the implied $625 million quarterly average. In reality, Revenue fell just slightly short.

Watson's Generic and Brand product segments posted Revenue increases, but the Distribution segment's Revenue declined 13 percent. Watson attributed the decline to "fewer new product launches in the quarter." The Distribution segment sells products other than those made by Watson itself.

The Gross Margin for the quarter, at 42.2 percent of Revenue, beat our 40.5 percent target. This translates into a Cost of Goods Sold (CGS) of 57.8 percent of Revenue.

Depreciation was 3.2 percent of Revenue, in line with the forecast. The guidance from Watson to expect $80 million in annual Depreciation and Amortization expenses is accurate so far this year.

Research and Development (R&D) expenses were 6.3 percent of Revenue. This value was also very consistent with company guidance. Sales, General, and Administrative (SG&A) expenses were 16.8 percent of Revenue, compared to the forecast of 17.5 percent.

The greater-than-expected Gross Margin and the lower-than-expected SG&A expense more than made up for the slight Revenue shortfall. As a result, Operating Income exceeded our prediction by a healthy 16.5 percent.

Net Interest Expense was $1 million less than we expected. Our target for the Income Tax Rate was 37 percent, and the actual rate was 37.1 percent. Net Income, therefore, exceeded our estimate by 17.6 percent.


Cash Management. This gauge increased from the 10 points in March to 15 points now.


June
2008
3 mos.
ago
12 mos.
ago
Current Ratio2.9
2.7
2.4
LTD/Equity
41.8%
43.3%55.2%
Debt/CFO
2.1 yrs
2.0 yrs
2.1 yrs
Inventory/CGS
131 days
127 days
109 days
Finished Goods/Inventory
67.7%
70.0%65.5%
Days of Sales Outstanding (DSO)44.2 days
48.3 days
50.7 days
Working Capital/Market Capitalization 20.4%
17.1%
13.3%
Cash Conversion Cycle Time67.8 days
76.3 days
80.2 days

The big increase in Working Capital was the predominant reason for the score increase, but the nice decrease in Days of Sales Outstanding helped as well. We continue to be troubled by the increase in Inventory, but we aren't sure whether it reflects changing product demand or a different sales mix.


Growth. This gauge decreased from 11 points in March to 8 points now.


June
2008
3 mos.
ago
12 mos.
ago
Revenue growth5.8%
9.3%
33.8%
Revenue/Assets 70.8%
71.3%
67.0%
CFO growth
-16.9%
-4.3%
38.4%
Net Income growth N/A
N/A
N/A
Growth rates are trailing four quarters compared to four previous quarters.

Revenue/Assets is much higher than historical averages, but we need to remember that this reflects the company's increasing dependence on high-volume generic drugs. We remain concerned about the fading Cash Flow from Operations.


Profitability. This gauge didn't change from 15 points in March.


June
2008
3 mos.
ago
12 mos.
ago
Operating Expenses/Revenue 87.7%
89.0%91.3%
ROIC 7.5%
6.6%4.5%
FCF/Equity
16.5%
17.3%23.3%
Accrual Ratio
-4.4%
-5.3%15.6%

Operating expenses have edged down because the Gross Margin has improved. ROIC seems to be recovering from anemic levels. By dropping over the last year, the Accrual Ratio is indicating that more of the company's Net Income is due to Cash Flow from Operations (CFO), and, therefore, less is due to changes in non-operational Balance Sheet accruals.


Value. Watson's stock price decreased during the quarter from $29.32 to $27.17. The Value gauge, based on the latter price, rose to 15 points from 11 points three months ago.


June
2008
3 mos.
ago
12 mos.
ago
P/E 17.4
21.5
N/A
P/E to S&P 500 average P/E 98%
125%N/A
Price/Revenue 1.3
1.4
1.6
Enterprise Value/Cash Flow (EV/CFO)
9.5
10.19.9
Watson's valuation ratios can be compared with other companies in the Generic Drug industry.


An Overall gauge score of 56, of 100 possible, points is a good result, and it suggests that Watson deserves increased attention. We would still like to see lower Inventory levels, higher CFO, and better ROIC.

INTC: Financial Analysis through June 2008 (Update)

Intel Corporation's (INTC) preliminary financial statements for the second quarter, which ended on 28 June 2008, did not include a complete Cash Flow statement. In our initial analysis of these results, we estimated Net Cash Flow from Operations and Cash Used for Investments from other data.

Since Intel subsequently submitted a complete 10-Q quarterly report, we now have the Cash Flow data and much other useful information about the second quarter. We then used the data in the 10-Q to update our evaluation of the quarter.

The GCFR gauge scores only changed slightly from the initial second-quarter analysis, as can be seen below:

The latest data changed the following metrics from the values reported earlier:

Gauge
Metric
Actual value
Estimated value
Cash Management



None


Growth




CFO growth
25.0%
26.1%
Profitability




FCF/Equity
23.0%
23.3%

Accrual Ratio
0.5%
-0.6%
Value



Enterprise Value/Cash Flow (EV/CFO)8.4
8.3






The data in the 10-Q didn't change our assessment of Intel's first-quarter Income Statement and the comparison to our previously posted expectations. Readers interested in this analysis are referred to our earlier posting.

05 August 2008

CSCO: Financial Analysis through July 2008

We have analyzed Cisco's preliminary results for the quarter and fiscal year that ended on 26 July 2008. When Cisco issues a 10-K report for the year, with much supplemental information, we will determine if the GCFR gauge scores need to be adjusted.

Cisco Systems, Inc. (CSCO), the proud plumber of the Internet, has a commanding position in the market for enterprise networking products and services, such as routers. The latest leg down in equity markets have brought Cisco shares to newer lows.

Earlier, when we analyzed Cisco's April quarter, the Overall Gauge measured 43 (of 100 possible) points. Of the four individual gauges that fed into April's composite result, Profitability was the strongest at 12 (of 25) points, and Growth was weakest at 9 (of 25) points. The Value gauge has perked up as the price of Cisco shares have fallen.

Now, with data available from the July 2008 quarter, our gauges display the following scores:



Before examining the factors that affected each gauge, we will compare the latest quarterly Income Statement to our previously announced expectations.


We use the Income Statement prepared in accordance with U.S. GAAP, rather than the non-GAAP ("pro forma" or "ex-items") data that gets so much attention. In the latest quarter, the non-GAAP results exclude expenses of $532 million ($381 million after tax).


Please note that the tabular format below, which we use for all analyses, can and often does differ in material respects from company-used formats. A common difference is the classification of income and expenses as Operating and Non-Operating. The standardization is simply for convenience and to facilitate cross-company comparisons.

($M)

July 2008
(actual)
July 2008
(predicted)
July 2007
(actual)
Revenue (1)
10364
10329 9433
Op expenses





CGS (2) (3698)
(3667)
(3365)

R&D (1306)
(1343)
(1178)

SG&A (3) (2682)
(2686)
(2404)

Other (4) (149)
(140)
(183)
Operating Income
2529
2494 2303
Other income





Investments
0
0
0

Interest, etc. (5)
157
150 228
Pretax income

2686
2644 2531
Income tax

(672)
(635)
(601)
Net Income
2014
2009 1930


$0.33
$0.33/sh
$0.31/sh
Shares outstanding

6034
6030
6275
(1) Total net sales.
(2) Total cost of sales
(3) Sales and marketing +General and administrative
(4) Amortization of purchased intangible assets + In-process research and development
(5) Interest and other income (loss), net


Revenue in the July 2008 quarter was 9.9 percent greater than in the year-earlier quarter. Cisco's guidance for the quarter had been to expect Revenue growth of 9 to 10 percent. Our target was the 9.5 percent midpoint of the range. Revenue in the most recent four quarters (i.e., fiscal 2008) exceeded Revenue in the four previous quarters (i.e., fiscal 2007) by 13.2 percent.


Cisco achieved a Gross Margin of 64.3 percent in the quarter, which almost satisfied our 64.5 percent target. [The company's guidance was to expect a 65 percent margin, and we did well by trimming it by 0.5 percent.] The actual Gross Margin is equivalent to a Cost of Goods Sold (CGS) of 35.7 percent of Revenue.


Research and Development (R&D) expenses were 12.6 percent of Revenue, a little less than the 13.0 percent prediction. Sales, General, and Administrative (SG&A) expenses, at 25.9 percent of Revenue were almost identical to our 26.0 percent estimate.


Other operating expenses (primarily amortization of purchased intangible assets) were $9 million more than our prediction.

The slightly higher than anticipated Revenue, offset partially by higher miscellaneous expenses, was the principal reason Operating Income surpassed our forecast value by 1.4 percent.

Non-operating interest and other income was $7 million more than expected. The Income Tax Rate was 25 percent, instead of the predicted 24 percent.


Net Income essentially matched our prediction.


Cash Management. This gauge increased from 10 points in April to 16 points now.


July
2008
3 months
ago
12 months
ago
Current Ratio2.6
2.6
2.4
LTD/Equity
18.6%
19.4%20.4%
Debt/CFO
0.6 yrs
0.6 yrs
0.6 yrs
Inventory/CGS
33.2 days34.2 days39.0 days
Finished Goods/Inventory
67.4%
68.0%64.9%
Days of Sales Outstanding (DSO)36.0 days
35.1 days
38.1 days
Working Capital/Market Capitalization 15.6%
12.8%
9.7%
Cash Conversion Cycle Time (CCCT)
47.6 days
47.0 days
52.9 days

With just a couple of minor exceptions, the Cash Management metrics improved during the July quarter. The percentage of Finished Goods in the Inventory is higher than we prefer, but down a little from the April quarter. Days of Sales Outstanding is up from April, but down from July 2007. We prefer to see steady declines in both of these metrics.



Growth. This gauge increased from 9 points in April to 11 points now.



July
2008
3 months
ago
12 months
ago
Revenue growth13.2%
15.3%
22.6%
Revenue/Assets 67.3%
67.6%
65.5%
CFO growth
19.6%
16.7%
27.9%
Net Income growth 9.8%
14.7%
31.4%
Growth rates are trailing four quarters compared to four previous quarters.

As predicted, Revenue growth has decelerated. Cash Flow from Operations rebounded, but didn't match fiscal 2007's torrid pace. Net income, which benefited from a change in the income tax rate from 22.5 to 21.5 percent, also slowed.


Profitability. This gauge increased from 12 points in April to 15 points now.


July
2008
3 months
ago
12 months
ago
Operating Expenses/Revenue 74.9%
74.7%73.9%
ROIC 21.7%22.7%20.7%
FCF/Equity
31.5%30.3%28.1%
Accrual Ratio (*)
0.3%4.1%10.4%
* The correction of a date entry error has led to restated Accrual Ratio figures and Profitability gauge scores


Cisco is to be commended for maintaining ROIC and FCF at loftly levels, despite a challenging economic conditions. The decreasing Accrual Ratio tells us that more of the company's Net Income is due to CFO, and, therefore, less is due to changes in non-operational Balance Sheet accruals.


Value. Cisco shares decreased in price from $25.64 on 30 April to $21.99 on 31 July. The Value gauge, based on the latter price, increased from 11 to 16 points.


July 20083 months
ago
12 months
ago
5-year
median
P/E 16.5
19.5
23.823.7
P/E to S&P 500 average P/E 94%
108%150%142%
Price/Revenue 3.4
4.0
5.0
5.0
Enterprise Value/Cash Flow (EV/CFO)
9.4
12.215.715.4
Cisco's valuation ratios can be compared with other companies in the Networking & Communication Devices industry.


This may be the closest we've ever come to predicting a company's actual quarterly results. To be sure, we benefited from company-provided guidance.

The July results led to increases in all four of the gauge scores. The Overall Gauge score of 62 points, of 100 possible points, is a very good score. It could be suggesting that Cisco shares, which have dropped steeply in the last three quarters, may have bottomed.