Unit 3 team project

profileechidester
MT217TeamProjectFinancialDataWalMartFinancials.xlsx

Balance Sheet

Walmart ( WMT)
Millions of USD (except for per share items) As of 2015 As of 2014
Cash & Equivalents $ 7,759 $ 6,012
Total Receivables, Net 5,813 6,096
Total Inventory 46,310 45,315
Prepaid Expenses 2,251 1,811
Total Current Assets 62,133 59,687
Property/Plant/Equipment, Total - Gross 138,614 142,830
Total Assets $ 200,747 $ 202,517
Accounts Payable 37,224 36,347
Accrued Expenses 18,685 17,807
Notes Payable/Short Term Debt 799 3,517
Current Port. of LT Debt/Capital Leases 6,468 3,566
Other Current liabilities, Total 6,448 6,684
Total Current Liabilities 69,624 67,921
Total Long Term Debt 42,964 48,233
Deferred Income Tax 8,169 8,164
Minority Interest 3,416 5,111
Total Liabilities 124,173 129,429
Total Equity 76,574 73,088
Total Liabilities & Shareholders' Equity 200,747 202,517
- -
Total # Common Shares Outstanding $ 3,227 $ 3,230

Income Statement

Walmart ( WMT)
Millions of USD (except for per share items) 2015 2014
Sales $ 114,826 $ 114,960
Cost of Goods Sold 86,483 86,714
Gross Profit 28,343 28,246
Selling/General/Admin. Expenses, Total 22,663 22,053
Operating Income 5,680 6,193
Interrest and Taxes 2,336 2,600
Net Income $ 3,344 $ 3,593
Market Price/Share $ 65.68 $ 84.26
Shares Outstanding 3,210 3,210

Sheet1