15 January 2008

INTC: Financial Analysis through December 2007

We analyzed Intel's (INTC) preliminary financial results for the quarter that ended on 29 December 2007. Because the results did not include a complete Cash Flow statement, we had to estimate a key parameter, Net Cash Flow from Operations, from other data. When Intel submits the full 10-K report for the year to the SEC, we will find re-assess the results.

Intel manufactures integrated circuits for computers, servers, handheld devices, and communication products.

Intel's shares recovered nicely in 2007, rising 30 percent from $20.45 to $26.66. The gain was helped by favorable reviews given to Intel's newest products and market share recaptured from steadfast competitor Advanced Micro Devices (AMD). However, the new year has not been kind to Intel shares, and the price has dropped all the way to $21.77 before bouncing back a little. The losses have been attributed to the slowing economy, an anti-trust investigation, and analyst downgrades.

When we evaluated Intel after the third quarter, we noted higher Revenue, Cash Flow from Operations, and Net Income. These improvements pushed the Overall Gauge up from a weak 20 points to a more moderate score of 30. Of the four individual gauges, Cash Management was the strongest at 14 points. Unfortunately, the double-weighted Value Gauge made no contribution whatsoever to the score. [The recent dip in the stock price could have a positive effect on the Value gauge.]

Now, with the available data from the December 2007 quarter, our gauges display the following scores:

Before we examine each gauge, let's compare the latest Income Statement to our previously posted expectations.


($M)
Dec 2007
(actual)
Dec 2007
(predicted)
Dec 2006
(actual)
Revenue
10712108009694
Operating
expenses





CGS(4486)(4644)(4884)

R&D(1481)(1620)(1426)

SG&A(1462)(1512)(1434)

Other(236)(130)(462)
Operating
Income

304728941488
Other income




Investments(19)07

Interest, etc.233150632
Pretax income
326130442127
Income tax
(990)(883)(626)
Net Income
227121611501


0.38/sh0.37/sh0.26/sh



Revenue was near the low end of the $10.5 to $11.1 billion range forecast by the company in October. We had assumed the midpoint of the range would be achieved. Therefore, instead of a predicted 11.4 percent increase over the comparable value in the year-earlier quarter, the increase was only 10.5 percent.

A better story can be told with Operating Expenses. Intel estimated that Cost of Goods Sold (CGS) would be 43 percent of Revenue, and the actual value was 41.9 percent. Research and Development (R&D) expenses were 13.8 percent of Revenue, nicely below our 15 percent estimate. Similarly, Sales, General, and Administrative (SG&A) expenses were 13.6 percent of Revenue, a bit better than our forecast of 14 percent.

The lower-than-expected costs more than made up for the Revenue shortfall. As a result, Operating Income was 5.3 percent above the forecast value.

Non-operating income was $64 million greater than expected. However, the Income Tax Rate was 30.4 percent, exceeding the predicted 29 percent. Net Income exceeded our prediction by a healthy 5.1 percent.

It's strange that the stock market reacted so negatively to Intel's results. We believe the company largely met or surpassed guidance for the quarter. If lower expenses weren't the consequence of one-term gimmicks, future quarters will benefit.


Cash Management. This gauge decreased from 14 points in September to 13 points now.

The measures that helped the gauge were:
The measures that hurt the gauge were:
  • Finished Goods/Inventory = 41.6 percent, up from 38.5 percent last year; did sales grow slower than the company had hoped?
  • Inventory/CGS = 76.1 days, down from September's 77.7 days and 79.1 days in December 2006; still high, though, compared to historic levels.

Growth. This gauge increased from 8 points in September to 11 points now.

The measures that helped the gauge were:
  • Net Income growth = 38.3 percent year-over-year; up from -42 percent
  • Revenue growth = 8.3 percent year-over-year, a reversal from -8.9 percent
  • CFO growth = 8.3 percent (estimated) year-over-year, a major turn-around from last year's -28 percent
The measures that hurt the gauge were:

Profitability. This gauge decreased from 13 points in September to 12 points now.

The measures that helped the gauge were:
The big factor in the decrease in operating expenses were cuts in R&D and SG&A and a percentage of Revenue.

The measures that hurt the gauge were:

Value. Intel's stock price rose over the course of the quarter from $25.86 to $26.86. The Value gauge, based on the latter price, didn't get out of its zero-point rut.

The average P/E for the Semiconductor industry has dropped substantially to 22.6. The average Price/Sales for the Semiconductor industry is 5.8.


We had noted after recent quarters that Intel's stock price was increasing at a pace faster than the laudable improvements in operating performance. Our Value gauge for Intel had been stuck at embarrassingly low levels for more than a year, and we fretted that the nice gains the company was racking up in the stock market were not fully justified.

Now, however, the share price has given up the bulk of 2007's gains.

Given the reaction tonight to the December results, it is likely that the shares will open below $20 tomorrow morning. Patient investors might consider this to be an attractive, if admittedly contrarian, purchase opportunity. A $20 share price would cause the Value gauge to increase from 0 points to 9 points (out of 25), and the Overall gauge would inflate from 29 to 47 points (out of 100). The latter score, while a little too low to be a clear "buy" signal, is close to those levels that often anticipate stock price gains 12 months in the future. Keep in mind that we haven't yet assessed a full Cash Flow statement and our concerns about Inventory levels.

13 January 2008

AAA Non-Financials Down to Five

In the last week, Standard & Poor's dropped the credit rating of United Parcel Service (UPS) to a notch below AAA. There are now only five U.S. non-financial firms sporting the highest ranking. According to BusinessWeek, these are:
  • Johnson & Johnson (JNJ)
  • Automatic Data Processing (ADP)
  • General Electric (GE)
  • Exxon Mobil (XOM)
  • Pfizer (PFE)
The days when companies vied for the highest ratings and the longest records for increased dividends seemed to have receded into history. (Quaint traces of the competition can still be found, more so with dividends than credit ratings.) Firms are willing to operate with greater financial leverage as evidenced by higher Debt-to-Equity ratios. They will even take on additional debt to repurchase shares in the company, which increases the ratio from top and bottom, but might increase earnings per share. Home Depot intends to do just that, as part of a recapitalization plan; however, their borrowings might be less than originally planned because credit is more difficult to obtain these days.

This is, by no means, a new phenomenon. In the book Quality of Earnings, which we recently completed, Thornton Oglove cites a relevant example involving a stock repurchase from the 1980's involving Avon.

At GCFR, we include two debt-related metrics in our Cash Management gauge: the aforementioned ratio of Long-Term Debt to Equity and total Debt to Cash Flow from Operations. We like to see some leverage -- corporate investments in productive capital equipment or R&D is a justifiable use of debt -- but it has to be affordable. When debt levels get to high, it becomes that much harder for the company to get additional cash needed to take advantage of new opportunities or to get through a bad spell.

We suspect the current problems in credit markets might actually lead to increased emphasis on corporate credit-worthiness. Might the list of AAA-rated firms actually go up instead of down one day? We don't know when this last happened.

06 January 2008

NOK: Look Ahead to December 2007 Results

Nokia's (NOK) results through the third quarter of 2007 were outstanding. Net Income was up an impressive 62 percent year-over-year, and Cash Flow from Operations rose a powerful 76 percent over this period. Revenue increased 18 percent.

In dollar terms, the stock soared at an even faster pace. From 31 December 2006 through 31 December 2007, Nokia American Depository Receipts (ADRs) advanced from $20.32 to $38.39, or 89 percent. Our austere Value Gauge, however, isn't one to celebrate when share prices rise by rates greater than earnings, causing multiples to expand. In our analysis results after the third quarter, the Overall Gauge score for Nokia dropped to 25 out of 100 possible points because of the valuation concerns.

We also expressed some questions about how much of the growth was due the formation of the Nokia Siemens Networks partnership in the second quarter, tax changes, and the weakening of the dollar. (Nokia's results are expressed in Euros.)

On 24 January, Nokia will report its fourth quarter and full year results for 2007. The additional data should give us better visibility into company performance.

Because Revenue has been accelerating, we believe it is possible that Nokia's sales were around €14.0 billion in the fourth quarter. This figure would constitute year-over-year growth of 20 percent; coincidentally, it would also be 20 percent greater than the €11.7 billion revenue in the fourth quarter of 2006. Collectively, professional analysts are a little more optimistic than we are: their average estimate for fourth quarter revenue is $21.13 billion (€14.3 billion at the current exchange rate )

Nokia's Gross Margin has been around 33 percent of Revenue, give or take a couple of points, for the last couple of years. Since the company seems to be emphasizing increased market share, we're not going to look for a significant improvement in profitability in the fourth quarter. Matching the 33 percent figure with our Revenue projection, our expectation for Costs of Goods Sold in the quarter is €9.4 billion.

Research and Development and Sales, General and Administrative expenses have each been about 10 percent of Revenue recently, although they have been edging upward. We will assume these percentages hold true in the second quarter. Therefore, we're estimating these expenses at €1.4 billion each in the fourth quarter. If we assume another €25 million in miscellaneous operating charges, the estimate for Operating Income turns out to be €1.8 billion.

Investment and interest income/expenses are tough to predict because they vary greatly from quarter to quarter. For the record, we're assuming €67 million net non-operating income. If we subtract €480 million for income taxes, using the company's guidance for an effective 26 percent tax rate, the prediction for Net Income is €1.4 billion (€0.35/share). The analyst estimate is $0.61 (€0.41) per share


(€M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue
14000
11701
Op expenses




CGS 9380
7908

R&D 1400
1065

SG&A 1400 1189

Other 25
20
Operating
Income

1795
1519
Other income




Investments
(5)
(4)

Interest, etc.
72
44
Pretax income

1862
1559
Income tax

484
286
Net Income
1378
1273


0.35/sh
0.32/sh




25 December 2007

ADP: Look Ahead to December 2007 Results

When we analyzed ADP (ADP) after the third quarter of the calendar year (first quarter of ADP's fiscal year), we found that the company had achieved its highest Overall Gauge score, 43 out of 100 possible points, since December 2003. However, we noted that corporate restructuring activities, such as the Broadridge spin-off, could have skewed the calculations by degrading the comparability of ADP's recent and historical financial performance.

Quarter-to-quarter and year-to-year comparisons of key metrics greatly influences our gauge scores.

With each new set of quarterly results, we get a chance to see whether recent blips in particular metrics were due to one-time factors or whether they indicate sustained trends in, for example, Growth and Profitability. Given some significant changes at ADP, we're anxiously awaiting the company's results for the waning December quarter.

Also, since ADP invests billions of dollars in client funds in high-quality debt securities, we'll be looking to see if the credit market's problems have seeped into ADP's triple-A world.

ADP's third-quarter report included some helpful guidance for fiscal 2008. The guidance indicated that the company anticipates full year revenue growth between 12 and 13 percent. Therefore, it seems reasonable to expect Revenue in the December quarter of about $2.1 billion. This figure would translate into year-over-year Revenue growth of 12.8 percent, while only being 11.0 percent more than Revenue in the December 2006 quarter.

We don't have explicit guidance for Gross Margin, only hints that margins are improving. Using recent history as guide, we'll look for a Gross Margin of 57 percent in the December quarter. Therefore, we're anticipating Cost of Goods Sold (CGS) -- what ADP calls Operating Expenses -- of 0.43 * $2.1 billion = $903 million.

Depreciation expenses are normally about 3 percent of Revenue. This should work out to be about $63 million in December quarter.

Our estimate for Research and Development (R&D) expenses ("Systems Development and Programming Costs") is 6.5 percent of Revenue. This would equate to $137 million

Sales, General, and Administrative (SG&A) expenses are volatile, but the ratio recently came down to 27 percent of Revenue. For the subject quarter, the estimate would be 0.27 * $2.1 billion = $567 million.

Rolling up the figures identified above, we come up with an estimate for Operating Income in the quarter of $431 million.

For net non-operating income (i.e., other income less interest expense), $15 million would seem to be a reasonable estimate based on recent data.

If the Income Tax Rate is 37.0 percent, Net Income from continuing operations will be $281 million ($0.52 per share).


($ M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue (1)

2100
1893
Operating
expenses




CGS (2) (903)
(827)

Depreciation (3)
(63)
(51)

R&D (4) (137)
(119)

SG&A (567)
(520)

Other
0
(0)
Operating
Income

431
375
Other income




Investments
0
0

Interest, etc.
15
28
Pretax income

446
403
Income tax

(165)
(150)
Net Income
281
253


$0.52/sh
0.46/sh
1. Total revenues includes interest on funds held for clients and Professional Employer Organization revenues.
2. Operating expenses
3. Depreciation and amortization.
4. System development and programming

24 December 2007

KG: Look Ahead to December 2007 Results

Our last evaluation of King Pharmaceuticals (KG) occurred not long after the decision by the U.S. Court of Appeals on 11 September 2007 to invalidate King's patent for Altace®. (The Court, in December, denied the company's petition for a rehearing.) Altace® is an ACE inhibitor used to treat patients with cardiovascular risks. It had accounted for about 1/3 of King's net sales. As a result of the court's decision, King's third quarter financial statements included asset impairment charges (covering intangible assets and inventory) totaling $250 million. It also led King to accelerate a shift in the company's marketing focus and to layoff 20 percent of staff.

King stock, which had been declining before the ruling, fell further when the news became public. King shares now sell for less than 1/2 of their 52-week high and less than 1/4 of the all-time high.

The drop in the stock price to reflect the loss of expected future profits threw our evaluation methodology out of whack. Our Overall Gauge score for King perversely soared because it compared the diminished stock price to previous earnings and cash flow and saw a bargain. Clearly, however, King Pharmaceuticals' future earnings and cash flow will be much less without Altace® exclusivity.

Given the uncertainties, we're going to have to rely heavily on guidance from King to look ahead to the fourth-quarter results. Fortunately, the conference call with analysts after the third quarter included much useful guidance for the fourth quarter. Unfortunately, top-line Revenue guidance wasn't provided.

King's year-over-year Revenue growth rate has recently been fluctuating between 7 and 12 percent, which is a much slower pace than the company once enjoyed. Considering that it will probably take some time for competitors to take a serious bite out of Altace® sales, but also that the sales force might have lost some motivation, we'll assume Revenue in the fourth quarter will grow at a rate not less than the bottom of the recent range. Fourth-quarter Revenue of $524 million would translate into a 7 percent year-over-year growth rate.

King announced that it anticipates a Gross Margin of approximately 76 percent in the fourth quarter. High margins such as this, or even better, are not unusual for specialty drug manufacturers. This margin would result in a Cost of Goods Sold (CGS) of 24 percent of $524 million, or $126 million.

After shortening the predicted life of intangible assets associated with Altace®, King stated at the conference call that they now expect Depreciation and Amortization expense in the fourth quarter to be approximately $40 million.

The company indicated that its full year 2007 Research and Development (R&D) investment will be in line with last year. Given that R&D was $143.6 million in 2006, and $104.5 million in the first nine months of 2007, it's not hard to figure out that fourth quarter R&D should be about $39.1 million.

King gave guidance for Sales, General, and Administrative (SG&A) expenses in 2008 but not for the fourth quarter of 2007. Historical results would suggest that 33 percent of Revenue is good estimate for SG&A expenses. This would be $173 million if our Revenue estimate stands up.

King often takes special operating charges that determine the quarter's success. The charges range, in no particular pattern, between negligible and huge. We're going to assume, rather arbitrarily, a $50 million charge in the fourth quarter.

Our estimates would lead to Operating Income of $96 million.

Non-operating income has recently been about $7 million per quarter. If the Income Tax Rate (another fluctuating parameter) is 31 percent, Net Income would be $71 million.


($ M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue

524
513
Op expenses




CGS (126)
(114)

Depreciation
(40)
(37)

R&D (39)
(41)

SG&A (173) (232)

Other
(50)
(48)
Operating Income
96
42
Other income




Investments
0
0

Interest, etc.
7
7
Pretax income

103
49
Income tax

(32)
(12)
Net Income
71
37


0.29/sh
0.15/sh




23 December 2007

WPI: Look Ahead to December 2007 Results

When we analyzed Watson Pharmaceuticals (WPI) after the third-quarter results became available, we noted continued progress consolidating last year's Andrx Corp. acquisition. We expressed some concern that evidence of operational efficiency improvements was becoming harder to find. We were also troubled that Finished Goods/Inventory moved up to 67.1 percent (believed to be a record high for Watson), from 65.5 percent in June, and 52.3 percent in September 2006 (pre-Andrx).

A good fourth quarter could ameliorate our concerns.

Watson included guidance for the full year in their third-quarter report. With this guidance, it's not hard to model the Income Statement for the fourth quarter. The company's top- and bottom-line expectations for the quarter are clear. This is also true for some in-between figures. Where specific guidance wasn't provided for lines on the Income Statement, we tried to fill the gaps with historically grounded estimates.

The recent guidance began with a $2.5 billion estimate for total net Revenue for the full year of 2007. Since Sales in the first three quarters were $1.87 billion, the company must be expecting Revenue of $630 million in the December quarter. Back in February, Watson estimated that Revenue for 2007 would be between $2.5 and $2.6 billion. They subsequently zeroed in on the lower figure.

Watson's Gross Margin has been declining as a percentage of Revenue -- probably a result of more generics in the product mix -- but this ratio rebounded a few points in the last two quarters. If we assume the Gross Margin in the fourth quarter will match the third quarter's 42 percent of Revenue, our estimate for the Cost of Goods Sold (CGS) is 58 percent of $630 million, which equals $366 million.

Depreciation expenses have been running at about 7 percent of Revenue. For the fourth quarter, this would be about $44 million.

Watson forecast Research and Development (R&D) expenses for 2007 at approximately six percent of Revenue. This equates to $150 million over the year. Since R&D expenses in the first three quarters totaled $109 million, the estimate for the fourth quarter is $41 million.

Similarly, Watson approximated the year's Sales, General, and Administrative (SG&A) expenses at 17 percent of annual Revenue, which would be about $425 million. Since SG&A costs in the first nine months of the year were $313 million, these costs should be $112 million in the fourth quarter.

These estimates would result in an Operating Income of $67 million.

Watson's non-operating income and expenses are typically minor. Lacking specific guidance, we'll assume a $7 million net expense. This would lead to Income before Income Taxes of $60 million.

With a 37 percent Income Tax Rate, Net Income will be $38 million ($0.33/share) for the quarter and $141 million ($1.20/share) for the year. This is consistent with Watson's guidance for Earnings per Share in 2007 between $1.30 and $1.33. The difference in the figures is a consequence of the company excluding from their estimate approximately $19 million ($12 million net of tax, or $0.10 per diluted share) of acquisition, litigation and impairment charges and certain other gains and losses.

Note that the quarter-to-quarter comparison below is skewed by the $500 million charge in the fourth quarter of 2006 for in-process R&D associated with the Andrx acquisition.


($ M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue

630
621
Op expenses




CGS (366)
(410)

Depreciation
(44)
(42)

R&D (41)
(41)

SG&A (112) (102)

Other
0
(501)
Operating Income
67
(476)
Other income




Investments
0
0

Interest, etc.
(7)
(6)
Pretax income

60
(481)
Income tax

22
(8)
Net Income
38
(489)


$0.33/sh
(4.80)/sh




16 December 2007

COP: Look Ahead to December 2007 Results

One might assume that soaring crude oil prices equates to windfall profits for energy behemoth ConocoPhillips (COP), which will announce its fourth-quarter earnings on 23 January 2008. In support for this assumption, one could note that Conoco shares have held up fairly well in a volatile market. Although below the $90 high established in July, the share price is up almost 16 percent year to date.

Conoco actually faces several significant challenges. Lower natural gas prices, compressed refining margins, and loss of its Venezuelan operations have all put pressure on Conoco's earnings. As a result, Conoco shares have lagged behind those of other major integrated oil companies.

Our analysis of Conoco after the September quarter produced an Overall Gauge score of 24 points, with the double-weighted Value Gauge contributing zero points to the total. One reason Conoco shares appear overvalued relative to historic norms is the termination of operations in Venezuela. About 9 percent of Conoco's crude-oil production in the September 2006 quarter came from Venezuela. However, we concluded that Venezuela was not the sole explanation for Conoco's low score. The refining margin, the price of natural gas, and operational efficiency all need to improve to impel the gauges upward.

Given its sensitivity to external factors, we struggle each quarter to model Conoco's next earnings report. The difficulty begins with the top line. We haven't found quarterly Revenue guidance provided by the company itself, and estimates of current Revenue based on previous growth rates hasn't been particularly accurate recently. The Yahoo Finance page includes a $74.7 billion Revenue estimate, but that figure was submitted by a single anonymous analyst. By comparison, 16 analysts submitted Earnings per Share estimates.

We have to dismiss the $74.7 billion Revenue estimate as unrealistic, since quarterly sales have been between $40 and $50 billion for the last few years. We're going to set a more modest $48 billion target, admittedly without much conviction, for fourth-quarter revenues. This figure is 4.2 percent greater that sales in the third quarter, and 16 percent greater than the very weak revenue figure of the December 2006 quarter.

Conoco's Gross Margin has edged up over the last couple of years from about 25 percent of revenue to about 30 percent, although it was a couple of points less in the third quarter. We'll set the gross-margin target in the fourth quarter at 29 percent. In other words, we're guessing the Cost of Goods Sold will be 71 percent of $48 billion or $34.1 billion.

We'll also assume, based on historic data, a Depreciation expense of 4.5 percent of revenue, or $2.2 billion. Similarly, we'll estimate SG&A expenses at 12 percent of revenue, or $5.8 billion given our revenue estimate. We will also add $250 million for exploration expense and $200 million for non-recurring operating charges.

These figures would result in an Operating Income just under $5.6 billion.

We then need to consider non-operating income and expenses, such as equity in the earnings of affiliates, minority interests, and interest. The net figure for these income and expense items has been trending up, and we will set our expectation at $1.2 billion. This pushes our estimate of pre-tax income to $6.8 billion

Conoco's effective income tax rate generally seems to be between 40 and 45 percent, so we will split the difference. If the rate is 42.5 percent in the fourth quarter, the tax bill would be $2.9 billion.

Our estimate for Net Income is, therefore, $3.9 billion ($2.35 per share).


($M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue
48000
41519
Op expenses




CGS (34080)
(28039)

Depreciation (2160)
(2002)

Exploration (250)
(391)

SG&A (5760)
(5176)

Other
(200)
(420)
Operating Income
5550
5221
Other income




Equity income
1100
852

Interest, etc.
100
(156)
Pretax income

6750
5917
Income tax

(2869) (2720)
Net Income
3881
3197


2.35/sh
1.91/sh




15 December 2007

Happy Birthday Ted Oglove

footnoted.org, which should be a regular stop for all GCFR readers, is celebrating the 75th birthday of Thornton “Ted” Oglove.

Ted started the "Quality of Earnings Report" newsletter and wrote the book "Quality of Earnings." The book is often cited, such as this recent reference from Motley Fool.

Our copy of the book is working its way through Amazon.com's efficient distribution system.

TDW: Look Ahead to December 2007 Results

It has been a roller coaster year for Tidewater shareholders. The price per share increased linearly from $45 in early January to $80 in July, before returning to its starting point, or nearly so, with the stomach-turning plunges familiar to amusement park patrons.

The drop for this owner of "the world's largest fleet of vessels serving the global offshore energy industry" occurred despite crude oil prices rising to historic levels.

When we analyzed the company's September quarter results, after the first stock price nosedive, we found that our Overall Gauge for Tidewater had declined from lofty levels to a modest 35 out of 100 possible points. We attributed the weaker score to slowing growth and higher costs.

The Overall gauge score peaked in late 2006, anticipating the stock price's rise and its subsequent fall. Revenue started to surge at Tidewater in late 2004, after a couple years of flat (or declining) performance. The maximum growth rate was seen in June 2006, when quarterly revenues were 40 percent greater than the year-earlier period. Year-over-year revenue growth peaked soon thereafter at 34 percent.


By comparison, year-over-year revenue growth through September 2007 was down to 18 percent.

Tidewater's revenue is dependent on the number of vessels they own, the average vessel utilization, and lease charges (typically expressed in dollars per day). The utilization rate has been the weakest of the three components recently. Based on extrapolations, our forecast for Revenue in the December 2007 quarter is $326 million, which is 13 percent greater than Revenue in December 2006. If achieved, year-over-year Revenue growth would be 15 percent.

Tidewater's Gross Margin increased from about 35 percent of revenue in 2004 to almost 55 percent at the end of 2006. It fell back to 49 percent in the September quarter. One factor that increased costs (and reduced Revenues) was "regulatory drydocking." (With Tidewater deploying larger vessels, maintenance activities are making quarterly results more erratic.) Tidewater has already indicated that vessel operating costs in the December quarter will increase as new vessels are added to the fleet and other vessels undergo maintenance. We will look for the Gross Margin in the December quarter to remain at 49 percent. Given our revenue estimate, we're looking for a Cost of Goods Sold (i.e., vessel operating costs plus costs of other marine revenues) of 0.51* $326 million = $166 million.

Depreciation has been about 10 percent of revenue in recent quarters. This would equate to 0.1 * $326 million = $33 million for December. Similarly, if trends continue, SG&A expense should also be about 10 percent of revenue, or another $33 million.

As a result, operating income of $95 million seems attainable. If we guess an additional $10 million in income from asset sales and interest, and a 19 percent income tax rate, our estimate for net income become $85 million ($1.53 per share). This is below for the $93 million earned in the December 2006 quarter. However, with a net income of $6.20 per share over the four quarters, the Price/Earnings ratio would be mere 8.7 using Friday's closing stock price.

($M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue
326
288
Op expenses




CGS (166)
(131)

Depreciation (33)
(30)

SG&A (33)
(25)
Operating Income
95
103
Other income




Asset sales
3
9

Interest, etc.
7
4
Pretax income

105
115
Income tax

(20)
(22)
Net Income
85
93


1.53/sh
1.67/sh




11 December 2007

PEP: Look Ahead to December 2007 Results

PepsiCo (PEP) shares, as shown here, have repeatedly established new 52-week highs. With the dollar weak, PepsiCo's significant overseas operations are attractive. Also, with uncertain economic growth, investors are drawn to defensive, non-cyclical industries, such as food and beverages.

Our assessment of PepsiCo after the third quarter was generally positive. Revenue was higher than we forecast, and PepsiCo did a good job controlling expenses in spite of increases in raw material costs. As a result, Operating Income was 14 percent above the predicted value, and Net Income exceeded our forecast by 19 percent. The latter result was aided by a $115 million favorable resolution of foreign tax matters.

The Overall gauge score of 39 in September might seem weak, but that is misleading. The gauge for PepsiCo is now just a few points below the top of its historic range. For whatever reason, the score for PepsiCo never gets very high. Nevertheless, the Overall score correlates fairly well with future increases in PepsiCo's stock price. With 28 quarters of data, the correlation coefficient between the score and one-year price growth is 62 percent.

As usual, prior to the release of another quarter's earnings, we find ourselves wondering if the good times at PepsiCo will continue. By most accounts, they are one of the better managed companies in the country. What is reasonable to expect?

In February, PepsiCo provided guidance for 2007 indicating "the Company expects mid-single-digit volume and net revenue growth, with revenue growth outpacing volume growth." With this in mind, we're looking for fourth-quarter revenues of $10.95 billion. This figure would equate to 9.3 percent year-over-year revenue growth and a 5.5 percent increase over the December 2006 quarter.

The gross margin for PepsiCo always seems to be about 55 percent of revenue, so we're comfortable estimating the Cost of Goods Sold at 0.45 * $10.95 billion = $4.93 billion. Similarly, SG&A expenses have recently been around 35 percent of revenue, but tend to be several points higher in the fourth quarter. Our assumption for these costs in the fourth quarter is 0.39 * $10.95 billion = $4.27 billion. We'll also assume a $60 million charge for amortization of intangible assets and restructuring charges. (The company issued guidance to expect restructuring charges of about $0.03 per share in the fourth quarter.)

Bottler equity income is both significant and erratic. It tends to be relatively weak in the December quarter. Since bottler equity income was $218 million in the September quarter, we think it is reasonable to expect an income of $140 million in the fourth quarter.

A $25 million charge for net interest expenses seems reasonable given recent history.

The income tax rate presents another complication. The company indicated that tax rate volatility will continue, but they are assuming that the average for year will be no more 27.7 percent. We've used this full-year estimate for the fourth quarter.

Rolling up these estimates, we're looking for net income of $1.31 billion ($0.79) for the quarter. The quarter appears weaker than the year-earlier period because the latter benefited from an unusually low tax rate.

($M)

Dec 2007
(predicted)
Dec 2006
(actual)
Revenue
10951
10383
Op expenses




CGS (4928)
(4744)

SG&A (4271) (4072)

Amortization,
etc.
(60)
(54)
Operating Income
1692
1513
Other income




Equity income
140
131

Interest, etc.
(25)
(4)
Pretax income

1807
1640
Income tax

(501)
(144)
Net Income
1307
1784


0.79/sh
$1.06/sh