Archive for March, 2010

Why You Should Back Your Own Analysis – The Private Equity Example

Sunday, March 14th, 2010

/* var quicktagsL10n = {
quickLinks: "(Quick Links)",
wordLookup: "Enter a word to look up:",
dictionaryLookup: "Dictionary lookup",
lookup: "lookup",
closeAllOpenTags: "Close all open tags",
closeTags: "close

tags”,
enterURL: “Enter the URL”,
enterImageURL: “Enter the URL of the image”,
enterImageDescription: “Enter a description of the image”,
fullscreen: “fullscreen”,
toggleFullscreen: “Toggle fullscreen mode”
};
try{convertEntities(quicktagsL10n);}catch(e){};
/* ]]> */

edToolbar()

In November 2006 – Telecom New Zealand ($TEL.NZ) announced plans to sell their directory business in a competitive process. Analysts placed a range of values between NZ$1.5 billion to NZ$2.2 billion. I ran some numbers and came up with a NZ$850 million valuation – using Yell Group ($YELL) in the UK as a comparator. In my analysis I wrote the following paragraph:

I believe these numbers (NZ$1.5-2.2 billion) are fantasy.  The top of our valuation – based on sensitivities – is NZ$1.1 billion.  Using the current 13.8x Yell multiple gives a valuation of NZ$1.21 billion.

As a result of some discussions I revised the analysis 24 hours later with some more aggressive assumptions. My updated valuation was NZ$1.10 billion with a range of NZ$867 million to NZ$1.36 billion.

But hey – there was a fully-fledged private equity boom going on. What did I know.

In early 2007 to get to the short-list of potential acquirers for the Telecom New Zealand directory business required a NZ$2.1 billion bid. I wrote yet another piece – with the following excerpts:

But it appears our valuation was wrong.  The rumours in the market were that it took NZ$2.1 billion to make the short-list and the four finalists are all private equity players.  Our valuation was NZ$1.1 billion – that is a long way short of NZ$2.1 billion.

Here at Valuecruncher we back our analysis – and when we are that far out we want to know why.

and

This has been bugging me – I don’t like being this far out on valuations.  I like to think it isn’t typical.

Then I proceeded to explain the bid valuation as best I could (summary – really cheap debt).

In March 2007 with the closing of the sale to CCMP I noted:

Valuecruncher believes the result is an excellent one for Telecom.

Since 2007 it hasn’t been an easy time for owners of highly leveraged directory assets. Debt isn’t as cheap as it was (check out this Bloomberg piece from February 2007 – the world has changed). Another strange thing – people are also using this internet thing where they previously relied on services like directories. That means there is pressure on key directory revenue streams (like advertising).

There is a long piece in the New Zealand media today (Sunday Star Times written by Tim Hunter) about the challenges facing the directory business – now called Yellow Pages Group. It quotes a number of unnamed sources using Yell Group ($YELL) in the UK as a valuation comparator (“Yell in the UK has just restructured and trades at seven times earnings“). With Yellow Pages Group having EBITDA of around NZ$130 million – that places an enterprise value on Yellow Pages Group of “NZ$750-$800 million“. Note the article has senior debt holders being owed NZ$1.2 billion – ouch. The article is a good piece of analysis by Tim Hunter.

Our Valuecruncher interactive analyst report for Yell Group backs up this analysis (have a play with the DCF tab as well). A 6.3x EV/EBITDA multiple for Yell Group and a NZ$130 million EBITDA gives an enterprise value for Yellow Pages Group of NZ$819 million. Enterprise value is the value of the whole business (equity and debt).

Hold on – isn’t that just about where I started?

Lesson: Do robust analysis and run the numbers – and back that (even in the middle of a private equity boom).

edCanvas = document.getElementById(‘content’);

More on this topic (What's this?) Read more on Private Equity at Wikinvest

Running The Numbers – Telecom New Zealand ($TEL.NZ)

Thursday, March 11th, 2010

/* var quicktagsL10n = {
quickLinks: "(Quick Links)",
wordLookup: "Enter a word to look up:",
dictionaryLookup: "Dictionary lookup",
lookup: "lookup",
closeAllOpenTags: "Close all open tags",
closeTags: "close

tags”,
enterURL: “Enter the URL”,
enterImageURL: “Enter the URL of the image”,
enterImageDescription: “Enter a description of the image”,
fullscreen: “fullscreen”,
toggleFullscreen: “Toggle fullscreen mode”
};
try{convertEntities(quicktagsL10n);}catch(e){};
/* ]]> */

edToolbar()

It has been a tough and challenging 2010 for Telecom New Zealand ($TEL.NZ) – New Zealand’s largest listed company. $TEL.NZ is trading close to a 52-week low at NZ$2.24. There has been widespread outages on their mobile XT network and yesterday a group of New Zealand entrepreneurs (including Valuecruncher investor Lance Wiggs) announced a new international broadband initiative to complete with the Southern Cross Cable Network (of which $TEL.NZ is the largest shareholder). Time to look at some valuation numbers – where is $TEL.NZ coming out?

Valuecruncher Interactive Analyst Report For $TEL.NZ

Discounted Cash Flow Valuation

We have completed a discounted cash flow valuation using our interactive tools (there is a “discounted cash flow analysis” link just under the company name on the company page). We have populated our model with a mixture of consensus analyst estimates and Valuecruncher estimates. Our analysis produces a valuation of NZ$2.70 for $TEL.NZ – 20.5% above the current share price. We see $TEL.NZ undervalued at the moment. But how about compared to a peer group?

Comparator Analysis

I am going to look at only one of the metrics we use at Valuecruncher – EV/EBITDA. Enterprise Value (EV) is simply market capitalization plus net debt [long-term borrowings less cash]. We use EV to capture the impact of debt and cash on a company’s balance sheet – market capitalization doesn’t capture different capital structures when comparing companies. EV/EBITDA shows how a dollar of profit (measured in as Earnings Before Interest Taxes Depreciation and Amortization) is being valued by the market against the comparator set.

On an EV/EBITDA basis $TEL.NZ is trading at 3.7x ($TEL.NZ is being valued at 3.7x last year’s profit at the EBITDA line). A dollar of $TEL.NZ EBITDA is worth less than a dollar of $T, $VZ, $VOD.O or $TLS.AX EBITDA. $TEL.NZ is a smaller scale but broadly similar business – $VOD.O is perhaps an outlier.

If we raise the $TEL.NZ EV/EBITDA multiple to the average of $T, $VZ and $TLS.AX (4.7x) then this gives a share price of NZ$3.17 – 41.5% above the current share price. This valuation is in line with our DCF analysis – but even higher.

telnz-20100312

telnz-v2-20100312

Summary

Based on our DCF valuation – $TEL.NZ looks undervalued. Looking at some comparators – the market is valuing $TEL.NZ lower compared to the peer group. $TEL.NZ looks cheap at current prices – even with the challenges the business is facing.

Disclosure: no positions.



edCanvas = document.getElementById(‘content’);

More on this topic (What's this?)
Two Trades Executed
New Zealand's Bakken
Thoughts on Green Telecom
Read more on Investing in New Zealand, Telecommunications at Wikinvest

You are currently browsing the Valuecruncher blog archives for March, 2010.

Subscribe

Categories