Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3.5.4 - Profitability Ratios for Walmart 1) What is Walmart's net profit margin for the year of 2018 (round it to 2 numbers after the

3.5.4 - Profitability Ratios for Walmart 1) What is Walmart's net profit margin for the year of 2018 (round it to 2 numbers after the decimal point; Enter the answer in percentage format to one decimal place without the % sign -> 9.30 and not 9.3% or .093)? 2) What is Walmart's ROA for the year of 2018 (round it to 2 numbers after the decimal point; Enter the answer in percentage format to one decimal place without the % sign -> 9.30 and not 9.3% or .093)? 3) What is Walmart's ROE for the year of 2018 (round it to 2 numbers after the decimal point; Enter the answer in percentage format to one decimal place without the % sign -> 9.30 and not 9.3% or .093)? 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 FY 2016 FY 2015 01/31/2017 01/31/2016 01/31/2015 7.722.0 7,722.01 0.0 6.283.0 6.283 01 0.01 44 269.0 3,6230 0.0 6.756.0 6.756 01 0.01 5,614 01 5,614.0 0.01 43.783.0 3,511.01 0.0 6.867.0 6 6,8670 0.0 5.835.0 5,8350 0.0 43,046.0 1,941.0 0.0 8.705.0 8.705 0.01 5,624.0 5,624 0 0.01 44 469.0 1,4410 0.00 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.0 510,329.0 4,0760 365,301.0 385,301.0 129,104.0 0.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 8.739.0 11,460.0 4.281.0 4,751.0 4700 7.179.0 0.0 00 0.0 7,179.0 509.0 6.670.01 0.0 0.0 6,670.01 FY 2018 FY 2017 01/31/2018 01/31/2017 500,343.0 485,873.0 495,761.0 481,317.0 4.5820 4,556 01 373,396.0 361.256.00 373,396.0 361,256.01 126,947.0 124,617.0 0.0 0.0 106,510.0 101,853.0 106,510.0 101,8530 0.0 0.0 0.0 0.0 20,437.0 22,764.0 5,314.0 2.267.0 1,826 0 1,944 01 1,978.0 2,044.0 152.0 100.0 0.0 0.0 3.488.0 323.0 15,123.0 20,497.00 4,500.0 5,204.0 4.780.0 5,459.0 -1800 7450 10,523.0 14,293.0 0.0 0.0 0.0 00 0.0 0.0 10,523.0 14,293.0 561.0 650.0 9,862.0 13,643.0 00 0.0 0.0 0.0 9,862.0 13,643.0 FY 2016 FY 2015 01/31/2016 01/31/2015 482.1.30.0 485,651.0 478,614.0 482.229.0 3.516 0 3.4220 350,984.0 365,086.00 360,984.0 365,086.0 121,146.0 120,565.0 0.0 0.0 97,0410 93 418,0 97,0410 93,4180 0.0 0.0 0.0 0.0 24,105.0 27,147.01 2.467.0 2.348.0 1 1,946 0 2,0480 2,027.0 2,161.0 81.0 1130 0.0 0.0 5210 300.0 21,638,0 24,799.0 6,558.0 7.9850 7.584.0 8,504.0 - 1,0260 5190 15,080.0 16,814.0 0.0 -285.0 0.0 2850 0.0 0.0 15.080,0 17,099.00 386.0 736.0 14,694.0 16,363.00 0.0 0.0 0.0 0.01 14,694.0 16,363.00 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, Nat + 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 3,623.01 61,897.00 111.395.0 192,888.0 81,493.0 0.0 46,003.01 31,181,0 31, 1810 00 1.796.0 4120 12,614.0 157,398.01 219,295.01 3,511.0 59,664.0 114,018.01 197.8570 83,039.00 0.01 30.04001 18,242.0 18,2420 00 1,879.0 508.0 9.4110 144,858.0 204,522.0 1.941.0 57,689.0 114,178.0 191, 129.0 76,951.0 0.0 26.9580 17.037.0 17.037.0 00 1,565.0 479.0 7,8770 141,136.0 198,825.0 1,441.0 60,239.0 116,516.01 188,054.00 71,538.0 0.0 22,826 0 16,695.0 16,695.0 0.0 1,504.01 621.0 4,005.01 139,342.0 199,581.00 9,135.0 9,1350 0.0 6,778.0 6,778 0 0.0 45,141.0 2.224.0 0 0.0 7280 0.0 1,496.0 63,278.0 116,655.0 182,6340 65,979.0 0.0 23,5570 18,102.0 18,102.0 0.0 1.033.0 5120 3,910 0 140,212.0 203,490.0 6,670.0 58,615 0 38,487.0 521.00 19,607 0 6,004.0 2,708.0 551.00 551.0 Net Income Avail to Common, Adj Net Abnormal Losses (Gains) Net Extraordinary Losses (Gains) 13,293.4 3.431.4 0.0 58,526 0 38,410.0 1,021.0 19,0950 5.904.0 1,592.0 2870 287.0 13.456.3 -186.71 0.0 16,240,2 1622 -285.0 63 0080 41,433.0 921.0 20 654 0 3,920.0 1,099.0 5650 565.0 14,143.6 -550.4 0.0 0.0 67,7150 47.050.0 428.0 20.227 01 7.830.0 5.225.0 7290 729.0 0.0 1,8760 1,932.0 1,9320 0.0 68 8590 46,092.0 645.0 22 1220 9.662.0 52570 5670 667.0 - 3.738.0 0.0 00 0.0 0.0 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.281 2.995.0 3.29 3.29 4.44 3,1010 4.40 4.40 4.34 Liabilities & Shareholders' Equity + Payables & Accruals + Accounts Payable + Accrued Taxes + Other Payables & Accruals + ST Debt + ST Borrowings + ST Lease Liabilities + ST Finance Leases + ST Operating Lease + Current Portion of LT Debt Other ST Liabilities + Deferred Revenue + Derivatives & Hedging + Deferred Tax Liabilities + Discontinued Operations + Misc ST Liabilities Total Current Liabilities + LT Debt +LT Borrowings + LT Lease Liabilities +LT Finance Leases 3,2070 4.58 4.58 4.41 3,2300 5.07 4.98 5.03 2.256.0 0.0 0.0 0.0 2.745.0 0.0 0.01 0.01 Diluted Weighted Avg Shares Diluted EPS, GAAP Diluted EPS from Cont Ops Diluted EPS from Cont Ops, Adjusted 2,945.01 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 0 4.57 4.57 4.40 3.243.01 5.05 4.96 5.01 4,0250 823.0 0.0 767.0 56.0 00 0.0 65,253.0 39,645.0 37,039.0 2,6060 2,606.0 0.0 77,477.0 45,340 39,657.0 6,683.0 6,683.0 0.01 78,521.0 32,784.01 26.004.0 6,780 0 6,780.01 - 0.00 64,619.0 40,385.00 34,570.00 5,816 0 5,816.0 0.0 66.928.0 38,309.0 32.806.0 6,0030 6,003.0 Reference Items Accounting Standard EBITDA US GAAP 35.635.0 US GAAP 30,966.0 US GAAP 32,844.0 US GAAP 33,559.0 US GAAP 36,320.0 0.0 15,844.0 0.0 0.0 12,395.0 0.01 12,553.0 0.0 10,965.0 0.0 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 6.93 6.19 6.76 24,957.01 20,466.00 22,764.0 21,957.0 20,437.0 22.764.0 25.10 25.37 25.65 4.27 4.08 4.69 1.30 1.97 2.81 233,820.45 217,540.43 211,249.13 2.08 2.04 2.00 6,092.3 6,124.0 6,216.01 17.0 36.0 10,678.0 10,500.0 10,080.0 3,000.00 2.900.0 2,600.0 6.96 24, 105.0 24,105.00 25.13 5.00 3.05 209.621.74 1.96 6,294.0 39.0 9,454.0 2,500.0 7.48 27,220.00 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 +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 0.01 6,296.0 4,291.0 5,257.0 62,184.0 139,661.00 0.0 3,253.0 288.0 2,965.0 0.0 80,785.0 -11,542.0 72,496.00 7,138.0 79,634.0 219,295.0 0.0 3,831.0 4,227.0 4,337.00 45,179.0 123,700.00 0.0 2,943.00 295.0 2,648.00 0.0 85,107.0 -10,181.0 77,869.00 2,953.0 80,822.0 204,522.0 0.0 4,333.0 3,839.00 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.00 80,535.0 198,825.01 0.0 3,357.0 4,382.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.01 199,581.0 12,655.0 0.0 0.0 0.0 0.0 0.0 4.671.0 4,460.0 3,524.0 52,300.0 117,553.0 0.0 2,785.0 323.0 2,462.0 0.0 85.777.0 -7,168.0 81,394.0 4,543.0 85,937.0 203,490.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 US GAAPI US GAAP US GAAP US GAAP US GAAP 2,878.0 2,952.0 3,048.0 3,162.01 3,228.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 14,118.0 15,366.0 18.139.0 21,505.00 17,910.0 7,412.01 7,447.0 6,568.0 6,367.0 2,893.0 0.0 8.3 46,448.0 35.690.00 35,862.0 37,685.0 36,414.0 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

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

Contemporary Economics An Applications Approach

Authors: Robert Carbaugh

8th Edition

1138652199, 978-1138652194

More Books

Students also viewed these Finance questions

Question

What do their students end up doing when they graduate?

Answered: 1 week ago

Question

What are the organizations reputation goals on this issue?

Answered: 1 week ago

Question

What change do you need to make to achieve the desired position?

Answered: 1 week ago