Quantitative Problems Chapter 111. If the investment bankers retained $1.26 per share as fees, what was the net proceeds to Ebay? What was the market capitalization of new shares of Ebay?Solution: Net Proceeds to Ebay  (18.00  1.26)  3,500,000  $58,590,000.00Market Cap  44.88  3,500,000  157,080,0002. Two common statistics in IPOs are underpricing and money left on the table. Underpricing is defined as percentage change between the offering price and the first day closing price. Money left on the table is the difference between the first day closing price and the offering price, multiplied by the number of shares offered. Calculated the underpricing and money left on the table for Ebay. What does this suggest about the efficiency of the IPO process?Solution: Underpricing  ((44.88  18.00)/18.00)  149.33%MLOT  (44.88  18.00)  3,500,000  $94,080,0003. The shares of Misheak, Inc. are expected to generated the following possible returns over the next 12 months:If the stock is currently trading at $25/share, what is the expected price in one year. Assume that the stock pays no dividends.Solution: The expected return over the next 12 months is calculated as:0.05  0.10  0.05  0.25  0.10  0.30  0.15  0.25  0.25  0.10  0.10This suggests that the expected price is $25 * (1.10)  $27.504. Suppose Soft People, Inc. is selling at $19.00 and currently pays an annual dividend of $0.65 per share. Analysts project that the stock will be priced around $23.00 in one year. What is the expected return?Solution:5. In September of 2004, Microsoft, Inc. was trading at $27.29 per share. At that time, Microsoft was paying an annual dividend of $0.32 per share, and analysts had set a 1-year target price around $33.30 per share. What is the expected return on this stock?Solution:6. LaserAce is selling at $22.00 per share. The most recent annual dividend paid was $0.80. Using the Gordon Growth model, if the market requires a return of 11%, what is the expected dividend growth rate for LaserAcer?Solution:7. Huskie Motor’s just paid an annual dividend of $1.00 per share. Management has promised shareholders to increase dividends a constant rate of 5%. If the required return is 12%, what is the current price per share?Solution:8. In September of 2004, Microsoft, Inc. was trading at $27.29 per share. At that time, Microsoft was paying an annual dividend of $0.32 per share, which is double its 2003 dividend of $0.16 per share. If this trend is expected to continue, what is the required return on Microsoft?Solution: or ke  102%.This seems a bit high. Perhaps investors don’t believe this trend will continue forever, or this isn’t the correct valuation model for Microsoft!9. Gordon & Co.’s stock has just paid its annual dividend $1.10 per share. Analysts believe that Gordon will maintain its historic dividend growth rate of 3%. If the required return is 8%, what is the expected price of the stock next year?Solution:10. Macro Systems just paid an annual dividend of $0.32 per share. Its dividend is expected to double for the next four years (D1 through D4), after which it will grow at a more modest pace of 1% per year. If the required return is 13%, what is the current price?Solution:11. Nat-T-Cat Industries just went public. As a growing firm, it is not expected to pay a dividend for the first five years. After that, investors expect Nat-T-Cat to pay an annual dividend $1.00 per share (i.e., D6  1.00), with no growth. If the required return is 10%, what is the current stock price?Solution:So, P0  P5/(1.10)5  $6.2112. Analysts are projecting that CB Railways will have earnings per share of $3.90. If the average industry ratio is about 25, what is the current price of CB Railways?Solution: Price  3.90  25  $97.5013. For 2003, Microsoft, Inc. reported earnings per share around $0.75. If Microsoft is in an industry with a ratio ranging from 30 to 40, what is a reasonable price range for Microsoft?Solution: Microsoft’s price should be between $0.75  30 to $0.75  40, or $22.50 to $30.00.14. Consider the following security information for 4 securities making up an index:What is the change in the value of the index from time  0 to time  1 if the index is calculated using a value-weighted arithmetic mean?Solution: For a value-weighted arithmetic mean, the change is calculated as follows:First, the market value at time  0 is calculated as:The change is then calculated as:Index1  Index0  1.002715. An index had an average (geometric) mean return over 20 years of 3.8861%. If the beginning index value was 100, what was the final index value after 20 years?Answer: The actual return over the 20 years is (1.038861)20  2.143625So, the final index value is 214.362516. $1/(1  0.51)  $20/(1  0.15)  $18.2617. 23  $3.5  $80.50.Chapter 11 The Stock Market 83Quantitative Problems Chapter 11Ebay, Inc. went public in September of 1998. The following information on shares outstanding was listed in the final prospectus filed with the SEC1.In the IPO, the Ebay issued 3,500,000 new shares. The initial price to the public was $18.00 per share. Thefinal first-day closing price was $44.88.1. If the investment bankers retained $1.26 per share as fees, what was the net proceeds to Ebay? What was the market capitalization of new shares of Ebay?Solution: Net Proceeds to Ebay  (18.00  1.26)  3,500,000  $58,590,000.00Market Cap  44.88  3,500,000  157,080,0002. Two common statistics in IPOs are underpricing and money left on the table. Underpricing is defined as percentage change between the offering price and the first day closing price. Money left on the table is the difference between the first day closing price and the offering price, multiplied by the number of shares offered. Calculated the underpricing and money left on the table for Ebay. What does this suggest about the efficiency of the IPO process?Solution: Underpricing  ((44.88  18.00)/18.00)  149.33%MLOT  (44.88  18.00)  3,500,000  $94,080,0003. The shares of Misheak, Inc. are expected to generated the following possible returns over the next 12 months:Return Probability5% 0.105% 0.2510% 0.3015% 0.2525% 0.10If the stock is currently trading at $25/share, what is the expected price in one year. Assume that the stock pays no dividends.Solution: The expected return over the next 12 months is