Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3.5.3 - Turnover Ratios for Walmart 1) What is Walmart's inventory turnover ratio for the year of 2018 (round it to 3 numbers after the
3.5.3 - Turnover Ratios for Walmart 1) What is Walmart's inventory turnover ratio for the year of 2018 (round it to 3 numbers after the decimal point -> 0.112)? 2) What is Walmart's Days Sales in Inventory ratio for the year of 2018 (round it to 3 numbers after the decimal point -> 0.112)? 3) What is Walmart's Total Asset Turnover Ratio ratio for the year of 2018 (round it to 3 numbers after the decimal point -> 0.112)?
WMT's financial statement: (right click table > open image in new tab > (to see image more clear)
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 FY 2015 01/31/2016 01/31/2015 FY 2018 01/31/2018 500,343.0 495,761.00 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.00 5,314.0 1,826.0 1.978.0 7,722.01 7,722.0 0.0 6,283.01 6,283.0 0.0 44,269.00 3,623.0 0.0 6,756.0 6.756.0 0.0 5,614.0 5,614.0 0.0 43,783.0 3,511.01 0.0 6.867.0 6.867.0 0.0 5,835.0 5,835.0 0.0 43,046.00 1,941.0 0.0 8,705.01 8.705.0 0.0 5,624.0 5,624.0 0.0 44,469.00 1,441.0 0.0 9,135.0 9,135.0 0.0 6,778.0 6,778.0 0.0 45,141.0 2.224.0 0.0 In Millions of USD except Per Share 12 Months Ending Revenue + Sales & Services Revenue + Other Revenue - Cost of Revenue + Cost of Goods & Services Gross Profit + Other Operating Income -Operating Expenses + Selling, General & Admin + Research & Development + Other Operating Expense Operating Income (Loss) - Non-Operating (Income) Loss + Interest Expense, Net + Interest Expense Interest Income + Foreign Exch (Gain) Loss + Other Non-Op (Income) Loss Pretax Income - Income Tax Expense (Benefit) + Current Income Tax + Deferred Income Tax Income (Loss) from Cont Ops - Net Extraordinary Losses (Gains) + Discontinued Operations + XO & Accounting Changes Income (Loss) Incl. MI - Minority Interest Net Income, GAAP Preferred Dividends - Other Adjustments Net Income Avail to Common, GAAP FY 2019 01/31/2019 514,405.00 510,329.0 4,076.0 385,301.0 385,301.0 129,104.0 0.0 107,147.01 107,147.0 0.01 0.0 21,957.00 10,497.0 1,758.01 1,975.0 217.0 0.0 8,739.0 11,460.0 4,281.0 4.751.0 470.0 7,179.0 0.0 FY 2017 01/31/2017 485,873.0 481,317.0 4.556.0 361,256.0 361,256.0 124,617.01 0.01 101,853.0 101,853.0 0.0 0.01 22,764.0 2,267.0 1,944.0 2,044.0 100.0 0.0 323.0 20,497.0 6,204.0 5,459.0 745.0 FY 2016 01/31/2016 482,130.0 478,614.0 3.516.0 360.984.0 360,984.0 121,146.0 0.0 97,041,01 97,041.00 0.0 0.0 24,105.00 2,467.0 1,946.0 2,027.0 81.0 0.0 521.0 21,638.0 6,558.0 7,584.0 -1,026.0 15,080.0 0.0 0.0 0.0 15,080.0 386.0 14,694.0 0.0 0.01 14,694.0 FY 2015 01/31/2015 485,651.0 482,229.01 3.422.0 365,086.01 365,086.0 120,565.00 0.0 93,418.01 93,418.0 0.01 0.0 27,147.0 2.348.0 2,048.0 2,161.0 113.01 0.0 300.0 24,799.0 7,985.01 8,504.01 -519.0 16,814.0 -285.0 -285.0 0.0 17,099.0 736.0 16,363.0 0.0 0.0 16,363.0 In Millions of USD except Per Share 12 Months Ending Total Assets + Cash, Cash Equivalents & STI + Cash & Cash Equivalents + ST Investments + Accounts & Notes Receiv + 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 152.0 3,623.0 61,897.0 111,395.0 192,888.0 81,493.0 0.0 46,003.0 31,181.0 31,181.0 0.0 1,796.0 412.0 12,614.0 157,398.01 219,295.0 0.0 3,488.0 15,123.0 4,600.0 4,780.0 -180.0 10,523.0 0.0 0.0 0.0 10,523.0 661.0 9,862.0 0.0 0.01 9,862.00 3,511.0 59,664.0 114,818.0 197,857.00 83,039.0 0.01 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.00 191,129.00 76,951.0 0.0 26,958.0 17.037.00 17.037.0 0.01 1,565.0 479.0 7,877.0 141,136.0 198,825.00 1,441.0 60,239.0 116,516.0 188,054.0 71,538.0 0.0 22,826.01 16,695.0 16,695.0 0.01 1,504.0 621.0 4.006.0 139,342.01 199,581.0 728.0 0.0 1,496.0 63,278.0 116,655.0 182,634.0 65,979.0 0.0 23,557.0 18,102.0 18, 102.0 0.0 1,033.0 512.0 3,910.0 140,212.0 203,490.0 14,293.0 0.0 0.01 0.0 14,293.0 0.0 0.0 7,179.0 509.0 6,670.00 0.0 0.0 6,670.0 650.0 13,643.0 0.01 0.0 13,643.0 68,859.0 46,092.0 645.0 22,122.01 9,662.0 5,257.0 667.0 667.0 63.008.0 41,433.0 921.0 20,654.0 3,920.0 1,099.0 565.0 565.0 58,615.0 38,487.01 521.0 19,607.0 6,004.0 2,708.0 551.0 551.0 Net Income Avail to Common, Adj Net Abnormal Losses (Gains) Net Extraordinary Losses (Gains) 58,526.0 38,410.0 1,021.0 19.095.0 5,904.0 1,592.0 287.0 287.0 6,670.0 0.0 0.0 Liabilities & Shareholders' Equity + Payables & Accruals + Accounts Payable + Accrued Taxes + Other Payables & Accruals + ST Debt + ST Borrowings + ST Lease Liabilities + ST Finance Leases + ST Operating Leases + Current Portion of LT Debt + Other ST Liabilities + Deferred Revenue 13,293.4 3,431.4 0.0 67.715.0 47,060.0 428.0 20,227.01 7,830.0 5,225.0 729.0 729.0 0.0 1,876.0 1,932.01 1,932.00 13,456.3 -186.71 0.01 14,143.6 -550.4 0.0 16,240.2 162.2 -285.0 2,995.0 3.29 3,101.01 4.40 Basic Weighted Avg Shares Basic EPS, GAAP Basic EPS from Cont Ops Basic EPS from Cont Ops, Adjusted 2,929.0 2.28 2.28 2.28 3,207.0 4.58 4.58 4.41 3.230.0 5.07 4.98 5.03 3.29 4.40 3,738.01 0.0 0.00 2,256.0 0.0 0.0 2,745.0 0.0 0.0 4,025.0 823.0 0.0 4.44 4.34 0.0 0.0 0.0 0.0 767.00 Diluted Weighted Avg Shares Diluted EPS, GAAP Diluted EPS from Cont Ops Diluted EPS from Cont Ops, Adjusted 2,945.0 2.26 2.26 2.26 3,010.0 3.28 3.28 4.42 3,112.0 4.38 4.38 4.32 3,217.0 4.57 4.57 4.40 3,243.0 5.05 4.96 5.01 0.0 77,477.0 46,340.00 39,657.0 6,683.00 6,683.0 0.0 15,844.0 0.0 0.0 0.0 78,521.0 32,784.0 26.004.0 6,780.0 6,780.0 0.0 66,928.0 38,809.0 32,806.0 6,003.0 6,003.0 0.0 64,619.0 40,386.00 34,570.01 5,816.00 5,816.0 56.01 0.01 0.01 65,253.0 39,645.0 37,039.00 2,606.0 2,606.0 12,395.0 0.0 12,553.0 0.0 10.965.0 0.01 Reference Items Accounting Standard EBITDA EBITDA Margin (T12M) EBITA EBIT Gross Margin Operating Margin Profit Margin Sales per Employee Dividends per Share Total Cash Common Dividends Capitalized Interest Expense Depreciation Expense Rental Expense Source: Bloomberg US GAAP US GAAP 35,635.0 30.966.0 6.93 6.19 24,957.00 20,466.0 21,957.0 20.437.00 25.10 25.37 4.27 4.08 1.30 1.971 233,820.45 217,540.43 2.08 2.04 6,092.3 17.0 10,678.0 10,500.0 3,000.00 US GAAPI US GAAP 32,844.0 33,559.01 6.76 6.96 22,764.0 24, 105.0 22,764.0 24,105.01 25.65 25.13 4.69 5.00 2.811 3.05 211,249.13 209,621.74 2.00 1.96 6,216.0 6,294.00 36.0 39.0 10,080.0 9,454.0 2,600.0 2,500.00 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.01 59.00 9,100.0 2,800.0 + Derivatives & Hedging + Deferred Tax Liabilities + Discontinued Operations + Misc ST Liabilities Total Current Liabilities + LT Debt + LT Borrowings + LT Lease Liabilities +LT Finance Leases + LT Operating Leases + Other LT Liabilities + Accrued Liabilities + Pension Liabilities + Pensions + Other Post-Ret Benefits + Deferred Revenue + Deferred Tax Liabilities + Derivatives & Hedging + 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 6,124.01 0.0 6,296.0 4,291.0 5,257.0 62,184.0 139,661.0 0.0 3,253.01 2,900.0 0.0 3,831.0 4.227.01 4,337,0 45,179.0 123,700.0 0.0 2,943.0 295.00 2,648.0 0.0 85,107.00 -10,181.0 77,869.00 2,953.00 80,822.0 204,522.0 288.0 0.0 4,333.0 3,839.0 4,381.0 51,362.0 118,290.00 0.0 2,676.0 305.0 2,371.0 0.0 89,354.0 - 14,232.01 77,798.01 2,737.0 80,535.0 198,825.00 12,655.0 0.01 0.0 0.0 0.0 0.01 4.671.0 4,460.00 3,524.01 52,300.00 117,553.0 0.01 2.785.01 323.01 2,462.01 0.01 85,777.01 -7.168.01 81,394.0 4,543.0 85,937.00 203,490.0 0.0 3.357.0 4,382.0 3,226.0 51,351.0 115,970.0 0.0 2,122.0 317.00 1,805.01 0.0 90,021.00 -11,597.01 80,546.0 3,065.0 83,611.0 199,581.0 2,965.0 0.0 80,785.0 -11,542.0 72,496.00 7,138.0 79,634.00 219,295.00 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 US GAAP US GAAP US GAAP US GAAP US GAAP 2,878.0 2,952.0 3,048.0 3,162.00 3,228.00 0.00 0.0 0.0 0.0 0.0 0.01 0.0 0.01 0.0 0.01 14,118.0 15,366.0 18,139.0 21,505.01 17,910.00 7,412.0 7,447.0 6.568.0 6,367.0 2,893.0 0.0 8.31 46,448.0 35,690.0 35,862.0 37,685.0 36,414.01 58.33 44.16 44.53 45.07 42.37 21.96 32.01 33.42 34.91 34.14 0.80 0.76 0.86 0.93 0.97 1.86 3.92 8.00 11.05 12.17 7,666.0 6,500.00 5,635.0 4,500.00 6,300.0 2,200,000.00 2,300,000.00 2,300,000.00 2,300,000.00 2,200,000.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started