Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. Show data and caculations within excel. (first two pictures are of Target's cash flow statement and second two pictures are walmart's cash flow statement)
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
walmart balance sheet (first two) and target balance sheet (second two pictures) image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Target Corporation (NYSE:TGT) > Financials > Cash Flow in Millions of the reported currency excepper starteris Template: Period Type: Currency Units: Source: Standard Annus Reported Currency SAPC (0) Capital & Proprietary Restatement: Order Conversion: Decimals: Filings Latest on Right Historical Cap (D) Cash Flow For the Fiscal Period Ending Currency Related 12 months Jan-30 2016 USD Restated 12 months Jan-28-2017 USD Related 12 months Feb-03-2018 USD 12 months Feb-02-2019 USD 12 months Feb-01-2020 USD LTM 12 months Aug-01-2020 USD Net Income Depreciation & Amort Amort. Goodwill and intangibles Depreciation & Amort, Total 3.363.0 2.1900 230 2.213.0 2.734.0 2,305.0 130 2.318.0 2.9140 2.4020 140 24760 2,937,0 2.400.0 140 2.474.0 32810 2.5910 130 2.0040 3.5220 2.500.0 13.0 2.582.0 (110) 3.0 92.0 (Gain) Loss From Sale Of Assets Asel Writdown & Restructuring Costs Stock-Based Compensation Net Cash From Discord und Ops Other Operating Advies Change in Inventories Changin Acc. Payable Change in Omer Net Operating Assets Cash from Ops 1150 7040 (3640) (318.0) 1130 1070 3940 293.0 (1060) 1170 910 1120 740 (710) (348.0) 13070 2630 6935.0 2.0 3150 (9000) 1,1270 (2100) 5,973.0 6.0 23.0 1470 18.0 1780 505.0 1400 2170 7. 1170 50.0 23.0 1850 10.0 63.0 205.0 1.8880 1,0880 9.621.0 1.1680 5958.0 5.4440 (1.438.0) 280 (1.5470 06.0 (2.533.0) 310 (512.0) (3.5180) 850 (3.027.02 630 (3.0470) 63.0 1.8750 240 28.0 (56.0) 15.0 200 22.0 Capital Expenditure Sale of Property, Partand Equipment Cash Acquisitions Divestres Invest in Marketable & Equity Securt Net (Inc.) Dec. in Los OriginatedSold Other Investing Activities Cash from Investing Short Term Deted Long Term Debt issued Total Debt sued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid 190 5080 (1.473.0) (3.075.0) (3.416.0) (2.140 (29420) 1,977.0 1,977.0 7390 790.0 1.7390 1.730.0 3,2250 (85.0) (85.C) (26490) (2640.0) (2.192.0) (2.192.0) (2010) (281.0) (2.009.00 (2.000.00 (1.169.0) Issuance of Common Stock Repurchase of Conton Stock 3000 (3.483.0) 2210 (3.706 ) 1080 (1.048.0) 98.0 (2.1240) 73.0 (1.505.00 560 (1.509) 1150 7040 (3640) (3160) (3820) 1.1680 5,950.0 1130 1070 3940 293.0 (1060 (3110 5,444.0 910 1120 740 (710) (3480) 1 3070 2030 6,933.0 920 1320 30 3150 (9000) 1,1270 (210,0) 5,973.0 230 147.0 180 1780 5050 1000 2170 7.1170 1850 180 000 205.0 1,6880 1.08 9,010 (1,6380) 28.0 (1.5470) 60 (25330) 310 (518.00 (3.516.0) 850 (3.0270) 6370 (3.047) 630 20.0 (55.00 150 200 22.0 1.875.0 240 - 19.0 5080 (1.473.0 (3.075.0) 13,416.0) (2.944.0) (2.962.0) 7300 7300 1970 1.7300 1,7300 3.225.0 (860) (2810) 24 Aset Wadon & Rouring Costa 25 Stock-Based Composition 26 Net Cash From Discontinued Ops 27 Other Operating Act 28 Charge in invertories 29 Charge in Acc. Payil 30 Change in Other Net Operating Assets 31 Cash from Ops. 32 33 Cap Expenditure 34 Sale of Property. Part, and Equipment 35 Cash Aquins 36 Divestres 37 Invest in Marble & Equity Securt 38 Net (Ine) Dec. in Los Originated Sold 39 Other investing Activities 40 Cash from Investing 41 42 Short Term Dettlosed 43 Long Term Debt und 44 Total Debt ved 45 Short Term De Repaid 46 Long Term De Rapid 47 Tot Debt Repaid 48 49 le Connontok 50 Rapurchase Common Stock 51 52 Common Dividends Paid 53 Tot Dividenda Pald 54 55 Social Dividend Paid 56 Omer Financing Advies 57 Cash from Financing 58 59 Net Change in Cash 60 61 Supplemental Items 62 Cash Interest Paid 63 Cash Te Pad 64 Levered Free Cash Flow 65 Unlevered Free Cash Flow 66 Charge in Net Working Capital 67 Nelled 68 Net Cash From Discontinued Ops.- Investing 69 Filing Date 70 Rent Type 71 Caoution Type 60 (2.6490 (2.640.0) (2.1920 (2.1920) (2.089 0) (2.000) (1.169.0) 3000 (9.4000) 1000 (10) (3.7060) 900 12.124.0) 730 (1.00) 500 (1.600) 1001 (1,820) MO (1.330 TOO (1.335.6) DO (1.330.01 13401 (30) (4,630.01 (5.505.09 (3.729.00 (3,644.0) (3.152.01 (831.0 111 12:10 STRATA 4320 8960 8040 (1270) 5.186.4 5.585.8 (1.4840) 900.0 1,5140 3:4493 3,8049 2040 (8720) 6780 9340 3.6755 4,000 (1.215.00 3730 1.5498 1.839 (1040) (2010) 3.8550 (9710) (3300) 4020 6980 5.408.1 5.085.6 (2.8900) 2.056,0 19.0 Mar-14-2015 RS REP Mar. 11. 20120 Nar-13-2019 RS REP Mar.11-2020 RS REP Mar-11-2020 NC REP Aug 25 2120 O LTM REP Restatement Order: Conversion: Decimals: Latest Filings Latest on Right Historical Capital 1 (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-2020 USD 9,862.0 10,5290 10,529.0 6,670.0 10,6780 10,678.0 11.467.0 11,467.0 17,895.0 11,5030 11,593.0 5 Walmart Inc. (NYSE:WMT) > Financials > Cash Flow 6 7 in Millions of the reported cumoncy, except per sharedoms. Template: Standard 8 Period Type: Annual 9 Currency: Reported Currency 10 S&P Capital IQ (Default 11 Source: Capital IQ & Proprietary 12 13 14 Cash Flow Restated 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.0 19 Depreciation & Amon 9,4540 10.080.0 20 Depreciation & Amort, Total 9,454.0 10,080.0 21 22 Gain) Loss From Sale Of Assets 23 Gain) Loss On Sale Of Invest. 24 Other Operating Activities 1,124.0 1.6170 25 Change in Ace Receivable (19.0) H020) 26 Change in Inventories (703.0) 1.0210 27 Change in Ace Payable 2,000.0 3,942.0 28 Change in Ine. Taxes (472.0) 492,0 29 Change in Other Net Operating Assets 1,466.0 1.2000 30 Cash from Ops 27,552.0 31,673.0 31 32 Capital Expenditure (11,477.0) (10.619.0) 33 Sale of Property, Plant, and Equipment 635.0 450,0 34 Cash Acquisitions (2.463.0) 35 Divestitures 2460 662,0 36 Invest in Marketable & Equty Securt (1.901.0) 37 Nel (in.) Deo. In Loans Originated/Sold 38 Other Investing Acties (79.0) (310) 39 Cash from westling (10,675.0) (13.090.0) 40 4.703.0 (1.074.0) (1400) 4,086 0 (5570) 9280 20.337.0 4,850.0 3,516.0 1,744.0 (368.0) (1,311,0) 1,831,0 (40.0) 183.0 27,753.0 15.0 (1.8860) 1,105.0 1540 (3000) (274) (93.0) 1860 25.255.0 52.0 15,161,0) 1,206.0 (1.0) 1,940.0 2 2,020.0 205.0 3,2710 33,026,0 (10.051.0) 3780 (375.0) 1,048.0 110,344,0) 519,0 (14,656.0) 876,0 (10.705.0) 3210 (56.0) 833.0 (9.403.0) 278.0 (1750) 0 (170) 09,079.0) 1431.0) (24,036.0) 4790 9.128.0) 364,0 (0,9380) (11.477.0) 6350 (10,619.0) 450.0 12.463.0) 6620 (1,901.0) (10.051.0) 378,0 (375.0) 1,046,0 (10,3440) 519.0 (14,656.0) 8780 (10.705.0) 321.0 (56.0) 833.0 (9.403.0) 2760 (1750) 2460 (77.0) (790) (10.675.0) (31.0) (13,896.0) (431.0) (24,036.0) 479.0 (9.128.0) 364.0 (8.9380) 1.2350 390 1.274.0 4.148.0 7.476,0 11.624.0 1.472.0 137,0 137.0 (1,673.0) (2,055.0) (3,728.0) 15.872.0 15,872.0 (530) (3.784.0) (3,837.0) 5,492.0 5.492.0 14,656.0) (1,907.0) 16,563.0) (4.432.0) (4.432.0) (13.061.0) (13.061.0) (7.707.) (4.112.0) (8,298.0) (8.296.0) 07.410.0) (5,717,0) (2.733.0) 32 Captal Expenditure 33 Sale of Property. Plant, and Equipment 34 Cash Acquisitions 35 Divestres 36 Invest. in Marketable & Equity Securt. 37 Net (Inc.) Dec. in Loans Originated Sold 38 Other Investing Activities 39 Cash from Investing 40 41 Short Term Debt Issued 42 Long-Term Debt issued 43 Total Debt issued 44 Short Term Debt Repaid 45 Long-Term Debt Repaid 46 Total Debt Repaid 47 48 Repurchase of Common Stock 49 50 Common Dividends Paid 51 Total Dividends Paid 52 53 Special Dividend Paid 54 Other Financing Activities 55 Cash from Financing 56 57 Foreign Exchange Rate Ad 58 Net Change in Cash 59 60 Supplemental items 61 Cash Interest Paid 62 Cash Taxes Paid 63 Lovered Free Cash Flow 64 Unlevered Free Cash Flow 65 Change in Not Working Capital 66 Net Debt issued 67 Filing Date 68 Rostatement Type 69 Calculation Type 70 18.294.0) (6.294.0) 10.216.0) 16,216.0) (8.124.0) (6.124.0) 10.102.0) 18,102.0) 18.048.0) 16,048.0) (0.070,0) (5.070.0) (2.721.0) (16.285.0) 1967.0) (19,072.0) (4.018.0) (19.875.0) (1,060,0) (2,537.0) (1.463.0) (14,299.0) (1.5440) (16.582.0) 487.0 169.0) (1.0220) 10. (452.0) 11.7470 (438.0) 742.0 1280 7.6144 2.540.0 8.1110 14,540.1 16.1326 (2.6420) (3.158.0) Mar-30-2018 RS REP 2,351.0 4,507.0 17.910.1 19,389.5 (5.105.0) (3,591,0) Mar-28-2019 RS REP 2.450.0 6.179.0 16.4984 17.954,6 (3.765,0) (1.437.0) Mar-20-2020 RS REP 2,3480 3,982.0 12,984.9 14,451.1 4790 12,035.0 Mar-20-2020 NC REP 2.464.0 3,616,0 15.145.1 16,769.5 (1.736,0) (1.071.0) Mar-20-2020 0 REP 2.464.0 3.616.0 24.889.0 26.473.4 (7.790.0) (8.235.0) Sep-02-2020 LTM D E F G S&P Capital 10 Restatement: Order: Conversion Decimals: Fing Latest on Right Historical Capital (D) Jan-31-2018 USD Jan-31-2019 USD Jan-31-2020 USD Jul-31-2020 USD 8,7580 6.756.0 7.7220 7.722.0 9,4650 9,465.0 16.9080 16.906.0 3.0140 5,6140 6.283.0 6,2040 6,234.0 5,111,0 4,700 3.5110 M200 3.6230 MASSO 1.4220 41 OMO 180 5 Walmart Inc. (NYSE:WMT) > Financials > Balance Sheet 6 7 Millions of the reported currency excap per share them Template: Standard 8 Period Type Amul 9 Currency: Reported Currency 10 Unite S&P CWD 11 Source Capital & Proprietary 12 13 14 Balance Sheet Balance Sheet of 15 Jan-31-2016 Jan-31-2017 16 Currency USD USD 17 ASSETS 18 Cash And Equivalente 8.7050 6.8870 19 Total Cash & ST Investments 8.705.0 6,367 20 21 Accounts recevoie 5.6240 5,8050 22 Tot Receivables 5.6240 5.BOSO 23 24 wtry 4400 3000 25 Prud 1410 19410 20 One Current Assets 27 Tot Current Auto 0.230.0 57.000 28 29 Groms Proovy Plats per 0540 191,1200 30 And Depreciation (71.500 70.95101 31 Net Property, Plant & Equipment 110.5160 114178.0 32 33 Longmarts 6210 490 34 Goodwill 10.6050 17.0370 35 Other Wangi . 36 Deferred Tax As LT 1.5040 1.5850 37 Other Long Term Auto 4.0000 73770 38 Total Ass 108. ROSA 39 40 LIABILITIES 41 Accounts Payable 304870 41,433.0 42 Accrued Exp 19 8070 18.798.0 43 Sam Borrowings 28 1.0990 44 Curr. Port of LTD 2.7450 2.250.0 45 Curr. Port of Loose 551.0 535.0 46 Curr.Income Tax Payable 5210 9210 47 Ured Revenue Current 1680 48 One Current Labs 49 Tot Current Liabilities 64.8190 86.828.0 50.6640 61.007.0 61.000 40000 19770 (83.039.00 114,8180 195700 (37,1780) 111 3850 217.00 (90.300,00 127,649.0 2109170 (97.6230 122.894.0 7.6140 18.2420 10.500 29.5420 39950 31,1810 5.8000 1,7380 3.231.0 210 2256 5.9900 31.0730 5.2000 1,9140 3.4830 VARA 1.8790 2.3050 204520 9.3810 480920 20,1050 5.2570 3,7380 6670 8450 2,0170 470000 20.2270 52250 1.81 72910 4280 19120 41.973.0 20.3080 5750 5,362.0 2-3040 280.0 1.9900 4832200 23.7680 3570 5.5530 2.283.0 8100 310000 78.521.0 TT ATT 77.790.0 61.990 3,080.0 81,957.0 71.790.0 41,7070 20.320 400 20.478.0 1400 6.2040 52210 154.943.0 12.1790 15 185.0 2340 3.2470 33.930 2830 3,1970 87.6140 (128050) 74 6800 [157840) 753100 0.083.0 5,8070 $1.5520 81.1972 WASSA ZAZ 20 48 Other Current Life 49 Total Current Liabitos 64.619.0 66.928.0 78.521.0 77 4770 50 51 Long Term Det 39.9620 6450 302310 39680 52 Long Term Les 5.8160 6.003.0 6.7800 6.63000 53 Pansion & Other Post Retireers 2050 332.0 2010 175.0 54 Del Tax Usby, Non-Curr. 3.350 43030 3,831.0 55 Other Non Current Libis 3,0210 4,049.0 4.0580 5,082.0 56 Total Liabilities 115.970.0 118.290.0 123.700.0 139,661.0 57 58 Common Stock 3170 3050 2950 2880 59 Additional Paid in Cap 1.8080 2.3710 2.6480 2.905.0 60 Retained Earning 90,0210 19,354,0 95.1070 80,7950 61 Treasury Stock 62 Comprehensive Inc. and Other (11.5070 (14.23201 (10,1810) (11 520) 63 Total Common Equity 80 40 77,7980 TT.860.0 12.490 64 65 Minority rest 3,0050 27370 2.9500 7,1380 66 67 Total Equity 26110 5 82.8220 68 69 Total Lities And Equity 12. VILA 191 204.5220 2011 70 71 Supplemental Home 72 Tol Sw Out on Filing Date 3,1443 3.033.0 2.9507 2.889.7 73 Total Seres Out on Balance SheetDate 3.620 310680 2.9620 2.8780 74 Book Share $25.47 $25.52 $28.38 $25.19 75 Tangle Book Value 13,851.0 60,7010 59.6270 35.515.0 76 Tangle Book $20.10 $19.93 $20 2 $1234 77 To Do 50,7720 18.88 486730 58.481.0 78 Net Det 2,0670 39.7010 39.9170 507390 79 Det Equivalent Oper Leases 20,0000 20.000 23.2000 240000 80 To Minority rest 3.000 27370 2.9530 7,1300 81 Invertory Method LIFO UFO LFO LIFO 82 Land 25.0240 24,8010 25.2000 24.COM 83 Building 95,850 98.5470 101,1550 101,005.0 84 Machinery 49,9500 51300 55,0820 56,8040 85 Construction in Page 4,5300 43010 3,6100 3,4740 86 Ft Time Employees 2.300,000 2,300,000 2,300,000 2.200.000 87 Ander Cap. Le Gross 11,0960 11,6370 12.7030 12,780.0 88 Assets under Create Accum. Der (4.7510 (5.1800) (5.580.0) (5.8820 89 Aoun Alware for Doubu Acte 700 NA NA NA 90 ling Mar-30-2018 Mar 28 2019 Mar-20-2020 Mar-20-2000 91 Resort Type NC NC NG NC 92 Coulon Type RUP RUP REP 93 94 95 Note: For multiple class corporis, total scout we primary care equivalere, and for foreign companies listed as primary ADRs, she court ADR-valet re 28323 28325 31356 73.1200 63.040 2010 6.8330 UFO 246190 105 5140 80.940 37510 2.200.000 NA NA NA Mar 20 2020 O REP 2.6338 2.310 $26.57 45,700.0 $16.15 70.220 533000 NA 5,0670 NA NA NA NA NA NA NA NA Sep-09-2000 REP 1 S&P 3 Capital IQ 5 Target Corporation (NYSE:TGT) > Financials > Balance Sheet 7 A Millions of the reported currency except per she terms. Template Standard 8 Period Type: Aus 9 Currency Reported Currency 10 Unit S&P Cap (Det) 11 Source Capital & Proprietary 12 Restatement: Order: Conversion Decimal: Latestonian Historical Capa (Default) Jan-30-2016 USD Reclassified Jan-28-2017 USD Restated Feb-03-2018 USD Feb-02-2019 USD Feb-01-2020 USD Aug-01-2020 USD 4,0480 25120 2.6430 25770 7.2840 270 7.3110 4,040.0 2,5120 2.643.0 1,500.0 25770 7000 7380 7.0 9290 9290 1.1000 1,100.0 0820 9820 8.8780 2140 82000 2070 2130 11 8.5970 1570 2140 12.540.0 9,4070 1570 2000 12.510.0 8.9920 1540 2170 12.0020 14100 14310 17,6230 14 Balance Sheet Balance Sheets of 15 16 Currency 17 ASSETS 18 Cash And Equivalery 19 Short Term verters 20 Total Cash & ST Investments 21 22 Account Receive 23 Other Receives 24 Total Receivables 25 26 tary 27 Prepaid 28 Ohe Current Asset 29 Tot Current Auto 30 31 Gross Property Part & Equipment 32 Accurated Depreciation 33 Net Property, Plant & Equipment 34 35 Long-term investments 38 Goodwill 37 Omer anges 38 Deferred Charges. LT 39 One Long Term Assets 40 Total Assets 41 42 LIABILITIES 43 Accounts Payable 44 Accrued Exp 45 Curr. Port of LTD 46 Curr. Port of La 47 Curr.Income Tax Payne 48 Urearned Revenue, Current 41,400 2010 25.2170 2011 (174130 246510 48180 MON 21.420.0 40,1050 (1820 27,400.0 411830 19.6040 21.51.0 33130 1910 20.072.0 40 2390 - 6300 790 100 6000 000 1370 6330 530 270 1300 610 810 0100 A22120 500 78.0 5200 5600 6340 112 5350 ATRIA 74180 1.9420 72520 1.800.0 1,7180 8.8770 2.0870 2010 2280 97810 20040 1.002.0 2190 99200 1.983.0 940 2870 10.7280 4.0750 1090 2070 5000 6440 VA 1580 693.0 MA 7270 3000 . 9350 VA 775.0 20v 775.0 - 9950 12800 14.470 15.8420 14 2000 2.2410 10 ans o 3.578.0 539.0 1070 1.1220 180 30.94.0 11210 35,4220 20 82210 84110 82000 7,1210 968 11,831.0 (833.0 12.578. 11,3310 12.5706 ATRO 46 Curr. Port of Laos 2280 2190 47 Curr.Incorre Tas Payable 5020 1580 . 48 Unand Ravenue. Current 0640 6800 7270 8400 49 Omer Current Us 1290.0 1.000 1.1320 1.1580 50 Total Current Liabilities 12 6220 12.707.0 13.052.0 15.0140 51 52 Long Term Dell 11,9450 11.0310 10 2380 9.2550 53 Long Term Les 28090 2,9720 54 Unearned Revenue, Non-Current 6800 6300 800.0 5700 55 Pension & Other Post Relre. Bereits 340 400 410 400 56 De Tax Uly. Non-Curr. 6230 010 693.0 9720 57 One Non-Current Les 1 2010 1200 12190 1,1700 58 Tots 27305.0 26.480 2120 29993 59 60 Common Stock 500 480 450 430 61 Addow Paid in Cow 53680 56610 5580 6,0420 62 Rod Eng a 1880 58840 64950 8.017 63 Treasury Stock 64 Comprehensive Inc. and Other (200 8380 7470 (8050 65 Tot Common Equilly 12. 10,953.0 11,6510 11 2010 66 67 Total Equity 11.6510 68 69 Tot Llis And Equity 4212 VALO 412800 70 Supplementima 72 To Swoonlig Date 0000 5827 5388 5103 73 Tots out on acero 6022 5002 5417 5178 74 Book Valur RI 75 Tante Bok Ve 12.30 19,7700 10.920 10.000 78 Tangie Back $19.3 5202 77 Tower 12.79 12.7490 13.400 13,4480 78 Ned De 2.7220 1020 10.8330 79 Div. of Unded Pro. Develt Oligion (1001 70 70 330 80 Dell Opere AMO 1.60 1,200 81 Inventory Mood UFO LIFO LIFO LFO 82 and 6.1250 6980 0950 6.0510 83 Bilding 27 0500 27,6110 209780 20,3600 84 May 7.9540 6.1540 3.2000 8.4500 85 Construction in Progress 3150 2000 4800 4300 86 Full Time Employees 341.000 323,000 345.000 300.000 87 Assets de Cae Lee Gross NA NA 1.1590 8720 88 Assets under Cap. L Accum. Der NA NA (3170) (3710) 89 Filing Date Mar 14 2010 Mar 13 2010 Mar 11-2020 Mar-11-2020 90 Rent Type NC RC RS NC 91 Calotion Type RUP RUP RUP REP 92 93 94 Note Formule class companies, tal share courts are primary class equivalent and for foreign companies listed as primary ADRs. Share courts are ADR-equivalent 3003 5010 5042 123 47 11.1670 12.5780 2514 10.7570 13.9940 11.3070 1170 21020 LIFO 0.0000 294230 8.750 5300 30.000 1.1300 (410) Mar. 11-2020 o REP NA NA NA 0.0270 30.9460 8.2960 8110 NA NA NA Aug 29 2020 0 REP Target Corporation (NYSE:TGT) > Financials > Cash Flow in Millions of the reported currency excepper starteris Template: Period Type: Currency Units: Source: Standard Annus Reported Currency SAPC (0) Capital & Proprietary Restatement: Order Conversion: Decimals: Filings Latest on Right Historical Cap (D) Cash Flow For the Fiscal Period Ending Currency Related 12 months Jan-30 2016 USD Restated 12 months Jan-28-2017 USD Related 12 months Feb-03-2018 USD 12 months Feb-02-2019 USD 12 months Feb-01-2020 USD LTM 12 months Aug-01-2020 USD Net Income Depreciation & Amort Amort. Goodwill and intangibles Depreciation & Amort, Total 3.363.0 2.1900 230 2.213.0 2.734.0 2,305.0 130 2.318.0 2.9140 2.4020 140 24760 2,937,0 2.400.0 140 2.474.0 32810 2.5910 130 2.0040 3.5220 2.500.0 13.0 2.582.0 (110) 3.0 92.0 (Gain) Loss From Sale Of Assets Asel Writdown & Restructuring Costs Stock-Based Compensation Net Cash From Discord und Ops Other Operating Advies Change in Inventories Changin Acc. Payable Change in Omer Net Operating Assets Cash from Ops 1150 7040 (3640) (318.0) 1130 1070 3940 293.0 (1060) 1170 910 1120 740 (710) (348.0) 13070 2630 6935.0 2.0 3150 (9000) 1,1270 (2100) 5,973.0 6.0 23.0 1470 18.0 1780 505.0 1400 2170 7. 1170 50.0 23.0 1850 10.0 63.0 205.0 1.8880 1,0880 9.621.0 1.1680 5958.0 5.4440 (1.438.0) 280 (1.5470 06.0 (2.533.0) 310 (512.0) (3.5180) 850 (3.027.02 630 (3.0470) 63.0 1.8750 240 28.0 (56.0) 15.0 200 22.0 Capital Expenditure Sale of Property, Partand Equipment Cash Acquisitions Divestres Invest in Marketable & Equity Securt Net (Inc.) Dec. in Los OriginatedSold Other Investing Activities Cash from Investing Short Term Deted Long Term Debt issued Total Debt sued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid 190 5080 (1.473.0) (3.075.0) (3.416.0) (2.140 (29420) 1,977.0 1,977.0 7390 790.0 1.7390 1.730.0 3,2250 (85.0) (85.C) (26490) (2640.0) (2.192.0) (2.192.0) (2010) (281.0) (2.009.00 (2.000.00 (1.169.0) Issuance of Common Stock Repurchase of Conton Stock 3000 (3.483.0) 2210 (3.706 ) 1080 (1.048.0) 98.0 (2.1240) 73.0 (1.505.00 560 (1.509) 1150 7040 (3640) (3160) (3820) 1.1680 5,950.0 1130 1070 3940 293.0 (1060 (3110 5,444.0 910 1120 740 (710) (3480) 1 3070 2030 6,933.0 920 1320 30 3150 (9000) 1,1270 (210,0) 5,973.0 230 147.0 180 1780 5050 1000 2170 7.1170 1850 180 000 205.0 1,6880 1.08 9,010 (1,6380) 28.0 (1.5470) 60 (25330) 310 (518.00 (3.516.0) 850 (3.0270) 6370 (3.047) 630 20.0 (55.00 150 200 22.0 1.875.0 240 - 19.0 5080 (1.473.0 (3.075.0) 13,416.0) (2.944.0) (2.962.0) 7300 7300 1970 1.7300 1,7300 3.225.0 (860) (2810) 24 Aset Wadon & Rouring Costa 25 Stock-Based Composition 26 Net Cash From Discontinued Ops 27 Other Operating Act 28 Charge in invertories 29 Charge in Acc. Payil 30 Change in Other Net Operating Assets 31 Cash from Ops. 32 33 Cap Expenditure 34 Sale of Property. Part, and Equipment 35 Cash Aquins 36 Divestres 37 Invest in Marble & Equity Securt 38 Net (Ine) Dec. in Los Originated Sold 39 Other investing Activities 40 Cash from Investing 41 42 Short Term Dettlosed 43 Long Term Debt und 44 Total Debt ved 45 Short Term De Repaid 46 Long Term De Rapid 47 Tot Debt Repaid 48 49 le Connontok 50 Rapurchase Common Stock 51 52 Common Dividends Paid 53 Tot Dividenda Pald 54 55 Social Dividend Paid 56 Omer Financing Advies 57 Cash from Financing 58 59 Net Change in Cash 60 61 Supplemental Items 62 Cash Interest Paid 63 Cash Te Pad 64 Levered Free Cash Flow 65 Unlevered Free Cash Flow 66 Charge in Net Working Capital 67 Nelled 68 Net Cash From Discontinued Ops.- Investing 69 Filing Date 70 Rent Type 71 Caoution Type 60 (2.6490 (2.640.0) (2.1920 (2.1920) (2.089 0) (2.000) (1.169.0) 3000 (9.4000) 1000 (10) (3.7060) 900 12.124.0) 730 (1.00) 500 (1.600) 1001 (1,820) MO (1.330 TOO (1.335.6) DO (1.330.01 13401 (30) (4,630.01 (5.505.09 (3.729.00 (3,644.0) (3.152.01 (831.0 111 12:10 STRATA 4320 8960 8040 (1270) 5.186.4 5.585.8 (1.4840) 900.0 1,5140 3:4493 3,8049 2040 (8720) 6780 9340 3.6755 4,000 (1.215.00 3730 1.5498 1.839 (1040) (2010) 3.8550 (9710) (3300) 4020 6980 5.408.1 5.085.6 (2.8900) 2.056,0 19.0 Mar-14-2015 RS REP Mar. 11. 20120 Nar-13-2019 RS REP Mar.11-2020 RS REP Mar-11-2020 NC REP Aug 25 2120 O LTM REP Restatement Order: Conversion: Decimals: Latest Filings Latest on Right Historical Capital 1 (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-2020 USD 9,862.0 10,5290 10,529.0 6,670.0 10,6780 10,678.0 11.467.0 11,467.0 17,895.0 11,5030 11,593.0 5 Walmart Inc. (NYSE:WMT) > Financials > Cash Flow 6 7 in Millions of the reported cumoncy, except per sharedoms. Template: Standard 8 Period Type: Annual 9 Currency: Reported Currency 10 S&P Capital IQ (Default 11 Source: Capital IQ & Proprietary 12 13 14 Cash Flow Restated 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.0 19 Depreciation & Amon 9,4540 10.080.0 20 Depreciation & Amort, Total 9,454.0 10,080.0 21 22 Gain) Loss From Sale Of Assets 23 Gain) Loss On Sale Of Invest. 24 Other Operating Activities 1,124.0 1.6170 25 Change in Ace Receivable (19.0) H020) 26 Change in Inventories (703.0) 1.0210 27 Change in Ace Payable 2,000.0 3,942.0 28 Change in Ine. Taxes (472.0) 492,0 29 Change in Other Net Operating Assets 1,466.0 1.2000 30 Cash from Ops 27,552.0 31,673.0 31 32 Capital Expenditure (11,477.0) (10.619.0) 33 Sale of Property, Plant, and Equipment 635.0 450,0 34 Cash Acquisitions (2.463.0) 35 Divestitures 2460 662,0 36 Invest in Marketable & Equty Securt (1.901.0) 37 Nel (in.) Deo. In Loans Originated/Sold 38 Other Investing Acties (79.0) (310) 39 Cash from westling (10,675.0) (13.090.0) 40 4.703.0 (1.074.0) (1400) 4,086 0 (5570) 9280 20.337.0 4,850.0 3,516.0 1,744.0 (368.0) (1,311,0) 1,831,0 (40.0) 183.0 27,753.0 15.0 (1.8860) 1,105.0 1540 (3000) (274) (93.0) 1860 25.255.0 52.0 15,161,0) 1,206.0 (1.0) 1,940.0 2 2,020.0 205.0 3,2710 33,026,0 (10.051.0) 3780 (375.0) 1,048.0 110,344,0) 519,0 (14,656.0) 876,0 (10.705.0) 3210 (56.0) 833.0 (9.403.0) 278.0 (1750) 0 (170) 09,079.0) 1431.0) (24,036.0) 4790 9.128.0) 364,0 (0,9380) (11.477.0) 6350 (10,619.0) 450.0 12.463.0) 6620 (1,901.0) (10.051.0) 378,0 (375.0) 1,046,0 (10,3440) 519.0 (14,656.0) 8780 (10.705.0) 321.0 (56.0) 833.0 (9.403.0) 2760 (1750) 2460 (77.0) (790) (10.675.0) (31.0) (13,896.0) (431.0) (24,036.0) 479.0 (9.128.0) 364.0 (8.9380) 1.2350 390 1.274.0 4.148.0 7.476,0 11.624.0 1.472.0 137,0 137.0 (1,673.0) (2,055.0) (3,728.0) 15.872.0 15,872.0 (530) (3.784.0) (3,837.0) 5,492.0 5.492.0 14,656.0) (1,907.0) 16,563.0) (4.432.0) (4.432.0) (13.061.0) (13.061.0) (7.707.) (4.112.0) (8,298.0) (8.296.0) 07.410.0) (5,717,0) (2.733.0) 32 Captal Expenditure 33 Sale of Property. Plant, and Equipment 34 Cash Acquisitions 35 Divestres 36 Invest. in Marketable & Equity Securt. 37 Net (Inc.) Dec. in Loans Originated Sold 38 Other Investing Activities 39 Cash from Investing 40 41 Short Term Debt Issued 42 Long-Term Debt issued 43 Total Debt issued 44 Short Term Debt Repaid 45 Long-Term Debt Repaid 46 Total Debt Repaid 47 48 Repurchase of Common Stock 49 50 Common Dividends Paid 51 Total Dividends Paid 52 53 Special Dividend Paid 54 Other Financing Activities 55 Cash from Financing 56 57 Foreign Exchange Rate Ad 58 Net Change in Cash 59 60 Supplemental items 61 Cash Interest Paid 62 Cash Taxes Paid 63 Lovered Free Cash Flow 64 Unlevered Free Cash Flow 65 Change in Not Working Capital 66 Net Debt issued 67 Filing Date 68 Rostatement Type 69 Calculation Type 70 18.294.0) (6.294.0) 10.216.0) 16,216.0) (8.124.0) (6.124.0) 10.102.0) 18,102.0) 18.048.0) 16,048.0) (0.070,0) (5.070.0) (2.721.0) (16.285.0) 1967.0) (19,072.0) (4.018.0) (19.875.0) (1,060,0) (2,537.0) (1.463.0) (14,299.0) (1.5440) (16.582.0) 487.0 169.0) (1.0220) 10. (452.0) 11.7470 (438.0) 742.0 1280 7.6144 2.540.0 8.1110 14,540.1 16.1326 (2.6420) (3.158.0) Mar-30-2018 RS REP 2,351.0 4,507.0 17.910.1 19,389.5 (5.105.0) (3,591,0) Mar-28-2019 RS REP 2.450.0 6.179.0 16.4984 17.954,6 (3.765,0) (1.437.0) Mar-20-2020 RS REP 2,3480 3,982.0 12,984.9 14,451.1 4790 12,035.0 Mar-20-2020 NC REP 2.464.0 3,616,0 15.145.1 16,769.5 (1.736,0) (1.071.0) Mar-20-2020 0 REP 2.464.0 3.616.0 24.889.0 26.473.4 (7.790.0) (8.235.0) Sep-02-2020 LTM D E F G S&P Capital 10 Restatement: Order: Conversion Decimals: Fing Latest on Right Historical Capital (D) Jan-31-2018 USD Jan-31-2019 USD Jan-31-2020 USD Jul-31-2020 USD 8,7580 6.756.0 7.7220 7.722.0 9,4650 9,465.0 16.9080 16.906.0 3.0140 5,6140 6.283.0 6,2040 6,234.0 5,111,0 4,700 3.5110 M200 3.6230 MASSO 1.4220 41 OMO 180 5 Walmart Inc. (NYSE:WMT) > Financials > Balance Sheet 6 7 Millions of the reported currency excap per share them Template: Standard 8 Period Type Amul 9 Currency: Reported Currency 10 Unite S&P CWD 11 Source Capital & Proprietary 12 13 14 Balance Sheet Balance Sheet of 15 Jan-31-2016 Jan-31-2017 16 Currency USD USD 17 ASSETS 18 Cash And Equivalente 8.7050 6.8870 19 Total Cash & ST Investments 8.705.0 6,367 20 21 Accounts recevoie 5.6240 5,8050 22 Tot Receivables 5.6240 5.BOSO 23 24 wtry 4400 3000 25 Prud 1410 19410 20 One Current Assets 27 Tot Current Auto 0.230.0 57.000 28 29 Groms Proovy Plats per 0540 191,1200 30 And Depreciation (71.500 70.95101 31 Net Property, Plant & Equipment 110.5160 114178.0 32 33 Longmarts 6210 490 34 Goodwill 10.6050 17.0370 35 Other Wangi . 36 Deferred Tax As LT 1.5040 1.5850 37 Other Long Term Auto 4.0000 73770 38 Total Ass 108. ROSA 39 40 LIABILITIES 41 Accounts Payable 304870 41,433.0 42 Accrued Exp 19 8070 18.798.0 43 Sam Borrowings 28 1.0990 44 Curr. Port of LTD 2.7450 2.250.0 45 Curr. Port of Loose 551.0 535.0 46 Curr.Income Tax Payable 5210 9210 47 Ured Revenue Current 1680 48 One Current Labs 49 Tot Current Liabilities 64.8190 86.828.0 50.6640 61.007.0 61.000 40000 19770 (83.039.00 114,8180 195700 (37,1780) 111 3850 217.00 (90.300,00 127,649.0 2109170 (97.6230 122.894.0 7.6140 18.2420 10.500 29.5420 39950 31,1810 5.8000 1,7380 3.231.0 210 2256 5.9900 31.0730 5.2000 1,9140 3.4830 VARA 1.8790 2.3050 204520 9.3810 480920 20,1050 5.2570 3,7380 6670 8450 2,0170 470000 20.2270 52250 1.81 72910 4280 19120 41.973.0 20.3080 5750 5,362.0 2-3040 280.0 1.9900 4832200 23.7680 3570 5.5530 2.283.0 8100 310000 78.521.0 TT ATT 77.790.0 61.990 3,080.0 81,957.0 71.790.0 41,7070 20.320 400 20.478.0 1400 6.2040 52210 154.943.0 12.1790 15 185.0 2340 3.2470 33.930 2830 3,1970 87.6140 (128050) 74 6800 [157840) 753100 0.083.0 5,8070 $1.5520 81.1972 WASSA ZAZ 20 48 Other Current Life 49 Total Current Liabitos 64.619.0 66.928.0 78.521.0 77 4770 50 51 Long Term Det 39.9620 6450 302310 39680 52 Long Term Les 5.8160 6.003.0 6.7800 6.63000 53 Pansion & Other Post Retireers 2050 332.0 2010 175.0 54 Del Tax Usby, Non-Curr. 3.350 43030 3,831.0 55 Other Non Current Libis 3,0210 4,049.0 4.0580 5,082.0 56 Total Liabilities 115.970.0 118.290.0 123.700.0 139,661.0 57 58 Common Stock 3170 3050 2950 2880 59 Additional Paid in Cap 1.8080 2.3710 2.6480 2.905.0 60 Retained Earning 90,0210 19,354,0 95.1070 80,7950 61 Treasury Stock 62 Comprehensive Inc. and Other (11.5070 (14.23201 (10,1810) (11 520) 63 Total Common Equity 80 40 77,7980 TT.860.0 12.490 64 65 Minority rest 3,0050 27370 2.9500 7,1380 66 67 Total Equity 26110 5 82.8220 68 69 Total Lities And Equity 12. VILA 191 204.5220 2011 70 71 Supplemental Home 72 Tol Sw Out on Filing Date 3,1443 3.033.0 2.9507 2.889.7 73 Total Seres Out on Balance SheetDate 3.620 310680 2.9620 2.8780 74 Book Share $25.47 $25.52 $28.38 $25.19 75 Tangle Book Value 13,851.0 60,7010 59.6270 35.515.0 76 Tangle Book $20.10 $19.93 $20 2 $1234 77 To Do 50,7720 18.88 486730 58.481.0 78 Net Det 2,0670 39.7010 39.9170 507390 79 Det Equivalent Oper Leases 20,0000 20.000 23.2000 240000 80 To Minority rest 3.000 27370 2.9530 7,1300 81 Invertory Method LIFO UFO LFO LIFO 82 Land 25.0240 24,8010 25.2000 24.COM 83 Building 95,850 98.5470 101,1550 101,005.0 84 Machinery 49,9500 51300 55,0820 56,8040 85 Construction in Page 4,5300 43010 3,6100 3,4740 86 Ft Time Employees 2.300,000 2,300,000 2,300,000 2.200.000 87 Ander Cap. Le Gross 11,0960 11,6370 12.7030 12,780.0 88 Assets under Create Accum. Der (4.7510 (5.1800) (5.580.0) (5.8820 89 Aoun Alware for Doubu Acte 700 NA NA NA 90 ling Mar-30-2018 Mar 28 2019 Mar-20-2020 Mar-20-2000 91 Resort Type NC NC NG NC 92 Coulon Type RUP RUP REP 93 94 95 Note: For multiple class corporis, total scout we primary care equivalere, and for foreign companies listed as primary ADRs, she court ADR-valet re 28323 28325 31356 73.1200 63.040 2010 6.8330 UFO 246190 105 5140 80.940 37510 2.200.000 NA NA NA Mar 20 2020 O REP 2.6338 2.310 $26.57 45,700.0 $16.15 70.220 533000 NA 5,0670 NA NA NA NA NA NA NA NA Sep-09-2000 REP 1 S&P 3 Capital IQ 5 Target Corporation (NYSE:TGT) > Financials > Balance Sheet 7 A Millions of the reported currency except per she terms. Template Standard 8 Period Type: Aus 9 Currency Reported Currency 10 Unit S&P Cap (Det) 11 Source Capital & Proprietary 12 Restatement: Order: Conversion Decimal: Latestonian Historical Capa (Default) Jan-30-2016 USD Reclassified Jan-28-2017 USD Restated Feb-03-2018 USD Feb-02-2019 USD Feb-01-2020 USD Aug-01-2020 USD 4,0480 25120 2.6430 25770 7.2840 270 7.3110 4,040.0 2,5120 2.643.0 1,500.0 25770 7000 7380 7.0 9290 9290 1.1000 1,100.0 0820 9820 8.8780 2140 82000 2070 2130 11 8.5970 1570 2140 12.540.0 9,4070 1570 2000 12.510.0 8.9920 1540 2170 12.0020 14100 14310 17,6230 14 Balance Sheet Balance Sheets of 15 16 Currency 17 ASSETS 18 Cash And Equivalery 19 Short Term verters 20 Total Cash & ST Investments 21 22 Account Receive 23 Other Receives 24 Total Receivables 25 26 tary 27 Prepaid 28 Ohe Current Asset 29 Tot Current Auto 30 31 Gross Property Part & Equipment 32 Accurated Depreciation 33 Net Property, Plant & Equipment 34 35 Long-term investments 38 Goodwill 37 Omer anges 38 Deferred Charges. LT 39 One Long Term Assets 40 Total Assets 41 42 LIABILITIES 43 Accounts Payable 44 Accrued Exp 45 Curr. Port of LTD 46 Curr. Port of La 47 Curr.Income Tax Payne 48 Urearned Revenue, Current 41,400 2010 25.2170 2011 (174130 246510 48180 MON 21.420.0 40,1050 (1820 27,400.0 411830 19.6040 21.51.0 33130 1910 20.072.0 40 2390 - 6300 790 100 6000 000 1370 6330 530 270 1300 610 810 0100 A22120 500 78.0 5200 5600 6340 112 5350 ATRIA 74180 1.9420 72520 1.800.0 1,7180 8.8770 2.0870 2010 2280 97810 20040 1.002.0 2190 99200 1.983.0 940 2870 10.7280 4.0750 1090 2070 5000 6440 VA 1580 693.0 MA 7270 3000 . 9350 VA 775.0 20v 775.0 - 9950 12800 14.470 15.8420 14 2000 2.2410 10 ans o 3.578.0 539.0 1070 1.1220 180 30.94.0 11210 35,4220 20 82210 84110 82000 7,1210 968 11,831.0 (833.0 12.578. 11,3310 12.5706 ATRO 46 Curr. Port of Laos 2280 2190 47 Curr.Incorre Tas Payable 5020 1580 . 48 Unand Ravenue. Current 0640 6800 7270 8400 49 Omer Current Us 1290.0 1.000 1.1320 1.1580 50 Total Current Liabilities 12 6220 12.707.0 13.052.0 15.0140 51 52 Long Term Dell 11,9450 11.0310 10 2380 9.2550 53 Long Term Les 28090 2,9720 54 Unearned Revenue, Non-Current 6800 6300 800.0 5700 55 Pension & Other Post Relre. Bereits 340 400 410 400 56 De Tax Uly. Non-Curr. 6230 010 693.0 9720 57 One Non-Current Les 1 2010 1200 12190 1,1700 58 Tots 27305.0 26.480 2120 29993 59 60 Common Stock 500 480 450 430 61 Addow Paid in Cow 53680 56610 5580 6,0420 62 Rod Eng a 1880 58840 64950 8.017 63 Treasury Stock 64 Comprehensive Inc. and Other (200 8380 7470 (8050 65 Tot Common Equilly 12. 10,953.0 11,6510 11 2010 66 67 Total Equity 11.6510 68 69 Tot Llis And Equity 4212 VALO 412800 70 Supplementima 72 To Swoonlig Date 0000 5827 5388 5103 73 Tots out on acero 6022 5002 5417 5178 74 Book Valur RI 75 Tante Bok Ve 12.30 19,7700 10.920 10.000 78 Tangie Back $19.3 5202 77 Tower 12.79 12.7490 13.400 13,4480 78 Ned De 2.7220 1020 10.8330 79 Div. of Unded Pro. Develt Oligion (1001 70 70 330 80 Dell Opere AMO 1.60 1,200 81 Inventory Mood UFO LIFO LIFO LFO 82 and 6.1250 6980 0950 6.0510 83 Bilding 27 0500 27,6110 209780 20,3600 84 May 7.9540 6.1540 3.2000 8.4500 85 Construction in Progress 3150 2000 4800 4300 86 Full Time Employees 341.000 323,000 345.000 300.000 87 Assets de Cae Lee Gross NA NA 1.1590 8720 88 Assets under Cap. L Accum. Der NA NA (3170) (3710) 89 Filing Date Mar 14 2010 Mar 13 2010 Mar 11-2020 Mar-11-2020 90 Rent Type NC RC RS NC 91 Calotion Type RUP RUP RUP REP 92 93 94 Note Formule class companies, tal share courts are primary class equivalent and for foreign companies listed as primary ADRs. Share courts are ADR-equivalent 3003 5010 5042 123 47 11.1670 12.5780 2514 10.7570 13.9940 11.3070 1170 21020 LIFO 0.0000 294230 8.750 5300 30.000 1.1300 (410) Mar. 11-2020 o REP NA NA NA 0.0270 30.9460 8.2960 8110 NA NA NA Aug 29 2020 0 REP

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Quest For A Science Of AccountingAn Anthology Of The Research Of Robert R. Sterling

Authors: Thomas A. Lee, Peter W. Wolnizer

1st Edition

0367698196, 9780367698195

More Books

Students also viewed these Accounting questions