I have to calculate free cash flow and had incorrect on prior assignment. The guidance I received from the professor was: FCF = Net cash flow from operations - capital expenditures - cash paid for acquisitions

Be very careful here; the above equation assumes that capital expenditures and acquisitions are listed as Positive Values (if they are negative, adjust the negative signs). FCF will always be less than Net Cash Flow from Operations. So, look before you leap.

Net cash flow from operations is easy to find in the statement of cash flow.

What are capital expenditures (CAPEX)?

Capital expenditures are funds paid out for buildings, computer equipment, machinery, office equipment, vehicles, software, etc. Or simply expenditures in operating capital {from the cash flow statement} that will contribute to the company's net earnings.

If you can't find any item(s) that fit the above definition, assume that the capital expenditures = 0

Cash paid for acquisitions is listed in the statement of cash flow.

I know it should be net cash flow from operations - capital expenditures-cash paid for acquisitions. Can you tell me what the excel formula would be?

AutoSave Off HI module6FINAL - Excel Search A BELLI, NANCY File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial 10AA === 20 Wrap Text General 1 TIX AY X Cut LECopy Format Painter Paste BIU CA Merge & Center $ %, 8-20 Insert Delete Format Ideas AutoSum Fill Sort & Find & Clear Filter Select Editing Conditional Format as Cell Formatting Table Styles Sensitivity Clipboard Font Alignment Number Styles Cells Ideas Sensitivity J18 X f B C D E F G H J K L M N 0 RATIOS 2018 2019 0.73 2.680 0.77 -7.13 2017 0.89 0.34 Current Ratio Debt to Income Free Cash Flow Earnings Per Share Price Earnings Ratio turn on Equity Net Profit Margin A 4 Powered by Clearbit 5 Kimberly-Clark Corp. (NYS: KMB) 6 7 Exchange rate used is that of the Year End reported date 8 9 10 As Reported Annual Balance Sheet 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Cash & cash equivalents 17 Accounts receivable from customers 18 Other accounts receivable 19 Less allowance for doubtful accounts & sales discounts 20 Accounts receivable, net 21 Raw materials 22 Work in process 23 Finished goods 24 Supplies & other inventories 25 Inventories, gross 26 Excess of FIFO or weighted average cost over LIFO cost 27 Inventories 28 Other current assets 29 Total current assets 30 Land 31 Buildings 32 Machinery & equipment 33 Construction in progress 34 Property, plant & equipment, gross 35 Less accumulated depreciation 36 Property, plant & equipment, net 37 Investments in equity companies ... P & G Cash Flow P & G Stock prices 12/31/2019 12/31/2018 USD USD Not Qualified Not Qualified Yes Yes Thousands Thousands 442000 539000 2131000 2050000 181000 167000 49000 53000 2263000 2164000 321000 362000 206000 214000 1147000 1153000 271000 275000 1945000 2004000 155000 191000 1790000 1813000 562000 525000 5057000 5041000 165000 169000 2877000 2787000 13946000 14059000 851000 699000 17839000 17714000 10389000 10555000 7450000 7159000 268000 224000 KMB Balance Sheets KMB Income Statements KMB Cash Flow 12/31/2017 USD Not Qualified Yes Thousands 616000 2203000 168000 56000 2315000 345000 213000 1105000 303000 1966000 176000 1790000 490000 5211000 173000 2830000 14612000 300000 17915000 10479000 7436000 233000 KMP 3 Year ... + 100% H Type here to search i e g ) * 10:18 AM 2/10/2021 AutoSave Off Hav module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA === 20 a Wrap Text 1 General 12 AT TIX X Cut LECopy Format Painter AY O 5 Fill Paste BIU CA ES $ % Insert Delete Format Ideas Merge & Center Conditional Format as Cell Formatting Table Styles Sensitivity Sort & Find & Filter Select Clear Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity A61 X A B D E F G H I 1 J K M N 0 36 Proceeds from dispositions of property 242000 51000 37 Proceeds from sales of investments 38 Investments in time deposits -568000 -353000 -214000 39 Maturities of time deposits 542000 272000 183000 40 Other investing activities 49000 5000 -35000 41 Net cash flows from investing activities -1042000 -902000 -851000 42 Cash dividends paid -1408000 - 1386000 -1359000 43 Change in short-term debt 303000 -34000 360000 44 Debt proceeds 706000 507000 937000 45 Debt repayments -707000 407000 - 1481000 46 Cash paid on redeemable preferred securities of subsidiary 47 Proceeds from exercise of stock options 228000 62000 121000 48 Acquisitions of common stock for the treasury -800000 -800000 -911000 49 Shares purchased from noncontrolling interests 50 Other financing activities - 114000 -57000 -88000 51 Net cash flows from financing activities -1792000 -2115000 -2421000 52 Effect of exchange rate changes on cash & cash equivalents 1000 -30000 36000 53 Change in cash & cash equivalents -97000 -77000 -307000 54 Cash & cash equivalents - beginning of year 539000 616000 923000 55 Cash & cash equivalents - end of year 442000 539000 616000 56 Interest paid 255000 298000 354000 57 Income taxes paid 528000 395000 961000 58 59 60 Mergent Online. (2021) Kimberly-Clark Corporation Retreived February 7, 2021 :https://www-mergentonline-com.ezproxy snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=4738&period=Annuals&dataarea=CF&range=5¤cy=AsRep&scale=ASF 61 62 63 64 65 66 67 68 69 70 P&G Cash Flow P & G Stock prices KMB Balance Sheets KMB Income Statements KMB Cash Flow KMP 3 Year ... + B + 100% IH Type here to search e 10:19 AM 2/10/2021 AutoSave Off Hav module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA === 20 a Wrap Text General 1 AT TIX Y X Cut LECopy Format Painter o 5 Fill Paste BIU A EEEEEE $ % Insert Delete Format Merge & Center Ideas Conditional Format as Cell Formatting Table Styles Sensitivity Clear Sort & Find & Filter Select Editing Clipboard Font Alignment Number Styles Cells Ideas Sensitivity J18 X H J K L M N 0 A B D E F G 46 Accrued taxes - income & other 231000 260000 249000 47 Operating lease 130000 48 Accrued restructuring 93000 118000 49 Accrued interest 81000 75000 68000 50 Derivatives 14000 45000 51 Other accrued expenses 324000 319000 298000 52 Accrued expenses & other current liabilities 1978000 1793000 1730000 53 Dividends payable 352000 345000 341000 54 Total current liabilities 6919000 6536000 5858000 55 Notes & debentures 6749000 6756000 6577000 56 Industrial development revenue bonds 169000 169000 264000 57 Bank loans & other financings in various currencies 54000 35000 37000 58 Total long-term debt 6972000 6960000 6878000 59 Less current portion 759000 713000 406000 60 Long-term debt 6213000 6247000 6472000 61 Noncurrent employee benefits 897000 931000 1184000 62 Deferred income taxes 511000 458000 395000 63 Other liabilities 520000 328000 299000 64 Redeemable preferred securities of subsidiaries 29000 64000 65 Redeemable preferred & common securities of subsidiaries 61000 66 Common stock 473000 473000 473000 67 Additional paid-in capital 556000 548000 776000 68 Common stock held in treasury, at cost 4454000 3956000 4431000 69 Retained earnings 6686000 5947000 6730000 70 Unrealized translation -2271000 -2297000 -1864000 71 Defined benefit pension plans -979000 -1017000 -976000 72 Other postretirement benefit plans - 13000 12000 -39000 73 Deferred gains (losses) on cash flows hedges 74 Cash flow hedges & other -31000 3000 -40000 75 Accumulated other comprehensive income (loss) -3294000 3299000 -2919000 76 Total Kimberly-Clark Corporation stockholders' equity -33000 -287000 629000 77 Noncontrolling interests 227000 241000 253000 78 Total stockholders' equity 194000 -46000 882000 79 on Mocasst lisa 100211 Ibach Cloc. Cornacation Datesid Cabrian. 7001 - ++ Osastoolios 005 ASC Loobuoduos financialo obogata P&G Cash Flow P & G Stock prices KMB Balance Sheets KMB Income Statements KMB Cash Flow KMP 3 Year ... + Oscatado.Lubac-47200 cariad-Assuolo O data sa-DOO CASAS-CO LESSON-A.Doncsola-Aol B + 100% IH Type here to search i e 9 10:18 AM 2/10/2021 AutoSave Off He module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA === 20 a Wrap Text General 1 AT TIX X Cut LECopy Format Painter AY O 5 Fill Paste BIU CA $ -% ! Insert Delete Format Merge & Center Ideas Conditional Format as Cell Formatting Table Styles Sensitivity Sort & Find & Filter Select Clear Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity J34 fx E F G H H | J L M N o Q B 115095 11260 4299 1623 468 341 D 118310 10344 3208 1298 513 268 156 2027 7470 120406 9632 2792 1344 277 449 168 1994 7024 2323 9054 3388 6183 1676 11705 38 Total assets 39 Accounts payable 40 Marketing & promotion 41 Compensation expenses 42 Restructuring reserves 43 Taxes payable 44 Legal & environmental 45 Other accrued & other liabilities 46 Accrued & other liabilities 47 Current liabilities held for sale 48 Current portion of long-term debt 49 Commercial paper 50 Loan due August 2018 51 Other debt due within one year 52 Debt due within one year 53 Total current liabilities 54 Notes 55 Debentures 56 Finance lease obligations 57 All other long-term debt 58 Current portion of long-term debt 59 Long-term debt 60 Deferred income taxes 61 Pension benefits 62 Other postretirement benefits 63 Uncertain tax positions 64 U.S. Tax Act transitional tax payable 65 Long term operating leases 66 Other noncurrent liabilities 67 Other noncurrent liabilities 68 Total liabilities 69 Convertible class A preferred stock 70 Common stock 71 Additional paid-in capital 70 Docsnt for con debt retirement P&G Balance Sheets 126 9697 30011 19743 228 33 3779 3388 20395 6899 5622 1098 472 2343 1772 7761 800 90 10423 28237 18484 327 107 3717 1772 20863 6163 4768 1495 581 2654 173 13554 30210 14864 417 51 4382 1676 18038 8126 5487 1333 564 676 10211 67516 928 4009 63827 1-14C P & G Cash Flow 666 10164 65427 967 4009 63846 1004 P & G Stock prices 870 8254 64628 1006 4009 63641 1210 KMB Balance Sheets P& G Income Statements KMB IL ... + Ready B + 100% Type here to search e 9 )) #9 4:27 PM 2/10/2021 AutoSave Off HI module6FINAL - Excel Search A BELLI, NANCY File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial 10AA === 20 Wrap Text General 1 TIX AY X Cut LECopy Format Painter Paste BIU CA Merge & Center $ %, 8-20 Insert Delete Format Ideas AutoSum Fill Sort & Find & Clear Filter Select Editing Conditional Format as Cell Formatting Table Styles Sensitivity Clipboard Font Alignment Number Styles Cells Ideas Sensitivity J18 X f B C D E F G H J K L M N 0 RATIOS 2018 2019 0.73 2.680 0.77 -7.13 2017 0.89 0.34 Current Ratio Debt to Income Free Cash Flow Earnings Per Share Price Earnings Ratio turn on Equity Net Profit Margin A 4 Powered by Clearbit 5 Kimberly-Clark Corp. (NYS: KMB) 6 7 Exchange rate used is that of the Year End reported date 8 9 10 As Reported Annual Balance Sheet 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Cash & cash equivalents 17 Accounts receivable from customers 18 Other accounts receivable 19 Less allowance for doubtful accounts & sales discounts 20 Accounts receivable, net 21 Raw materials 22 Work in process 23 Finished goods 24 Supplies & other inventories 25 Inventories, gross 26 Excess of FIFO or weighted average cost over LIFO cost 27 Inventories 28 Other current assets 29 Total current assets 30 Land 31 Buildings 32 Machinery & equipment 33 Construction in progress 34 Property, plant & equipment, gross 35 Less accumulated depreciation 36 Property, plant & equipment, net 37 Investments in equity companies ... P & G Cash Flow P & G Stock prices 12/31/2019 12/31/2018 USD USD Not Qualified Not Qualified Yes Yes Thousands Thousands 442000 539000 2131000 2050000 181000 167000 49000 53000 2263000 2164000 321000 362000 206000 214000 1147000 1153000 271000 275000 1945000 2004000 155000 191000 1790000 1813000 562000 525000 5057000 5041000 165000 169000 2877000 2787000 13946000 14059000 851000 699000 17839000 17714000 10389000 10555000 7450000 7159000 268000 224000 KMB Balance Sheets KMB Income Statements KMB Cash Flow 12/31/2017 USD Not Qualified Yes Thousands 616000 2203000 168000 56000 2315000 345000 213000 1105000 303000 1966000 176000 1790000 490000 5211000 173000 2830000 14612000 300000 17915000 10479000 7436000 233000 KMP 3 Year ... + 100% H Type here to search i e g ) * 10:18 AM 2/10/2021 AutoSave Off Hav module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA === 20 a Wrap Text 1 General 12 AT TIX X Cut LECopy Format Painter AY O 5 Fill Paste BIU CA ES $ % Insert Delete Format Ideas Merge & Center Conditional Format as Cell Formatting Table Styles Sensitivity Sort & Find & Filter Select Clear Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity A61 X A B D E F G H I 1 J K M N 0 36 Proceeds from dispositions of property 242000 51000 37 Proceeds from sales of investments 38 Investments in time deposits -568000 -353000 -214000 39 Maturities of time deposits 542000 272000 183000 40 Other investing activities 49000 5000 -35000 41 Net cash flows from investing activities -1042000 -902000 -851000 42 Cash dividends paid -1408000 - 1386000 -1359000 43 Change in short-term debt 303000 -34000 360000 44 Debt proceeds 706000 507000 937000 45 Debt repayments -707000 407000 - 1481000 46 Cash paid on redeemable preferred securities of subsidiary 47 Proceeds from exercise of stock options 228000 62000 121000 48 Acquisitions of common stock for the treasury -800000 -800000 -911000 49 Shares purchased from noncontrolling interests 50 Other financing activities - 114000 -57000 -88000 51 Net cash flows from financing activities -1792000 -2115000 -2421000 52 Effect of exchange rate changes on cash & cash equivalents 1000 -30000 36000 53 Change in cash & cash equivalents -97000 -77000 -307000 54 Cash & cash equivalents - beginning of year 539000 616000 923000 55 Cash & cash equivalents - end of year 442000 539000 616000 56 Interest paid 255000 298000 354000 57 Income taxes paid 528000 395000 961000 58 59 60 Mergent Online. (2021) Kimberly-Clark Corporation Retreived February 7, 2021 :https://www-mergentonline-com.ezproxy snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=4738&period=Annuals&dataarea=CF&range=5¤cy=AsRep&scale=ASF 61 62 63 64 65 66 67 68 69 70 P&G Cash Flow P & G Stock prices KMB Balance Sheets KMB Income Statements KMB Cash Flow KMP 3 Year ... + B + 100% IH Type here to search e 10:19 AM 2/10/2021 AutoSave Off Hav module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA === 20 a Wrap Text General 1 AT TIX Y X Cut LECopy Format Painter o 5 Fill Paste BIU A EEEEEE $ % Insert Delete Format Merge & Center Ideas Conditional Format as Cell Formatting Table Styles Sensitivity Clear Sort & Find & Filter Select Editing Clipboard Font Alignment Number Styles Cells Ideas Sensitivity J18 X H J K L M N 0 A B D E F G 46 Accrued taxes - income & other 231000 260000 249000 47 Operating lease 130000 48 Accrued restructuring 93000 118000 49 Accrued interest 81000 75000 68000 50 Derivatives 14000 45000 51 Other accrued expenses 324000 319000 298000 52 Accrued expenses & other current liabilities 1978000 1793000 1730000 53 Dividends payable 352000 345000 341000 54 Total current liabilities 6919000 6536000 5858000 55 Notes & debentures 6749000 6756000 6577000 56 Industrial development revenue bonds 169000 169000 264000 57 Bank loans & other financings in various currencies 54000 35000 37000 58 Total long-term debt 6972000 6960000 6878000 59 Less current portion 759000 713000 406000 60 Long-term debt 6213000 6247000 6472000 61 Noncurrent employee benefits 897000 931000 1184000 62 Deferred income taxes 511000 458000 395000 63 Other liabilities 520000 328000 299000 64 Redeemable preferred securities of subsidiaries 29000 64000 65 Redeemable preferred & common securities of subsidiaries 61000 66 Common stock 473000 473000 473000 67 Additional paid-in capital 556000 548000 776000 68 Common stock held in treasury, at cost 4454000 3956000 4431000 69 Retained earnings 6686000 5947000 6730000 70 Unrealized translation -2271000 -2297000 -1864000 71 Defined benefit pension plans -979000 -1017000 -976000 72 Other postretirement benefit plans - 13000 12000 -39000 73 Deferred gains (losses) on cash flows hedges 74 Cash flow hedges & other -31000 3000 -40000 75 Accumulated other comprehensive income (loss) -3294000 3299000 -2919000 76 Total Kimberly-Clark Corporation stockholders' equity -33000 -287000 629000 77 Noncontrolling interests 227000 241000 253000 78 Total stockholders' equity 194000 -46000 882000 79 on Mocasst lisa 100211 Ibach Cloc. Cornacation Datesid Cabrian. 7001 - ++ Osastoolios 005 ASC Loobuoduos financialo obogata P&G Cash Flow P & G Stock prices KMB Balance Sheets KMB Income Statements KMB Cash Flow KMP 3 Year ... + Oscatado.Lubac-47200 cariad-Assuolo O data sa-DOO CASAS-CO LESSON-A.Doncsola-Aol B + 100% IH Type here to search i e 9 10:18 AM 2/10/2021 AutoSave Off He module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA === 20 a Wrap Text General 1 AT TIX X Cut LECopy Format Painter AY O 5 Fill Paste BIU CA $ -% ! Insert Delete Format Merge & Center Ideas Conditional Format as Cell Formatting Table Styles Sensitivity Sort & Find & Filter Select Clear Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity J34 fx E F G H H | J L M N o Q B 115095 11260 4299 1623 468 341 D 118310 10344 3208 1298 513 268 156 2027 7470 120406 9632 2792 1344 277 449 168 1994 7024 2323 9054 3388 6183 1676 11705 38 Total assets 39 Accounts payable 40 Marketing & promotion 41 Compensation expenses 42 Restructuring reserves 43 Taxes payable 44 Legal & environmental 45 Other accrued & other liabilities 46 Accrued & other liabilities 47 Current liabilities held for sale 48 Current portion of long-term debt 49 Commercial paper 50 Loan due August 2018 51 Other debt due within one year 52 Debt due within one year 53 Total current liabilities 54 Notes 55 Debentures 56 Finance lease obligations 57 All other long-term debt 58 Current portion of long-term debt 59 Long-term debt 60 Deferred income taxes 61 Pension benefits 62 Other postretirement benefits 63 Uncertain tax positions 64 U.S. Tax Act transitional tax payable 65 Long term operating leases 66 Other noncurrent liabilities 67 Other noncurrent liabilities 68 Total liabilities 69 Convertible class A preferred stock 70 Common stock 71 Additional paid-in capital 70 Docsnt for con debt retirement P&G Balance Sheets 126 9697 30011 19743 228 33 3779 3388 20395 6899 5622 1098 472 2343 1772 7761 800 90 10423 28237 18484 327 107 3717 1772 20863 6163 4768 1495 581 2654 173 13554 30210 14864 417 51 4382 1676 18038 8126 5487 1333 564 676 10211 67516 928 4009 63827 1-14C P & G Cash Flow 666 10164 65427 967 4009 63846 1004 P & G Stock prices 870 8254 64628 1006 4009 63641 1210 KMB Balance Sheets P& G Income Statements KMB IL ... + Ready B + 100% Type here to search e 9 )) #9 4:27 PM 2/10/2021