finance final exam 1

Valuation of Coupons.com

The following questions require you, among other things, to estimate the stock price for Coupons.com, and provide the analysis as requested. You will need to use “Sources of Financial Data” listed in Course Content[1] to obtain the necessary financial info/statements for Coupons.com. Identify its peer companies and obtain pricing and financial information for them. For some parts of the exam you might already have numbers from the Midterm. Don’t forget to make adjustments in response to my feedback comments, if necessary.

1. Choose several peer companies for Coupons.com and justify your choice. Choose several valuation multiples and using comparable ratios of peer companies (as we did in Project 2 and discussed in Conferences) and Coupons.com financial information from prospectus, estimate the company’s stock price on March 6, 2014. It is required for this question to list your major assumptions and properly reference sources of information that you used in your calculations.
2. Using the same peers and industry data, please estimate Coupons.com ‘s WACC Show all your data used for calculations. Again, please state all your assumptions and sources of information.
3. Coupons.comwent public on March 7, 2014. How do your relative valuations compare to the company’s IPO price (what was the IPO price)? How do they compare to its first trading day opening and closing prices (what were these prices)? If your valuations differ from observed prices, can you briefly forward any possible explanations?
4. In June 2011 SMALLCAP World Fund, Inc. acquired 3,276,690 series B preferred shares at a price of $13.73 per share. According to the Coupons.comIPO prospectus, at IPO the each series B share will be converted to 1 (one) common share. If SMALLCAP World Fund, Inc. participated in IPO and could sell some of these shares at the IPO price, what would be its annualized rate of return on this investment? You may assume the investment date to be exactly 33 months (11 quarters) earlier, or use the XIRR function – – one solution is enough! Did SMALLCAP World Fund, Inc. sell any shares at IPO in reality? Why/why not?
5. The following information is for pedagogical purposes only and unlike earlier questions does not deal with real situation. There are rumors that Coupons.com has a three year agreement with a major mobile network, according to which Coupons.com  has a right to advertise coupons to users of this network by paying annual fee of $50 M at the beginning of the year. Once usage starts, it cannot be terminated until the end of the contract, but the start can be postponed. The current estimate is that if the company uses the network this year, its revenues will be $60 M in today’s dollars. Each year revenues can go up 20% or down 15% in comparison with the previous year. If the risk-free rate is 5%, what should the company do? Please provide as many details as possible in your explanations and support them by numbers.

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