Purchase Solution

Not what you're looking for?

This question requires you, among other things, to calculate the stock price for Facebook, and provide the needed analysis as asked in what follows. You will need to use "Sources of Financial Data" to obtain the necessary financial info/statements for Facebook, Inc., identify its peer companies and obtain pricing and financial information for them.

A. Develop a DCF model using Excel to estimate the fair value of the firm's common shares on May 21, 2012 - for historical numbers use the data from SEC filings including S-1 form with all amendments and 424B4 form (Prospectus), and other sources of financial data. Don't forget to include the terminal value (value after the forecast period) in your estimate.
B. For each of the value drivers (i.e., revenues growth and profit margin over the forecast period, tax rate, WACC etc.), identify your sources and assumptions, and show all you calculations. This is especially important for the WACC that you will use to calculate the NPV, due to the sensitivity of your results to this critical parameter.
C. Perform a sensitivity analysis for WACC, growth rate and profit margin.
D. Using comparable ratios of peer companies, estimate the company's stock price on May 21, 2012. List the major assumptions and sources of information that you used in your calculations. Were your assumptions reasonable enough? Explain.
E. Facebook, Inc. went public on May 18, 2012. How do your DCF and relative valuations compare with the company's IPO price? Its first-day closing? If your valuations differ from observed prices, can you briefly forward any possible explanations?
F. In 2007 it was rumored that Microsoft offered to buy Facebook. Eventually, it did acquire a very small stake in the company. What is your estimate of a fair value of Facebook to Microsoft at that time? What were Microsoft strategic considerations of this deal?
G. In May 2009, Mail.ru Group Limited invested \$200 million in the company by buying 44,037,540 shares of Series E convertible preferred stock. If Mail.ru Group could sell these shares at the IPO, what would be its annualized return? Can it sell these shares? Explain

Make sure to justify your responses by using the available data/info and carrying out any needed and relevant calculations.

Here is the part of this list:
- Yahoo Finance;
- Reuters;
- Edgar (SEC source of 10-K, S-1 form, Prospectus and other required financial reports);
- Hoovers (general company information);
- Bloomberg (a good source of interest rate data);
- Wall Street Journal (free site of the famous newspaper);
NYSE Euronext (New York Stock Exchange website);

##### Solution Summary

The valuations of Facebook requirements are examined.

Solution provided by:
###### Education
• Chartered Accountant (Equivalent to CPA in US), Institute of Charted Accountants of India
• Bachelor of Commerce, West Bengal University
###### Recent Feedback
• "I got this feedback and I wanted to know if you can explain it to me. I noticed something within your workings which I believe is incorrect.  It looks like you've mistaken the Debt ratio for the Equity Multiplier.  You've done a calculation to determine Return on Equity (ROE) but if you take a look at the ratios provided for us you'll see ROE listed on the bottom line already.  You can use ROE, Profit Margin and Total Asset Turnover to figure out the Equity Multiplier amount.  Equity multiplier is not provided for us and we need to calculate it.  I really hope this is helpful to you.  "
• "Very attentive to detail. Answers are designed in easy to understand format."
• "Fast response and thorough answer"
• "thank you very much! "
• "thank you so much !!!!!!!"

##### Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

##### Operations Management

This quiz tests a student's knowledge about Operations Management

##### Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.