The prompt is provided in the first image. I need to figure out all the highlighted parts of the 3rd image, "Cisco Consolidated Statement of Cash Flows." Hopefully this provides enough information but if you need more let me know. Thank you so much!

I have broke the 3rd image, "Cisco Consolidated Statement of Cash Flows" into three separate images so that it looks clear enough. Please let me know if there is anything else I can do to make this easier to comprehend.

J K L CISCO VALUATION M N O P Q R SL #N/A Free cash flow (FCF) year ending 27jul2017 Growth rate of FCF, years 1-5 Long-term FCF growth rate Weighted average cost of capital, WACC 4.00% 0.00% 12.600% Year 2017 2018 2019 2020 2021 2022 FCF Terminal value Total #N/A #N/A #N/A Enterprise value #N/A ASSUME MID YEAR DISCOUNTING!!! Add back initial cash and marketable securities in 2017) Subtract 2017 liabilities Equity value Shares outstanding Per share #N/A #N/A #N/A #N/A #N/A 5,370,000 Data table: Share value vs LT growth and WACC Long-term growth -2% 0% -4% 4% 6% 8% 10% WACC 10% 12% 14% 16% 18% 20% 22% > CISCO VALUATION - You are provided with the last three years of balance sheets and consolidated statements of cash flows for CISCO (data provided on the CISCO SCF and CISCO BAL SHEET tabs). Your task is three-fold: o Use the consolidated Statement of Cash Flows to determine the FCF for Cisco (template provided under CISCO TEMPLATES) o Use the FCF determined above along with the additional assumptions provided in the template to provide a valuation of CISCO's price per share. Assume mid-year discounting Make sure you add back both cash and short-term investments to your enterprise value Make sure you subtract ALL long term debt from your enterprise value this should include the current portion of long term debt) o While you are at it, figure out the sensitivity of the share value to the LT growth and discount rate assumptions (for your data table header, please use an IF function so that negative values show as nmf, as we did in the example in class). B C D E 1 CISCO CONSOLIDATED STATEMENT OF CASH FLOWS 2 Period Ending 27-Jul-17 29-Jul-16 30-Jul-15 3 Net Income 8,041,000 6,490,000 7,767,000 4 Operating Activities, Cash Flows Provided By or Used In 5 Depreciation 2,602,000 2,486,000 2,030,000 6 Adjustments To Net Income 1046,000 1,268,000 718,000 7 Changes In Accounts Receivables -574,000 -1,318,000 -2,524,000 8 Changes In Liabilities 1,337,000 1,025,000 2,438,000 9 Changes In Inventories -287,000 -147,000 -158,000 10 Changes in Other Operating Activities -674,000 275,000 -98,000 11 Total Cash Flow From Operating Activities 11,491,000 10,079,000 10,173,000 -SUMD3:D10) 12 -41,810,000 27,365,000 12,103,000 -1,126,000 -37,130,000 -48,690,000 17,538,000 19,300,000 18,117,000 23,697,000 -1,174,000 -1,008,000 13 Investing Activities, Cash Flows Provided By or Used In 14 Purchases of investments 15 Proceeds from sales of investments 16 Proceeds from maturities of investments 17 Acquisitions of property and equipment Acquistions of businesses, net of cash and cash 18 equivalents acquired 19 Purchases of investments in privately held companies 20 Return of investments in privately held companies 21 Other -375,000 -380,000 242,000 166,000 -3,815,000 -266,000 - 204,000 163,000 22,000 -2,934,000 -5,279,000 -137,000 58,000 128,000 -11,931,000 = SUM(D14:D21) 24 Financing Activities, Cash Flows Provided By or Used In 25 Dividends Paid 26 Sale Purchase of Stock 27 Net Borrowings 28 Other Cash Flows from Financing Activities 29 Total Cash Flows From Financing Activities -1,501,000 -658,000 -3,388,000 -5,065,000 -557,000 1,508,000 -93,000 151,000 -5,539,000 -4,064,000 -4,586,000 4,985,000 222,000 621,000 =SUM(D25:D28) 30 32 Change In Cash and Cash Equivalents 2,137,000 3,081,000 -1,137,000 =D11+D22+D29 33 34 Net interest paid 35 Tax rate 36 After-tax net interest 681,000 20.85% 777,000 17.06% 692,000 17.50% CISCO BALANCE SHEET 27-Jul-17 29-Jul-16 2 Period Ending 30-Jul-15 4 Assets 5 Current Assets 6 Cash And Cash Equivalents 9,799,000 7,662,000 4,581,000 Short Term Investments 38,917,000 36,923,000 35,280,000 8 Net Receivables 10,324,000 10,219,000 9,358,000 Inventory 1,663,000 1,486,000 1,327,000 10 Other Current Assets 1,230,000 941,000 875,000 11 Total Current Assets 61,933,000 57,231,000 51,421,000 =SUM(D6:010) 12 13 Long Term Investments 3,585,000 3,488,000 2,614,000 14 Property Plant and Equipment 3,402,000 3,916,000 3,941,000 15 Goodwill 16,998,000 16,818,000 16,674,000 16 Intangible Assets 1,959,000 2,541,000 3,274,000 17 Other Assets 3,882,000 3,101,000 3,206,000 18 Total Assets 91,759,000 87,095,000 81,130,000 ESUM(D11:017) 19 20 Liabilities 21 Current Liabilities 22 Accounts Payable 4,063,000 4,159,000 4.114,000 23 Short Current Long Term Debt 31,000 588,000 3,096,000 24 Other Current Liabilities 13,637,000 12,759,000 12,023,000 25 Total Current Liabilities 17.731,000 17,506,000 19,233,000 =SUM(D22:D24) 26 Long Term Debt 16,297,000 16,234,000 12,188,000 27 Other Liabilities 2,402,000 1,914,000 2,005,000 28 Deferred Long Term Liability Charges 4,028,000 4,182,000 3,419,000 30 Minority Interest 31 Total Liabilities 15,000 40,473,000 33,000 39,869,000 18,000 36,863,000 =SUM(D25:D30) 32 33 Stockholders' Equity 34 Common Stock 35 Retained Earnings 36 Other Stockholder Equity 37 Total Stockholder Equity 38 Total liabilities and equity 39,271,000 38,648,000 37,793,000 11,354,000 7,284,000 5,851,000 661,000 1,294,000 623,000 51,286,000 47,226,000 44,267,000 =SUM(D34:D36) 91,759,000 87,095,000 81,130,000 =D31+D37 E F G H | J K CISCO VALUATION L M N O P Q B C D CISCO CONSOLIDATED STATEMENT OF CASH FLOWS R 27-Jul-17 29-Jul-16 30-Jul-15 #NIA Free cash flow (FCF) year ending 27jul2017 Growth rate of FCF, years 1-5 Long-term FCF growth rate Weighted average cost of capital, WACC 4.00% 0.00% 12.600% 2 Period Ending 3 Net Income 4 Operating Activities, Cash Flows Provided By or Used In 5 Depreciation 6 Adjustments To Net Income 7 Changes in Accounts Receivables 8 Changes In Liabilities 9 Changes In Inventories 10 Changes in Other Operating Activities 11 Total Cash Flow From Operating Activities Year 2017 2018 2019 2020 2021 2022 FCF Terminal value Total #N/A #NIA #NIA 12 Enterprise value #NIA ASSUME MID YEAR DISCOUNTING!!! Add back initial cash and marketable securities (in 2017) Subtract 2017 liabilities Equity value Shares outstanding Per share #NIA #N/A #NIA 5,370,000'#NIA #N/A 13 Investing Activities, Cash Flows Provided By or Used In 14 Purchases of investments 15 Proceeds from sales of investments 16 Proceeds from maturities of investments 17 Acquisitions of property and equipment Acquistions of businesses, net of cash and cash 18 equivalents acquired 19 Purchases of investments in privately held companies 20 Return of investments in privately held companies 21 Other 22 Total Cash Flows From Investing Activities Data table: Share value vs LT growth and WACC -4% Long-term growth -2% 0% 4% 6% 8% 10% #NIA WACC 10% 12% 24 Financing Activities, Cash Flows Provided By or Used In 25 Dividends Paid 26 Sale Purchase of Stock 27 Net Borrowings 28 Other Cash Flows from Financing Activities 29 Total Cash Flows From Financing Activities 30 #NIA #N/A 32 Free cash flow before interest adjustment 33 34 Net interest paid 35 Tax rate 36 After-tax net interest #NIA 38 Free cash flow #N/A J K L CISCO VALUATION M N O P Q R SL #N/A Free cash flow (FCF) year ending 27jul2017 Growth rate of FCF, years 1-5 Long-term FCF growth rate Weighted average cost of capital, WACC 4.00% 0.00% 12.600% Year 2017 2018 2019 2020 2021 2022 FCF Terminal value Total #N/A #N/A #N/A Enterprise value #N/A ASSUME MID YEAR DISCOUNTING!!! Add back initial cash and marketable securities in 2017) Subtract 2017 liabilities Equity value Shares outstanding Per share #N/A #N/A #N/A #N/A #N/A 5,370,000 Data table: Share value vs LT growth and WACC Long-term growth -2% 0% -4% 4% 6% 8% 10% WACC 10% 12% 14% 16% 18% 20% 22% > CISCO VALUATION - You are provided with the last three years of balance sheets and consolidated statements of cash flows for CISCO (data provided on the CISCO SCF and CISCO BAL SHEET tabs). Your task is three-fold: o Use the consolidated Statement of Cash Flows to determine the FCF for Cisco (template provided under CISCO TEMPLATES) o Use the FCF determined above along with the additional assumptions provided in the template to provide a valuation of CISCO's price per share. Assume mid-year discounting Make sure you add back both cash and short-term investments to your enterprise value Make sure you subtract ALL long term debt from your enterprise value this should include the current portion of long term debt) o While you are at it, figure out the sensitivity of the share value to the LT growth and discount rate assumptions (for your data table header, please use an IF function so that negative values show as nmf, as we did in the example in class). B C D E 1 CISCO CONSOLIDATED STATEMENT OF CASH FLOWS 2 Period Ending 27-Jul-17 29-Jul-16 30-Jul-15 3 Net Income 8,041,000 6,490,000 7,767,000 4 Operating Activities, Cash Flows Provided By or Used In 5 Depreciation 2,602,000 2,486,000 2,030,000 6 Adjustments To Net Income 1046,000 1,268,000 718,000 7 Changes In Accounts Receivables -574,000 -1,318,000 -2,524,000 8 Changes In Liabilities 1,337,000 1,025,000 2,438,000 9 Changes In Inventories -287,000 -147,000 -158,000 10 Changes in Other Operating Activities -674,000 275,000 -98,000 11 Total Cash Flow From Operating Activities 11,491,000 10,079,000 10,173,000 -SUMD3:D10) 12 -41,810,000 27,365,000 12,103,000 -1,126,000 -37,130,000 -48,690,000 17,538,000 19,300,000 18,117,000 23,697,000 -1,174,000 -1,008,000 13 Investing Activities, Cash Flows Provided By or Used In 14 Purchases of investments 15 Proceeds from sales of investments 16 Proceeds from maturities of investments 17 Acquisitions of property and equipment Acquistions of businesses, net of cash and cash 18 equivalents acquired 19 Purchases of investments in privately held companies 20 Return of investments in privately held companies 21 Other -375,000 -380,000 242,000 166,000 -3,815,000 -266,000 - 204,000 163,000 22,000 -2,934,000 -5,279,000 -137,000 58,000 128,000 -11,931,000 = SUM(D14:D21) 24 Financing Activities, Cash Flows Provided By or Used In 25 Dividends Paid 26 Sale Purchase of Stock 27 Net Borrowings 28 Other Cash Flows from Financing Activities 29 Total Cash Flows From Financing Activities -1,501,000 -658,000 -3,388,000 -5,065,000 -557,000 1,508,000 -93,000 151,000 -5,539,000 -4,064,000 -4,586,000 4,985,000 222,000 621,000 =SUM(D25:D28) 30 32 Change In Cash and Cash Equivalents 2,137,000 3,081,000 -1,137,000 =D11+D22+D29 33 34 Net interest paid 35 Tax rate 36 After-tax net interest 681,000 20.85% 777,000 17.06% 692,000 17.50% CISCO BALANCE SHEET 27-Jul-17 29-Jul-16 2 Period Ending 30-Jul-15 4 Assets 5 Current Assets 6 Cash And Cash Equivalents 9,799,000 7,662,000 4,581,000 Short Term Investments 38,917,000 36,923,000 35,280,000 8 Net Receivables 10,324,000 10,219,000 9,358,000 Inventory 1,663,000 1,486,000 1,327,000 10 Other Current Assets 1,230,000 941,000 875,000 11 Total Current Assets 61,933,000 57,231,000 51,421,000 =SUM(D6:010) 12 13 Long Term Investments 3,585,000 3,488,000 2,614,000 14 Property Plant and Equipment 3,402,000 3,916,000 3,941,000 15 Goodwill 16,998,000 16,818,000 16,674,000 16 Intangible Assets 1,959,000 2,541,000 3,274,000 17 Other Assets 3,882,000 3,101,000 3,206,000 18 Total Assets 91,759,000 87,095,000 81,130,000 ESUM(D11:017) 19 20 Liabilities 21 Current Liabilities 22 Accounts Payable 4,063,000 4,159,000 4.114,000 23 Short Current Long Term Debt 31,000 588,000 3,096,000 24 Other Current Liabilities 13,637,000 12,759,000 12,023,000 25 Total Current Liabilities 17.731,000 17,506,000 19,233,000 =SUM(D22:D24) 26 Long Term Debt 16,297,000 16,234,000 12,188,000 27 Other Liabilities 2,402,000 1,914,000 2,005,000 28 Deferred Long Term Liability Charges 4,028,000 4,182,000 3,419,000 30 Minority Interest 31 Total Liabilities 15,000 40,473,000 33,000 39,869,000 18,000 36,863,000 =SUM(D25:D30) 32 33 Stockholders' Equity 34 Common Stock 35 Retained Earnings 36 Other Stockholder Equity 37 Total Stockholder Equity 38 Total liabilities and equity 39,271,000 38,648,000 37,793,000 11,354,000 7,284,000 5,851,000 661,000 1,294,000 623,000 51,286,000 47,226,000 44,267,000 =SUM(D34:D36) 91,759,000 87,095,000 81,130,000 =D31+D37 E F G H | J K CISCO VALUATION L M N O P Q B C D CISCO CONSOLIDATED STATEMENT OF CASH FLOWS R 27-Jul-17 29-Jul-16 30-Jul-15 #NIA Free cash flow (FCF) year ending 27jul2017 Growth rate of FCF, years 1-5 Long-term FCF growth rate Weighted average cost of capital, WACC 4.00% 0.00% 12.600% 2 Period Ending 3 Net Income 4 Operating Activities, Cash Flows Provided By or Used In 5 Depreciation 6 Adjustments To Net Income 7 Changes in Accounts Receivables 8 Changes In Liabilities 9 Changes In Inventories 10 Changes in Other Operating Activities 11 Total Cash Flow From Operating Activities Year 2017 2018 2019 2020 2021 2022 FCF Terminal value Total #N/A #NIA #NIA 12 Enterprise value #NIA ASSUME MID YEAR DISCOUNTING!!! Add back initial cash and marketable securities (in 2017) Subtract 2017 liabilities Equity value Shares outstanding Per share #NIA #N/A #NIA 5,370,000'#NIA #N/A 13 Investing Activities, Cash Flows Provided By or Used In 14 Purchases of investments 15 Proceeds from sales of investments 16 Proceeds from maturities of investments 17 Acquisitions of property and equipment Acquistions of businesses, net of cash and cash 18 equivalents acquired 19 Purchases of investments in privately held companies 20 Return of investments in privately held companies 21 Other 22 Total Cash Flows From Investing Activities Data table: Share value vs LT growth and WACC -4% Long-term growth -2% 0% 4% 6% 8% 10% #NIA WACC 10% 12% 24 Financing Activities, Cash Flows Provided By or Used In 25 Dividends Paid 26 Sale Purchase of Stock 27 Net Borrowings 28 Other Cash Flows from Financing Activities 29 Total Cash Flows From Financing Activities 30 #NIA #N/A 32 Free cash flow before interest adjustment 33 34 Net interest paid 35 Tax rate 36 After-tax net interest #NIA 38 Free cash flow #N/A