31 January 2009

Service Company Analysis (and Web Site Load Times)

We received a question from a reader:

How can I apply the gauges described here for a pure service company or an IT (non product) company - let's say Infosys or (in)famous Satyam.

With service companies, "Inventory" is not the meaningful parameter it is for manufacturers, and this reduces the information available to the Cash Management gauge.  By adjusting the weights of the metrics on which this gauge depends, we can still produce a Cash Management score.  However, the gauge is somewhat less insightful.

The other gauges apply equally to manufacturers and service companies.  No adjustments are necessary.

Compared to manufacturers, service companies tend to have a greater ratio of intangible assets to total assets.  Much of the assets are the skills of the people, the company's processes, and its relationships with customers.  If the company runs into trouble, these are harder to monetize than a factory full of equipment or a warehouse stuffed with inventory.

Brand-name pharmaceutical firms are similar in this respect.  They depend on smart researchers and valuable patents.  The researchers can leave for competitors and the patents expire or can be challenged in court.

We don't presently distinguish between tangible and intangible assets in computing a gauge scores, but we will investigate how we might do so.  Any suggestions?

-----

The same reader commented that the embedded spreadsheets, while useful, slow down the loading of the web site.  Thanks for the feedback -- this concerns us greatly.  We suspect the greater culprit are the embedded charts showing share prices over time.  The spreadsheets, hosted at zoho.com, seem more speedy.  We will cut out the price charts for the time being.  Please let us know if this makes a difference or if you believe the spreadsheets are in fact the problem. 

COP: Financial Analysis through December 2008

ConocoPhillips (NYSE: COP), a global energy behemoth, recently announced its results for the fourth quarter of 2008.  This post provides the GCFR analysis of the financial statements.

The operating results were overshadowed by almost $35 billion of asset impairment and other charges.  The write-downs were due to the "substantial decline in global equity markets, commodity prices, and margins."

On 30 September 2008, ConocoPhillips had total assets of $184.6 billion.  Therefore, the company erased about 19 percent of its assets.

The earnings announcement included Income and Cash Flow statements, and a plethora of data for each business segment, but it did not include a current Balance Sheet.  We would normally, to compute preliminary gauge scores, assume that the Balance Sheet didn't change materially in the last three months; however, the huge impairment charges are certainly material changes.  Instead, we decremented ConocoPhillips' assets and retained earnings by the impairment amounts.  This produces a rough approximation, at best, for the Balance Sheet as of 31 December 2008.  Our assumption is that the approximation is close enough for ratio analysis.

When ConocoPhillips files a 10-K, we will recalculate the gauge scores using the actual Balance Sheet data.


ConocoPhillips is the seventh-largest Major Integrated Oil & Gas company by market capitalization.  Holding the fifth spot on the Fortune 500 list, Conoco's heft was achieved with mergers and acquisitions.  Most notably, Conoco, Inc., and Phillips Petroleum combined in August 2002.  In March 2006, ConocoPhillips purchased Burlington Resources, which had extensive natural gas operations in North America, for $33.9 billion.

Berkshire Hathaway, Inc. (NYSE: BRK.A), run by super-investor Warren Buffett, and its affiliates owned about 84 million shares of ConocoPhillips on 30 September 2008.  The company's stake increased from 17.5 million shares on 31 March 2008. 

ConocoPhillips owned 20 percent of LUKOIL (OTC: LUKOY), which is responsible for more than 18 percent of Russia's oil production, on 30 September 2008.  LUKOIL's shrinking market value was responsible for $7.4 billion of the fourth quarter's impairment charges.


Three months ago, the GCFR Overall Gauge of ConocoPhillips rose to 52 of the 100 possible points -- not a bad score.  Our analysis report explained this result in some detail.


Now, with the actual and estimated data for the fourth quarter, our gauges display the following scores:

  • Overall: 43 of 100 (down from 52)

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 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.


http://sheet.zoho.com/public/ncarvin/template-income-statement-1?mode=html






Revenue in the fourth quarter was 15.5 percent less than in the year-earlier period.  We had expected Revenue drop 16.5 percent.  We're thrilled that our estimate was only off by 1.1 percent. 

Conoco's Revenue in all of 2008 was greater than that in 2007 by 28 percent.  High energy prices earlier in the year was the principal reason for the Revenue surge.

The Cost of Goods Sold [i.e., purchased crude oil, natural gas and products + Production and operating expenses] was 74.1 percent of Revenue in the fourth quarter, which equates to a Gross Margin of 25.9 percent.  Our forecast for the margin had been a sliver higher at 26 percent, so this was another good projection. 

In the December 2007 quarter, the Gross Margin was 27.8 percent.

Depreciation expenses were 5.1 percent of Revenue.  We had predicted 4.5 percent.  The asset write-downs might have led to accelerated depreciation.

Exploration costs were $73 million more than the $400 million we had assumed based on the company's guidance.  The reason for the discrepancy isn't yet clear.

Sales, General, and Administrative (SG&A) expenses, which in our categorization is dominated by non-income taxes, were 10.4 percent of Revenue, which compares favorably to our 11 percent estimate. 

Alas, all our good work to estimate Operating results were nullified by the billions of goodwill impairments and other non-recurring operating costs.

Operating Income, therefore, was a monumental loss.  However, if the relevant impairment charges are ignored, Operating Income is $3.95 billion.  This figure is only 1.8 percent less than our $4.02 billion estimate.

The set of non-operating gains and losses is dominated by the write-down of the LUKOIL investment.

The official bottom-line for the quarter is a Net Loss of $31.8 billion (minus $21.37 per share).  Again, if impairment charges are ignored, Net Income is $2.7 billion ($1.81 per share).  Our estimate for Net Income had been $2.95 billion ($1.97 per share).


Cash ManagementDecember
2008
3 months
ago
12 months
ago
Current Ratio1.0
1.00.9
LTD/Equity
36.9%
23.4%22.8%
Debt/CFO
1.0 yrs
0.8 yrs
0.9 yrs
Inventory/CGS
N/A
 N/A N/A
Finished Goods/Inventory
N/A
 N/A N/A
Days of Sales Outstanding (DSO)25.3 days
22.5 days
29.7 days
Working Capital/Market Capitalization  -1.2%
-0.9%
-1.3%
Cash Conversion Cycle Time-0.6 days
-0.2 days
-2.1 days
Gauge Score (0 to 25)
13
15
10

The Cash Management metrics are likely to change when an up-to-date Balance Sheet is published.  The big increase in Long-term Debt to Equity is indicating a surge in the debt; it's a consequence of the the impairment charges taking a huge bite out of Shareholders' Equity.


GrowthDecember
2008
3 months
ago
12 months
ago
Revenue growth28.5%
41.3%
2.1%
Revenue/Assets 147%
139%
109%
CFO growth
-7.7%
13.7%
14.1%
Net Income growth N/A
78.6%
-23.5%
Gauge Score (0 to 25)13
23
3
Growth rates are trailing four quarters compared to four previous quarters.

The steep rise in energy prices, now dramatically reversed, powered sharp Revenue growth most of the year.  Revenue/Assets rose because the impairment charges cut deeply into Assets.

Net Income growth is N/A because the company recorded a huge loss in 2008.


ProfitabilityDecember
2008
3 months
ago
12 months
ago
Operating Expenses/Revenue 100.2%
88.5%90.6%
ROIC N/A
14.1%8.2%
FCF/Equity
4.8%
13.4%14.9%
Accrual Ratio
-14.6%
3.4%-2.3%
Gauge Score (0 to 25)8
7
12

The Profitability figures are thrown into disarray by the large fourth-quarter impairment and other charges.  It's ironic that non-cash charges make the company's earnings appear to be of higher quality, as indicated by the much lower Accrual Ratio.


ValueDecember
2008
3 months
ago
12 months
ago
P/E N/A
5.8
12.0
P/E to S&P 500 average P/E N/A
33%67%
Price/Revenue 0.3
0.4
0.8
Enterprise Value/Cash Flow (EV/CFO)
4.3
5.06.6
Gauge Score (0 to 25)11
14
0

Conoco shares fell 29 percent during the fourth quarter, $73.25 to $51.80.  During 2008, the price per share dropped 41 percent.  The price has been trimmed a little more in early 2009, but, in keeping with the normal GCFR practice, we used the quarter-end share price to compute the Value gauge score. 

If the impairment charges are excluded, Conoco's P/E ratio is about 4 on a trailing-twelve-months basis.

Conoco's valuation ratios can be compared with other companies in the Major Integrated Oil and Gas industry.


OverallDecember
2008
3 months
ago
12 months
ago
Gauge Score (0 to 100)43
52
24


The fourth-quarter of 2008 will be remembered at ConocoPhillips as the one during which the historic decline in energy prices led the company to mark down the value of its intangible assets and investments by approximately $35 billion (about 19 percent of total assets.)  Discontinuities of this magnitude make year-to-year and quarter-to-quarter comparisons difficult.  However, when the analytical challenge is more difficult, an analyst discover opportunities hidden to investors that rely solely on bottom-line figures.

30 January 2009

COP: 2008-4Q Earnings

ConocoPhillips (NYSE: COP) recently announced its results for the fourth quarter of 2008. The results included impairment charges that added up to $34.5 billion. The last "b" is not a typo.

This huge expense complicates our analysis. It will probably take us another couple of days to update our gauges and report on the results.

In the mean time, we offer a spreadsheet comparing the actual results (with and without the impairment charges) with our previously announced expectations. The Revenue level we forecasted turned out to be a good estimate.

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.

http://sheet.zoho.com/public/ncarvin/template-income-statement-1?mode=html

29 January 2009

TDW: Financial Analysis through December 2008

Tidewater Inc. (NYSE: TDW) has announced better-than-expected earnings and filed a 10-Q for the quarter that ended on 31 December 2008.  This post provides the initial GCFR analysis of the period, which was the third quarter of the company's fiscal 2009.

Tidewater "owns 431 vessels, the world’s largest fleet of vessels serving the global offshore energy industry."  Headquartered in New Orleans, the company has grown far beyond its Gulf of Mexico base.  International operations contributed 84 percent of Tidewater's Revenue in fiscal 2008.  To continue this growth, Tidewater is substantially expanding and modernizing its fleet with annual investments between $300 million and $500 million.

As of 31 December 2008, Tidewater is obligated to purchase 56 new vessels at a total cost of about $1.1 billion.  Delivery of these vessels will take place between now and July 2012.

Despite large capital expenditures, Tidewater management was optimistic enough in May 2008 about cash flows to raise the dividend by 67 percent.  In addition, the company's board authorized $200 million of share repurchases.  However, the 10-Q reports that none of $200 million has, as yet, been spent.  Tidewater is holding onto cash "[d]ue to the distress in the capital and liquidity markets" and to "maximize available liquidity for all investment opportunities."

The global economic slump has greatly reduced demand and, therefore, prices for crude oil and natural gas.  Lower prices should, in time, lead to less offshore production and, therefore, diminish the need for maritime support services. 

Tidewater has reported, for example, that the number of offshore drilling rigs in the Gulf of Mexico is at historically low levels.

A greater number of out-of-service vessels, and reduced lease rates for those that remain in service, would presumably lower the market value of Tidewater's fleet.   Tidewater has had significant success moving vessels to more active locations.

David Phillips (a/k/a the 10-Q Detective, which we highly recommend) has asked whether Tidewater would be able to find alternative funding sources to meet its capital commitments if Cash Flow from Operations falls short of the company's expectations.





The GCFR Overall Gauge of Tidewater stood at 34 of the 100 possible points after the September 2008 quarter.  Our analysis report explained this result in some detail.  The increase in the Overall score was mostly due to the Value gauge moving up as Tidewater's share price fell. 


Now, with the available data from the December 2008 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 communicated expectations

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.


http://sheet.zoho.com/public/ncarvin/tdw-income-statement?mode=html





Revenue in the quarter was 15.3 percent greater than in the year-earlier period, whereas we had estimated that Revenue would grow by 9 percent.  In the last four quarters, Tidewater brought in 12 percent more Revenue than during the prior four quarters.

Tidewater's Cost of Goods Sold (CGS) (i.e., Vessel operating costs and Costs of other marine revenues) was 47.7 percent of Revenue.  Therefore, the company achieved a Gross Margin in the quarter of 52.3 percent, which was significantly better than our 47.2 percent estimate.

Depreciation expenses were 8.9 percent of Revenue, which basically matches our 9.0 percent estimate.

Sales, General, and Administrative (SG&A) expenses were 8.7 percent of Revenue, rather less than our prediction of 10.0 percent.

Operating Income, as we define it, was 24 percent more than in the year-earlier quarter.  It surpassed our estimate by 31 percent.  We expected Operating Income to decline by 4.9 percent.

Income from Asset Sales matched our $5 million estimate, which was based on an average of recent quarters.  Miscellaneous non-operating income was $3.8 million more than we forecast. 

The effective Income Tax Rate in the quarter was 16.1 percent, which was below the 18 percent guidance. 

Net Income was 31 percent more than in the December 2007 quarter, and it was 34 percent more than our prediction.  We had expected a decrease of 2.2 percent.  On a per-share basis, earnings rose by 37 percent.  The reduced number of shares outstanding magnified the earnings per share growth rate.  Our EPS projection matched the actual figure.


Cash ManagementDecember
2008
3 months
ago
12 months
ago
Current Ratio3.0
2.82.7
LTD/Equity
14.0%
14.7%16.1%
Debt/CFO
0.6 yrs
0.6 yrs
0.7 yrs
Inventory/CGS
N/A
N/AN/A
Finished Goods/Inventory
N/A
N/AN/A
Days of Sales Outstanding (DSO)86.2 days
86.8 days
87.3 days
Working Capital/Market Capitalization  16.7%
11.1%
11.6%
Cash Conversion Cycle Time (CCCT)
69.6 days
71.7 days
56.5 days
Gauge score (0 to 25 points)
16
8
8

Tidewater's Balance Sheet is solid and becoming more so. 


GrowthDecember
2008
3 months
ago
12 months
ago
Revenue growth12.0%
10.5%
14.3%
Revenue/Assets 48.6%
47.5%
47.0%
CFO growth
10.9%
6.2%
1.9%
Net Income growth 9.0%
0.0%
5.2%
Gauge score (0 to 25 points)10
3
7
Growth rates are trailing four quarters compared to four previous quarters.

Revenue growth bounced back and both Cash Flow from Operations and Net Income grew at accelerating paces.


ProfitabilityDecember
2008
3 months
ago
12 months
ago
Operating Expenses/Revenue 70.0%
70.8%68.0%
ROIC 15.2%14.6%16.2%
FCF/Equity
3.7%3.5%5.6%
Accrual Ratio
8.7%8.4%6.7%
Gauge score (0 to 25 points)2
2
4

The increase in Operating Expenses is a significant challenge for Tidewater.  Crew and repair/maintenance costs are up substantially.  In addition, Free Cash Flow is negatively affected by the high capital expenditures associated with the fleet expansion and modernization.  We're also concerned that the increasing Accrual Ratio is indicating that less of the company's Net Income is due to CFO, and, therefore, more is due to changes in non-operational Balance Sheet accruals. 


ValueDecember
2008
3 months
ago
12 months
ago
P/E 5.4
8.0
8.4
P/E to S&P 500 average P/E 40%
45%47%
Price/Revenue 1.5
2.1
2.4
Enterprise Value/Cash Flow (EV/CFO)
4.3
6.56.7
Gauge score (0 to 25 points)23
15
17

Tidewater's stock price dropped 27 percent during the quarter, from $55.36 to $40.27.

The valuation ratios can be compared with other companies in the Shipping industry.
 

OverallDecember
2008
3 months
ago
12 months
ago
Gauge score (0 to 100 points)56
34
41


The jump in the Overall score is a result of an exceptionally strong fourth quarter of 2008 for Tidewater. Revenue growth surged, yet costs remained under controlled.  It turns out that many of the company’s operating costs do not change proportionally with changes in revenue. Therefore, increases in Revenue translate fairly directly into earnings and cash flow growth.

Despite significant capital spending, Tidewater's balance sheet is strong.

Tidewater's management has diversified the business into various international markets. (In fiscal 2009 to date, Revenues generated from international operations were 87 percent of total Revenues.) Management also deserves credit for in investing in the future by acquiring more modern, efficient vessels without harming the company's financial strength.  If the pace of the economy picks up, Tidewater will be ready.

28 January 2009

TDW: Fiscal 2009 Third Quarter Earnings

Tidewater Inc. (NYSE: TDW) has announced earnings for the quarter that ended on 31 December 2008.

The results substantially succeeded our expectations.  A full GCFR analysis will be posted in the next day or two, but our initial estimate is that our Overall Gauge rose from 34 to 56 points.

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.


http://sheet.zoho.com/public/ncarvin/tdw-income-statement?mode=html

27 January 2009

HD: New Charges in the Fourth Quarter of 2008

Home Depot, Inc., announced it will discontinue its EXPO Design Center business, putting 7000 jobs at risk.  The company also provided information regarding its results in the fourth quarter of fiscal 2008, which will end on 1 February 2009.

We used the figures in the announcement to revise our previously posted look-ahead earnings model for the quarter.


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 competes fiercely with Lowe's (NYSE: LOW) and a multitude of smaller hardware and lumber retailers.

The EXPO stores "offer products and services primarily related to design and renovation projects."


To account for store closure-related asset impairments, severance pay, and other related expenses, Home Depot indicated that it would recognize a pre-tax charge of $390 million in the fourth quarter.  Additional charges totaling $142 million are anticipated in future quarters.

Separate from the EXPO decision, Home Depot announced that it would record an after-tax $55 million charge "related to the working capital dispute" resulting from the sale of the HD Supply business in 2007.  And, there will be an additional $163 million pre-tax charge to reflect the reduced value of its investment in HD Supply.

Home Depot had invested $325 million for a 12.5 percent equity stake in HD Supply.  Home Depot has also guaranteed $1.0 billion of HD Supply debt.


With the three new charges added to our model, we now expect a Net Loss of $46 million (-$0.03/share).  We had previously expected Net Income of $360 million ($0.21/share) for the quarter.

Actual results for the quarter will be reported on 24 February 2009.


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.

http://sheet.zoho.com/public/ncarvin/hd-income-statement?mode=html


25 January 2009

Best 25 Financial Blogs

Time Magazine has published a list of the 25 best financial blogs.  Congratulations to the honorees, all of which are excellent.

We already read several of the top blogs daily, and many of the sites are probably familiar to frequent GCFR visitors.  Nevertheless, we suspect most readers will find several new items to add to the "favorites" list of their browser or RSS reader.

No, GCFR didn't make the cut, but we are anxiously waiting for a Top 2500 list to come out ;-)


We can report proudly that a few of the honored blogs link to GCFR.  Footnoted.org, which is on the new list, gave us encouragement when we were starting out.  We are very grateful for the guidance and kindnesses we've received from various financial bloggers.

24 January 2009

MSFT: Financial Analysis through December 2008

Microsoft Corp. (NASDAQ: MSFT) has announced earnings and filed a 10-Q report for the quarter that ended on 31 December 2008.  This post provides the initial GCFR analysis of the period, which was the second quarter of the company's fiscal 2009.

The earnings data was accompanied by a widely anticipated statement indicating that Microsoft will "eliminate up to 5,000 jobs ... over the next 18 months, including 1,400 jobs today."


A high-tech Goliath, Microsoft is best known for operating system and application software, but the company also sells video game consoles, music players, and computer peripherals

In recent years, Microsoft has increased its role in the online advertising business, in direct competition with Google Inc. (NASDAQ: GOOG).  Interest in this business resulted in Microsoft offering $40+ billion to acquire Yahoo! Inc. (NASDAQ: YHOO).  However, the bid was withdrawn when Yahoo's management resisted.  Since that decision, Carol Bartz replaced co-founder Jerry Yang as Yahoo CEO, and this has led to frequent speculation that talks between the two firms might heat up again.  A three-way deal involving the AOL subsidiary of Time Warner Inc. (NYSE: TWX) is also possible, although less likely.


Last September, Microsoft joined the elite ranks of non-financial entities with AAA bond ratings, which is the highest S&P grade.  After Microsoft's board authorized as much as $6 billion worth of debt, the company established a program allowing issuance of $2 billion of short-term commercial paper.  Microsoft also opened a $2 billion revolving credit facility.

Microsoft also initiated a new $40 billion share repurchase program, and the company increased its quarterly dividend by 18 percent.


MSFT common shares were not immune to the market meltdown in 2008.  The price per share dropped 46 percent during the calendar year.






Three months ago, the GCFR Overall gauge of Microsoft registered 57 of the 100 possible points -- down just 4 points.  Our full evaluation of the September 2008 quarter was explained in this analysis report.  The Growth and Profitability gauges weakened in this period, but the Value gauge remained a robust 18 of 25 possible points.  Net Income was 2.0 percent more than in the year-earlier quarter.


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

Before we examine each gauge, we will compare the latest Income Statement to our expectations, which were based on company guidance and our trend analysis.

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.


http://sheet.zoho.com/public/ncarvin/msft-income-statement?mode=html






Revenue in the December quarter was much less than the $17.3 to $17.8 billion guidance provided by the company when it reported September's results.  Revenue fell below the midpoint of the range, $17.55 billion, by 5.2 percent.  When compared to the year-earlier quarter, Revenue grew by a mere 1.6 percent.

Changes in currency exchange rates added $200 million to fourth quarter Revenue. 

A substantial deceleration of personal computer sales growth, coupled with a greater proportion of low-cost netbook PCs, led to decreased sales of Microsoft Windows. 


We expected Microsoft to attain a Gross Margin of 81 percent of Revenue in the quarter, and they fell far short of this target.  The actual value was 76.5 percent since the Cost of Goods Sold was 23.5 percent of Revenue.  In the year-earlier quarter, the margin was 78.4 percent of Revenue. 

While there are many components of CGS, Microsoft made a point of mentioning that costs for online "traffic acquisition" were higher.

Research and Development expenses were 13.8 percent of Revenue in the quarter, surprisingly less than our 14.5 percent estimate.

Sales, General, and Administrative expenses were 27 percent of Revenue, nicely less than our 30 percent estimate.  The increase in these expenses relative to the previous year was "primarily as a result of increased corporate marketing and advertising campaigns, headcount-related expenses, and bad debt expenses."

The lower than expected R&D and SG&A expenses were not enough to compensate for the disappointing Revenue and Gross Margin.  As a result, Operating Income was 7.3 percent less than the value we forecast.  Operating Income was below the bottom of the $6.1 billion to $6.4 billion range indicated in the company's guidance.

Investment and interest income, which had been reliable source of income for cash-laden Microsoft, flipped to a substantial expense in the fourth quarter.  The explanation is that the fourth quarter included a $400 million loss on derivatives and a $350 million loss on "foreign currency remeasurements."

Pre-Tax Income was below our $6.66 billion projection by 15.3 percent.

The Income Tax Rate of 26 percent was below the predicted 29 percent because a greater percentage of earnings were in lower-tax jurisdictions.  Net Income in the quarter missed our prediction by 11.7 percent, and it was also 11.3 percent less than last year's value.


Cash ManagementDecember
2008
3 mos.
ago
12 mos.
ago
Current Ratio1.6
1.5
1.7
LTD/Equity
0%
0%0%
Debt/CFO
 0.1 yrs
0.1 yrs
0.0 yrs
Inventory/CGS
25.9 days
43.7 days39.0 days
Finished Goods/Inventory
66.9%
72.0%57.9%
Days of Sales Outstanding (DSO)66.5 days
54.8 days
67.8 days
Working Capital/Market Capitalization  8.0%
5.2%
4.6%
Cash Conversion Cycle Time-13.2 days
0.6 days
-5.8 days
Gauge Score (0 to 25)
16
11
12

The last two measures above are the most noteworthy.  The increasing ratio of Working Capital to Market Capitalization hints of Microsoft's transformation from a growth stock to a value play.  Although the relevance of the CCCT when assessing Microsoft can be called into question because it depends, in part, on Inventory data -- the big downward jump (a good thing) shows that Microsoft's ability to manage its cash flow remains powerful.



GrowthDecember
2008
3 mos.
ago
12 mos.
ago
Revenue growth7.1%
14.1%
25.7%
Revenue/Assets 93.1%
94.4%
86.6%
CFO growth
-8.2%
-2.6%
58.7%
Net Income growth 1.6%
19.4%
42.4%
Gauge Score (0 to 25)10
17
25
Growth rates are trailing four quarters compared to four previous quarters.

Revenue, Cash Flow, and Net Income growth have all either slowed significantly or been eliminated.

Revenue/Assets, a metric to which we give substantial weight, remains much above historic levels.

The drop in Cash Flow for Operations would concern us greatly, except that the decrease was due to a $3.1 billion payment to the settle a tax audit from 2000-2003.



ProfitabilityDecember
2008
3 mos.
ago
12 mos.
ago
Operating Expenses/Revenue 64.5%
63.4%60.4%
ROIC 108%
115%120%
FCF/Equity
48.5%
47.6%55.3%
Accrual Ratio
+0.1%
+0.6%-5.1%
Gauge Score (0 to 25)10
10
19

While the rise in operating expenses shows that Microsoft is less profitable than it once was, the company's profitability is still significant when assessed by traditional return-on-investment metrics.


ValueDecember
2008
3 mos.
ago
12 mos.
ago
P/E 10.1
13.8
20.0
P/E to S&P 500 average P/E 75%
77%112%
Price/Revenue 2.8
4.0
5.8
Enterprise Value/Cash Flow (EV/CFO)
7.6
11.814.3
Gauge Score (0 to 25)24
18
6

Microsoft's stock price dropped all the way from $35.60 to $19.44 during 2008,  and the plunge has continued in January.  The Value gauge, based on the year-end price, is within one point of it maximum value.

Microsoft's valuation ratios can be compared with other companies in the Application Software industry.

Who would have ever imagined that these ratios for Microsoft would be as low as they are now.


OverallDecember
2008
3 mos.
ago
12 mos.
ago
Gauge Score (0 to 100)68
57
52


The rises in the double-weighted Value gauge and the Cash Management gauge pushed up the Overall score to a level that is normally very attractive.

Towards the end of 2008, sales of IT systems decelerated suddenly.  Fourth quarter Revenue and earnings projections made in October and November by hardware and software vendors alike proved, in most cases, to be wildly optimistic.  The earlier declines in equity prices, which were triggered by the financial industry's catastrophic missteps, and which might have seem unjustified for big, rich technology companies, now seem prescient.

After the steep drop in the price of Microsoft shares, the company's Market Value is about $153 billion.  During the last six troubling months, Microsoft's Cash Flow from Operations was $9.15 billion.  If this performance were to matched in the next six months, we could say that the present Price to Cash Flow ratio is about 8.4.  This is equivalent to a cash yield of about 12 percent.  Even if Cash Flow drops by, say, $1 billion to cover severance costs, the cash yield would still be an enticing 11 percent.