In Excel / show your work ( formulas )

Ten years ago, Video Toys began manufacturing and selling coin-operated arcade games. The company has done well in that dividends have been growing at a 15 percent compounded annual rate for the past five years The last Dividend paid, which was just yesterday, was $1.50 per share. The annual growth rate of 15% is expected to be maintained for the next 3 years, after which dividends are expected to grow at half that rate for 1 year. Beyond that time, Video Toys' dividends are expected to grow at 5 percent per year A. Ifthe company was going to go public today, what would be the price per share that you think the public offer price should be if your required rate of return on equity is 18 percent? (10 points B. The company has a total of 10,000,000 shares. 5 million shares will be sold in the IPO and 5 million shares will remain in the possession of the founder, Mr Strong. What is the total value of the company' equity after the IPO? (5 points)