Free Cash Flow Calculation:

Calculate each company's Free Cash Flow for each of the last 4 fiscal years. Use a tax rate of 25% and use the depreciation and amortization from the Cash Flow statement.

Please use excel cell formulas and functions to compute answers to these questions in spreadsheet. Show data and calculations within excel. (first two pics are of target's cash flow statement and other two are walmart's cash flow statement)

AutoSave Target Financials Home Insert Page Layout Formulas Data Review View Arial 8 A- A- Wrap Text General Paste B I Merge & Center $ - % 89 Fe 1 fx B D E G Target Corporation (NYSE:TGT) > Financials > Cash Flow in Millions of the reported curry, Good pershare/toms. Template Period Type Currency Units: Source Restatement: Order Conversion Decimal Am Report Currency SSP COD Capital Party Latest Filling Letonight Historical Capital (D) D 4 Cash Flow R For the Fiscal Period Ending Related 12 months Jan-30-2016 USD Rostad 12 months Feb-03-2018 USD 12 months Feb-02-2019 USD 6 Currency LTM 12 months Aug-01-2020 USD 12 months Feb-01-2020 USD USD 2730 2050 360 2.100 230 2.2130 2.40 2.620 3,5720 2.9370 2.4000 14.0 2.4740 3,2810 2,5910 30 2.00110 2.et 130 2,20 1963.0) (110 30 1170 910 1120 1150 500 230 1650 180 132.0 136 16.09 320) OTO 3040 2233 (1960 (308 33.0 (9000) 11270 (2900 STO 80 23.0 1470 0 1280 5050 1000 217.0 7.117.0 2000 LANO 5.958.0 6.885.0 9.4210 7 B Netlone 9 Depreciation Amort CO Amort of Goodwil and intangibles 1 Depreciation & Amort. Total 22 23 Games From swe Of Assets 24 set Whedon & Restructuring Costs 25 Sock Band Compensation 26 Net Cash From Discord 27 Ore Operating Activities 28 Charge inverter 29 Change in Aos. Payable 30 Change in Other Net Operating Ass 31 Cash from Ops 32 33 Capital Expenditure 34 Sale of Property. Plart, and Equipment 35 Cash Acquisitions 36 Diver 37 vest in Markable & Equity Secut 38 Netine) Dec. in Lars Originald 39 Other resing Activiti 40 Cmh from Inting 41 42 Short Term Det 43 Long Term Datud 44 Total Debt 45 Short Term De Rapat 46 Long-Term Deot Repaid 47 Total Debt Repad 48 49 ce of Common Stock 50 Repurchase of Common Stock 51 (10) 280 (1500 12.500 210 (580 (30470 (2.516.01 350 - (3027) 630 150 2010 - 220 16750 240 - 190 Seo 2.075.0 (34160 (2.440 - TO 7200 7200 17300 20 3.225.0 200 1860 155.0 2.1900) (2.1920 2010 ( 21.0 (2.000) (2,000.00 (1,182.0 000 2010 SEO 2,400 TOO (1) 11.69.) utoSave OFF Target Financials Home Insert Page Layout Formulas Data Review View Arial 8 A- A Wrap Text General Paste 00 B I A Merge & Center - $ % 2 1 fx B D E F G 1150 7010 (3040) (318.0) Stock-Based Compensation Net Cash From Discorud Ops Other Operating Activities Change in Inventories Change in Acc. Payable Change in Other Net Operating Assets Cash from Ops 1470 18.0 1650 180 1130 1070 3910 280.0 (1660) 3380) 5.84 132.0 30 3150 (900.0) 1120 74.0 (710) (3480) 13070 2030 6,205.0 1,000 5.958.0 (2100) 5.973.0 5050 140.0 2170 7,117,0 2460 1680 1,068 Q.10 (1.5470) 40 (2.5330) 31.0 (518) (3.5160) 30 (3.0070 10 - (1,4380) 200 - 1,8750 240 - 190 508.0 (560) 150 200 220 (1.473.0) (2.05.) (2416.0) (2.9460) - 1.9770 1977 en 7380 799.0 17380 1,730.0 3,225.0 (860) (83.0 (28109 (2.6490 (2,649.0 (2.1920) (2.1920 2.6690 (2.009.09 (1.100.0 3000 4530) 2210 (3.706) 1080 (1.046 (2.124.02 730 (1,565.0 Captal Expenditure Sale of Property. Plart, and Equipment Cash Acquistions 3 Divestures The Market & Ely Securt Net (Inc) Dec. in Los Origine sold 9 Other Investing Activites 0 Cash from Investing 1 2 Short Term Debted 3 Long Term Dettissued -4 Total Debt issued 5 Sport Term Dect Read 16 Long Term Deli Repard 37 Total Debt Repaid 8 49 ar of Commons 550 Rapurther Common Shock 51 52 Common Dividends Paid 53 Total Dividenda Paid 54 55 sec Dividend Pad 56 Financing Act 57 Cash from Financing 58 59 Net Change in Cash 60 61 Supplements 62 Cintag 83 Chad 64 lavered Free Cashflow 65 Unlovered From Can Flow 66 Change in Not Working Capital 87 Net Det 58 Not Fron Discontinued Ops - Investing 89 Fing 70 Resumer Type 71 Calculation Type 72 560 (1,600 (1.3820) (1.362.01 (1.3380 (1.348.) (1,3380 (1.335.0 (1,335.0 (1,300.00 (1,3300 (1.334.0) (1.21 (4.6300 15.05.09 (3,729.0 (3,644.0) 13.12.07 (831.01 180 11 LLEN LO 1. 49220 3040 (1270 5.1.4 SB (1.484.0) (5) 190 Mar.14-2018 RS REP 9000 15140 3443 3,8049 2010 16.12.09 6780 MO 36755 40038 (1.215.00 1.4500 33.0 19408 1.79 (1910 (2810) 3,331 3,660 (071) (3300) 492.0 B010 5.4001 SEK (2.000 20000 Mar 15 2009 RS REP Mar. 11-2020 RS REP Mar. 11-2020 NC REP Mar. 11-20 0 REP Aug 25-2 0 LTM Income Statement Balance Sheet Cash Flow + Ready AutoSave LORE Walmart Financials Fa20 online Home Insert Page Layout Formulas Data Review View Arial 8 A- AT Wrap Text General Paste B 1 U - Merge & Center $ - % Conditional Format Cell Formatting as Table Styles D E F G Restatement Order Conversion: Decimals: Latest Fings Latest on Font Historical Capital IQ (Default) Restated 12 months Jan-31-2018 USD 12 months Jan 31 2019 USD 12 months Jan-31-2020 USD LTM 12 months Jul 31 2010 USD 9.1020 10 5200 10.529. 0,670 10,678 0 10,678.0 14,881.0 11 4670 11,487. 17,895.0 11,5030 11,503 A1 5 Walmart Inc. (NYSE:WMT) > Financials > Cash Flow 6 7 in Milons of the reported currency, except per share tems Template: Standa B Period Type Annual 9 Currency Reported currency 10 S&P Capital IQ (Defaut 11 Source Captal & Proprietary 12 13 14 Cash Flow Restased Restated For the Fiscal Period Ending 12 months 12 months 15 Jan-31-2016 Jan-31-2017 16 Currency USD USD 17 18 Net Income 14,694.0 13.643 19 Deprecision & Amor 9,4540 10 000 20 Depreciation & Amort, Total 9.454.0 10.000 21 22 ani Los From Sans Of Assets 23 in Los Os Se On 24 Other Operating Activities 1.1240 1,6170 25 Change in At Receivable 118.01 14020) 25 Charge is inventions (703) 27 Change in Are Payable 2,000 3,0420 26 Charge in. Tas 147201 29 Dragon Net Operating Assets 12800 30 Cash from O 21,6520 31,6730 31 32 Captal Expenditure 111,47701 [10,6100) 33 Sale of Property Plant, and Equipment 6350 4560 34 Can Agustin 12.483.0) 35 Die 240.0 6620 36 in Marketable & Equity Securt 11,1010) 37 Net Inc) Dec. in Loans Orgined 38 Open Activities (790) (310) 39 Cash to investing (10.675.0) 113,096.01 40 41 Got Tam Deed 1.235.0 Income Statement Balance Sheet Cash Flow + Ready 52.0 (5.161.0) 1.200.0 4,7030 (1.014 0) (1400) 4.000.0 (557.0 4,650.0 3,6180 1,744.0 (380) 11,311.00 1,8310 1400) 1030 27,753 (1,380.00 1,105.0 1540 (3000) 12740) 1.0400 2,020.0 205.0 3,271.0 33.000 1800 20,337. (10,051.00 3780 (378.00 1.0400 (10,3440) 510.0 (14,6560) 8780 (9.403.0) 278.0 (17501 0 (10.705.0) 3210 (550) 833.0 - - 479.0 (9,1280) 072.0 10.01 14310 24,0360 3640 0.2380) 4,1480 Autove O Walmart Financials Fa20 online Home Insert Page Layout Formulas Data View Review Inser Arial . Wrap Text General Deler Paste B I ** Merge & Center $ - % Conditional Format Cell Formatting as Table Styles - Forme A1 B D E F G H 6350 458.0 2.463.0) 602.0 (1.901.0) 3780 375.0) 10460 519.0 (14.658.0) 8780 3210 560) 6330 276.0 (1750) 246.0 (19.01 (10,675.0 (31.0) (13.896.0) (770) (9,079.0) (431.0) (24,0360) 479.0 19.128.0) 354.0 (8,9380) 1.2350 39 1.274.0 4,148.0 74760 11.6240 1.472.0 137.0 131.0 (1.673.0) (2,055.0) (3.720.0) 15,8720 15,8720 (530) 3.784.01 3,837.0) 5,492.0 4.658.0) (1,907.) 6.5630) (4.432.0) (4.4320) (13.061.0) (13,061.0) (7.707.0) 14.112.09 18.293.0) 18,296.0) 7.410.0 (5.717,0) 12.733.0) 33 Sale of Property, Plant, and Equipment 34 Cash Acquisitions 35 Divestitures 36 Invest in Marketable & Equity Securt 37 Net (inc) Dec. in Loans originatedSold 38 Other Investing Activities 39 Cash from west 40 41 Short Term Debt issued 42 Long-Te Debt issued 43 Total Debt issued 44 Short Term Debt Repaid 45 Long-Term Debt Repaid 46 Total Debt Repaid 48 Repurchase of Cormon Stock 49 50 Common Dividends Paid 51 Total Dividends Paid 52 53 Special Dividend Paid 54 Ore Francing Activities 55 Cash from Financing 56 57 Foreign Exchange Rate Adi 58 Net Change in Cash 59 60 Supplements 61 CashPad 62 Cash Taxes Paid 63 Levered Free Cash Rew 64 Une Free Flow 65 Change in Net Working Capital 66 Net Destes 67 Fig Date 68 Retent Type 69 Cation Type 70 10,2940) 15.214.0) 0.2180) 16.216.0) 0.124.0) 16.1240) 0.10201 16.102.0) 16.048.0 16,048.0) 18.070) (6,0706) 2.2210 (16,285,0) 19670 119.072.0) 14.01 ) (19.875.0) 1.000) 02.537.0) (14630) (14.299.0) (15440) (16,582.0) (4380) 1890) 11.0220 0.00 1280 (4520) 1.AZDI 487 110.00 2.540.0 8.1110 14.5401 16.1326 (2.6420 3.1580) Mar-30-2018 RS REP 2,351.0 4,5070 17,090.1 19,39.5 105.0) 0.5010) Mar 28-2019 2.4500 6,1700 164084 17-9548 0.765.0) 2,348.0 3.820 12.084.0 14,451.1 4790 12,0350 Mar 20-2020 NC 2.4640 3.8160 15.145.1 16,7995 (1.736.0) 11.07.01 Mar-20-2020 0 REP 2,6840 3,6180 214,000 26,473.4 0.7000) 15,233.0) Sep-02-2020 O LTM M-20-2020 REP REP Income Statement Balance Sheet Cash Flow + Roare AutoSave Target Financials Home Insert Page Layout Formulas Data Review View Arial 8 A- A- Wrap Text General Paste B I Merge & Center $ - % 89 Fe 1 fx B D E G Target Corporation (NYSE:TGT) > Financials > Cash Flow in Millions of the reported curry, Good pershare/toms. Template Period Type Currency Units: Source Restatement: Order Conversion Decimal Am Report Currency SSP COD Capital Party Latest Filling Letonight Historical Capital (D) D 4 Cash Flow R For the Fiscal Period Ending Related 12 months Jan-30-2016 USD Rostad 12 months Feb-03-2018 USD 12 months Feb-02-2019 USD 6 Currency LTM 12 months Aug-01-2020 USD 12 months Feb-01-2020 USD USD 2730 2050 360 2.100 230 2.2130 2.40 2.620 3,5720 2.9370 2.4000 14.0 2.4740 3,2810 2,5910 30 2.00110 2.et 130 2,20 1963.0) (110 30 1170 910 1120 1150 500 230 1650 180 132.0 136 16.09 320) OTO 3040 2233 (1960 (308 33.0 (9000) 11270 (2900 STO 80 23.0 1470 0 1280 5050 1000 217.0 7.117.0 2000 LANO 5.958.0 6.885.0 9.4210 7 B Netlone 9 Depreciation Amort CO Amort of Goodwil and intangibles 1 Depreciation & Amort. Total 22 23 Games From swe Of Assets 24 set Whedon & Restructuring Costs 25 Sock Band Compensation 26 Net Cash From Discord 27 Ore Operating Activities 28 Charge inverter 29 Change in Aos. Payable 30 Change in Other Net Operating Ass 31 Cash from Ops 32 33 Capital Expenditure 34 Sale of Property. Plart, and Equipment 35 Cash Acquisitions 36 Diver 37 vest in Markable & Equity Secut 38 Netine) Dec. in Lars Originald 39 Other resing Activiti 40 Cmh from Inting 41 42 Short Term Det 43 Long Term Datud 44 Total Debt 45 Short Term De Rapat 46 Long-Term Deot Repaid 47 Total Debt Repad 48 49 ce of Common Stock 50 Repurchase of Common Stock 51 (10) 280 (1500 12.500 210 (580 (30470 (2.516.01 350 - (3027) 630 150 2010 - 220 16750 240 - 190 Seo 2.075.0 (34160 (2.440 - TO 7200 7200 17300 20 3.225.0 200 1860 155.0 2.1900) (2.1920 2010 ( 21.0 (2.000) (2,000.00 (1,182.0 000 2010 SEO 2,400 TOO (1) 11.69.) utoSave OFF Target Financials Home Insert Page Layout Formulas Data Review View Arial 8 A- A Wrap Text General Paste 00 B I A Merge & Center - $ % 2 1 fx B D E F G 1150 7010 (3040) (318.0) Stock-Based Compensation Net Cash From Discorud Ops Other Operating Activities Change in Inventories Change in Acc. Payable Change in Other Net Operating Assets Cash from Ops 1470 18.0 1650 180 1130 1070 3910 280.0 (1660) 3380) 5.84 132.0 30 3150 (900.0) 1120 74.0 (710) (3480) 13070 2030 6,205.0 1,000 5.958.0 (2100) 5.973.0 5050 140.0 2170 7,117,0 2460 1680 1,068 Q.10 (1.5470) 40 (2.5330) 31.0 (518) (3.5160) 30 (3.0070 10 - (1,4380) 200 - 1,8750 240 - 190 508.0 (560) 150 200 220 (1.473.0) (2.05.) (2416.0) (2.9460) - 1.9770 1977 en 7380 799.0 17380 1,730.0 3,225.0 (860) (83.0 (28109 (2.6490 (2,649.0 (2.1920) (2.1920 2.6690 (2.009.09 (1.100.0 3000 4530) 2210 (3.706) 1080 (1.046 (2.124.02 730 (1,565.0 Captal Expenditure Sale of Property. Plart, and Equipment Cash Acquistions 3 Divestures The Market & Ely Securt Net (Inc) Dec. in Los Origine sold 9 Other Investing Activites 0 Cash from Investing 1 2 Short Term Debted 3 Long Term Dettissued -4 Total Debt issued 5 Sport Term Dect Read 16 Long Term Deli Repard 37 Total Debt Repaid 8 49 ar of Commons 550 Rapurther Common Shock 51 52 Common Dividends Paid 53 Total Dividenda Paid 54 55 sec Dividend Pad 56 Financing Act 57 Cash from Financing 58 59 Net Change in Cash 60 61 Supplements 62 Cintag 83 Chad 64 lavered Free Cashflow 65 Unlovered From Can Flow 66 Change in Not Working Capital 87 Net Det 58 Not Fron Discontinued Ops - Investing 89 Fing 70 Resumer Type 71 Calculation Type 72 560 (1,600 (1.3820) (1.362.01 (1.3380 (1.348.) (1,3380 (1.335.0 (1,335.0 (1,300.00 (1,3300 (1.334.0) (1.21 (4.6300 15.05.09 (3,729.0 (3,644.0) 13.12.07 (831.01 180 11 LLEN LO 1. 49220 3040 (1270 5.1.4 SB (1.484.0) (5) 190 Mar.14-2018 RS REP 9000 15140 3443 3,8049 2010 16.12.09 6780 MO 36755 40038 (1.215.00 1.4500 33.0 19408 1.79 (1910 (2810) 3,331 3,660 (071) (3300) 492.0 B010 5.4001 SEK (2.000 20000 Mar 15 2009 RS REP Mar. 11-2020 RS REP Mar. 11-2020 NC REP Mar. 11-20 0 REP Aug 25-2 0 LTM Income Statement Balance Sheet Cash Flow + Ready AutoSave LORE Walmart Financials Fa20 online Home Insert Page Layout Formulas Data Review View Arial 8 A- AT Wrap Text General Paste B 1 U - Merge & Center $ - % Conditional Format Cell Formatting as Table Styles D E F G Restatement Order Conversion: Decimals: Latest Fings Latest on Font Historical Capital IQ (Default) Restated 12 months Jan-31-2018 USD 12 months Jan 31 2019 USD 12 months Jan-31-2020 USD LTM 12 months Jul 31 2010 USD 9.1020 10 5200 10.529. 0,670 10,678 0 10,678.0 14,881.0 11 4670 11,487. 17,895.0 11,5030 11,503 A1 5 Walmart Inc. (NYSE:WMT) > Financials > Cash Flow 6 7 in Milons of the reported currency, except per share tems Template: Standa B Period Type Annual 9 Currency Reported currency 10 S&P Capital IQ (Defaut 11 Source Captal & Proprietary 12 13 14 Cash Flow Restased Restated For the Fiscal Period Ending 12 months 12 months 15 Jan-31-2016 Jan-31-2017 16 Currency USD USD 17 18 Net Income 14,694.0 13.643 19 Deprecision & Amor 9,4540 10 000 20 Depreciation & Amort, Total 9.454.0 10.000 21 22 ani Los From Sans Of Assets 23 in Los Os Se On 24 Other Operating Activities 1.1240 1,6170 25 Change in At Receivable 118.01 14020) 25 Charge is inventions (703) 27 Change in Are Payable 2,000 3,0420 26 Charge in. Tas 147201 29 Dragon Net Operating Assets 12800 30 Cash from O 21,6520 31,6730 31 32 Captal Expenditure 111,47701 [10,6100) 33 Sale of Property Plant, and Equipment 6350 4560 34 Can Agustin 12.483.0) 35 Die 240.0 6620 36 in Marketable & Equity Securt 11,1010) 37 Net Inc) Dec. in Loans Orgined 38 Open Activities (790) (310) 39 Cash to investing (10.675.0) 113,096.01 40 41 Got Tam Deed 1.235.0 Income Statement Balance Sheet Cash Flow + Ready 52.0 (5.161.0) 1.200.0 4,7030 (1.014 0) (1400) 4.000.0 (557.0 4,650.0 3,6180 1,744.0 (380) 11,311.00 1,8310 1400) 1030 27,753 (1,380.00 1,105.0 1540 (3000) 12740) 1.0400 2,020.0 205.0 3,271.0 33.000 1800 20,337. (10,051.00 3780 (378.00 1.0400 (10,3440) 510.0 (14,6560) 8780 (9.403.0) 278.0 (17501 0 (10.705.0) 3210 (550) 833.0 - - 479.0 (9,1280) 072.0 10.01 14310 24,0360 3640 0.2380) 4,1480 Autove O Walmart Financials Fa20 online Home Insert Page Layout Formulas Data View Review Inser Arial . Wrap Text General Deler Paste B I ** Merge & Center $ - % Conditional Format Cell Formatting as Table Styles - Forme A1 B D E F G H 6350 458.0 2.463.0) 602.0 (1.901.0) 3780 375.0) 10460 519.0 (14.658.0) 8780 3210 560) 6330 276.0 (1750) 246.0 (19.01 (10,675.0 (31.0) (13.896.0) (770) (9,079.0) (431.0) (24,0360) 479.0 19.128.0) 354.0 (8,9380) 1.2350 39 1.274.0 4,148.0 74760 11.6240 1.472.0 137.0 131.0 (1.673.0) (2,055.0) (3.720.0) 15,8720 15,8720 (530) 3.784.01 3,837.0) 5,492.0 4.658.0) (1,907.) 6.5630) (4.432.0) (4.4320) (13.061.0) (13,061.0) (7.707.0) 14.112.09 18.293.0) 18,296.0) 7.410.0 (5.717,0) 12.733.0) 33 Sale of Property, Plant, and Equipment 34 Cash Acquisitions 35 Divestitures 36 Invest in Marketable & Equity Securt 37 Net (inc) Dec. in Loans originatedSold 38 Other Investing Activities 39 Cash from west 40 41 Short Term Debt issued 42 Long-Te Debt issued 43 Total Debt issued 44 Short Term Debt Repaid 45 Long-Term Debt Repaid 46 Total Debt Repaid 48 Repurchase of Cormon Stock 49 50 Common Dividends Paid 51 Total Dividends Paid 52 53 Special Dividend Paid 54 Ore Francing Activities 55 Cash from Financing 56 57 Foreign Exchange Rate Adi 58 Net Change in Cash 59 60 Supplements 61 CashPad 62 Cash Taxes Paid 63 Levered Free Cash Rew 64 Une Free Flow 65 Change in Net Working Capital 66 Net Destes 67 Fig Date 68 Retent Type 69 Cation Type 70 10,2940) 15.214.0) 0.2180) 16.216.0) 0.124.0) 16.1240) 0.10201 16.102.0) 16.048.0 16,048.0) 18.070) (6,0706) 2.2210 (16,285,0) 19670 119.072.0) 14.01 ) (19.875.0) 1.000) 02.537.0) (14630) (14.299.0) (15440) (16,582.0) (4380) 1890) 11.0220 0.00 1280 (4520) 1.AZDI 487 110.00 2.540.0 8.1110 14.5401 16.1326 (2.6420 3.1580) Mar-30-2018 RS REP 2,351.0 4,5070 17,090.1 19,39.5 105.0) 0.5010) Mar 28-2019 2.4500 6,1700 164084 17-9548 0.765.0) 2,348.0 3.820 12.084.0 14,451.1 4790 12,0350 Mar 20-2020 NC 2.4640 3.8160 15.145.1 16,7995 (1.736.0) 11.07.01 Mar-20-2020 0 REP 2,6840 3,6180 214,000 26,473.4 0.7000) 15,233.0) Sep-02-2020 O LTM M-20-2020 REP REP Income Statement Balance Sheet Cash Flow + Roare