FIN 630 Final Exam 2014

Question # 00022152 Posted By: spqr Updated on: 08/05/2014 08:59 PM Due on: 09/21/2014
Subject Finance Topic Finance Tutorials:
Question
Dot Image

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.com went 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.com IPO 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 thatCoupons.com has a three year agreement with a major mobile network, according to whichCoupons.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.


Dot Image
Tutorials for this Question
  1. Tutorial # 00021486 Posted By: spqr Posted on: 08/05/2014 09:00 PM
    Puchased By: 5
    Tutorial Preview
    The solution of FIN 630 Final Exam 2014...
    Attachments
    FIN_630_Final_Exam_2014_Solution_Worksheet.xlsx (76.8 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    ...KM Rating Amazing tutorial experience 05/22/2015
    b_w...002 Rating Supportive tutors 12/25/2014
    o...tte Rating Tutorials prepared by experts 12/25/2014

Great! We have found the solution of this question!

Whatsapp Lisa