Please fill out all green cells and show work.

This is the discount dividend model needed:

8 Required 9 n the year ended December 31, 2013 (Period 0), the Company's net income was $988,700,000, and there were 307,554,060 shares outstanding 10 For the next ten years (Periods 1 through 10), the Company's net income is expected to increase by 5.5% each year, and by 3.7% for every 11 subsequent year (starting from Period 11) The Company expects to issue 12,445,940 shares of common stock (in addition to their outstanding 12 stock) in Period 11. 13 Assume that Allergan, Inc. plans to pay dividends every period (starting with Period 1) at a rate of 25% of net income, per share. 14 Assume that the internal rate of return is 8%. 1. Using the discount dividend model (page 41 of the text) formula, determine the stock price. Show your computations using the format 15 shown below for each of the periods. 16 Note: 17 18 You may consider inserting additional rows in the template below. 19 2. on November 6, 2014, Allergan, Inc.'s stock price was trading at $197.40. Based on your computation of the stock price using the 20 divident discount model, would you recommend purchasing the stock? 21 22 23 Answers: 24 25 Based on my analysis below. I will recommend purchasing the stock Select "Yes" or "No" 26 Net Income Expected Dividend Expected Sum of Expected Period Net Income Shares Rate of Return Growth Rate Per Share Value Values 27 NIAI N/Al 28 N/A 988700,000 5.50%. NIA 29 300 31 32 33 35 36 37 38 39 41 42 43 45 46 47 48 49 Insert as ma above lines as necessa 50