Archive for the ‘International’ Category

Running The Numbers - PepsiCo ($PEP) is it recession-vulnerable?

Thursday, October 23rd, 2008

Previously Valuecruncher has looked at Coca-Cola ($KO).  With Nielson rating carbonated beverages a recession vulnerable category we thought it was time to have a look at PepsiCo ($PEP).  How does the current share price look?

Valuecruncher valuation model of $PEP with interactive assumptions

Valuecruncher produces a valuation of US$48.01 for $PEP. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 10.5% below the current share price of US$53.64.

Assumptions

  • RevenueReuters aggregates 10 analysts covering $PEP and these analysts have mean estimates of 2008 and 2009 revenues of US$43.5 billion and US$46.7 billion respectively. For our analysis we have used US$43.0 billion in 2008, US$46.0 billion in 2009 and US$47.5 billion in 2010.
  • Profitability: We have used an EBITDA margin of 20.0% in 2008 rising to 21.0% in 2010. Reuters has $PEP‘s EBITD margin at 20.8% last year and 22.0% over the last five-years.
  • Capital Expenditure: We have assumed capital expenditures of US$2.5 billion per annum moving forward.
  • Discount Rate: 9.0%.  Valuecruncher used a discount rate of 8% in our $KO valuation.  We believe a discount rate in the 8-9% range is reasonable.
  • Terminal Growth Rate: 3.0%.

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

Play with our assumptions – what does your analysis say?

Disclosure: None

 

Valuation In Times Of Turmoil

Monday, October 13th, 2008

It has been a week of financial market turmoil. The Dow is closed at 8,451 on Friday – over 40% below the 52-week high of 14,279 and down 18% for last week alone. There are a lot of very smart people concerned that the markets and broader global economy are headed for a long-term slump. Within this turmoil there is a lot of discussion about valuation. Here at Valuecruncher we wanted to explain our take on valuation and the analysis we provide.

Here at Valuecruncher we believe that in the long-run markets are broadly efficient – market prices properly reflect the intrinsic value of assets. By intrinsic value we mean a ‘true’ underlying value. However, in the short-term there can be and are inefficiencies. At Valuecruncher, valuation is an attempt to estimate what this intrinsic value is and how it relates to current market prices. At Valuecruncher we do that by calculating a discounted cash flow (DCF) valuation. As we noted, in the longer-term we believe that markets will price assets at this intrinsic value. In the shorter term market prices may differ (either up or down). Our approach is a longer term approach. If someone is looking for a valuation of where a stock will be this week – a DCF isn’t the way to go. However, if you want to understand the underlying value of a stock relative the market price and have a longer-term view – that is where a DCF adds value.

For example: Apple ($AAPL). On 4 June 2008 with the $AAPL share price at US$186.10 our estimate of the $AAPL intrinsic value was US$146.70. By 23 September 2008 with the $AAPL share price at US$131.05 our estimate of the $AAPL intrinsic value was US$163.98. $AAPL closed on Friday at US$96.80. In just over four months the market price of $AAPL has dropped 48% – dramatic times indeed. Our estimate of intrinsic value has changed based on changing assumptions of the underlying business. But what we are trying to estimate is the intrinsic value – and we have argued it is both below and above the prevailing share price of $AAPL over the last four months.

At Valuecruncher we will continue to put out our take on the intrinsic value of companies like $AAPL and how this relates to the current share price. Our on-line interactive valuation models allow anyone to change our assumptions and calculate their own intrinsic value. In our own analysis we are going to try and avoid rhetoric like “buy”, “sell”, “cheap” and “expensive”. Ours is a longer-term analysis. We still believe that in the long-run that market prices and intrinsic value will eventually converge.

Understanding intrinsic value helps us to understand corporate transactions like share buy-backs. It can illuminate mergers and acquisitions activity. It can even expose opportunities to invest (and dispose) of stocks.

After a wild week we expect there are still some brave souls out there trying at assess value.

More on this topic (What's this?)
DJIA Technical Analysis: Three Lines in the Sand
Top 20 one day percent decreases in Dow Jones
Are Insurers Next?
Read more on Dow Jones Industrial Average at Wikinvest

Running The Numbers – Amazon ($AMZN) still looks expensive

Friday, September 26th, 2008

As recently as 11 August 2008 $AMZN was trading at US$88.09.  With $AMZN now trading around the US$70 mark – does this represent a good opportunity to buy?  We decided to look at the underlying numbers for $AMZN using the Valuecruncher on-line valuation model to see what we think about the current share price.

Valuecruncher valuation model of $AMZN with interactive assumptions

Valuecruncher produces a valuation of US$62.65 for $AMZN.  This is a current valuation not a target price.  This valuation is 10% below the current share price of US$69.96.

Assumptions

Our assumptions are revenues of US$19.5 billion in 2008 growing to US$30.5 billion in 2010. We have used an EBITDA margin of 7% in 2008 increasing to 8% in 2010. We used a terminal growth rate of 5%. We used a terminal capital expenditure number of US$375 million. We have used a WACC (discount rate) of 10.5%.  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 $AMZN balance sheet – Valuecruncher calculates a net debt number.

Based on our analysis the current share price looks expensive.  We recognise that $AMZN has a range of potentially valuable growth options (especially their Web Services platform). Currently it is very difficult to determine a value of these growth options – we have made a broad attempt with our growth projections and terminal growth rate. However, it appears that these options are being valued into the current share price at a level beyond what we are projecting.  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.

 

More on this topic (What's this?)
Blog Review
A Storm Blows In From Amazon
CDN: Enter Amazon!
Read more on Amazon.com at Wikinvest

Running The Numbers – Apple (AAPL) Looks Cheap

Tuesday, September 23rd, 2008

The on-going turmoil in the markets and analysts lowering estimates across the technology sector has had a big impact on Apple’s (AAPL) share price.  AAPL finished at US$131.05 on the 22 September 2008 – 35% below the 52 week high of US$202.96.  We decided to look at the underlying numbers for AAPL using the Valuecruncher on-line valuation model to see where we place the current share price.

Valuecruncher valuation model of AAPL with interactive assumptions

Valuecruncher produces a valuation of US$163.98 for AAPL.  This is a current valuation not a target price.  This valuation is 25% above the current share price of US$131.05 (note our model picks up an earlier price of US$140.91 because we completed the valuation earlier).

Assumptions

Our assumptions are revenues of US$32.5 billion in 2008 growing to US$50.0 billion in 2010. We have used an EBITDA margin of 20.5% in 2008 dropping to 19.5% in 2010. We used a terminal growth rate of 5.75%. We used a terminal capital expenditure number of US$1.25 billion. We have used a WACC (discount rate) of 10.0%.  All of these assumptions can be amended in the Valuecruncher on-line valuation model to adjust the valuation.

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

Based on our analysis the current share price looks cheap.  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

Anyone For A Cheap Coca-Cola?

Monday, September 1st, 2008

The Coca-Cola Company (KO) is trading at the bottom of their 52-week range (US$49.44-65.59). Typically KO has been one of the world’s most admired stocks. Warren Buffett’s Berkshire Hathaway is the second largest holder of KO stock with a US$10.4 billion investment in the company. Analysts are however beginning to move away from the stock.

At Valuecruncher we decided to put some numbers around KO using our on-line valuation tool.

KO Valuation

KO grew revenues from US$21.7 billion in 2004 to US$28.9 billion in 2007 – a 9.9% compound annual growth rate. Our assumptions of revenues for the next three years are US$33.15 billion in 2008 growing to US$36.65 billion in 2010 – an 8.3% compound annual growth rate. We have projected EBITDA margins to be 29% in 2008 then flat at 30% to 2010. We have used a terminal growth rate of 3.25%. We calculated this terminal growth rate based on year three (2009-10) growth of 4.1% dropping to a 3.0% stable growth rate by year 10. We used a terminal capital expenditure number of US$1.75 billion. We have used a WACC (discount rate) of 8.0%.

Valuecruncher valuation model of KO with interactive assumptions

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

Our analysis gives a valuation of US$54.73 per share which is 5% above the current share price of US$52.07.

One of Warren Buffett’s famous quotes is “It’s far better to buy a wonderful company at a fair price than a fair company at a wonderful price”. At US$52.07 a share – in our view KO 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.

Valuing Adobe

Monday, August 11th, 2008

Over the last four years Adobe’s revenues have grown at 25% p.a. to over $3 billion in the year ending 30 November 2007. This growth has been driven by the Creative Solutions segment consisting of Adobe’s Creative Suite and Photoshop offerings. Creative Solutions grew 37 % and represented 60% ($1.07 billion) of Adobe’s revenues in the six months to 30 May 2008.

Trading at $45.15, the upper end of their 12 month range ($30.70 - $48.47) and up 46.6% since March 17 we decided to apply the Valuecruncher interactive valuation tool to Adobe.

Adobe Chart

Discounted Cash Flow (DCF) Assumptions and Valuation

Based on historic growth rates and analysts estimates we have forecast Adobe’s revenues to grow to $4.6 billion in 2010 representing an annualised growth rate of 13.4% over the next three years. We have projected slight expansion in EBITDA margins from 40% in 2008 to 42% in 2010. We have used a terminal growth rate of 5% and a WACC (discount rate) of 11.25% (based on Aswath Damodaran’s estimate for the computer software/services sector).

Valuecruncher valuation model of Adobe and interactive assumptions.

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

Our analysis gives a valuation of $39.41 which is 12.7% below the current share price of $45.15.

Comparable Company Analysis

Based on our DCF analysis Adobe appears slightly over valued. To provide additional context to our analysis and the current price we have collated the trading multiples of Adobe’s competitors and other software companies. We have included companies such as Apple and Google because they are considered key competitors by Adobe despite software sales not representing their core business.

Company Price P/E (ttm)
Adobe - Current Market 45.15 30.14
Adobe - Valuecruncher DCF 39.41 26.31
Apple 169.55 33.15
Google 495.01 32.53
Intuit 29.87 19.56
Microsoft 28.13 15.07
Oracle Corporation 23.52 22.27
Application Software Industry
NA 22.27

Adobe is currently trading at a P/E ratio considerably higher than the industry average and appears fully priced based on the comparable company analysis.

Key Considerations

  • Can Adobe continue to grow their core offerings in the face of increasing competition and the threat of free or open source alternatives?
  • Will Adobe develop new material revenue streams beyond their core Creative Solutions and Knowledge Worker Solutions segments? e.g. Mobile and Device Solutions represented $37.4 million or 2% of Adobe’s revenues in the six months to 30 May 2008.

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?)
Yahoo + Adobe: It's A Vision Thing
Valuation-Adobe Systems Inc. (ADBE)
Read more on Adobe Systems 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

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

Starbucks puts on the brakes – what does it mean for the current valuation

Wednesday, July 2nd, 2008

This week Starbuck’s (SBUX) announced it was closing 500 US locations and cutting 7% of its workforce. At Valuecruncher we decided to have a look at some projected financial numbers to analyse what this means for the slower brewing coffee giant utilising our on-line valuation tool.

This is the quantitative take on Starbucks – for a qualitative take; Portfolio magazine profiles Starbucks CEO Howard Schultz in this month’s issue.

SBUX Valuation

Starbucks grew revenues from US$5.3 billion in 2004 to US$9.4 billion in 2007 – a 21% compound annual growth rate. Our assumptions of revenues for the next three years are US$10.5 billion in 2008 growing to US$12.5 billion in 2010 – a 9% compound annual growth rate. We have projected EBITDA margins to be flat at 10%. We have used a terminal growth rate of 4.5%. We calculated this terminal growth rate based on year three growth of 8.7% dropping to a 4% stable growth rate by year 10. We used a terminal capital expenditure number of US$800 million. We have used a WACC (discount rate) of 10%.

Valuecruncher Valuation SBUX

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

Our analysis gives a valuation of US$15.07 which is 4.3% below the current share price of US$15.74.

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?)
Starbucks Throws in the Towel
Read more on Starbucks at Wikinvest

You are currently browsing the archives for the International category.

Subscribe

Categories