Please help solve for the attached problem. This is for the dividend discount model.

ACTG 053 Financial Statement Analysis Final Project Part 4: Dividend Discount Model Maximum Points: Points Earned: 25.00 - Required: In the year ended December 31, 2013 (Period 0), the Company's net income was $988,700,000, an For the next ten years (Periods 1 through 10), the Company's net income is expected to increase b subsequent year (starting from Period 11). The Company expects to issue 12,445,940 shares of co stock) in Period 11. Assume that Allergan, Inc. plans to pay dividends every period (starting with Period 1) at a rate of 2 Assume that the internal rate of return is 8%. 1. Using the discount dividend model (page 41 of the text) formula, determine the stock pric shown below - for each of the periods. Note: 2. You may consider inserting additional rows in the template below. On November 6, 2014, Allergan, Inc.'s stock price was trading at $197.40. Based on your divident discount model, would you recommend purchasing the stock? Answers: Based on my analysis below, I will recommend purchasing the stock. Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Net Income 988,700,000 Net Income Growth Rate 5.50% Shares 307,554,060 Expected Dividend Per Share N/A 18 19 20 >>>Insert as many above lines as necessary