At Valuecruncher we decided to put some numbers around the future performance of EXPE using our on-line valuation tool.
EXPE Valuation
EXPE grew revenues from US$1.8 billion in 2004 to US$2.7 billion in 2007 – a 14% compound annual growth rate.Our assumptions of revenues for the next three years are US$3.0 billion in 2008 growing to US$3.75 billion in 2010 – a 12% compound annual growth rate (2007-10).We have projected EBITDA margins to be flat at 25% to 2010.We have used a terminal growth rate of 3.75%.We calculated this terminal growth rate based on year three (2009-10) growth of 10% dropping to a 3.0% stable growth rate by year 10.We used a terminal capital expenditure number of US$150 million.We have used a WACC (discount rate) of 12.0%.
The key assumptions as we see them are:
EXPE Revenues for the next three years.We believe that 12% per annum growth (2007-10) is a reasonable estimate.
EXPE WACC.We view EXPE’s WACC in the 11-13% range.We took a mid-point.This discount rate is intended to reflect the potential uncertainties of the EXPE cash flows in the near term.
Our analysis incorporates the cash and debt on the EXPE balance sheet – Valuecruncher calculates a net debt number.
Our analysis gives a valuation of US$23.21 per share which is 20% above the current share price of US$19.27.
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.
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.
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).
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.
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.
Like many others, we are not quite sure what to make of IAC Interactive (IACI).IACI incorporates a range of interactive businesses including: Ask.com (the number four search engine property), the Home Shopping Network (HSN), Ticketmaster, Lending Tree and Realestate.com as well as travel business Interval International.IACI announced in November 2007 a plan to split the business into five separate listed entities.We decided to have a look at the company using the Valuecruncher interactive tool.The approach we have taken is to look at the value of cash flows being produced by the combined entity – to see where the current share price comes out.This is not a sum-of-the-parts valuation where we try to place a value on the component parts of IACI.We are in-effect assuming the break-up does not occur and the business continues as usual.
IACI grew revenues from US$5.0 billion in 2004 to US$7.4 billion in 2008 – a 12.6% compound annual growth rate. Our assumptions of revenues for the next three years are US$6.6 billion in 2008 growing to US$7.35 billion in 2010 – a 4.9% compound annual growth rate. We have projected EBITDA margins to grow from 11.0% in 2008 to 12.0% in 2010. We have used a terminal growth rate of 3.5%. We used a terminal capital expenditure number of US$250 million. We have used a WACC (discount rate) of 12%.
Our analysis incorporates the cash and debt on the IACI balance sheet – Valuecruncher calculates a net debt number.
Our analysis gives a valuation of US$21.89 which is 17.9% above the current share price of US$18.57.
Based on our analysis, IACI shares look cheap. The total looks like less than the sum of the parts.What happens with the breakup will be interesting to watch. 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.
Last week Cisco (CSCO) announced their quarter 4 results.The response was pretty positive but analysts were concerned about a lack of guidance from the data-networking equipment and software giant.
At Valuecruncher we decided to put some numbers around the potential future performance of CSCO using our on-line valuation tool.
CSCO Valuation
CSCO grew revenues from US$22.0 billion in 2004 to US$39.5 billion in 2008 – a 15.7% compound annual growth rate.Our assumptions of revenues for the next three years are US$43.5 billion in 2009 growing to US$52.5 billion in 2011 – a 10% compound annual growth rate.We have projected EBITDA margins to grow from 29.0% in 2009 to 30.0% in 2011.We have used a terminal growth rate of 4.5%.We calculated this terminal growth rate based on year three growth of 10% dropping to a 4.0% stable growth rate by year 10.We used a terminal capital expenditure number of US$1.25 billion.We have used a WACC (discount rate) of 10.5%.
The key assumptions as we see them are:
CSCO Revenues for the next three years.We believe that 10% per annum growth is a reasonable estimate to start with.
CSCO EBITDA margins.We are comfortable with a slight rise.2011 EBITDA margins in the 29-31% range appear reasonable.
CSCO WACC.We view CSCO’s WACC in the 10-11% range.We took a mid-point.
Our analysis incorporates the cash and debt on the CSCO balance sheet – Valuecruncher calculates a net debt number.
Our analysis gives a valuation of US$28.51 per share which is 19% above the current share price of US$23.93.
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.
AT&T has released its second quarter results announcing revenues of $61.6 billion and operating income of $12.5 billion for the first half of the year. This result was dominated by strong growth in wireless revenues (up 15.8% in the second quarter) and speculation on the impact of the 3G iPhone on AT&T’s third quarter numbers.
AT&T’s current price of $30.17 is at the bottom of their 12 month range ($29.72 to $42.97) so we decided to apply our discounted cash flow valuation tool to AT&T. Utilising analyst projections, AT&T’s MD&A and our own analysis we arrive at a valuation of $39.25 for AT&T, a 30% discount to the current share price.
AT&T’s strong wireless growth is offset by declining voice revenues (down 7.8% or $1.6 billion in the six months to 30 June 2008).
What are AT&T’s long-term growth prospects beyond the Apple iPhone deal?
Despite these downside risks AT&T looks attractive at a $30 share price the question is whether the market will recognise the discount AT&T appears to be trading at.
McDonalds recently released their second quarter result announcing $6.1 billion revenue for the quarter and a 6.1% increase in comparable sales. At $59.77 McDonalds is trading at the upper end of their 12 month range ($46.64 - $63.69) and are currently rated a buy or strong buy by 11 of 17 analysts aggregated by Yahoo Finance.
MCD Valuation
We have assumed McDonalds revenues will grow to $25 billion in 2010 representing an annualised growth rate of 3.14% over the next three years. This growth will be driven by a combination of organic growth of existing stores and the ongoing opening of new stores.
EBITDA margins are projected to grow from 31.5% in 2008 to 33.5% in 2010 reflecting Mcdonalds’ strategy of focusing on franchised and affiliate stores. “Margins” derived from franchise operated stores for the first half of 2008 averaged 81.9% versus 17.1% for company operated stores. McDonalds re-franchised 300 stores in the first half of 2008 and plans re-franchise 1,000 to 1,500 by 2010.
We have assumed a constant capital expenditure of $2 billion per annum over the next three years consistent with McDonalds’ 2008 guidance. In 2008 this capital expenditure will be split 50/50 between the opening of 1,000 stores (net 600 stores) and reinvesting in existing stores.
A WACC (discount rate) of 8% has been used and terminal growth rate of 3% has been applied to McDonalds ongoing cash flows beyond 2010.
Our analysis incorporates the cash and debt on the MCD balance sheet – Valuecruncher calculates a net debt number.
Our analysis gives a valuation of $62.50 per share which is 4.6% above the current share price of $59.77.
The current share price is consistent with our analysis but McDonalds faces a number of challenges that limit the share price’s upside potential. These challenges include:
Pressure on margins from increased food and labour costs (e.g. chicken and beef costs are expected to increase by between 5% and 9% in 2008) are ongoing issues facing the industry.
Sustaining U.S. sales growth is a challenge in an extremely competitive industry exposed to changing customer tastes. Growth drivers in the key U.S. market have been chicken, breakfast, beverages and convenience. The breakfast and beverage markets are extremely competitive as major industry participants see this as a key growth area in a saturated restaurant market.
International expansion in markets such as China and Russia has been a key driver in McDonalds growth with over 50% of the company’s operating income being derived outside the U.S. in the first half of 2008. The reported growth of McDonalds international business has been amplified by currency movements. Adjusting for currency movements McDonalds revenues decreased slightly in the first half of 2008. The company’s share price is exposed to currency movements (approximately 50% of the company’s debt is denominated in foriegn currencies) and dependent on maintaining their strong growth in international markets.
McDonalds sees itself primarily as a franchisor and a key driver in our projected margin expansion is the focus on re-franchising restaurants. This re-franchising and the continuing opening of new stores rely on the economic viability of the individual restaurants. A potential economic slow-down and cost inflation will impact on the viability of the individual stores flowing through to both the revenue and margin growth assumptions.
With over 31,000 stores worldwide and approximately $63.5 billion in total system sales in 2007 McDonalds is the global leader in convenience restaurants that won’t be disappearing anytime soon. This scale combined with McDonalds plans to return $5.6 billion to $7.6 billion to shareholders over the next 18 months may make the company a safe haven despite the “limited” upside share price potential.
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.
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%.
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.
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%.
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.
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%.
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.
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.
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.