Question

1 Approved Answer

Posted on Sep 07, 2024

1. What is Walmart's Equity Multiplier for the year of 2018 (round it to 3 numbers after the decimal point -> 0.581)? To access WMT's

1. What is Walmart's Equity Multiplier for the year of 2018 (round it to 3 numbers after the decimal point -> 0.581)?

To access WMT's financial statement, click

2. What is Walmart's Cash Coverage Ratio for the year of 2018 (round it to 3 numbers after the decimal point -> 0.581)?

To access WMT's financial statement, click

image text in transcribed

Walmart Inc (WMT US) - GAAP Walmart Inc (WMT US) - Standardized FY 2019 FY 2018 01/31/2019 01/31/2018 FY 2017 01/31/2017 FY 2016 01/31/2016 FY 2019 01/31/2019 514,405.0 510.329.0 4.076.0 385,301.0 385,301.0 129,104.0 7,7220 7.7220 0.0 6.293.0 6.283.0 0.0 44 269.0 3.6230 0.0 6,756.0 6,756.0 0.0 5,614.0 5,614.00 0.0 43,783.0 3,511.0 0.0 6.867.0 0.0 5.835.0 5,835.0 0.0 43,048.0 1.941.0 8,7050 8,705.0 0.0 5,624.0 5,824.0 0.0 44 469.0 1 4410 0.0 - In Millions of USD except Per Share 12 Months Ending 5 Revenue + Sales & Services Revenue 3 + Other Revenue - Cost of Revenue 0 + Cost of Goods & Services 1 Gross Profit 2 + + Other Operating Income 3 - Operating Expenses + Seling. General & Admin 5 + Research & Development 6 + Other Operating Expense 7 Operating Income (Loss) 8 - Non-Operating income) Loes 9 + Interest Expense, Net 0 + Interest Expense 1 - Interest Income 2 + Foreign Exch (Gain) Loss 3 + Other Non-Op Income) Lose 4 Pretax Income 5 - Income Tax Expense (Benefit) 6 + Current Income Tax 7 + Deferred Income Tax 8 Income (Loss) from Cont Ops 9 -Net Extraordinary Losses (Gains) 0 + Discontinued Operations 1 + XO & Accounting Changes 2 Income (Loss) Incl. MI 3 - Minority Interest 4 Net Income, GAAP S - Preferred Dividends 6 - Other Adjustments 7 Net Income Avail to Common. GAAP 3,511.0 59,664.0 107,147.0 107.147.0 0.0 0.0 21,957.0 10,497.0 1,758.0 1,975.0 217.0 0.0 9.739.0 11,460.0 4,281.0 4,751.0 470.0 7,179.0 0.0 0.0 0.0 7,179.0 509.0 6,670.0 0.0 0.0 6.670.0 FY 2018 01/31/2018 500,343.0 495,761 C 4,582.0 373,396.0 373,396.0 126,947.0 0.0 106,510.0 106,510.0 0.0 0.0 20,437,0 5,314,0 1,828.0 1,978.0 152.0 0.0 3,488.0 15,123.0 4,600.00 4,780.0 -180.0 10,523.0 0.01 0.0 0.0 10,523.0 661.0 9,862.0 0.0 0.0 9,862.0 FY 2017 FY 2016 01/31/2017 01/31/2016 485,873.0 482,130.0 481,317,0 478,614.01 4.556.0 3,516.0 361.256.0 360,984.0 361,256.0 360,984.0 124,617.0 121,146.0 0.0 0.0 101,853.0 97,041.0 101,853.0 97,041.0 0.0 0.0 0.0 0.0 22.764.0 24,105.0 2,267.0 2,467.0 1,944.0 1,948.0 2,044.0 2,027.0 1000 81.0 0.0 0.0 323.0 521.0 20,497.0 21,638.0 6,204.0 6,558.0 5,459.0 7,584.0 745.0 -1,026.0 14,293.0 15,080.0 0.0 0.0 0.0 0.0 0.0 14.293.0 15,080.0 650.0 386.0 13,643.0 14,694.0 0.0 0.0 0.0 0.0 13.643.0 14.694.0 114,8180 In Millions of USD except Per Share 12 Months Ending Total Assets + Cash Cash Equivalents & STI + Cash & Cash Equivalents + ST Investments Accounts & Notes Recei + Accounts Receivable, Net + Notes Receivable, Net + Inventories + Other ST Assets + Derivative & Hedging Assets + Deferred Tax Assets + Discontinued Operations + Misc ST Assets Total Current Assets + Property, Plant & Equip, Net + Property Plant & Equip - Accumulated Depreciation +LT Investments & Receivables + Other LT Assets + Total Intangible Assets + Goodwill + Other Intangible Assets + Deferred Tax Assets + Derivative & Hedging Assets + Misc LT Assets Total Noncurrent Assets Total Assets FY 2015 01/31/2015 485,651.0 482.229.0 3.422.0 365.086.0 365,086.0 120,585.0 0.0 93.418.0 93.419.0 0.0 0.0 27.147.0 2,348.0 2,048.0 2.161.0 113.0 0.0 300.0 24,799.0 7.985.0 8,504.0 -519.0 16,814.0 -295.0 -285.0 0.0 17.099.0 738.0 16,383.0 0.0 0.0 16.363.0 3,623.0 61.897.0 111.395.0 192 998.0 81,4930 0.01 46,003.0 31,181.0 31,181.0 0.0 1.796.01 4120 12,614.0 157,398.0 219,295.0 197,857.0 83,039.0 0.0 30.040.0 18,242.0 18,242.0 0.0 1,879.0 508.0 9,411.0 144,858.0 204,522.0 1,941.0 57,689.0 114,178.0 191,129.0 76.951.0 0.0 25,958.0 17.037.0 17.037.0 0.0 1,565.0 479.0 7.877.0 141,136.0 198,825.0 1,441.0 60.239.0 116,516.0 188 054 71,5380 0.0 22,826.0 16,695.0 16,695.0 0.0 1.504.0 6210 4,006.0 139,342.0 199,581.0 Liabilities & Shareholders' Equity + Payables & Accruals + Accounts Payable + Accrued Taxes 67.715.0 47 0600 4280 68,859.0 46,092.0 645.01 83,009.0 41.433.0 921.01 58.615.0 38 497 0 5210 39 Net Income Avail to Common, Adj 40 Not Abnormal Losses (Gains) 41 Not Extraordinary Lasses (Gains) 6,670.0 0.0 0.0 13,293.4 3.431.4 0.0 13,456.3 -186.7 0.0 14.143.6 560.4 0.0 16.240.2 162.2 285.0 9,662.0 5,257.0 687.0 667.0 3,920.0 1,099.0 585.0 565.0 8,004.0 2,700.0 551.0 551.0 3,7380 43 Basic Weighted Avg Shares 44 Basic EPS, GAAP 45 Basic EPS from Cont Ops 46 Basic EPS from Cont Ops, Adjusted 2,256.01 2,929.0 2.28 2.28 2.28 2.995.0 3.29 3.29 4.44 3.101.0 4.40 4.40 4.34 7,830.0 5.225.0 729.0 729.0 0.0 1,876.0 1,932.0 1.932.0 0.0 3,207.0 4.58 4.58 4.41 3,230.0 5.07 4.98 5.03 2,745.0 0.0 0.0 0.0 0.0 2.945 0 2.26 2.26 2.26 3.010.0 3.28 3.28 4.42 3.1120 4.38 4.38 4.32 3.2170 4.57 4.57 4.40 3.243.0 5.05 4.96 5.01 0.0 78,521.0 32,794 0 26,0040 6.7800 6,780 0 0.0 77,477.0 46,340.0 39.6570 6,683.0 6.6830 0.0 15.844.0 0.0 0.0 0.0 66,928.0 38,809.0 32,806.0 6,003.01 6,003.0 - 12.553.0 0.0 0.0 64,619.0 40,386,0 34,570,0 5,816.0 5.916.0 10,965.0 48 Diuted Waighted Avg Shares 49 Diluted EPS, GAAP 50 Diluted EPS from Cont Ops 51 Diluted EPS from Cont Ops, Adjusted 52 53 Reference Items 54 Accounting Standard 55 EBITDA 56 EBITDA Margin (T12M) 57 EBITA 58 EBIT 59 Gross Margin 60 Operating Margin 61 Proft Margin 62 Sales per Employee 63 Didends per Share 64 Total Cash Common Didende 65 Capitalized Interest Expense 66 Depreciation Expense 67 Rental Expense 68 Source: Bloomberg 69 70 71 72 73 74 75 Sheet1 US GAAP 35.635.0 6.93 24,9570 21.957.0 25.10 4.27 1.30 233.82045 2.08 6.092.3 12.395.0 0.0 + ST Debt + ST Borawings + ST Lease Liabiities +ST Finance Lease +ST Oparting Leases + Current Portion of LT Debt + Other ST Liabilities + Defemd Rovenus + Derivatives & Hedging + Defemd Tax Liabilities + Discontinued Operations + MIC ST Liabilities Total Current Liabilities +LT Debt + LT Borrowings + LT Lease Liabilties +LT Finance Leases +LT Operating Lease + Other LT Liabilities + Accrued Liabilities + Pension Liabilities + Pensions + Other Post-Ret Benetts + Deferred Revenue + Deferred Tex Llabilties + Derivatives & Hedging + Misc LT Llablities Total Noncurrent Liabilities Total Liabilities + Preferred Equity and Hybrid Capital + Share Capital & APIC + Common Stock + Additional Paid in Capital - Treasury Stock + Retained Eamings + Other Equity Equity Before Minority Interest US GAAP 30.966.0 6.19 20.466.0 20.437,0 25.37 4.08 1.97 217.540.43 2.04 6,124.0 17.0 10.500.0 2.900.0 US GAAP 32,844.0 6.76 22,764.0 22,764.0 25.55 4.59 2.81 211.249.13 2.00 6,216.01 36.00 10,080.0 2,500.0 US GAAP 33,559.0 6.96 24, 105.0 24,105.0 25.13 5.00 3.05 209.621.74 1.96 6,294.0 39.0 9,454.0 2,500.0 US GAAP 36,320.0 7.48 27,220.0 27,147.0 24.83 5.59 3.37 220,750.45 1.92 6,185.0 59.0 9,100.0 2.800.0 0.0 4.333.0 3.839.01 4,381.0 51,362.0 118,290.0 0.0 3,357.0 4,382.0 3,226.0 51,351.0 115,970.0 10.678.0 3.000.0 0.0 6.296.0 4.291.0 5.257.0 62,184.0 139,661.0 0.0 3.253.0 288.0 2.965.0 0.0 80.785.0 -11.542.0 72.496.0 0.0 3.831.0 4.227.0 4,337.0 45,179.0 123,700.0 0.0 2.943.0 295.0 2.648.0 0.0 85,107.0 -10.181.0 77.869.0 2.676.0 305.01 2.371.0 2,122.0 317.0 1.805.0 0.0 90,021.0 -11,597.0 80.546.0 89,354.0 -14.232.0 77.798.0 Capitalized Interest Expense pepreciation Expense Rental Expense Source: Bloomberg 10,678.0 3,000.0 17.0 10,500.0 2,900.0 36.0 10,080.0 2,600.0 39.0 9,454.0 2,500.0 59.0 9, 100.0 2,800.0 1 + Misc LT Liabilities Total Noncurrent Liabilities Total Liabilities + Preferred Equity and Hybrid Capital + Share Capital & APIC + Common Stock + Additional Paid in Capital - Treasury Stock + Retained Earnings + Other Equity Equity Before Minority Interest + Minority/Non Controlling Interest Total Equity Total Liabilities & Equity 5,257.0 62,184.0 139,661.0 0.0 3,253.0 288.0 2,965.0 0.0 80,785.0 -11,542.0 72,496.0 7,138.0 79,634.0 219,295.0 4,337.0 45,179.0 123,700.0 0.0 2,943.0 295.0 2,648.0 0.0 85,107.0 -10,181.0 77,869.0 2,953.0 80,822.0 204,522.0 4,381.0 51,362.0 118,290.0 0.0 2,676.0 305.0 2,371.0 0.0 89,354.0 -14,232.0 77,798.0 2,737.0 80,535.0 198,825.0 3,226.0 51,351.0 115,970.0 0.0 2,122.0 317.0 1,805.0 0.0 90,021.0 -11,597.0 80,546.0 3,065.0 83,611.0 199,581.0 2 U US GAAP 3,162.0 0.0 US GAAP 2,878.0 0.0 0.0 14,118.0 7,412.0 US GAAP 2,952.0 0.0 0.0 15,366.0 7,447.0 US GAAP 3,048.0 0.0 0.0 18, 139.0 6,568.0 0.0 21,505.0 6,367.0 Reference Items Accounting Standard Shares Outstanding Number of Treasury Shares Pension Obligations Future Minimum Operating Lease Obligations Capital Leases - Total Options Granted During Period Options Outstanding at Period End Net Debt Net Debt to Equity Tangible Common Equity Ratio Current Ratio Cash Conversion Cycle Cash Held Overseas Number of Employees Source: Bloomberg 46,448.0 35,690.0 35,862.0 37,685.0 58.33 44.16 44.53 45.07 21.96 32.01 33.42 34.91 0.80 0.76 0.86 0.93 1.86 3.92 8.00 11.05 7,666.0 6,500.0 5,635.0 4,500.0 2,200,000.00 2,300,000.00 2,300,000.00 2,300,000.00 2,20