Question

In: Finance

Can you do a comparable valuation for alibaba? Use the easiest ratios you can and make...

Can you do a comparable valuation for alibaba? Use the easiest ratios you can and make it less than 3 minutes

Solutions

Expert Solution

The comparable valuation of Alibaba is done as follows

The three most commonly used valuation ratios are used in order to value the compare the financials and arrive at a relative valuation

1. EV/SALES

2. EV/EBITDA

3. P/E or the price earnings ratio

The Market data collected inc;udes

Market data

Company

Price

M.Cap

Enterprise Value $

Alibaba

294

43652

7130

Tencent Holdings

557

20452

1660

The LTP of the share

The Market Cap

And the Enterprise value which includes = Market cap +debt – cash

The Financial data includes

Financial data

Sales

EBITDA

Earnings

2589

905

2012

321

405

1254

Sales

EBITDA

And Earnings data of the company

Now we calculate the valuation ratios as :

EV/SALES = total EV / total sales

EV/EBITDA= EV / EBITDA data

PE ratio = price of share / eps

=Price of share / ( Total earnings/(M.cap / Price of share ))

Market data

Financial data

Valuation Ratios

Company

Price

M.Cap

Enterprise Value $

Sales

EBITDA

Earnings

EV/SALES

EV/EBITDA

P/E

Alibaba

294

43652

7130

2589

905

2012

2.754

7.878

21.696

Tencent Holdings

557

20452

1660

321

405

1254

5.171

4.099

16.309

Average

3.963

5.989

19.003

· So from the data we can see that

· p/e ratio of alibaba is higher than the comparable company and also I to the average industry standards

· The EV/sales or the enterprise value to sales of Alibaba is higher than that of Tencent corp, hence the company is costly in terms of its enterprise value to sales ratio

· EV/EBITDA of alibaba is also higher than the industry standards , however it is considered healthy as it is below the acceptance standards of 10.

Thanks


Related Solutions

There are two major approaches to corporate valuation: a) using comparable firms (via multiples, i.e. ratios)...
There are two major approaches to corporate valuation: a) using comparable firms (via multiples, i.e. ratios) and b) discounted cash flows based methods (FCF models, capital budgeting metrics all fall into this category). Based on the case, which method (A or B above) do you find more useful? Briefly discuss relative strengths and weaknesses you can think of for both methods. Answer detailed.
You are trying to value a company using the relative valuation approach. Suppose comparable companies are...
You are trying to value a company using the relative valuation approach. Suppose comparable companies are trading at an average trailing EV/EBITDA multiple of 5.7. The company you are valuing generated an EBITDA of $271 million over the last twelve months, has $386 million of debt, $51 million in cash, and 13 million shares outstanding. What is the company's implied share price? Round to one decimal place.
Examine the financial ratios, stock valuation and news about Amazon. Do you see the firm’s share...
Examine the financial ratios, stock valuation and news about Amazon. Do you see the firm’s share price rising/decreasing in the near-, intermediate- and long-term? Do you believe the firm has a stable future of sustainable growth, currently stagnant, or is heading for financial failure? Why?
1. Examine the financial ratios, stock valuation and news about Walmart. Do you see the firm’s...
1. Examine the financial ratios, stock valuation and news about Walmart. Do you see the firm’s share price rising/decreasing in the near-, intermediate- and long-term? Do you believe the firm has a stable future of sustainable growth, currently stagnant, or is heading for financial failure? Why? 2. Would you invest in Walmart? Why or why not? through their 10 k filling or using recent price
1. Examine the financial ratios, stock valuation and news about Amazon. Do you see the firm’s...
1. Examine the financial ratios, stock valuation and news about Amazon. Do you see the firm’s share price rising/decreasing in the near-, intermediate- and long-term? Do you believe the firm has a stable future of sustainable growth, currently stagnant, or is heading for financial failure? Why? 2. Would you invest in Amazon? Why or why not?
Do you see the use of ratios as a tool in the evaluation and decision making...
Do you see the use of ratios as a tool in the evaluation and decision making process?
Problem 2 - Use of Ratios to Make Other Calculations You have a company that currently...
Problem 2 - Use of Ratios to Make Other Calculations You have a company that currently has a market capitalization of $4.6 billion It has a market to book ratio of 3 and a book debt to equity ratio of 6. If cash is $1.1 billion, what is the company's enterprise value? Solution: Discussion of the Dupont Formula The Dupont Formula is a way of disaggregating the components of ROE ROE = Net Margin X Asset Turnover X Equity Multiplier...
Can you look at financial statement and comparable analysis  position to do a 3 minute stock pitch...
Can you look at financial statement and comparable analysis  position to do a 3 minute stock pitch about Netflix? Give 3 reasons why you would pick this stick, whether it would be on sell or buy and risk involved. consider price/earning too. Please provide all details
In the attached table, you are given valuation ratios for Eli Lily & Co. as well...
In the attached table, you are given valuation ratios for Eli Lily & Co. as well as select competitors and the pharmaceutical and biotech industry. Using this data, assess whether Eli Lily & Co. is correctly valued. Explain your rationale. If, in your opinion, it is not correctly valued, explain whether it is overvalued or undervalued and the basis for your opinion and what ratios support your conclusion. Row headers in order: Price to earnings (P/E), Price to next year...
Many analysts prefer to use a relative valuation technique, such as comparing P/E ratios, because these...
Many analysts prefer to use a relative valuation technique, such as comparing P/E ratios, because these techniques are more grounded in theory than the DCF approaches. True or False?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT