Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Wal-Mart Stores, Inc. (NYS: WMT) Wal-Mart Stores, Inc. (NYS: WMT) Balance Sheet

ID: 2652612 • Letter: W

Question

Wal-Mart Stores, Inc. (NYS: WMT)

Wal-Mart Stores, Inc. (NYS: WMT)

Balance Sheet Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date 01/31/2015 01/31/2014 01/31/2013 Currency USD USD USD Audit Status Not Qualified Not Qualified Not Qualified Consolidated Yes Yes Yes Scale Thousands Thousands Thousands Cash & cash equivalents 9135000 7281000 7781000 Receivables, net 6778000 6677000 6768000 Inventories 45141000 44858000 43803000 Prepaid expenses & other current assets 2224000 1909000 1588000 Current assets of discontinued operations - 460000 - Total current assets 63278000 61185000 59940000 Land 26261000 26184000 25612000 Buildings & improvements 97496000 95488000 90686000 Fixtures & equipment 45044000 42971000 40903000 Transportation equipment 2807000 2785000 2796000 Construction in progress 5787000 5661000 5828000 Property & equipment, at cost 177395000 173089000 165825000 Less: accumulated depreciation 63115000 57725000 51896000 Property & equipment, net 114280000 115364000 113929000 Property under capital leases 5239000 5589000 5899000 Less: accumulated amortization 2864000 3046000 3147000 Property under capital leases, net 2375000 2543000 2752000 Goodwill 18102000 19510000 20497000 Other assets & deferred charges 5671000 6149000 5987000 Total assets 203706000 204751000 203105000 Short-term borrowings 1592000 7670000 6805000 Accounts payable 38410000 37415000 38080000 Accrued wages & benefits 4954000 4652000 5059000 Self-insurance 3306000 3477000 3373000 Accrued taxes 2592000 2554000 2851000 Other accrued liabilities 8300000 8110000 7525000 Accrued liabilities 19152000 18793000 18808000 Accrued income taxes 1021000 966000 2211000 Long-term debt due within one year 4810000 4103000 5587000 Obligations under capital leases due within one year 287000 309000 327000 Current liabilities of discontinued operation - 89000 - Total current liabilities 65272000 69345000 71818000 Unsecured debt 45443000 45073000 42882000 Other debt 453000 801000 1099000 Total long-term debt 45896000 45874000 43981000 Less: current portion 4810000 4103000 5587000 Long-term debt 41086000 41771000 38394000 Long-term obligations under capital leases 2606000 2788000 3023000 Deferred income taxes & other liabilities 8805000 8017000 7613000 Redeemable noncontrolling interest - 1491000 519000 Common stock 323000 323000 332000 Capital in excess of par value 2462000 2362000 3620000 Retained earnings (accumulated deficit) 85777000 76566000 72978000 Currency translation & other -6355000 -2722000 47000 Derivative instruments -134000 336000 129000 Minimum pension liability -679000 -610000 -763000 Accumulated other comprehensive income (loss) -7168000 -2996000 -587000 Total Walmart shareholders' equity 81394000 76255000 76343000 Noncontrolling interests - 5084000 5395000 Nonredeemable noncontrolling interest 4543000 - - Total equity 85937000 81339000 81738000

Explanation / Answer

2015 2014 2013 Current Asset Ratio= Current Assets/ Current Liabilities 63278000/65272000 0.97 61185000/69345000 0.88 59940000/71818000 0.83 Total Debt Ratio= TA-TE/TA 203706000-85937000/203706000 0.57 204751000-81339000/204751000 0.6 203105000-81738000 /203105000 0.6 TIE= EBIT/Interest 27147000/2461000 11.03 26872000/2335000 11.5 27801000/2251000 12.4 Cash Coverage Ratio=EBIT+Depre/Interest 27147000/2461000 11.03 26872000/2335000 11.5 27801000/2251000 12.4 As only accumulated dep is given Receivable Turnover= Sales/ Accounts Receivable 482229000/6778000 71.14 473076000/6677000 70.9 466114000/6768000 68.9 PM=NI/Sales 16363000/482229000 0.03 16022000/473076000 0.03 16999000/466114000 0.03 tat= Sales/TA 482229000/203706000 2.36 473076000/204751000 2.31 466114000/203105000 2.29 ROA=NI/TA 16363000/203706000 0.08 16022000/204751000 0.07 16999000/203105000 0.08