Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Comparison Analysis. Compare and contrast each financial ratio of Target and Walmart or vice versa. Which company do you think is managing each ratio better

Comparison Analysis. Compare and contrast each financial ratio of Target and Walmart or vice versa. Which company do you think is managing each ratio better and each group of ratios better (liquidity, asset management, debt, and profitability)? Explain why.

(Target Income Statement)

image text in transcribedimage text in transcribedimage text in transcribed

(Target Balance Sheet)

image text in transcribedimage text in transcribed

(Target Cash Flows)

image text in transcribedimage text in transcribed

(Walmart Income Statement)

image text in transcribedimage text in transcribedimage text in transcribed

(Walmart Balance Sheet)

image text in transcribedimage text in transcribed

(Walmart Cash Flow)

image text in transcribedimage text in transcribed

Income Statement For the Fiscal Period Ending Income Statement Income Statement Income Statement Income Statement Income Statement Reclassified Restated Restated 12 months 12 months 12 months 12 months 12 months Jan-30-2016 Jan-28-2017 Feb-03-2018 Feb-02-2019 Feb-01-2020 USD USD USD USD USD LTM 12 months Aug-01-2020 USD Currency 73,785.0 Revenue Other Revenue Total Revenue 69,414.0 857.0 70,271.0 71,786.0 928.0 72,714.0 74,433.0 923.0 75,356.0 77,130.0 982.0 78,112.0 83,613.0 1.040.0 84,653.0 73,785.0 52,241.0 Cost Of Goods Sold Gross Profit 49,145.0 21,126.0 51,125.0 21,589.0 53,299.0 22,057.0 54,864.0 23,248.0 59,957.0 24,696.0 21,544.0 14,473.0 14,086.0 14,990.0 15,606.0 16,163.0 17,081.0 Selling General & Admin Exp. R & D Exp. Depreciation & Amort. Other Operating Expense/Income) 1,969.0 2,0450 2,225.0 2,224.0 2,357.0 2,334.0 Other Operating Exp., Total 16,442.0 16,131.0 17.215.0 17,830.0 18,520.0 19,415.0 Operating Income 5,102.0 4,995.0 4,374.0 4,227.0 4,728.0 5,281.0 (607.0) (569.0) (530.0) (461.0) (467.0) (460.0) Interest Expense Interest and Invest. Income Net Interest Exp. (607.0) (569.0) (530.0) (461.0) (467.0) (460.0) Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items 2.0 3,768.0 3.0 4,264.0 (15.0) 4,806.0 4,495.0 4,426.0 3,844.0 (177.0) (41.0) (41.0) Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. Gain (Loss) On Sale Of Assets Asset Writedown Other Unusual Items EBT Incl. Unusual Items 620.0 (15.0) (92.0) (43.0) (422.0) 3,961.0 (91.0) (123.0) 3,630.0 (23.0) (10.0) 4,190.0 (70.0) (226.0) 4,469.0 4,923.0 3,676.0 Income Tax Expense Earnings from Cont. Ops. 1,602.0 3,321.0 1,295.0 2,666.0 722.0 2,908.0 746.0 2,930.0 921.0 3,269.0 956.0 3,513.0 42.0 68.0 6.0 7.0 12.0 9.0 Earnings of Discontinued Ops. Extraord. Item & Account Change Net Income to Company 3,363.0 2,734.0 2,914.0 2,937.0 3,281.0 3,522.0 Minority Int. in Earnings Net Income 3.363.0 2.734.0 2.914.0 2.937.0 3.281.0 3.522.0 Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items 3,363.0 3,321.0 2,734.0 2,666.0 2,914.0 2,908.0 2,937.0 2,930.0 3,281.0 3,269.0 3,522.0 3,513.0 Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. $5.36 5.29 627.7 $4.73 4.62 577.6 $5.33 5.32 546.8 $5.56 5.54 528.6 $6.42 6.4 510.9 $6.98 6.97 504.3 Diluted EPS Diluted EPS Excl. Extra Items Weighted Avg. Diluted Shares Out. $5.32 5.25 632.9 $4.7 4.58 582.5 $5.3 5.29 550.3 $5.51 5.5 533.2 $6.36 6.34 515.6 $6.92 6.9 509.3 Normalized Basic EPS Normalized Diluted EPS $4.48 4.44 $4.79 4.75 $4.39 4.37 $4.46 4.42 $5.22 5.17 $5.96 5.9 Dividends per Share Payout Ratio % $2.16 40.5% $2.32 49.3% $2.44 45.9% $2.52 45.5% $2.6 40.5% $2.64 37.9% Supplemental Items EBITDA EBITA EBIT EBITDAR As Reported Total Revenue Effective Tax Rate % Current Domestic Taxes Current Foreign Taxes Total Current Taxes Deferred Domestic Taxes Deferred Foreign Taxes Total Deferred Taxes 7,315.0 5,125.0 5,102.0 7,497.0 NA 32.5% 1,917.0 7.0 1,924.0 (322.0) NA (322.0) 7,313.0 5,008.0 4,995.0 7,505.0 70,271,0 32.7% 1,249.0 6.0 1,255.0 41.0 (1.0) 40.0 6,850.0 4,388.0 4,374.0 7,062.0 72,714.0 1. 19.9% 851.0 59.0 910.0 (202.0) 14.0 (188.0) 6,701.0 4,241.0 4,227.0 6,941.0 75,356,0 350.0 20.3% 373.0 51.0 424.0 320.0 2.0 7,332.0 4,741.0 4,728.0 7,606.0 78,112.0 22.0% 705.0 38.0 743.0 179.0 (1.0) 178.0 7,863.0 5,294.0 5,281.0 NA 84.653.0 21.4% 705.0 38.0 743.0 179.0 (1.0) 178.0 322.0 Normalized Net Income 2,809.4 2,766.3 2,402.5 2,355.0 2,665.0 3,003.8 NA 51.0 NA 42.0 (59.0) NA NA (16.0) 42.0 (31.0) Mar-14-2018 RC REP Interest Capitalized Interest on Long Term Debt Non-Cash Pension Expense Filing Date Restatement Type Calculation Type NA 36.0 (85.0) Mar-13-2019 RS REP NA 42.0 (25.0) Mar-11-2020 NC REP (47.0) Mar-11-2020 Mar-11-2020 Aug-28-2020 o RS REP REP LTM Supplemental Operating Expense Items Advertising Exp. Selling and Marketing Exp. Net Rental Exp. Imputed Oper. Lease Interest Exp. Imputed Oper. Lease Depreciation 1,434.0 1,434.0 182.0 67.4 114.6 1,465.0 1,465.0 192.0 68.5 123.5 1,457.0 1,457.0 212.0 68.6 143.4 1,494.0 1,494.0 240.0 65.7 174.3 1,647.0 1,647,0 274.0 74.7 199,3 NA 1,647.0 NA 116.0 115.0 134.0 152.0 Stock-Based Comp., SG&A Exp. Stock-Based Comp., Unallocated Stock-Based Comp., Total - 118.0 118.0 152.0 18.0 170.0 116.0 115.0 134.0 152.0 Balance Sheet Balance Sheet as of: 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 Currency ASSETS Cash And Equivalents Short Term Investments Total Cash & ST Investments 4,046.0 2,512.0 2,643.0 1,556.0 2,577.0 7,284.0 27.0 7,311.0 4,046.0 2,512.0 2,643.0 1,556.0 2,577.0 Accounts Receivable Other Receivables Total Receivables 736.0 736.0 749.0 749.0 929.0 929.0 1,100.0 1,100.0 962.0 962.0 8,876.0 Inventory Prepaid Exp. Other Current Assets Total Current Assets 8,601.0 214.0 533.0 14,130.0 8,309.0 207.0 213.0 11,990.0 8,597.0 157.0 214.0 12,540.0 9,497.0 157.0 209.0 12,519.0 8,992.0 154.0 217.0 12,902.0 1,436.0 17,623.0 Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment 41,463.0 (16,246.0) 25,217.0 42,071.0 ( (17,413.0) 24,658.0 44,818.0 (18,398.0) 26,420.0 46,185.0 (18,687.0) 27,498.0 48,183.0 (19,664.0) 28,519.0 48,313.0 (19,341.0) 28,972.0 239.0 630.0 79.0 10.0 633.0 66.0 137.0 633.0 53.0 Long-term Investments Goodwill Other Intangibles Deferred Charges, LT Other Long-Term Assets Total Assets 27.0 133.0 61.0 84.0 610.0 40.262.0 4.0 133.0 50.0 76.0 520.0 37.431.0 634.0 40.303.0 564.0 41.290.0 535.0 42.779.0 1,166.0 48.000.0 7,418.0 1,942.0 823.0 7,252.0 1,866.0 1,718.0 LIABILITIES Accounts Payable Accrued Exp. Curr. Port. of LT Debt Curr. Port of Leases Curr. Income Taxes Payable Unearned Revenue, Current Other Current Liabilities Total Current Liabilities 8,677.0 2,087,0 201.0 228.0 9,761.0 2,034.0 1,002.0 219.0 9,920.0 1,983.0 94.0 267.0 10,726.0 4,075.0 109.0 207.0 775.0 502.0 644.0 1,293.0 12,622.0 158.0 693.0 1,020.0 12,707.0 727.0 1,132.0 13,052.0 840.0 1,158.0 15,014.0 935.0 1,288.0 14,487.0 15,892.0 11,945.0 11,031.0 14,200.0 2,241.0 Long-Term Debt Long-Term Leases Unearned Revenue, Non-Current Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities 660.0 54.0 823.0 1,201.0 27,305.0 630.0 46.0 861.0 1,203.0 26,478.0 10,238.0 2,809.0 600.0 41.0 693.0 1,219.0 28,652.0 9,255.0 2,972.0 570.0 40.0 972.0 1,170.0 29,993.0 10,035.0 3,578.0 539.0 107.0 1,122.0 1,078.0 30,946.0 1,121.0 1,968.0 35,422.0 50.0 5,348.0 46.0 5,661.0 5,884.0 45.0 5,858.0 6,495.0 43.0 6,042.0 6,017.0 42.0 6,226.0 6,433.0 42.0 6,248.0 7,121.0 8,188.0 Common Stock Additional Paid In Capital Retained Earnings Treasury Stock Comprehensive Inc. and Other Total Common Equity (629.0) 12,957.0 (638.0) 10,953.0 (747.0) 11,651.0 (805.0) 11,297.0 (868.0) 11,833.0 (833.0) 12,578.0 Total Equity 12.957.0 10.953.0 11.651.0 11.297.0 11,833.0 12.578.0 Total Liabilities And Equity 40.262.0 37.431.0 40.303.0 41.290.0 42.779.0 48.000.0 Supplemental Items Total Shares Out. on Filing Date Total Shares Out on Balance Sheet Date Book Value/Share Tangible Book Value Tangible Book Value/Share Total Debt Net Debt Debt Equiv. of Unfunded Proj. Benefit Obligation Debt Equivalent Oper. Leases Inventory Method Land Buildings Machinery Construction in Progress Full Time Employees Assets under Cap. Lease, Gross Assets under Cap. Lease, Accum. Depr. Filing Date Restatement Type Calculation Type 600.0 602.2 $21.52 12,763.0 $21.19 12,768.0 8,722.0 (10.0) 1,456.0 LIFO 6,125.0 27,059.0 7,964.0 315.0 341,000 NA NA Mar-14-2018 NC RUP 552.7 556.2 $19.69 10,770.0 $19.37 12,749.0 10,237.0 7.0 1,536.0 LIFO 6,106.0 27,611.0 8,154.0 200.0 323,000 NA NA Mar-13-2019 RC RUP 538,8 541.7 $21.51 10,942.0 $20.2 13,476.0 10,833.0 7.0 1,696.0 LIFO 6,095.0 26,978.0 8,268.0 440.0 345,000 1,153.0 (317,0) Mar-11-2020 RS RUP 516.3 517.8 $21.82 10,598.0 $20.47 13,448,0 11,892.0 33.0 1,920.0 LIFO 6,064.0 28,368.0 8,456.0 460.0 360,000 872.0 (371.0) Mar-11-2020 NC REP 501.0 504.2 $23.47 11,147.0 $22.11 13,974.0 11,397.0 117.0 2,192.0 LIFO 6,036.0 29,423.0 8,775.0 533.0 368,000 1,180.0 (441.0) Mar-11-2020 o 500.6 500.3 $25.14 12,578.0 $25.14 16,757.0 9,446.0 NA NA NA 6,027.0 30,946.0 8,296.0 811.0 NA NA NA Aug-28-2020 o REP REP Cash Flow LTM For the Fiscal Period Ending Restated 12 months Jan-30-2016 USD Restated 12 months Jan-28-2017 USD Restated 12 months Feb-03-2018 USD 12 months Feb-02-2019 USD 12 months Feb-01-2020 USD 12 months Aug-01-2020 USD Currency Net Income Depreciation & Amort. Amort. of Goodwill and Intangibles Depreciation & Amort, Total 3.363.0 2.190.0 23.0 2.213.0 2.734.0 2,305.0 13.0 2,318.0 2,914.0 2.482.0 14.0 2.476.0 2,937.0 2.480.0 14.0 2.474.0 3.2810 2,591.0 13.0 2,604.0 3,522.0 2,569.0 13.0 2,582.0 (563.0) (110) (Gain) Loss From Sale Of Assets Asset Writedown & Restructuring Costs Stock-Based Compensation Net Cash From Discontinued Ops. Other Operating Activities Change in Inventories Change in Aco. Payable Change in Other Net Operating Assets Cash from Ops. 115.0 704.0 (384.0) (316.0 (382.0) 1.168.0 5.958.0 113.0 107.0 394.0 293.0 (168.0) (338.0) 5,444.0 117.0 91.0 112.0 74.0 (71.0) (348.0) 1,307.0 283.0 6,935.0 3.0 92.0 132.0 3.0 315.0 (900.0) 1,127.0 (2100) 5,973.0 6.0 23.0 147.0 18.0 178.0 505.0 140.0 2170 7.117.0 50.0 23.0 165.0 16.0 63.0 246.0 1.688.0 1,088.0 9,421.0 (1.438.0) 28.0 (1.547.0) 48.0 (2,533.0) (3,516.0) 85.0 (3.027.0) 63.0 (3,047.0) 63.0 31.0 (518.0) Capital Expenditure Sale of Property, Plant, and Equipment Cash Acquisitions Divestitures Invest in Marketable & Equity Seourt. Net (Inc.) Dec. in Loans Originated Sold Other Investing Activities Cash from Investing 1.875.0 24.0 28.0 (550) 15.0 20.0 22.0 19.0 508.0 (1.473.0) (3,075.0) (3,416.0) (2,944.0) (2,962.0) 1,977.0 1,977.0 739.0 739.0 1,739.0 1,739.0 Short Term Debt Issued Long-Term Debt Issued Total Debt Issued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid 3.225.0 (85.0) (85.0) (2,649.0) (2,649.0) (2.192.0 (2.192.0) (281.0 (281.0) (2,089.0) (2,069.0) (1.169.0) Issuance of Common Stock Repurchase of Common Stock 300.0 (3.483.0) 221.0 (3.708.0) 108.0 (1,046.0) 98.0 (2.124.0) 73.0 (1,565.0) 58.0 (1.609.0) Common Dividends Paid Total Dividends Paid (1.382.0) (1.362.0) (1.348.0) (1,348.0) (1.338.0) (1,338.0) (1.335.0) (1,335.0) (1.330.0) (1.330.0) (1.334.0) (1.334.0) Special Dividend Paid Other Financing Activities Cash from Financing (4,630.0) (5,505.0) (3,729.0) (3,644.0) (3.152.0) (831.0) Net Change in Cash 1.836.0 (1.534.0) 131.0 (1.087.0) 1,021.0 5.628.0 Supplemental Items Cash Interest Paid Cash Taxes Paid Levered Free Cash Flow Unlevered Free Cash Flow Change in Net Working Capital Net Debt Issued Net Cash From Discontinued Ops. - Investing Filing Date Restatement Type Calculation Type 604.0 (127.0) 5,186.4 5,565.8 (1.484.0) (85.0) 19.0 Mar-14-2018 RS REP 999.0 1,514,0 3,449.3 3,804.9 204.0 (672.0) 678.0 934.0 3,675,5 4,006.8 (1,215.0) (1,453.0) 476.0 373.0 1,549.8 1,837.9 (104.0) (281.0) 492.0 696.0 3,363.1 3,655.0 (971.0) 492.0 696.0 5,408.1 5,695.6 (2,690.0) 2,056.0 (330.0) Mar-13-2019 RS REP Mar-11-2020 RS REP Mar-11-2020 NC REP Mar-11-2020 o REP Aug-28-2020 0 LTM Income Statement For the Fiscal Period Ending 12 months Jan-31-2016 USD 12 months Jan-31-2017 USD Reclassified 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 Currency 482,130.0 485,873.0 500,343.0 514,405.0 523,964.0 542,026.0 Revenue Other Revenue Total Revenue 482,130.0 485,873.0 500,343.0 514,405.0 523,964.0 542,026.0 Cost Of Goods Sold Gross Profit 360,984.0 121,146.0 361,256.0 124,617.0 373,396.0 126,947.0 385,301.0 129,104.0 394,605.0 129,359.0 408,363.0 133,663.0 97,041.0 101,853.0 106,010.0 106,987.0 107,891.0 108,640.0 Selling General & Admin Exp. R & D Exp. Depreciation & Amort. Other Operating Expense/(Income) . - Other Operating Exp., Total 97,041.0 101,853.0 106,010.0 106,987.0 107,891.0 108,640.0 Operating Income 24,105.0 22,764.0 20,937.0 22,117.0 21,468.0 25,023.0 Interest Expense Interest and Invest. Income Net Interest Exp. (2,548.0) 81.0 (2,467.0) (2,367.0) 100.0 (2,267.0) (2,330.0) 152.0 (2,178.0) (2,346.0) 217.0 (2,129.0) (2,599.0) 189.0 (2,410.0) (2.535.0) 151.0 (2,384.0) Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items (2.0) 19,986.0 87.0 19,145.0 40.0 22,679.0 21,638.0 20,497.0 18,759.0 (500.0) (900.0) (1,300.0) Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. Gain (Loss) On Sale Of Assets Legal Settlements Other Unusual Items EBT Incl. Unusual Items (3,516.0) (4,850.0) (160.0) 1,886.0 (15.0) 5,161.0 (52.0) (3,136.0) 15,123.0 (2,400.0) 24,088.0 21,638.0 20,497.0 11,460.0 20,116.0 Income Tax Expense Earnings from Cont. Ops. 6,558.0 15,080.0 6,204.0 14,293.0 4,600.0 10,523.0 4,281.0 7,179.0 4,915.0 15,201.0 5,960.0 18,128.0 Earnings of Discontinued Ops Extraord. Item & Account Change Net Income to Company 15,080.0 14,293.0 10,523.0 7,179.0 15,201.0 18,128.0 Minority Int. in Earnings Net Income (386.0) 14.694.0 (650.0) 13.643.0 (661.0) 9.862.0 (509.0) 6.670.0 (320.0) 14,881.0 (233.0) 17.895.0 Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items 14,694.0 14,694.0 13,643.0 13,643.0 9,862.0 9,862.0 6,670.0 6,670.0 14,881.0 14,881.0 17,895.0 17,895.0 $4.4 Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. $4.58 4.58 3,207.0 4.4 3.101.0 $3.29 3.29 2.995.0 $2.28 2.28 2,929,0 $5.22 5.22 2,850.0 $6.31 6.31 2,835,5 Diluted EPS Diluted EPS Excl. Extra Items Weighted Avg, Diluted Shares Out. $4.57 4.57 3,217.0 $4.38 4.38 3,112.0 $3.28 3.28 3,010,0 $2.26 2.26 2,945.0 $5.19 5.19 2,868.0 $6.27 6.27 2,853.0 Normalized Basic EPS Normalized Diluted EPS $4.1 4.08 $3.92 3.91 $3.69 3.68 $4.09 4.07 $4.09 4.06 $4.92 4.89 Dividends per Share Payout Ratio % $1.96 42.8% $2.0 45.6% $2.04 62.1% $2.08 91.5% $2.12 40.6% $2.14 33.9% Shares per Depository Receipt 0.25 0.25 0.25 0.25 0.25 0.25 Supplemental Items EBITDA EBITA EBIT EBITDAR As Reported Total Revenue Effective Tax Rate % Current Domestic Taxes Current Foreign Taxes Total Current Taxes Deferred Domestic Taxes Deferred Foreign Taxes Total Deferred Taxes 33,559.0 24,105.0 24,105.0 36,059.0 482,130.0 30.3% 6,184.0 1,400.0 7,584,0 (810.0) (216.0) (1,026.0) 32,844.0 22,764.0 22,764.0 35,444.0 485,873.0 30.3% 3,949.0 1,510.0 5,459.0 1,105.0 (360.0) 745.0 31,466.0 20,937,0 20,937,0 34,366.0 500,343.0 30.4% 3,403.0 1,377.0 4,780.0 (34.0) (146.0) (180.0) 32,795.0 22,117.0 22,117.0 35,795.0 514,405.0 37.4% 3,256.0 1,495,0 4,751.0 (377.0) (93.0) (470.0) 32,935.0 21,468.0 21,468.0 36,296.0 523,964.0 24.4% 3,381.0 1,205.0 4.586.0 698.0 (369.0) 329.0 36,616.0 25,023.0 25,023.0 NA 542,026.0 24.7% 3,381.0 1,205.0 4,586.0 698.0 (369.0) 329.0 Normalized Net Income Interest Capitalized Interest on Long Term Debt Filing Date Restatement Type 13,137.8 39.0 560.0 Mar-30-2018 NC 12,160.6 NA 323.0 Mar-28-2019 NC 11,063.4 NA NA Mar-20-2020 RC 11,982.3 NA NA Mar-20-2020 NC 11,645.6 NA 306.0 Mar-20-2020 O 13,941.4 NA NA Sep-02-2020 O Calculation Type REP REP REP REP REP LTM Supplemental Operating Expense Items Advertising Exp Selling and Marketing Exp. Net Rental Exp. Imputed Oper. Lease Interest Exp. Imputed Oper. Lease Depreciation 2,500.0 2,500.0 2,500.0 1,019.0 1,481,0 2.900.0 2,900.0 2,600.0 1,011.6 1,588.4 3,100.0 3,100.0 2,900.0 1,159.5 1,740.5 3,500.0 3,500.0 3,000.0 1,071.1 1,928.9 3,700.0 3,700.0 3,361.0 1,062.1 2,298.9 NA 3,700.0 NA Stock-Based Comp., SG&A Exp. Stock-Based Comp., Total 448.0 448.0 596.0 596.0 626.0 626.0 773.0 773.0 854.0 854.0 854.0 854.0 Balance Sheet Balance Sheet as of: Jan-31-2016 USD Jan-31-2017 USD Jan-31-2018 USD Jan-31-2019 USD Jan-31-2020 USD Jul-31-2020 USD Currency ASSETS Cash And Equivalents Total Cash & ST Investments 8,705.0 8,705.0 6,867.0 6,867.0 6,756.0 6,756.0 7,722.0 7,722.0 9,465.0 9,465.0 16,906.0 16.906.0 Accounts Receivable Total Receivables 5,624.0 5,624.0 5,835.0 5,835.0 5,614.0 5,614.0 6,283.0 6,283.0 6,284.0 6,284.0 5,111.0 5,111.0 44,469.0 1,441.0 Inventory Prepaid Exp. Other Current Assets Total Current Assets 43,046.0 1,941.0 43,783.0 3,511.0 44,269.0 3,623.0 44.435.0 1,622.0 41,084.0 1,895.0 60,239.0 57,689.0 59,664.0 61,897.0 61,806.0 64,996.0 Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment 188,054.0 (71,538.0) 116,516.0 191,129.0 (76,951.0) 114,178,0 197,857.0 (83,039.0) 114,818.0 198,570.0 (87,175.0) 111,395.0 217,349.0 (90,300.0) 127,049.0 219,917.0 (97,023.0) 122,894.0 621.0 16,695.0 479.0 17,037,0 7,614.0 18,242.0 10,569.0 29,542.0 Long-term Investments Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets 1,504.0 4.006.0 199.581.0 1.565.0 7,877.0 198.825.0 1,879.0 2,305.0 204.522.0 3,995.0 31,181.0 5,800.0 1,796.0 3,231.0 219,295.0 5,990.0 31,073.0 5,200.0 1,914.0 3,463.0 236.495.0 9,381.0 237,382.0 LIABILITIES Accounts Payable Accrued Exp. Short-term Borrowings Curr. Port of LT Debt Curr. Port. of Leases Curr. Income Taxes Payable Uneamed Revenue, Current Other Current Liabilities Total Current Liabilities 38,487,0 19,607.0 2,708.0 2,745.0 551.0 521.0 41,433.0 18.798.0 1,099.0 2,256.0 565.0 921.0 1,856.0 46,092.0 20,105.0 5,257.0 3,738.0 667.0 645.0 2,017.0 47,060.0 20,227.0 5,225.0 1,876.0 729.0 428.0 1,932.0 46,973.0 20,306.0 575.0 5,362.0 2,304.0 280.0 1,990.0 46,326.0 23,768.0 357.0 5,553.0 2,283.0 610.0 64,619.0 3,060.0 81,957.0 66,928.0 78,521.0 77,477.0 77,790.0 41,707.0 20,342.0 Long-Term Debt Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities 38,952.0 5,816.0 205.0 3,357.0 3,021.0 115,970.0 36,645.0 6,003.0 332.0 4,333.0 4,049.0 118,290.0 30,231.0 6,780.0 281.0 3,831.0 4,056.0 123,700.0 43,948.0 6,683.0 175.0 6,296.0 44,410.0 20,478.0 140.0 6,204.0 5,921.0 154,943.0 12,179.0 5,082.0 139,661.0 156,185.0 317.0 1,805.0 90,021.0 305.0 2,371.0 89,354.0 295.0 2,648.0 85,107.0 288.0 2,965.0 80,785.0 284.0 3,247.0 83,943.0 283.0 3,197.0 87.614.0 Common Stock Additional Paid In Capital Retained Eamnings Treasury Stock Comprehensive Inc. and Other Total Common Equity (11,597.0) 80,546.0 (14,232.0) 77,798.0 (10,181.0) 77,869.0 (11,542.0) 72.496.0 (12,805.0) 74,669.0 (15,784.0) 75,310.0 Minority Interest 3,065.0 2,737.0 2,953.0 7,138.0 6,883.0 5,887.0 Total Equity 83,611.0 80,535.0 80,822.0 79,634.0 81,552.0 81,197.0 Total Liabilities And Equity 199.581.0 198.825.0 204.522.0 219.295.0 236.495.0 237.382.0 2,832.3 2,832.5 $26.36 38,396.0 $13.56 73, 129.0 63,664,0 Supplemental Items Total Shares Out. on Filing Date Total Shares Out. on Balance Sheet Date Book Value/Share Tangible Book Value Tangible Book Value/Share Total Debt Net Debt Debt Equivalent Oper. Leases Total Minority Interest Inventory Method Land Buildings Machinery Construction in Progress Full Time Employees Assets under Cap. Lease, Gross Assets under Cap. Lease, Accum. Depr. Accum. Allowance for Doubtful Accts Filing Date Restatement Type Calculation Type 3,144.3 3,162.0 $25.47 63,851.0 $20.19 50,772.0 42,067.0 20,000.0 3,065.0 LIFO 25,624.0 96,845.0 49,950.0 4,539.0 2,300,000 11,096.0 (4,751.0) 70.0 Mar-30-2018 NC RUP 3,033.0 3,048.0 $25.52 60,761.0 $19.93 46,568.0 39,701.0 20,800.0 2,737.0 LIFO 24,801.0 98,547.0 51,843.0 4,301.0 2,300,000 11,637.0 (5,169.0) NA Mar-28-2019 NC RUP 2.950.7 2,952.0 $26.38 59,627.0 $20.2 46,673.0 39.917.0 23,200.0 2.953.0 LIFO 25,298.0 101,155.0 55,082.0 3,619.0 2,300,000 12,703.0 (5,560.0) . Mar-20-2020 NC RUP 2,869.7 2,878.0 $25.19 35,515,0 $12.34 58,461.0 50,739,0 24,000.0 7,138.0 LIFO 24,526.0 101,006.0 56,804.0 3,474.0 2,200,000 12,760.0 (5,682.0) NA 2,833.8 2,834.0 $26.57 45,768.0 $16.15 70,242.0 53,336.0 NA 5,887.0 NA NA NA NA 26,888.0 6,883.0 LIFO 24,619.0 105,674.0 60,984.0 3,751.0 2,200,000 NA NA NA Mar-20-2020 o REP NA NA NA NA Sep-02-2020 O Mar-20-2020 NC REP REP Cash Flow For the Fiscal Period Ending Restated 12 months Jan-31-2016 USD Restated 12 months Jan-31-2017 USD 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 Currency Net Income Depreciation & Amort. Depreciation & Amort., Total 14,694.0 9,454.0 9,454.0 13,643.0 10.080.0 10,080.0 9,862.0 10,529.0 10,529.0 6.670.0 10,678.0 10,678.0 14,881.0 11,467.0 11,467.0 17,895.0 11.593.0 11,593.0 4,850.0 (Gain) Loss From Sale Of Assets (Gain) Loss On Sale Of Invest. Other Operating Activities Change in Acc. Receivable Change In Inventories Change in Acc. Payable Change in Inc. Taxes Change in Other Net Operating Assets Cash from Ops. 1.124.0 (19.0) (703.0) 2,008.0 (472.0) 1,466.0 27,552.0 1,617.0 (402.0) 1,021.0 3,942.0 492.0 1,280.0 31,673.0 4,703.0 (1,074.0) (140.0) 4,086.0 (557.0) 928.0 28,337.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,886.0) 1,105.0 154.0 (300.0) (274.0) (93.0) 186.0 25,255.0 52.0 (5,161.0) 1,206.0 (1.0) 1,946,0 2,020.0 205.0 3,271.0 33,026.0 (11,477.0) 635.0 (10.619.0) 456.0 (2,463.0) 662.0 (1.901.0) (10.051.0) 378.0 (375.0) 1,046.0 (10,344.0) 519.0 (14,656.0) 876.0 (10.705.0) 321.0 (56.0) 833.0 (9,403.0) 276.0 (175.0) 0 Capital Expenditure Sale of Property, Plant, and Equipment Cash Acquisitions Divestitures Invest. in Marketable & Equity Securt. Net (Inc.) Dec. in Loans Originated/Sold Other Investing Activities Cash from Investing 246.0 - (79.0) (10,675.0) (31.0) (13,896.0) (77.0) (9,079.0) (431.0) (24,036.0) 479.0 (9,128.0) 364.0 (8,938.0) Short Term Debt Issued Long-Term Debt Issued Total Debt Issued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid 1,235.0 39.0 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 (53.0) (3,784.0) (3,837.0) 5,492.0 5,492.0 (4,656.0) (1,907.0) (6,563.0) (4,432.0) (4,432.0) (13,061.0) (13,061.0) (7,707.0) Repurchase of Common Stock (4,112.0) (8,298.0) (8,296.0) (7,410.0) (5,717.0) (2,733.0) Common Dividends Paid Total Dividends Paid (6,294.0) (6,294.0) (6,216.0) (6,216.0) (6,124.0) (6,124.0) (6,102.0) (6,102.0) (6,048.0) (6,048.0) (6,070.0) (6,070.0) Special Dividend Paid Other Financing Activities Cash from Financing (2,721.0) (16,285.0) (967.0) (19,072.0) (4,018.0) (19,875.0) (1,060.0) (2,537.0) (1,463.0) (14,299.0) (1,544.0) (16,582.0) Foreign Exchange Rate Adj. Net Change in Cash (1.022.0) (430.01 (452.0) 11.7470 487.0 (130.0) (438.0) 742.0 (69.0) 1.759.0 128.0 7.634.0 Supplemental Items Cash Interest Paid Cash Taxes Paid Levered Free Cash Flow Unlevered Free Cash Flow Change in Net Working Capital Net Debt Issued Filing Date Restatement Type Calculation Type 2,540.0 8,111.0 14,540.1 16,132.6 (2,642.0) (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,498.4 17,954.6 (3,765.0) (1.437.0) Mar-20-2020 RS REP 2,348,0 3,982.0 12,984.9 14,451.1 479.0 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 o REP 2,464.0 3,616.0 24,889.0 26,473.4 () (7,790.0) (6,235.0) Sep-02-2020 o LTM

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

Step: 3

blur-text-image

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

Public Finance A Contemporary Application Of Theory To Policy

Authors: David N Hyman

8th Edition

0324259700, 978-0324259704

More Books

Students also viewed these Finance questions