Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribedimage 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 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.00

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

Contemporary Economics An Applications Approach

Authors: Robert Carbaugh

8th Edition

1138652199, 978-1138652194

More Books

Students also viewed these Finance questions

Question

How is the education level required for a position established?

Answered: 1 week ago

Question

Why is a job analysis important?

Answered: 1 week ago