I need help with a data case involving Free Cash Flow Method. I will attach Question and work completed so far. I need help with number 6!

Data Case Chapter 9 Information gathered on 10-15-15 1a. Current Stock price $28.03 1b. Current Dividend Amount $0.92 3.28% Dividend Yeild 2a. Number of shares of stock outstanding (billions) $10.10 2b. Payout ratio 3.28% 176.78% 3. Expected Growth Rate 7.57% 4. (See the next three worksheets) 5a. Timeline for 5 years D0 $0.92 7.57% g 5b. $0.92 0.989644 1 0 5c. 15233000000 1.0645600508 1.145147 1.231835 1.325085 2 3 4 5 g=retention rate x return on new investment 6382000000 retention ratio= Return on Equity Long term Growth rate 5d. 0.4189588394 11.89% (Net Income/Total Stockholder equity) 8.61% P5 5e. 6i. 6ii. 6iii. 6iv 6v Stock Price for Year 5 = Current Stock Price= 0.1875427696 0.6305037332 0.4767718516 0.1342011711 RE 12.30% 35.896887293 RE P0 10.9% 44.0589594097 0.418959 Income Statement 31-Dec-14 148,589,000 83,859,000 31-Dec-13 146,045,000 79,817,000 31-Dec-12 146,684,000 77,167,000 64,730,000 66,228,000 69,517,000 - - - 34,026,000 3,993,000 - 35,143,000 4,818,000 - 35,897,000 3,832,000 - - - - 26,711,000 26,267,000 29,788,000 Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest - 26,711,000 9,482,000 17,229,000 1,772,000 -112,000 - 26,267,000 10,116,000 16,151,000 676,000 -298,000 - 29,788,000 27588667 0.187543 12,407,000 10668333.3333333 17,381,000 16920333.3333333 0.630504 2,534,000 -223,000 Net Income From Continuing Ops 15,457,000 15,475,000 14,847,000 -112,000 - - - -2,120,000 - - - -983,000 - - - 15,233,000 13,057,000 13,641,000 - - - 15,233,000 13,057,000 13,641,000 Period Ending Total Revenue Cost of Revenue Gross Profit 147106000 Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares Balance Sheet 31-Dec-14 31-Dec-13 31-Dec-12 Cash And Cash Equivalents 90,208,000 88,555,000 77,268,000 Short Term Investments 47,907,000 43,981,000 48,510,000 257,148,000 17,689,000 - 272,442,000 17,325,000 - 285,004,000 15,374,000 - 412,952,000 422,303,000 426,156,000 - - - Property Plant and Equipment 72,687,000 68,877,000 68,844,000 Goodwill Intangible Assets 76,553,000 14,156,000 77,648,000 14,310,000 73,114,000 11,980,000 - - - 69,460,000 2,541,000 73,147,000 275,000 104,959,000 -54,000 648,349,000 656,560,000 684,999,000 31,192,000 31,816,000 56,779,000 Short/Current Long Term Debt 101,727,000 108,014,000 131,515,000 Other Current Liabilities 75,521,000 66,742,000 61,095,000 Total Current Liabilities 208,440,000 206,572,000 249,389,000 Long Term Debt Other Liabilities 200,414,000 102,662,000 221,665,000 91,540,000 236,084,000 71,056,000 - - - 8,674,000 - 6,217,000 - 5,444,000 - 520,190,000 525,994,000 561,973,000 Misc Stocks Options Warrants - - - Redeemable Preferred Stock - - - Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity - 702,000 155,333,000 -42,593,000 - 14,717,000 - 702,000 149,051,000 -42,561,000 - 23,374,000 - 702,000 144,055,000 -34,571,000 - 12,840,000 Total Stockholder Equity 128,159,000 130,566,000 123,026,000 37,450,000 38,608,000 37,932,000 Period Ending Assets Current Assets Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Liabilities Current Liabilities Accounts Payable Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Net Tangible Assets 70136000 0.476772 Cash Flow 31-Dec-14 15,233,000 31-Dec-13 13,057,000 9,283,000 9,762,000 -1,186,000 -1,473,000 -392,000 2,080,000 4,333,000 2,953,000 Changes In Liabilities -210,000 2,253,000 -1,357,000 Changes In Inventories -872,000 -1,368,000 -1,274,000 3,075,000 2,175,000 8,029,000 27,710,000 28,579,000 31,331,000 -13,727,000 -13,458,000 -15,119,000 -4,267,000 19,414,000 6,979,000 12,964,000 23,161,000 19,442,000 -5,030,000 29,117,000 11,302,000 -8,851,000 -7,821,000 -7,189,000 1,624,000 -8,288,000 -204,000 Net Borrowings -8,658,000 -28,102,000 -40,704,000 Other Cash Flows from Financing Activities -1,073,000 -1,362,000 -2,977,000 Total Cash Flows From Financing Activities -16,958,000 -45,573,000 -51,074,000 -3,492,000 -795,000 1,278,000 2,230,000 11,328,000 -7,163,000 Period Ending Net Income 31-Dec-12 13,641,000 Operating Activities, Cash Flows Provided By or Used In Depreciation Adjustments To Net Income Changes In Accounts Receivables Changes In Other Operating Activities Total Cash Flow From Operating Activities 9,192,000 9412333.333 0.134201 Investing Activities, Cash Flows Provided By or Used In Capital Expenditures Investments Other Cash flows from Investing Activities Total Cash Flows From Investing Activities Financing Activities, Cash Flows Provided By or Used In Dividends Paid Sale Purchase of Stock Effect Of Exchange Rate Changes Change In Cash and Cash Equivalents 2012 Ebit/Sales Tax Rate Property Plant and Equip/Sa Depreciation/Property Plan Networking Capital/Sales Revenue Growth $ 2013 2014 Average 20.31% 14.58% 46.95% 13.35% 83.87% 17.99% 4.19% 47.16% 14.17% 89.40% 18.21% 10.28% 48.92% 12.77% 87.37% 18.83% 9.68% 47.67% 13.43% 86.88% 2015 157,787,978.80 2016 169,732,528.80 2017 182,581,281.22 2018 196,402,684.21 Stock Price 2014 Dividend Expected 5yr Growth Payout Ratio Retention Ratio Return on Equity Div Yeild 2019 211,270,367.41 2020 227,263,534.22 28.03 0.92 0.0757 1.7678 0.4189 11.89% 3.28% 2021 244,467,383.76