A great quarterly result from IBM ($IBM).  We decided to have a look at the latest numbers for $IBM and look at some comparator analysis.

Valuecruncher Interactive Analyst Report For $IBM

Valuecruncher’s interactive analyst report covers both comparator valuation analysis and a discounted cash flow (DCF) valuation for $IBM.

Starting with the comparator analysis:

• $IBM is compared to Microsoft ($MSFT), Oracle ($ORCL), Hewlett-Packard ($HPQ) and Accenture ($ACN).
• On an Enterprise Value (EV) /Revenue basis $IBM is valued less than half of $MSFT and $ORCL but nearly double $HPQ and $ACN. This is due to the relative profitability of those revenues - at the EBITDA line approximately 20% for $IBM versus 43-45% for $MSFT and $ORCL and 12-14% for $HPQ and $ACN.
• On an EV/EBITDA basis - the companies profits are being valued more closely. EBITDA is a measure of profitability - Earnings Before Interest, Taxes, Depreciation and Amortization.

Note: Enterprise Value is calculated as Market Capitalization plus Net Debt [Long-term Borrowings less Cash].

Our DCF valuation produces a value of US$108.42. This is just under 2% below the current share price of US$110.60.

Assumptions

• Revenue: Reuters aggregates 18 analysts covering $IBM and the mean estimates of 2009 and 2010 revenues are US$95.2 billion and US$97.3 billion respectively. For our analysis we have used US$95.0 billion in 2009, US$97.0 billion in 2010 and US$99.0 billion in 2011.
• Profitability: We have used an EBITDA margin of 22.5% in 2009 rising to 23.0% in 2010. Reuters has $IBM‘s EBITD margin at 20.8% last year and an average of 17.9% over the last five-years.
• Capital Expenditure: We have assumed capital expenditures of US$4.0 billion in 2009, US$4.5 billion in 2010 then US$5.0 billion per annum moving forward.
• Discount Rate: 10.5%.
• Terminal Growth Rate: 3.0%.

Our analysis incorporates the cash and debt on the $IBM balance sheet – Valuecruncher calculates a net debt number.

Both the comparator and DCF valuations are interactive. You can play with the assumptions and calculate your own valuations. Based on our analysis $IBM appears fairly valued.

Disclosure: None.

10 days ago we made the argument that the withdrawl of the IBM ($IBM) acquistion offer for Sun ($JAVA) was a problem for $JAVA shareholders. The heading for the post was “Sun ($JAVA) needs IBM ($IBM)“.  The basis of our analysis was that the IBM acquisition offer looked much better than Sun as a standalone business.

It looks like we were half right - the important half.  Today Oracle ($ORCL) announced the acquisition of Sun ($JAVA) at US$9.50 a share - just above the revised $IBM offer of US$9.40 a share.  Sun did not need IBM because of Oracle.  The logic of being acquired in the board price range was still compelling.

$JAVA has found an acquirer and this still looks a higher value option for $JAVA shareholders than remaining an independent company.  This is a good result for $JAVA shareholders.

Disclosure: None

Last weekend IBM ($IBM) withdrew their acquisition offer for Sun Microsystems ($JAVA).  Pre-offer $JAVA had not traded over US$6.00 since October last year.  The original $IBM offer was at US$9.55 (subsequently dropped to US$9.40).  With this offer $IBM was valuing $JAVA not as a standalone business - but as part of a combined entity.  The premium to the pre-offer share price represented the synergies $IBM believed they could achieve with the acquisition (additional revenues opportunities - but more likely expense savings).  These synergies are what allowed $IBM to make the offer they did.  Upon announcement of the offer the $JAVA shares traded as high as US$9.27.  With the withdrawal of the offer the shares fell back to close at $6.56 on 6 April - now US$6.68.  So what does a valuation of $JAVA as a standalone business look like? This is the way to examine $JAVA - to compare with a US$9.40 offer from $IBM.

Valuecruncher Interactive Analyst Report For $JAVA - New Format

Valuecruncher produces a valuation of US$6.44 for $JAVA. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 3.6% below the current share price of US$6.68.  It is 31.5% below the US$9.40 $IBM offer.

Assumptions

• Revenue: Reuters aggregates 15 analysts covering $JAVA and the mean estimates of 2009 and 2010 revenues are US$12.4 billion and US$12.2 billion respectively. For our analysis we have used US$12.4 billion in 2009, US$12.2 billion in 2010 and US$12.0 billion in 2011.
• Profitability: We have used an EBITDA margin of 4.5% in 2009 rising to 5.5% in 2010 and beyond. Reuters has $JAVA‘s EBITD margin at -7.5% last year and an average of 5.5% over the last five-years.
• Capital Expenditure: We have assumed capital expenditures of US$550.0 million in 2009 then US$450.0 million per annum moving forward.
• Discount Rate: 10.0%.
• Terminal Growth Rate: 3.0%.

Our analysis incorporates the cash and debt on the $JAVA balance sheet – Valuecruncher calculates a net debt number.

Based on our numbers - the $IBM offer looks very attractive for $JAVA shareholders.  Play with our assumptions – what does your analysis say? Our model is interactive - you can change any of our assumptions.

Disclosure: None

“In the short run, the market is a voting machine, but in the long run it is a weighing machine.” — Benjamin Graham, The Intelligent Investor

That is the best analysis we can find about the current market. We believe there is an intrinsic value for shares and our analysis attempts to calculate this. But in the short-term market sentiment is a key factor and at the moment the votes are primarily negative. But there are some positives appearing. This week it was IBM ($IBM). $IBM announced better than expected fourth quarter results. At Valuecruncher we have previously looked at $IBM. Our 2008 projections in our previous analysis were not far out - we projected 2008 revenues of US$105.0 billion against actuals of US$103.6. We decided to update our valuation of $IBM.

Valuecruncher valuation model of $IBM with interactive assumptions

Valuecruncher produces a valuation of US$128.62 for $IBM. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 42.8% above the current share price of US$90.07.

Assumptions

• Revenue: Reuters aggregates 15 analysts covering $IBM and these analysts have a mean estimate of 2009 revenues of US$103.2 billion. For our analysis we have used US$105.0 billion in 2009, US$107.0 billion in 2010 and US$110.0 billion in 2011.
• Profitability: We have used an EBITDA margin of 20% flat to 2010. Reuters had $IBM‘s EBITD margin at 20.26% in 2007 but is waiting for detailed profitability results for 2008 (including at the EBITDA line) which have not yet been released by the company.
• Capital Expenditure: We have assumed capital expenditures of US$4.5 billion in 2009 and 2010 rising to US$5.0 billion in 2011 and beyond.
• Discount Rate: 10.5%.
• Terminal Growth Rate: 3.0%.

Our analysis incorporates the cash and debt the $IBM balance sheet – Valuecruncher calculates a net debt number.

Our analysis has considerable range for downside:

• Increasing the discount rate to 11.5% drops our valuation to US$116.20.
• Lowering the terminal growth rate to 2% drops our valuation to US$117.41.
• Lowering our 2009-11 revenues to US$100.0 billion drops our valuation to US$116.43.
• Lowering our EBITDA margin to 17.5% from 2009 drops our valuation US$111.00.
• Combining all of these sensitivities results in a valuation of US$84.74 - 5.9% below the current share price.

Comparator Analysis

Comparator analysis (sometimes called comparison company analysis) is a relative valuation approach. For $IBM we looked at four peer companies - Accenture ($ACN), HP ($HPQ), Microsoft ($MSFT) and Oracle ($ORCL). We calculated enterprise values - market capitalisation plus net debt (long-term borrowings less cash). Then we measured a range of metrics against the enterprise value for $IBM and the peer set.

We have used the last financial year (LFY) as the base set of metrics. $IBM has not yet released the 2008 LFY profitability (EBIT and EBITDA) and free cash flow results. For this analysis we have used the 2008 revenue numbers with the 2007 profitability and free cash flow margins. The highlighted column links our DCF valuation to the current market valuation.

$IBM is currently trading in the middle to the upper-end of the valuation metrics of the peer group. Our DCF valuation places a value on $IBM well above where the market is currently valuing the company and the peer group. Reviewing our assumptions we remain comfortable with our valuation. Using the DCF valuation approach we believe that $IBM is trading at a discount to intrinsic value. The market is definitely voting negative - but in the long-run we believe $IBM represents value at current prices.

Play with our assumptions – what does your analysis say?

Disclosure: None

Microsoft ($MSFT) continues to trade under US$20 a share.  We have previously looked at $MSFT and felt it was undervalued in the US$20-25 range.  We decided it was time to revisit our valuation.

Valuecruncher valuation model of $MSFT with interactive assumptions

Valuecruncher produces a valuation of US$25.34 for $MSFT. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 33.6% above the current share price of US$18.96.

Assumptions

• Revenue: Reuters aggregates 30 analysts covering $MSFT and the mean estimate of 2009 revenues is US$67.3 billion. For our analysis we have used US$64.0 billion in 2009, US$68.5 billion in 2010 and US$72.5 billion in 2011.  Between 2004 and 2008 $MSFT grew revenues at a compound annual growth rate of 13.2% - revenues of US$36.8 billion in 2004 to US$60.4 billion in 2008.
• Profitability: We have used an EBITDA margin of 40.0% to 2011. Reuters has $MSFT‘s EBITD margin at 39.25% last year and an average of 37.0% over the last five-years.
• Capital Expenditure: We have assumed capital expenditures of US$3.75 billion per annum moving forward.
• Discount Rate: 11.0%.
• Terminal Growth Rate: 3.0%. In our assumptions we have 2010/11 revenue growth at 5.8% - we have assumed that growth eventually slows to a 3.0% long-term stable growth rate.  We have used 3.0% as our terminal growth rate.

Our analysis incorporates the cash on the $MSFT balance sheet – Valuecruncher calculates a net debt number.

Comparator Analysis

Comparator analysis (sometimes called comparison company analysis) is a relative valuation approach. For $MSFT we looked at four peer companies - IBM ($IBM), Apple ($AAPL), HP ($HPQ) and Google ($GOOG). We calculated enterprise values - market capitalisation plus net debt (long-term borrowings less cash). Then we measured a range of metrics against the enterprise value for $MSFT and the peer set.

We have used the last financial year (LFY) as the base set of metrics. $MSFT is currently priced at the bottom of the peer group for the EV/EBITDA and EV/EBIT metrics and in the middle for the EV/FCF metric.  The market is currently valuing the profits (EBIT and EBITDA) and free cash flow produced by $MSFT at less than half that of the comparable numbers for $GOOG. This reflects the perceived different future growth prospects of the two businesses.  The comparator numbers show $MSFT is comparably priced against the peer group - even with the strengths of their business model (39.8% EBITDA margins vs 18.9% for $IBM and 11.7% for $HPQ).  $MSFT’s growth is slowing - but it is still a very good business.  Should $MSFT’s profits (at the EBITDA and EBIT levels) really be valued less than $IBM and $HPQ?

Play with our assumptions – what does your analysis say? We think that $MSFT looks undervalued.  Our model is interactive - you can change any of our assumptions.

Disclosure: None

At Valuecruncher we have looked at $IBM several times.  Our valuations have been in the US$128 – US$141 range.  $IBM is currently trading at US$88.86 - when we looked previously $IBM was trading at US$126.52 and US$119.42.  We thought that it was time to revisit our valuation.

Valuecruncher valuation model of $IBM with interactive assumptions

Valuecruncher produces a valuation of US$130.55 for $IBM. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 46.9% above the current share price of US$88.86.

Assumptions

• Revenue: Reuters aggregates 17 analysts covering $IBM and these analysts have mean estimates of 2008 and 2009 revenues of US$106.7 billion and US$111.7 billion respectively. For our analysis we have used US$105.0 billion in 2008, US$106.5 billion in 2009 and US$110.0 billion in 2010.
• Profitability: We have used an EBITDA margin of 20% flat to 2010. Reuters has $IBM‘s EBITD margin at 20.26% last year.
• Capital Expenditure: We have assumed capital expenditures of US$5.0 billion in 2008 and 2009 rising to US$5.5 billion in 2010 and beyond.
• Discount Rate: 10.5%.
• Terminal Growth Rate: 3.0%.

Our analysis incorporates the cash and debt the $IBM balance sheet – Valuecruncher calculates a net debt number.

Play with our assumptions – what does your analysis say?

Disclosure: None

Valuecruncher has previously completed a valuation of $IBM. $IBM was trading at US$126.52 when we completed that valuation. Our valuation was US$141.42. With $IBM trading at US$119.42 we thought it was time to update this valuation.

Valuecruncher valuation model of $IBM with interactive assumptions

Valuecruncher produces a valuation of US$128.25 for $IBM. This is a current valuation not a target price. This valuation is 7.4% above the current share price of US$119.42.

Assumptions

Our assumptions are revenues of US$105.0 billion in 2008 growing to US$115.0 billion in 2010. This growth is a compound annual growth rate (CAGR) of 5% for 2007-10 this compares to a 4% CAGR from 2005-7. We have used a flat EBITDA margin of 20% to 2010. We used a terminal growth rate of 3.0%. We used a terminal capital expenditure number of US$5.5 billion. We have used a WACC (discount rate) of 9.0%. All of these assumptions can be amended in the Valuecruncher on-line valuation model to adjust the valuation.

Our analysis incorporates the cash and debt on the $IBM balance sheet – Valuecruncher calculates a net debt number.

Based on our analysis the current share price looks cheap. It appears an opportunity to be buying $IBM. Play with our assumptions – what does your analysis say?

Disclosure: None

Valuecruncher has a database of over 1,000 companies on major international exchanges. You can explore, create and share valuations for any of these companies.

Last week IBM announced earnings well above expectations. IBM is trading toward the top of the stock’s 52-week range. We decided to have a look at some projected financial numbers using our on-line valuation tool to see how the share price shapes up.

IBM Valuation

IBM grew revenues from US$91.4 billion in 2006 to US$98.8 billion in 2007 – 8% year-on-year growth. Our assumptions of revenues for the next three years are US$109.0 billion in 2008 growing to US$121.0 billion in 2010 – a 7% compound annual growth rate. We have projected EBITDA margins to grow from 20.0% in 2008 to 21.0% in 2010. We have used a terminal growth rate of 3%. We used a terminal capital expenditure number of US$5.75 billion. We have utilised a WACC (discount rate) of 9%.

Valuecruncher valuation model of IBM with interactive assumptions

Our analysis incorporates the cash and debt on the IBM balance sheet – Valuecruncher calculates a net debt number.

Our analysis gives a valuation of US$141.42 per share which is 19.3% above the current share price of US$126.52.

Based on our analysis the current share price looks undervalued. Play with our assumptions – what does your analysis say?

Valuecruncher has a database of over 1,000 companies on major international exchanges. You can explore, create and share valuations for any of these companies.