Pages

Friday, August 1, 2014

flipkart gets global attention

The firm and its value
Flipkart was founded in 2007 spending Rs.400,000 on set-up costs. Today it is being valued at about $7 b (Rs.420 b) as a result of its recent capital raising. At least for these new capital providers the investment is about that big. 

That brings us to find out what kind of returns these investors are seeking. If we go by what the founders have in mind, that is about $100 b value in the next 10 years, the return is 30%. In 5 years it is 70%. Not bad, only if that happens.

Flipkart works with merchants to sell through its online platform (hosting third-party sellers) and earns a fee on sale. It is reported that the revenues last year were about $1 b and expected revenues this year are about $3 b; the growth is phenomenal. 

The market and its share
Nomura expects online retailing in India to reach $23 b in the next 4 years. China's e-commerce sales are pegged at $180 b currently which is 9% of the country's retail of $2,000 b, whereas India's online retail is less than 1% of total retail of $500 b. However, some expect that in the next 20 years it would be about 20% online. As per this report, online retail in India will reach $76 b by 2021 (that is 7 more years).

So it comes to two things: 1) Estimate the total retail market in the next 10-20 years; and 2) Estimate Flipkart's share in that market.

Revenues and margins
While revenues are growing, online retailers in India are not showing any profits yet. Revenues are one thing, but what really counts is the bottom line. Retail is a tough business. After all the years Amazon is not that profitable.

So how much can Flipkart get to where the barriers of entry are not that much? Amazon, eBay, Snapdeal, there could be many more in the competition, both local and global. 

Expecting that Flipkart would become profitable soon (how soon is estimation) is a reasonable assumption. However, the operating margins of online retailers are not very high. We can assign 5% pretax operating margin and 3.5% net margin. At present this is negative for the Indian online retailers. Return on capital for Walmart is about 16% and for Amazon is about 40%. Where would Flipkart be?

The $7 b value 
With starting revenues of $1 b, operating margin of 5% and return on capital of 25%, and a modest cost of capital, expected revenues in the year 11 would have to be $97 b for Flipkart to justify a valuation of $7 b today. I am assuming here that Flipkart is profitable from now itself which is not the case. There is also the assumption of the stable growth period where growth and margins are capped to more reasonable (stable) figures. The model shows that all the value is driven during the stable growth period because of heavy reinvestment that would be required during the high-growth period. Forget dividends; there aren't going to be any. In fact, Flipkart would have to raise capital a few more times during the period.

Amazon's revenues for 2013 were $74 b and for Walmart they were $466 b. From $1 b to $97 b in 10 years the revenues of Flipkart will have to grow at 58% annually. If the expected return (cost of capital) is higher (take your pick), revenues will have to grow at an astronomical rate; this is because revenues of $97 b will not be enough to justify $7 b. 

Of course, we can change any of the inputs and justify that, and that is left to anyone. 

Now, if we assume that in the next 10 years the Indian online retail market would be that of China's current, i.e. $180 b, Flipkart's share in the revenue would be about 54%. Can it pull it off? We just heard that Amazon is going to invest $2 b in its Indian retail operations. 

Alternatively, if we assume that Flipkart is not going to be profitable anytime soon, the model has to be revised. If we expect that it should take about 5 years to get to profitability, the minimum earnings will have to be about $1 b until perpetuity to get $7 b of market value of its equity. This assumes that Flipkart is in a stable growth phase until perpetuity which is really not the case, but the point is that you need those earnings to justify that value. Walmart had $17 b of earnings in 2013 and Amazon had $274 m.

The moral
The moral of the story is that I cannot value these firms since there are too many expectations to have beyond the boundaries. Having said all this it is kudos to Flipkart for getting global attention.

Wednesday, July 30, 2014

spice jet, not that spicy

If you run a bad business no amount of smartness can do any better due to the inherent qualities of the business. Yet, people don't care. The result?



How much income have these businesses generated for the capital providers? Or should I rephrase that question to why do people invest in a bad business?

A not-so-smart investor would have made 70% over the last five years and about 179% over the last ten years, while the airlines gave nothing but pains to the stakeholders. 

Spice Jet is in trouble; King Fisher is already in trouble; and Jet Airways is looking at losses and debts. We already know about Air India and Indian Airlines, but don't have information about the other airlines which are not publicly traded, but here is the picture: 


What are these airlines doing, building castles in the air? These businesses require tons of money on a regular basis, yet don't earn enough on that capital. If you are in a bad business, you generally can't help it, or help yourself. What a business it has been - large capital, losses; more capital, more losses - a global airline phenomenon.

Today, Spicejet is available at Rs.7.50 b; Kingfisher at Rs.2.50 b; and Jet Airways at Rs.28 b; Any takers?

Who is learning? Not many, we guess. Is that pride and status, or hubris?

Saturday, July 26, 2014

is tcs worth $85b

I have to admit that I am not a fan of technology companies simply because my background is not technology and I am not particularly interested in learning about what these businesses do.

Nonetheless, when an Indian outsourcing company whose business was skilled labor arbitrage is making headlines regarding its size, it is a matter of some interest.

As per the PwC report the top technology companies by market capitalization as of 31 March 2014 are as follows:

I am not sure whether MasterCard is a technology business, that's not relevant though. Let's leave out TCMC as well. We have then SAP at $99 b of market value. Compare this to TCS which is now worth about $85 b (Rs.5,104 b). Is this a fair game? This report says that it could reach a market valuation of $100 b.

Before we discuss the story behind the game, let's look at some data.

TCS is now by far the largest company in terms of market cap in India:


It has beaten its Indian competitors hands down:


Its stock performance in the past five years has been outstanding:


All the reasons to cheer for the shareholders. However, when market value of its equity was about $65 b in October 2013 I argued that it was overvalued. There is no vindication as yet. Who is going to talk to the markets?

I had asked, is TCS worth $65 b? Now the same question looms, is TCS worth $85 b? Let's check its fundamentals, that is, its capacity to grow its cash flows.

TCS has shown impressive margins and return on capital over the years. It has also managed to keep taxes down - with an average effective tax rate much lower than the marginal tax rate.


Its free cash flow to firm (FCFF) has grown from Rs.12 b in 2006 to about Rs.124 b in 2014.

There is no debate: Historical performance of TCS has been quite good, and naturally, the market has rewarded its stock too. Currently it trades at a PE ratio of over 25 which is close to its historical high PE ratio.

Our next analysis is to assess its growth rate and growth period - at what rate will TCS grow from now until it becomes a mature business, and when will it become a mature business? There are no easy answers to these questions.

There is another way: It is far convenient to question the market's valuation rather than making predictions (on cash flows and growth) on our own especially for an information technology business. So here I go:

Assuming that TCS will continue (will it?) its show over the next ten years - the current return on capital of 58.61% will be sustained over five years, reducing over the next five years to reach a stable period return on capital of 25% at perpetuity. Pretax operating margin of 29.10% over five years, reducing over the next five years to reach a stable period margin of 20% at perpetuity. Effective tax rate increasing over the period to reach the marginal tax rate at year 11 - to get to the current market valuation of equity at Rs.5,104 b, TCS has to grow over 26% in the first five years and over 15% in the next five years. I usually do not violate the terminal period assumptions on growth rate, margins and return on capital, yet, I do consider that perpetual margins and return on capital assumed for TCS are more than modest.

Now, we can rephrase our original question from, is TCS worth $85 b to can TCS grow at 26% in the first five years and at 15% in the next five? Also, can it continue to sustain its high operating margin and return on capital?

The market has its own reason:

It is left to the investors to make a call on this, although it is worth noting that its revenue should reach Rs.5,576 b in the next 10 years with those growth rates. Is that possible? Sure; but, I am not going to bet on that.

Tuesday, April 22, 2014

diageo's fantasy has a cost

Diageo is taking steps ahead to complete its acquisition of a controlling interest in United Spirits. The last time I discussed this was in February 2013 when acquisition of shares based on a preferential issue to Diageo at Rs.1,440 per share put a value on the total equity of United Spirits at Rs.206 b. 

Well, since that time much has taken place; some as envisaged, and some not as much. As of 31 March 2014, Diageo owns 41.83 m shares of United Spirits, and United Breweries Holdings owns 8.62 m shares. 

Subsequently in April 2014, Diageo has come up with an open offer to acquire more (37.78 m) shares at Rs.3,030 per share, a significant premium to its original plan. With this offer Diageo considers that United Spirit's equity is more than Rs.440 b; its current market value is about Rs.415 b. Just for comparison in February 2013 it was Rs.247.86 b. This 67% increase in the market value is due to the expectations that Diageo would increase its offer price; and it did.

Now let's discuss whether United Spirits is worth that price.

Based on the provisional numbers supplied, its book value of debt as of 31 Dec 2013 was Rs.77.94 b and it had cash and investments of about Rs.4.5 b. Its expected revenues based on extrapolation for the full year are about Rs.108 b. Over the last five years, revenues have grown by 17.87% annualized; good stuff, there it ends though. Its operating margins have been falling since 2008 which currently stands at about 7%. Operating income in 2013 was not sufficient enough to cover finance costs of Rs.9.8 b; fortunately, its other income has been substantial due to interest on cash, income from IPL franchise and other items. I am not sure why United Spirits presents income from IPL franchise as part of its operating revenue. Its return on capital is less than 4%. Since its 2008 acquisition of Whyte & Mackay assets United Spirits book capital has increased significantly. With no corresponding increase in operating income the return on capital is affected adversely; Its 2013 operating income was lower than that of 2008. Now Diageo has to offload Whyte & Mackay assets back to the market at lower than its cost as per this report.

I am sure Diageo must have thought something about United Spirits; probably as its playground to increase market share, may be; Or it could be just one more expensive acquisition.

To justify Rs.415 b value for equity we have to do some reverse thinking to get the implied assumptions involved in valuation.

However, even with robust and optimistic assumptions I have found it a bit hard to come around and think like Diageo in justifying this acquisition at the price offered which is in fact higher than Rs.415 b.

I used a much higher operating margin of 15% which except for 2008 it hasn't reached at least in the last eight years I have looked at; and assumed a very low effective tax rate to begin with and expected it to reach the marginal tax rate on a gradual basis. With these assumptions I checked what combinations of return on capital and growth rates are required to get the current market value of Rs.2,853.95 per share. In all the scenarios United Spirits is expected to reach the stable growth period gradually, and accordingly demonstrate the characteristics of a stable growth firm; this means naturally there is a cap on the growth rate and return on capital until perpetuity.

Here's how it looked:

For instance, at 50% return on capital United Spirits should grow at about 35.75% in the next five years to justify the current market price; furthermore, the return on capital and growth rate should still have to be higher in the subsequent five years, although these should become lower gradually until the firm reaches the stable growth period. This means United Spirits should have to display extraordinary return on capital and growth rates in the next ten years in order to justify the current market price. Alternatively, at 25% return on capital (which is way higher than what it is currently) it has to grow at about 53.75% in the next five years.

I also looked at Diageo's operating margin and return on capital which stand at about 30% and 19% respectively. At these rates United Spirits will have to grow at 47% in the next five years.

An important aspect which is often forgotten in zest is that for a firm to grow it has to reinvest certain portion of its after-tax operating income; without this any firm can magically get to the desired value, albeit on paper.

In fact, as the return on capital becomes lower reinvestment required by United Spirits to get to the market price becomes higher. At 30% return on capital, reinvestment required exceeds 100% which means value generated during the first ten years becomes negative, and therefore the entire market price has to be powered by the terminal value.

Because of this reason, any higher operating margins at return on capital lower than 30% (and at the corresponding growth rate) would actually bring the value lower due to the burden on the terminal value, and it not being able to compensate for the initial ten years of negative values.

However, when return on capital is 40% (with the corresponding growth rate) or more, higher operating margins would be able to generate higher value.

It is also nice to check revenues at year five and year ten arrived at based on any growth rate assumptions, and ask whether these are achievable considering the available market, competition and market share. I checked, but then decided not to plot them on the graph...

If Diageo considers that any of these (or any other) combinations is possible, there is more power to this deal.

There is no fine on dreaming, is there? Nevertheless, if the dream is going to cost the shareholders there should be some fine...but how much?

Wednesday, April 16, 2014

is it a bargain deal for sun pharma

Expensive stock acquires (cheap?) stock
Sun Pharma has agreed to acquire 100% of Ranbaxy in a multi-billion dollar deal. The transaction will result in a combined entity which will play a dominant role in the specialty generics segment.

Whenever an acquisition takes place it is justified with a number of arguments in its favor; the most common are: strategic advantage, control, and synergy.

Let's still ask the question: Is this deal good for the shareholders of both Sun Pharma and Ranbaxy? If it is not, obviously the deal is superfluous, waste of resources, at least for one firm.

First, this will be an all-stock transaction; which means there will not be any direct and immediate impact on cash. When an acquisition is done through stock it is important to know whether stocks of both the acquirer and target are expensive or cheap compared to the quoted market prices. Without this understanding we cannot conclude whether the deal is value accretive.

Just before the announcement Ranbaxy was quoting at Rs.459.55.


And Sun Pharma was quoting at Rs.571.80.


In accordance with the deal, Ranbaxy shareholders will receive 0.80 share of Sun Pharma for each share of Ranbaxy. Based on the stock price of each firm the transaction (exchange ratio) appears to be at the current market prices. 

We can see that both stocks have popped up in the subsequent days; Ranbaxy quoting at Rs.468.40 on 11 April, and Sun Pharma at Rs.627.20. Sun Pharma has shown more optimism to this deal though as the stock has rallied about 9.60% in four days. The market must be considering that the deal is a bargain for Sun Pharma. Is it so?

The past performance
Let's start with the market value of the firms before the deal. 


This is how the firms have performed:

Past 6 months:


One year:

Two years:


Five years:


Struggling Ranbaxy
Now let's move to Ranbaxy. I am not sure whether it has actually returned 147% in the last five years; in 2008 and 2009, the market value of its equity was higher. Even in December 2004 Ranbaxy's market value of equity was Rs.236 b; now it is pretty much the same, in fact a bit lower at Rs.196 b.

This is how it has moved over the years.


Let's not do any compounding; we know that it is not so good.

The 2004 annual report had the following forecast:


Its 2012 revenues were a little more than $2 b, and for 2013 a little less than $2 b.

Assumptions drive analysis
Ranbaxy's 2013 annual report is not yet released. That's some problem, but not much. With Rs.108 b of revenues and Rs.4.4 b of operating income in 2013, the pretax operating margin is only 4.10%; it was about 12% in 2012. This compares pretty low with Sun Pharma's operating margin of about 42%. Similarly, return on capital of Ranbaxy is about 8% compared to 45% of Sun Pharma.

It is only fair to consider that the current fundamentals of the firms would drive their growth for the next five years. After that it is expected that Ranbaxy would move towards better margins and return on capital, and both Ranbaxy and Sun Pharma would become stable growth firms.

With these assumptions, the gap between market values of equity of Ranbaxy and Sun Pharma which is currently about 6.52x should come down only slightly but not significantly if these are independently valued. This is simply because in the next five years Ranbaxy should grow at much lower rate and Sun Pharma at much higher, and thus already building a base effect.

Since these firms are going to merge going forward, the benefits of synergy, if any, can add value to the combined firm. Obviously, the value of Synergy will depend upon the assumptions related to the benefits of synergy. Sun Pharma might have made assumptions such that synergy benefits accruing to the combined firm would make the acquisition justifiable.

With a generous dose of synergy benefits translating into better margins and return on capital, the deal appears to be indeed a bargain for Sun Pharma. If synergy benefits were lower or not to be there, obviously the bargain should reduce.

The bargain lies in the future
In the final analysis it all depends upon how Ranbaxy shapes up in the coming years; better operating margins and return on capital, combined with adequate reinvestment, including in research and development, should increase the value of the combined firm. Will this happen? Sun Pharma would expect so.

Can Ranbaxy catch up with Sun Pharma in terms of margins and return performance? Sure it can, and if it does, it is a real bargain deal for Sun Pharma.

The bigger bargain
There is one thing that is clear: Sun Pharma is using its over-priced stock to acquire Ranbaxy which is struggling at the moment. This itself could be the the real bargain.

Saturday, April 5, 2014

hdfc bank - is the market the truth

The multibagger bank
HDFC bank is one of the largest private sector banks in India. In about two decades of operations its market value of equity has reached Rs.1740 b. 

HDFC group holds about 22.64% of shares in the bank, and about 34% is held by the foreign institutional investors. Obviously, the market price is driven by the whims of the FIIs.

One year is good:


Two years is better:


Five years is even better:


If you had bought the stock in 1998 you would have made a lot of money:


The expectations are in tact:


The fundamentals
What is it that has made the bank the market's darling? Its earnings are increasing. In 2013 it earned Rs.68,696 m compared to Rs.22,489 m in 2009, an annual growth rate of over 32%. Its book value of equity has increased at 24.83% over the period.

For any bank the key factor is the quality of book value since poor judgment in granting loans would result in erosion of equity. Furthermore, banks have loads of debt on the balance sheet because that is their capital for growth. Therefore, it is a dangerous game to consider book value growth in isolation. It is also very difficult to estimate the percentage of bad loans which can only be analyzed in hindsight.

Since the FIIs are fond of HDFC bank the assumption probably is that its non-performing assets are on the lower side, and EPS growth rate is on the higher side. That's cool.

The bank's return on equity has consistently improved from about 14.90% in 2009 to about 22.74% in 2013.

So far the fundamentals of the bank appear to be good without having a judgment on the quality of its loans, and consequently, its book equity.

The latest quarterly numbers look good too. Heck, these are neither complete, nor consolidated financials.

Value and price
I have used the last audited consolidated financial statements as of 31 March 2013 which should be alright for our purposes, although we are about a year behind. I know twelve months are too long for markets; I can't help that though.

The bank had book value of equity per of share of Rs.154 as of 31 March 2013, earnings per share of Rs.28.87, and paid out dividends per share of Rs.5.50.

We have a few options here in picking EPS and ROE as the basis for estimating value. The assumption naturally is that over time the bank will increase its dividend payout ratio, and move towards becoming a stable-growth firm.

With the current EPS and ROE as the basis, and at the current stock price of Rs.725, the markets seem to be over-optimistic about its prospects.

With EPS and ROE normalized, a more reasonable approach considering our concerns on assessing quality of book value of a bank, the markets seem to be going overboard as the market price appears to be way too high. May be I am too conservative in this approach.

Catch the markets off guard
I finally let the market tell me its expectations on the stock; and here it is:

With the normalized numbers as the starting point, the market is expecting that the EPS growth rate in the first 5 years will be about 38.05%, and gradually drifting down in the next 5 years.

With the current numbers as the starting point, the market is expecting that the EPS growth rate in the first 5 years will be about 28.91%, and gradually drifting down in the next 5 years.

Alternatively, with the expected growth rate based on the current numbers, the market is estimating cost of equity of about 3.25% in the first 5 years, and gradually moving up towards the stable growth cost of equity in the next 5 years.


Seeking happiness
Our course of action: Do some thinking on the fundamentals of the bank, its value and price, or clap along if we feel like the market is the truth.

Friday, April 4, 2014

is there any folly in these markets

All markets are moving in a direction, upwards.

S&P-500 is up.


Sensex, Nifty and Mid-caps are up too.


The general feeling appears to be great when markets are rising, indicating some kind of a bull run. However, optimism has a cost as well; over-optimism in conjunction with hubris surely has. When emotions flow without restraint something goes wrong; invariably so when it comes to the financial markets. These markets do not understand human emotions, greed or fear, hubris or any other. Lest the costs become heavy, it is wise to keep a cool head, feet on ground, and emotions in check under all conditions.

These thoughts alright; the question is whether these markets are exhibiting any folly today. Nifty is currently trading at its all time high of 6736.10, with a PE ratio of 18.95, PB ratio of 3.25, and a dividend yield of 1.37%. Sure, it has seen much higher PE and PB ratios, and much lower dividend yields in the past. That does give some comfort, but not much.

There is another way to check whether Nifty is too high or not. Implied equity risk premium in the market price should tell us something about where the market is headed. It may still not be fully conclusive though. Since the dividend yields on the Indian markets have been too low, implied variables resulting from dividend discount model would not be that appropriate. Instead, free cash flows to equity based valuation should make sense. Earnings growth rate is assumed to be same as dividends growth rate which is alright since dividends usually follow earnings. Implied dividends growth rate, and then implied equity risk premium are calculated from the current market values.

The long-term government bond rate of 8.81% adjusted for default risk is used as a proxy for risk-free rate. Currently, Nifty has return on equity of 17.15% and dividend payout ratio of 25.96% which are not too far away from the long term average values.

Equity risk premium supplies some clue about the direction of the market; higher premium suggests that market is undervalued, and vice versa.

Based on the current market values of Nifty the implied equity risk premium is estimated at about 4.08%; with a historical average of 5-5.50%, it appears that Nifty is a bit overvalued.

It is a bit of fun to check out the equity risk premium values implied in the historical market values of Nifty.


The exercise is more out of curiosity than anything else. It tells something though...for those who are looking for clues. Are the markets heading towards a bubble, or not yet?

We are not near that dot-com bubble of 2000 yet might give some solace. Let's not make too much out of these, nevertheless.

The folly is always with us, never with the markets. Time to make detour with caution, I reckon.