Archive for July, 2008

Sun Microsystems (JAVA) – all about the profits

Thursday, July 31st, 2008

Sun Microsystems (JAVA) released their fourth quarter results on 16 July and is due to release full results on 1 August. With the release of the fourth quarter results Sun did not impress Wall Street analysts. We decided to have a look at some projected financial numbers using our on-line valuation tool to see how the current share price shapes up.

JAVA Valuation

JAVA grew revenues from US$11.19 billion in 2004 to US$13.87 billion in 2007 – a 7.4% compound annual growth rate. Our assumptions of revenues for the next three years are US$14.0 billion in 2009 growing to US$15.0 billion in 2011 – a 2.6% compound annual growth rate (2008-11). We have projected EBITDA margins to be flat at 10.0% to 2011. We have used a terminal growth rate of 2.5%. We used a terminal capital expenditure number of US$600 million. We have used a WACC (discount rate) of 12%.

Valuecruncher valuation model of JAVA with interactive assumptions

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

Our analysis gives a valuation of US$11.64 per share which is 14% above the current share price of US$10.21.

Based on our analysis the current share price looks undervalued. In our view the key assumption is the EBITDA margin moving forward. If JAVA can increase their EBITDA margin to 12% in 2011 that lifts our valuation to US$13.91 (36% above the current share price). However if JAVA’s EBITDA margin dropped to 8% in 2011 that lowers our valuation to US$9.38 (8% below the current share price). 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.

More on this topic (What's this?)
Monday Equity Ideas: WFR, SOLF, JAVA
Sun dimming — 6,000 to be laid off
Read more on Sun Microsystems at Wikinvest

Qualcomm (QCOM) over US$50 a share – even with the Nokia settlement, that looks rich

Friday, July 25th, 2008

At Valuecruncher we have long been an interested observer of Qualcomm (QCOM). QCOM designs, manufactures and markets digital wireless telecommunications products based on technology it has developed (CDMA). QCOM is an example of a company that has successfully commercialised in-house developed intellectual property (IP). This week QCOM announced the settlement of a long-running IP dispute with Nokia (NOK). Based on this settlement QCOM is trading at 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.

QCOM Valuation

QCOMM grew revenues from US$4.88 billion in 2004 to US$8.87 billion in 2007 – a 22% compound annual growth rate. Our assumptions of revenues for the next three years are US$10.5 billion in 2008 growing to US$13.5 billion in 2010 – a 15% compound annual growth rate. We have projected EBITDA margins to grow from 40.0% in 2008 to 45.0% in 2010. We have used a terminal growth rate of 5%. We calculated this terminal growth rate based on year three growth of 11% dropping to a 4.5% stable growth rate by year 10. We believe there is still considerable additional growth in mobile globally to come which QCOM is well positioned for. We used a terminal capital expenditure number of US$1.0 billion. We have used a WACC (discount rate) of 10%.

Valuecruncher valuation model of QCOM with interactive assumptions

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

Our analysis gives a valuation of US$45.11 per share which is 14% below the current share price of US$52.43.

Based on our analysis the current share price looks overvalued. The Nokia settlement is good news but the QCOM share price looks expensive. 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.

More on this topic (What's this?)
Everyone Loves Qualcomm Part II
Nokia (NOK) Stock Dividend Analysis
Read more on QUALCOMM, Nokia at Wikinvest

Below US$150 a share Apple (AAPL) looks a buy

Tuesday, July 22nd, 2008

With the release of Apple’s (AAPL) latest quarterly results the share price headed to the US$150 a share range in after-hours trading. Valuecruncher did a valuation for Apple in early June that put a base case valuation on AAPL of US$146.70 – 21% below the then share price of US$186.10. With AAPL moving into the range of our previous valuation – we decided to review our valuation using the Valuecruncher on-line valuation tool.

Apple (AAPL) Valuation Assumptions

Our assumptions are revenues of US$32.8 billion in 2008 growing to US$50.0 billion in 2010. We have used a flat EBITDA margin of 21% from 2008. We used a terminal growth rate of 5.75%. We used a terminal capital expenditure number of US$1.0 billion. We have used a WACC (discount rate) of 11.0%.

Valuecruncher valuation model of Apple (AAPL) with interactive assumptions

Our valuation comes out at US$149.75 per share. This is in-line with the current share price.

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

Apple is a great company with incredibly innovative products that consumers all around the world want desperately. That is a position that must be envied by all their competitors in the technology space and beyond.

Warren Buffett’s famous quote is “It’s far better to buy a wonderful company at a fair price than a fair company at a wonderful price”. At around US$150 a share – in our view Apple fits that criteria. 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.

More on this topic (What's this?)
Buy, Sell or Hold: Apple Inc.
Apple (AAPL): Steve Jobs' Replacement?
How Low Will Apple Go?
Read more on Apple at Wikinvest

Google (GOOG) worth US$1,000+ a share today – you must be dreaming

Monday, July 21st, 2008

A US fund manager Manning & Napier has come out with an amazing call in Barron’s that their current view of the Google (GOOG) share price equates to US$950-1,050. Henry Blodget works through some of the assumptions and is not convinced.

Neither are we.

We took the assumptions from Henry Blodget’s analysis in Silicon Alley Insider and ran these through the Valuecruncher on-line valuation tool to see what sort of numbers are required to justify a US$1,000 a share valuation for GOOG.

Assumptions – for a US$1,000 a share valuation for Google today

We started with a 2008 revenue number of US$22.5 billion – and then grew that at 30% per annum to 2010. We used a 40% EBITDA margin on these revenues. We used a US$4.25 billion terminal capital expenditure figure. For a discount rate (WACC) we used 10%.

These are aggressive projections for the period to the end of 2010. But where things get really wild is in determining the terminal growth rate. This is the rate that reflects the growth potential beyond 2010. To achieve a valuation over US$1,000 a share we have needed an 8% terminal growth rate. This is a big number. How big. To get to an 8% terminal growth rate requires a 30% growth rate from 2010 to 2011 then dropping to 6% in perpetuity from 2015. The growth numbers look like 24% in 2012, 18% in 2013, 12% in 2014 and 6% in 2015 and beyond. 6% is a big perpetuity number – 8% is huge. Play with the assumptions and see the impact. Note: in our model the terminal growth rate must be more than 2% below the discount rate. In this example we come up against this constraint.

Valuecruncher valuation model of US$1,000 Google share price with interactive assumptions

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

Here at Valuecruncher we do not believe that Google is worth over US$1,000 a share. The assumptions required are just too heroic to be realistic. A month ago we completed a scenario valuation for Google. We still stand by that as a way to look at and think about the valuation of Google.

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.

More on this topic (What's this?)
Big Brother is Watching
Google Will Build Server Farm in Austria
Read more on Google at Wikinvest

IBM Still Looks Cheap At US$130 A Share

Saturday, July 19th, 2008

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.

More on this topic (What's this?)
P/E Ratio Defined
The Greatest Ever Short Squeeze?
IBM One of the Few Strong Dow 30 Stocks
Read more on International Business Machines at Wikinvest

InBev acquire Anheuser Busch for US$70 a share – the numbers

Tuesday, July 15th, 2008

Last week here at Valuecruncher we looked at the then US$65 a share offer from InBev (INTB.BR) for Anheuser Busch (BUD) and came to the conclusion that US$65 a share looked cheap. Our view was “if InBev want to get this transaction completed there are a lot of obstacles but price looks the key one”. We were wrong. Price was the only obstacle. 24 hours after we wrote the post InBev increased their offer to US$70 a share and the deal was agreed on Sunday night (US-time).

Our analysis put a standalone value on the shares of Anheuser Busch at US$67.65. This is the value of Anheuser Busch remaining an independent company – i.e. not being acquired. Our view was with a standalone valuation above the offer price there was no way that Anheuser Busch would accept the offer. That changed with the InBev bid being lifted to US$70 a share.

Our analysis of the Anheuser Busch valuation as a standalone entity and the assumptions behind them:

Valuecruncher Valuation Anheuser Busch

To people outside the mergers and acquisitions processes these valuation discussions often appear petty. “What is difference between US$65 a share and US$70?”. The target company (the one potentially being acquired) needs to determine the value of their business as a standalone entity and this should be their bottom line number. This is what we did with our valuation of Anheuser Busch. The acquiring company will have completed their own merger financial models that show the combined business incorporating financial “synergies” (that usually means costs that can be cut but also additional revenues that can be achieved). The acquiring company will create a valuation for the target company based on these models. That valuation will drive the offer that is made for the target. The objective is to pay as little as possible and retain as many of the synergies for the acquiring company shareholders as can be achieved. To make an acquisition palatable to the target company shareholders the acquirer will often pay-away some of these financial synergies in their offer (i.e. give up some of the expected gains of the deal). This process is often called the “takeover premia” (or “premium for control”). The takeover premia is typically specific to the circumstances of each particular deal.

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.

More on this topic (What's this?)
Anheuser-Busch (BUD) Deal Finalized
Dividend Portfolio Update
Read more on Anheuser-Busch Companies at Wikinvest

A DCF Valuation Of Wal-Mart (WMT)

Tuesday, July 15th, 2008

Last week Wal-Mart announced solid June sales numbers. WMT 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.

WMT Valuation

Wal-Mart grew revenues from US$284.3 billion in 2005 to US$378.8 billion in 2008 – a 10% compound annual growth rate. Our assumptions of revenues for the next three years are US$405.0 billion in 2009 growing to US$465.0 billion in 2011 – a 7% compound annual growth rate. We have projected EBITDA margins to be flat at 7.5%. We have used a terminal growth rate of 3.5%. We calculated this terminal growth rate based on year three growth of 6.9% dropping to a 3% stable growth rate by year 10. We used a terminal capital expenditure number of US$14.5 billion. We have used a WACC (discount rate) of 8%.

Valuecruncher Valuation WMT

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

Our analysis gives a valuation of US$51.71 which is 8.0% below the current share price of US$56.29.

Based on our analysis the current valuation looks slightly overvalued. 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.

More on this topic (What's this?)
Adding to Walmart (WMT)
Some Purchases
Read more on Wal-Mart at Wikinvest

InBev’s US$65 offer for Anheuser Busch (BUD) looks cheap

Friday, July 11th, 2008

With InBev (INTB.BR) declining to raise their US$65 a share offer for Anheuser Busch (BUD) we decided to have a look at some projected financial numbers for BUD as a standalone entity using our on-line valuation tool. How does US$65 a share stack for BUD?

BUD Valuation

BUD grew revenues from US$14.9 billion in 2004 to US$16.7 billion in 2007 – a 3.7% compound annual growth rate. Our assumptions of revenues for the next three years are US$17.5 billion in 2008 growing to US$19.0 billion in 2010 – a 4.4% compound annual growth rate. We have projected EBITDA margins to be flat at 24%. We have used a terminal growth rate of 3%. We used a terminal capital expenditure number of US$900 million. We have also used a WACC (discount rate) of 7.5%.

Valuecruncher Valuation BUD

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

Our analysis gives a valuation of US$67.65 which is 8.9% above the current share price of US$61.30. Our valuation is also 4.1% above the InBev offer. This is a standalone valuation for BUD. If InBev want to get this transaction completed there are a lot of obstacles but price looks the key one.

The WACC (discount rate) and terminal growth are the key assumptions with our numbers. If the WACC (discount rate) is decreased to 7.0%, keeping all other assumptions constant, that increases our valuation from US$67.65 to US$76.77. A WACC (discount rate) of 7-8% is our estimate of a “reasonable” WACC (discount rate) for BUD. Dropping the terminal growth from 3.0% to 2.5% decreases our valuation from US$67.65 to US$60.67. A terminal growth rate in the 2.5-3.0% range is our estimate of a “reasonable” terminal growth rate for BUD.

Based on our analysis the current offer 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.

More on this topic (What's this?)
Anheuser-Busch (BUD) Deal Finalized
Dividend Portfolio Update
Read more on Anheuser-Busch Companies at Wikinvest

As Microsoft (MSFT) assesses their options – what about the core?

Wednesday, July 9th, 2008

Microsoft (MSFT) is in an interesting place at the moment - which is only in part to losing Bill Gates from day-today management. It created one of the dominant global businesses of the late 20th century but has struggled to move beyond the core products that drove this success. The Client (Windows), Server and Tools (enterprise solutions) and MBD (Office) divisions drive 83% of revenues and over 100% of operating profits (the On-line Services and Entertainment divisions are still operating at a loss). Microsoft has spent a lot of money and resources (especially senior management focus) on the aborted (maybe) attempt to acquire Yahoo (YHOO). We agree with the analysis that the pursuit of Yahoo is an attempt to compete with Google (GOOG) in what has become one of the dominant global businesses of the early 21st century (on-line advertising driven by search). The Microsoft acquisition of Powerset is a further example of this strategy of aiming to compete directly with Google.

At Valuecruncher we are not convinced by this strategy of competing with Google - we are not alone. We completely respect Microsoft’s previous successes in following into and then dominating markets. But in the on-line advertising and search market we see some of the same network effects that suggest a “winner takes all” competitive situation. At Valuecruncher we can see a situation where Google’s current dominance is eroded – but not because of a head-to-head battle with either Yahoo or Microsoft (or a potential combination). At Valuecruncher we believe that Microsoft should be looking beyond the current competitive situation to the next big profit pool. Hockey great Wayne Gretzky when asked about why he was successful is credited with the quote A good hockey player plays where the puck is. A great hockey player plays where the puck is going to be”. Easily said we recognise, but that is our view of where Microsoft should be directing their strategic efforts – not competing head-to-head with Google in a market their competitor dominates.

Any potential acquisition of all, or part, of the Yahoo business clouds any current valuation discussion of Microsoft. Some influential Microsoft insiders have suggested in a piece of high-level analysis that 1% of the global search market is worth US$1 billion in market capitalisation. Microsoft’s potential acquisition of Yahoo valued their share of the search market at more than that - US$47 billion for approximately 20% market share. What about the core Microsoft business? What if we ignore the potential Yahoo scenarios – what is the core Microsoft (MSFT) business worth?

The core Microsoft business is reasonably easy to value – if you exclude growth options. The business is growing well (if not at the levels of ten years ago) with robust margins. There is capital expenditure required to achieve the revenues and profitability. There is strong competitive positioning around these core products but with credible low-end competitors that have the potential to disrupt (i.e. Google Docs). The current business will change as technology develops – but as the current dominant player, Microsoft is well positioned to respond to competitive threats and to potentially lead innovation. At Valuecruncher we are not sure that Microsoft should be investing heavily in the on-line advertising and search market - they should be aiming beyond it.

MSFT Valuation

Microsoft grew revenues from US$36.8 billion in 2004 to US$51.1 billion in 2007 – an 11.5% compound annual growth rate. Our assumptions of revenues for the next three years are US$60.0 billion in 2008 growing to US$74.0 billion in 2010 – a 13.1% compound annual growth rate. We have projected EBITDA margins to be flat at 40%. We have used a terminal growth rate of 4.5%. We calculated this terminal growth rate based on year three growth of 10.4% dropping to a 4% stable growth rate by year 10. We used a terminal capital expenditure number of US$3.0 billion. We have used a WACC (discount rate) of 10.5%. Both the terminal growth rate and WACC have a material impact on the valuation.

Valuecruncher Valuation MSFT

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

Our analysis gives a valuation of US$33.01 which is 20% above the current share price of US$26.03. The market appears to be placing a negative value on the noise around an acquisition of all or part of Yahoo. Focusing on the harvesting the core business and innovating (by making small bets) beyond that core appears to be the highest value strategy for Microsoft.

Based on our analysis the core business 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.

More on this topic (What's this?) Read more on Microsoft, Yahoo! at Wikinvest

Is Amazon.com (AMZN) really worth over US$70 a share?

Monday, July 7th, 2008

At Valuecruncher we are keen watchers of Amazon.com (AMZN). As The Economist magazine pointed out last month – of the three pre-2000 internet giants (eBay and Yahoo are the others) it is AMZN that is currently thriving. We decided to put AMZN through the Valuecruncher on-line valuation tool.

AMZN Valuation

Our assumptions of revenues for the next three years are US$19.5 billion in 2008 increasing to US$29.5 billion in 2010. We have projected EBITDA margins increasing from 7% in 2008 to 8% in 2010.

We have used a terminal growth rate of 5%. Our view is that AMZN’s growth beyond 2010 will slow – but there is a distance to go yet. Our numbers project 2009 to 2010 revenue growth of 23%. This assumption has a significant impact on the valuation. If you believe AMZN has better future prospects – this will positively impact the valuation.

We have used a WACC (discount rate) of 10.5%. The WACC (discount rate) has a material impact on a discounted cash flow valuation (as does the terminal growth rate).

We used a terminal capital expenditure number of US$350 million. In our opinion capital expenditure should stabilize around this number.

AMZN Valuation

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

Our analysis gives a valuation of US$59.00 which is 19.5% below the current share price of US$72.00.

Our valuation incorporates a projection of growth for AMZN in the future. We recognise that AMZN has a range of potentially valuable growth options (especially their Web Services platform). Currently it is very difficult to determine the precise value of these growth options – we have made a broad attempt with our growth projections. However, it appears that these options are being factored into the current share price at a level beyond what we are projecting.

Based on our analysis, AMZN shares look expensive. 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.

More on this topic (What's this?)
Colleges Support Amazon's Kindle
Blog Review
Back from vacation
Read more on Amazon.com at Wikinvest

You are currently browsing the Valuecruncher blog archives for July, 2008.

Subscribe

Categories