Perform a sensitivity analysis for wacc

Assignment Help Finance Basics
Reference no: EM13288071

This question requires you, among other things, to calculate the stock price for Groupon Inc, and provide the needed analysis as asked in what follows. You will need to use "Sources of Financial Data" listed in Course Content to obtain the necessary financial info/statements for Groupon 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 at the end of 2011 - for historical numbers use the data from SEC filings including S-1 form with all amendments and 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 at the end of 2011. List the major assumptions and sources of information that you used in your calculations. Were your assumptions reasonable enough? Explain.

E. Groupon Inc. went public on November 4, 2011. How do your DCF and relative valuations compare with the company's IPO price? Its first-day closing? Average price for trading period in 2011? If your valuations differ from observed prices, can you briefly forward any possible explanations?

F. A year earlier, in November 2010, it was rumored that Google might acquire Groupon at $6 billion, but the acquisition never realized. What is your estimate of a fair value of Groupon to Google at that time? Please don't forget a possible synergy.

G. In November 2009, Accel Growth Fund invested $20 million in the company by buying 2,932,553 shares of Series E convertible preferred stock. What was the realized IRR of this investment, if "Each share of Series E preferred stock was converted into 12 shares of Class A common stock on October 31, 2011" (Amendment No. 8 to form S-1, filed with SEC on November 2, 2011, page II-3)?

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;
• Google 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);

 

Reference no: EM13288071

Questions Cloud

What is the stock expected dividend yield : If D0 = $2.25, g (which is constant) = 3.5%, and P0 = $52, what is the stock's expected dividend yield for the coming year?
What is the transformer used for in a full wave rectifier : What is the transformer used for in a full wave rectifier Can you make a bridge rectifier without a transformer What are the advantages of using a transformer If you initially have a transformer with a 1:1 ratio
How far is the mirror from the mans face : A concave shaving mirror has a radius of curvature of 40.1 cm. How far is the mirror from the man's face
What is the best estimate of stock current intrinsic value : The required return on WWW's stock is 9.00%. What is the best estimate of the stock's current intrinsic value?
Perform a sensitivity analysis for wacc : Using comparable ratios of peer companies, estimate the company's stock price at the end of 2011. List the major assumptions and sources of information that you used in your calculations. Were your assumptions reasonable enough? Explain.
Explain what is the concentration of the new solution : if a 5.0ml aliquot (portion) of the above solution was taken and diluted to 500.0mL. What is the concentration of this new solution
Determine how many in atoms are un-ionized : A Si sample contains 1016 cm-3 In acceptoratoms and a certain number of shallow donors. The In acceptorlevel is 0.16eV above Ev, and EF is 0.26eVabove Ev at 300K. How many (cm-3) In atoms are un-ionized (i.e., neutral)
Compute the magnitude of the acceleration of the masses : Two masses of 4.00 kg each, connected by a string, slide down a ramp making an angle of 45° with the horizontal. Find the magnitude of the acceleration of the masses
Compute only provide an estimate of the naoh concentration : Why does this calculation only provide an estimate of the NaOH concentration. In other words, why do we have to standardize the HaOH in this experiment to find its exact concentration

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Determine the objective function

A corporation produces two products: Product A and B. Each product must go through two processes. Each Product A produced requires 2 hours in Process 1 and five hours in Process two.

  Are these outcomes mutually exclusive

An airline tracks data on its flight arrivals. Over the past six months, 25 flights on one route arrived early, 150 arrived on time, 45 were late, and 30 were cancelled.

  Translation of foreign currencies

Describe the policies used in reflecting in the financial statements the impact of changes in foreign exchange rates.

  What is the equilibrium price of the stock

If your estimate of the company's required rate of return on its stock is 10%, what is the equilibrium price of the stock?

  Calculation of expected rate of return

Suppose you recently purchased a stock that is expected to earn 12 percent in a booming economy, 8 percent in a normal economy and lose 5% in a recessionary economy.

  Debt security and equity security

Distinguish between a debt security and an equity security. What are the main distinctions between a traditional financial instrument and a derivative financial instrument?

  What is the yield on 2-year treasury securities

What is the yield on 2-year Treasury securities? Round your answer to two decimal places.

  How to fit the numbers in to come up with this answer

what is the current value of the stock? A) $100 B) $105 C) $110 D) $120 I know the answer is B) $105 but can you please show me the full formula for P and how to fit the numbers in to come up with this answer?

  What was the portfolio beta before lauren stock

The last stock added to this portfolio is Lauren clothing,co., which has a beta of .70. What was the portfolio's beta before Lauren's stock was added?

  What is the dividend amount

The common stock of Connor, Inc., is selling for $22 a share and has a dividend yield of 4.4 percent. What is the dividend amount?

  What will be the current value of a single share

Spacefood products will pay a dividend of $2.40 per share this year. It is expected that this dividend will grow by 3% per year each year in the future. What will be the current value of a single share of Spacefood's stock if the firm's equity cos..

  Finance-net present value-payback

Project K costs $52,125, its expected net cash inflows is $12,000 per year for eight years, and its WACC is 12%. What's the project's NPV? What's the project's IRR?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd