Archive for the ‘Uncategorized’ Category

Some quick thoughts on the LinkedIn ($LNKD) IPO

Friday, May 20th, 2011

Wow – a blog post. It has been a while. Most of the action is happening over on Twitter:

@valuecruncher

With the LinkedIn ($LNKD) IPO occurring today – I wanted to give some thoughts. Here

they are:

LinkedIn ($LNKD) IPOed today closing at $94.25 for a market capitalisation of $8.9bn – at 31 December 2010 $LNKD had $92m of cash and no debt – so we will give $LNKD an Enterprise Value (EV) of $9.0bn.

Big result. On SecondMarket (private secondary market) LinkedIn shares had traded at $35 a share in March 2011. The IPO was priced at $45 a share. End of first day $94 a share. The IPO bankers – Morgan Stanley, Merrill Lynch and Allen & Company – may have some questions to answer about pricing. A lot of interest – a good IPO for the technology/internet sectors.

How about some ratios? We are going to focus on EV/Revenue – how is the market valuing a company as a ratio of revenues. Because we are talking about growth companies – we are going to use estimates of 2011 revenues. So EV/Revenue (Forecast 2011).

LinkedIn ($LNKD) had revenues of $78m in 2008, $120m in 2009 and $243m in 2010. The company says growth will slow this year. We have estimated 2011 revenues at $400m – our number.

LinkedIn ($LNKD) EV/Revenue [Fcst 2011] is therefore 22.5x

How about some context

Apple ($AAPL) EV – $285.6bn, 2011 forecast revenues – $103.0bn: EV/Revenue [Fcst 2011] 2.8x

Google ($GOOG) EV – $137.7bn, 2011 forecast revenues – $28.3bn: EV/Revenue [Fcst 2011] 4.9x

Facebook ($FBOOK) – a bit more detail. Market Cap – $75bn on SecondMarket and $85bn on SharesPost (we will use the lower). We will assume zero net debt (long-term borrowings less cash). Gives an EV of $75bn. A reliable estimate of Facebook ($FBOOK) revenues for 2011 is $4.05bn. EV/Revenue [Fcst 2011] 18.5x

LinkedIn ($LNKD) does look expensive. But a lot depends on the future growth prospects – as it does with all company valuations. How fast can LinkedIn grow paying subscribers? As a sample size of one – I love the LinkedIn service (freemium business model) but I get all the functionality that I need from the free offering.

It will be really interesting for Facebook ($FBOOK) investors to watch the LinkedIn IPO. I imagine that a number will now be pushing for an IPO for Facebook – with the success of the LinkedIn IPO. The gap in value between the SecondMarket trades for LinkedIn and and the IPO outcomes will have current investors salivating. From a market efficiency point of view – it will be interesting to see what happens to the next set of trades for Facebook on SecondMarket and SharesPost. Even if there is simply a lift in the Facebook multiples – our analysis of high-level EV/Revenue [Fcst 2011] for LinkedIn is 22.5x which equates, if applied to Facebook, a valuation over $90bn.

Interesting times…

NZX (New Zealand) Company of the Day Tweets – 30 December 2010

Thursday, December 30th, 2010

Here are the NZX (New Zealand Stock Exchange) company of the day Tweets from the last week:

PGG Wrightson ($PGW.NZ) http://bit.ly/aoEjKC | Partial takeover by Chines

e cos at $0.60 – which is above our value.

New Zealand Refining Company ($NZR.NZ) http://bit.ly/2kxrE | Near 52-week high – but looking expensive vs peers.

Briscoe Group ($BGR.NZ) http://bit.ly/d2TXkr | Trading near a 52-week high – but still looks cheap vs peers.

Comvita ($CVT.NZ) http://bit.ly/cthk8r | looking cheap vs peers – but an IP dispute loss http://bit.ly/foBZ7n

Michael Hill ($MHI.NZ) http://bit.ly/aRF12 | Founding interests trying to acq control stake @ NZ$0.90 (NZ$0.85 Fri)

Fisher & Paykel Appliances ($FPA.NZ) http://bit.ly/NINfN | dramatically cutting earnings guidance dated only 26 Nov

NZX ($NZX.NZ) http://bit.ly/H441n | NZ fin mkt operator looks expensive vs peers + ASX/SGX merger moves fwd a step

Delegat’s ($DGL.NZ) http://bit.ly/gLlXE7 | takeover of grape grower Oyster Bay now unconditional.

Air NZ ($AIR.NZ) http://bit.ly/7wmKK | Looking cheap against peers – and with Virgin Blue alliance decision due.

New Zealand Oil & Gas ($NZO.NZ) http://bit.ly/aUCJ3V | Looking cheap vs peers – but impact of $PRC.NZ still unclear

If you want to follow us on Twitter we can be found @Valuecruncher

More on this topic (What's this?)
New Zealand's Bakken
A Brief History of New Zealand Oil
Read more on Investing in New Zealand, Chun Yuan Steel, Abc Communications at Wikinvest

NZX Company of the Day

Tuesday, September 28th, 2010

On the @Valuecruncher Twitter account we have been running a “Company of the Day” series. We have focused on US stocks – but we have also started a series on companies on the viagra buy now

com/home”>New Zealand Stock Exchange.

The reason that we are doing this is that the level of analysis on New Zealand listed companies is very limited. For small markets like New Zealand this is a common issue. We are simply trying an experiment – by adding some analysis to a small market – what happens?

At the end of each week we are going to bring together the company of the day Tweets here on the blog.

Here is the Tweets from the last week (and a bit):

Abano Healthcare ($ABA.NZ) http://bit.ly/9jzkw1 | Mulling options to return capital to shareholders after NCH sale

Turners & Growers ($TUR.NZ) http://bit.ly/931kow

Hallenstein Glassons ($HLG.NZ) http://bit.ly/abASUA | Just posted a 53 per cent jump in full-year profit

AFFCO ($AFF.NZ) http://bit.ly/bUImPV | Brian Gaynor (@nzherald) analyses the NZ primary sector http://bit.ly/cAaLV2

Vector Limited ($VCT.NZ) http://bit.ly/11jwaU | Just completed a US$182m placement of unsecured notes to US insto’s

Pumpkin Patch ($PPL.NZ) http://bit.ly/sUmlM | Children’s fashion retailer – annual profit in line with expectations

Fisher & Paykel Healthcare ($FPH.NZ) http://bit.ly/Lm3Qj | Looking to scale in the Obstructive Sleep Apnoea market.

Briscoe Group ($BGR.NZ) http://bit.ly/d2TXkr | Retailer is looking cheap against the peer group.

NZ Exchange ($NZX.NZ) http://bit.ly/H441n | The NZ market operator is trading at the top of their peer group.

Nuplex Industries ($NPX.NZ) http://bit.ly/IGbCf | Considering a domicile shift to Australia

Fisher & Paykel Appliances ($FPA.NZ) http://soc.li/0AlV6LR | Making breakthroughs in fridge technology.

If you want to follow us on Twitter we can be found @Valuecruncher

More on this topic (What's this?) Read more on Investing in New Zealand at Wikinvest

New updates to Valuecruncher.com

Tuesday, January 6th, 2009

We have been fairly quiet when we have released changes to Valuecruncher.com in the past and thought it was high time that we started sharing more about the enhancements.

Homepage enhancementspurchase viagra

rong>

Over the last few months we have overhauled the design of the company and valuation pages and it was time for the homepage to get a face lift. In this most recent release we have made the following tweaks:

  • A larger list of recent valuations
  • More visible help on how to create valuations
  • A link to our private company valuation service
  • Generally improved the visual appearance of the homepage

Valuation enhancements

Previously, if you updated an existing valuation it would replace your old valuation. We decided it would be more helpful to users to be able to compare new and older valuations they had created and therefore updating valuations will now cause a new one to be created.

Many other small tweaks

There have been many other small changes made around the site that are designed to improve your experience with the Valuecruncher site.

We appreciate any feedback that users have about the site and actively take it into account when planning new features (of which we have many on the way!). Drop a comment and tell us how we could help you better find stocks to buy or sell.

Running The Numbers – General Mills ($GIS). Trading Higher Than 12 Months Ago

Wednesday, November 19th, 2008

General Mills ($GIS) the manufacturer and marketer of branded consumer foo

buy propecia no prescription

ds (such as Cheerios, Betty Crocker and Hamburger Helper) is one of the rare stocks trading higher today than 12 months ago. How does the current share price of $GIS look from an intrinsic value perspective?

Valuecruncher valuation model of $GIS with interactive assumptions

Valuecruncher produces a valuation of US$64.06 for $GIS. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 1.9% below the current share price of US$65.33. We believe the stock is trading broadly in-line with the intrinsic value.

Assumptions

  • Revenue: Reuters aggregates 11 analysts covering $GIS and these analysts have mean estimates of 2009 and 2010 revenues of US$14.5 billion and US$15.1 billion respectively. For our analysis we have used US$14.5 billion in 2009, US$15.0 billion in 2010 and US$15.5 billion in 2011.
  • Profitability: We have used an EBITDA margin of 19.0% in 2009 rising to 20.5% in 2011. Reuters has $GIS‘s EBITD margin at 18.8% last year and averaging 21.1% over the last five-years.
  • Capital Expenditure: We have assumed capital expenditures of US$550 million per annum moving forward.
  • Discount Rate: 9.0%.
  • Terminal Growth Rate: 3.0%.

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

Play with our assumptions – what does your analysis say?

Disclosure: None

View the full GIS chart at Wikinvest
More on this topic (What's this?) Read more on General Mills, Henders Land Dev at Wikinvest

Running The Numbers – Comcast ($CMCSA) well below our intrinsic value estimate

Monday, November 3rd, 2008

Comcast Corporation ($CMCSA) is a US cable company. At 31 December 2007 the company had approximately 24.1 million video subscribers, 13.2 million Internet subscribers and 4.6 million phone subscribers. The stock has dropped nearly 30% this year. How does the current share price look from an intrinsic value perspective?

Valuecruncher valuation model of $CMCSA with interactive assumptions

Valuecruncher produces a valuation of US$23.70 for $CMCSA. This is a current valuation (an estimate of intrinsic value using a discounted cash flow model) not a target price. This valuation is 50.4% above the current share price of US$15.76. $CMCSA appears to be trading well below our estimate of intrinsic value – with what we believe to be conservative assumptions.

Assumptions

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

Play with our assumptions – what does your analysis say?

Disclosure: None

View the full CMCSA chart at Wikinvest

AT&T: Looks like a buy at $30

Wednesday, August 6th, 2008

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.

Valuecruncher interactive valuation of AT&T and assumptions.

Supporting points for buying AT&T at $30 per share:

  • 18 of the 28 analysts aggregated by Yahoo Finance rate AT&T a buy or strong buy.
  • Analysts mean target price for AT&T is $41.31a 37% premium to the current share price.
  • A P/E ratio (ttm) of 13.40 at the lower end of the 5 year range (10.50 – 22.10).
  • AT&T’s exclusive iPhone partnership with Apple and the recently released 3G iPhone selling at twice the rate of the original iPhone.

Downside considerations:

  • The impact of AT&T’s estimated iPhone subsidy of $300 per device on revenues and margins.
  • 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.

More on this topic (What's this?)
(T) AT&T Offers New Calling Plan
(T) AT&T Eyes High-Speed Fiber Plan
Read more on AT&T at Wikinvest

5 Steps to Valuing a Business

Wednesday, May 23rd, 2007

Often at first glance the process of valuing your business can appear time consuming and intimidating. At Valuecruncher we have streamlined the process to the point where all that is required is a 1 page Excel worksheet and Valuecruncher will provide you with a 5 page valuation report within 48 hours. This post outlines the 5 steps involved in the Valuecruncher valuation process.

1. Collect the relevant information

The starting point for Valuecruncher valuing a business is the latest financial statements. The business’ accountant should be able to provide you with a copy of these.

Financial statements include:

1. Profit & Loss Statement        

2. Statement of Cash Flows        

3. Balance Sheet

Some accounting jurisdictions don’t require a Statement of Cash Flows – that isn’t a problem.  The profit and loss statement and balance sheet are the key starting point for completing the input sheet for a Valuecruncher valuation.  The only component we require from the Statement of Cash Flows is the capital expenditure for the business.  If there are any questions about the relevant information required – please don’t hesitate to contact the Valuecruncher team (http://www.valuecruncher.com/contact/).

2. Input relevant information into the Valuecruncher 1-page input sheet

Profit and Loss Statement

We start with the Profit and Loss Statement.  We are interested in four inputs from the Profit and Loss Statement and information on capital expenditure: revenues, profitability, depreciation and amortisation charges, and capital expenditure.

Compiling the Valuecruncher valuation input sheet: Profit and Loss Statement items – Example

Cash Flow Statement
The Cash Flow Statement provides the information required to compile the capital expenditure inputs.
Compiling the Valuecruncher valuation input sheet: Cash Flow Statement items - Example

Projections

The next step is then projecting forward key numbers – revenues, EBIT, depreciation and capital expenditure.  Valuation is a forward-looking exercise, even if the business mature and stable it is still important to compile projections.  Valuation is based on future performance of the business.  This may be the same as the current performance but it can also be materially, or slightly, different – either better or worse.  For a Valuecruncher valuation the Profit and Loss Statement projections are the key input.  The key projections required for valuation purposes are revenues, profitability, depreciation and capital expenditure.

Each business is different and has different expectations of future performance.  If the business is stable and not expecting to grow significantly then making projections is reasonably straightforward.  When the business is going through significant growth or the market the business operates in is uncertain – then the process is slightly more difficult.  It is however a good process for a business to look at what financial results it expects over coming years.  Making financial projections is subjective exercise that reflects the best estimate of an uncertain future. Don’t be intimidated by the uncertainty involved in compiling projections, they are only meant to represent the best estimate. Valuecruncher valuation reports provides sensitivity analysis that illustrates how alternative projections impact on the business valuation.

At Valuecruncher we often see a reasonably high-level approach taken to valuation – which is just fine.  It is typical for a business owner to say something like “we expect revenues to grow at 10% per annum over each of the next three years with profitability (at the EBIT level) margin (as a percentage) remaining the same as it is today.  We expect depreciation and amortisation to remain about where they are today.  We will be spending an additional $50,000 in capital expenditure next year but then expect capital expenditure to remain at the current level”.  With information even at that simplified level – the Valuecruncher input sheet can be completed.  If a business has detailed financial projections then these should be utilised.  Most businesses do not however have detailed projections.  High-level assumptions are all that is required for completing the Valuecruncher input sheet.

Some more tips for making projections

Revenue projections – a simplified approach to revenue projections involves estimating the short-term (next 3 years) revenue growth as a percentage. The estimated percentage growth can be based on historic growth rates or incorporate any expansion plans the business has. Valuecruncher can assist to covert projected growth rates into actual revenue figures if required.

Profitability projections – the best starting point for projecting profitability is the current levels. If the business is planning to introduce new technology or has recently increased production capacity it is possible that profitability will increase in the future – but there is usually an increase in costs associated with additional profitability. If a business has an owner that works in the business at a below market salary – this should be adjusted to market levels.

Businesses run at break-even – Valuecruncher often sees businesses that are run at break-even.  Our approach to valuation with these companies is to look what the level of profitability that companies in the industry typically operate at.  Then we will extrapolate that industry average profit performance to the business’ sales.  This approach provides a reasonable assessment of the value of the business even when the business is operating at break-even.  We have a table of average industry EBIT margins (click here).  If you are unsure or have questions about the appropriate EBIT margin to potentially use Valuecruncher is happy provide assistance.

Capital expenditure projections – when estimating capital expenditure required by a business it is important to consider the current status of the business’ assets and any investment that may be required for replacements or upgrades. Other examples of potential capital expenditure include research and development expenses.  The Valuecruncher input sheet also requires a terminal capital expenditure amount – this is simply the “typical” level of capital expenditure that the business would anticipate into the future.  We include this amount to ensure that capital expenditure figures do not get inflated by current spending and truly reflect the on-going capital expenditure of the business.

Depreciation – the starting point for projecting the depreciation charge is the current amount. If the business plans to invest in fixed assets the depreciation charge can be expected remain constant and potentially increase. If the business has no plans to invest in its assets the depreciation charge can be expected to decrease.

Balance Sheet

The Balance Sheet inputs for the Valuecruncher valuation are only historic numbers – there are no projections required.

Compiling the Valuecruncher valuation input sheet: Balance Sheet items – Example

3. The valuation calculation
 Valuecruncher incorporates the projections and balance sheet values supplied by client (via the input sheet) into a discounted cash flow (DCF) model. Valuecruncher estimates the long-term growth rate and the required rate of return for the business. Valuecruncher will calculate the sensitivity of the valuation to the projected revenue and profitability supplied by the client. The sensitivity analysis provides an indicative valuation range.  The DCF valuation is supplemented by comparable company analysis and an asset based valuation.

Comparable Company Analysis – Valuecruncher has an extensive database of information on companies in a wide range of industries around the world. Using the database Valuecruncher will compare the DCF valuation output with the implied valuation based on prices comparable companies have sold for and trading prices of publicly listed companies. Comparable company analysis is a relative measure of value that provides a check for the DCF valuation. The comparable company analysis does not incorporate the unique features and opportunities of a business but provides a market-based estimate of value.

Asset Analysis – Valuecruncher calculates the value of the business’ net tangible assets (NTA). This is a purely accounting based measure that incorporates the current book value of the business’ assets.  NTA is not a forward looking approach and it does not evaluate the earning potential of the assets. The NTA methodology is often impacted by the accounting treatment of assets (i.e. depreciation policies).

These three valuation methodologies form the cornerstone of the valuation frameworks used in global investment banks and major accounting firms.

4. Valuecruncher review the valuation
 Upon completing the valuation calculations a member of the Valuecruncher team will independently review the valuation including the projections and inputs provided by the client and the assumptions applied.
Common issues identified with valuations include:

  • Client revenue projections are overly optimistic reflecting a “best case” scenario opposed to an expected case.
  • EBIT margins are too high because all costs are not being incorporated. Often the “actual” owner’s salary is not fully reflected in the financial statements.
  • EBIT margins are too low because the company is being run at breakeven point with the owner expensing items through the business that are not part of the business’ operations.
  • Projected capital expenditure does not reflect the investment required to generate the projected growth.
     

If Valuecruncher identifies an issue that materially impacts the valuation the client will be contacted to clarify the issue before the valuation report is generated.

5. Valuecruncher provide the valuation report
 Valuecruncher compiles the inputs provided and the valuation outputs into a five-page valuation report. The valuation is expressed as an indicative range based on the DCF sensitivity analysis with a mid-point reflecting the inputs and projections supplied by the client; this is supplemented by the implied comparable company and NTA valuations. The report includes a summary of the valuation outputs and highlights any assumptions that may need to be reviewed. If after inspecting the report and assessing any potential issues raised by Valuecruncher the client wishes to revise the initial inputs provided, Valuecruncher will provide an updated valuation report for no additional fee.

Get a Valuecruncher valuation - click here

Download a PDF version of 5 Steps to Valuing a Business - click here

 

More on this topic (What's this?)
Today's Leading Industry
Early Industry Leaders
Read more on HSBC HLDG, Cheung Kong (HLDGS) at Wikinvest

Bancroft’s oppose $5 billion offer for Wall Street Journal – What are they thinking?

Friday, May 4th, 2007

Valuecruncher Valuation Report – Dow Jones & Company 

Rupert Murdoch’s News Corp has offered $60 a share for The Wall Street Journal publisher Dow Jones & Company, the unsolicited offer values the company at over $5 billion. Dow Jones & Company’s other publications include Dow Jones Newswire, Barron’s and MarketWatch.com. Dow Jones & Company would provide an excellent fit with Murdoch’s upcoming launch of the Fox Business channel. Despite the offer of $60 per share representing a significant premium to the closing price on Friday 30 April 07 of $36.33 the Bancroft family who collectively represent approximately 52% of the voting rights have indicated they will oppose the offer.

Based on analyst’s projections Valuecruncher values Dow Jones & Company at $34.89 per share with a range of $28.21 to $41.93. Valuecruncher’s valuation is slightly below the pre-offer price of $36.33 and the Murdoch offer is considerably higher the than the upper end of Valuecruncher’s sensitivity range. The offer price of $60 implies and EV-EBIT multiple of 35.6 compared to the Valuecruncher mid-point of 21.3. Pearson’s whose operations include the Financial Times and book publishers The Penguin Group are currently trading at an EV-EBIT multiple of 16.

Based on the discounted cash flow and comparable company analysis Rupert Murdoch’s offer appears attractive. I will give the Bancroft family the benefit of the doubt and assume that they are playing hardball and waiting for Murdoch to increase his bid. In the absence of an alternative offer this one appears a no brainer – take the cash.

Valuecruncher Assumptions

Cost of Capital (WACC): 10%

Short-term EBIT Growth: 56% (2007), 17% (2008) and 19% (2009) – Based on analysts estimates.

Terminal Growth Rate: 3%

More on this topic (What's this?)
DJIA Chart – Almost Time to Sell in May?
Dow Dogs Are Outperforming This Year
Dow 20,000
Read more on Dow Jones Industrial Average (DJI), News Corporation at Wikinvest

You are currently browsing the archives for the Uncategorized category.

Subscribe

Blog posts Click for updates

Categories