1 WMT_statements_without_solution Q . Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut Calibri (Body) 11 . A- A Wrap Text General 2 AutoSum Copy Fill Paste BI UTY A. Merge & Center $ ~ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter K10 X V fx Consolidated Statements Of Income (Audited) (USD $) 12 Months Ended In Millions, except Per Share data, unless otherwise specified 2014 2013 2012 2011 2010 Revenues: 4 Net sales $466,114 $443,854 $418,952 405,132 401,087 5 Membership and other Income 3,048 3,096 2,897 2,953 3,167 6 Total revenues 469,162 146,950 421,849 408,085 404,254 7 Costs and expenses: 8 Cost of sales 352,488 335,127 314,946 304,444 303,941 9 Operating, selling, general and administrative expenses 88,873 85,26! 81,361 76,639 77,546 10 Operating income 27,801 26,558 25,542 24,002 22,767 11 Interest: 12 Debt 1,977 2.034 1,928 1.787 1.896 13 Capital leases 274 288 277 278 288 14 Interest income -187 -162 -201 -181 -284 15 Interest, net 2,064 2,160 2,004 1,884 1,900 16 Income from continuing operations before income taxes 25,737 24,398 23,538 22,118 20,867 17 Provision for income taxes 18 Current Income Tax Expense 7,999 6,742 5,703 7,643 5.564 19 Deferred Income Tax Expense -18 1,202 876 -487 569 20 Total provision for income taxes 7,981 7,944 7,579 7,156 ,133 21 Income from continuing operations 17,756 16,454 15,959 14.962 13,734 22 Loss from discontinued operations, net of income taxes -67 1,034 -79 146 23 Consolidated net income 17,756 16,387 16,993 14,883 13,880 24 Less consolidated net income attributable to noncontrolling interest -757 -688 -604 -513 -499 25 Consolidated net income attributable to Walmart $16,999 $15,699 $16,389 14,370 13,381 26 Basic net income per common share: 27 Basic inco mon share from continuing operations attributable to Walmart $5.04 $4.56 $4.20 $ 3.74 $ 3.3 28 Basic loss per common share from discontinued operations attributable to Walmart SO $0.02) $0.28 $ (0.02) $ 0.04 29 Basic net income per common share attributable to Walmart $5.04 $4.54 $4.48 $ 3.72 $ 3.4 30 Diluted net income per common share: 31 Diluted income per common share from continuing operations attributable to Walmart $5.02 $4.54 $4.18 $ 3.73 3.35 32 Diluted loss per per common share from discontinued operations attributable to Walmart SO ($0.02) $0.29 $ (0.02) $ 0.04 33 Diluted net income per common share attributable to Walmart $5.02 $4.52 $4.47 $ 3.71 $ 3.39 34 Weighted-average common shares outstanding: 35 Basic 3,374 3,460 3,656 3,866 3,939 36 Diluted 3,389 3,474 3,670 3,877 3,951 37 Dividends declared per common share $1.59 $1.46 $1.21 $ 1.09 $ 0.95 38 39 40 41 42 43 Cash flow statement Income Statement Balance Sheet + Ready + 100%Home Insert Page Layout Formulas Data Review View Cut Calibri (Body) 11 . A- A = Copy Paste Format BI UT Y A. G3 X v fx Consolidated Balance Sheets (Audited) (USD $) In Millions, unless otherwise specified 2014 2013 201 2011 2010 2009 |Current assets: Cash and cash equivalents 7,781 6,55 7,395 7,907 $7,275 $5.492 5 Receivables, net 6,768 5,937 5,089 4,144 3,905 3,642 Inventories 13.80 10.714 36.318 32,713 34.511 35,159 Prepaid Expense and Other Assets, Current 1,58 1,774 3,091 3,128 3.063 2,760 Total current assets 59.940 54,975 51,893 18,032 48.949 18,020 Property and equipment 10 Land 25,612 23 499 24.386 22,591 19,852 19,879 11 Buildings and improvements 90.686 84,275 79,051 73,657 73,810 72,141 12 Fixtures and equipment 40.903 19,234 8.290 34,035 19 851 28,026 13 Transportation equipment 2,796 2,682 2,595 2,355 2,307 2.210 14 Construction in process 5,828 5,312 4,262 5,210 15 Property, Plant and Equipment, Grass 65,825 55,002 148,58 137,848 125,820 122,25 16 Less accumulated depreciation -51,896 -45,399 (43,486) (38,304) (32,964) (28,531) 17 Property and equipment, net 13,929 109,603 103 098 90 544 92 856 93,725 18 Property under capital leases: 19 Property under capital leases 5,899 5,936 5,905 5,669 5,341 5,736 20 Less accumulated amortization 3,147 3,215 3,125 2,9061 12.5441 (2,594] 1 Property under capital leases, net 2,752 2,721 2,780 2,763 2,797 3,142 22 G Goodwill 20 497 0,651 16,763 .6,126 15,260 5,879 23 Other assets and deferred charges 5,987 5,456 4,129 3,942 3,567 2,748 24 Total assets 203,105 193,406 180,663 170,407 $163,429 $163,514 25 Current liabilities: 6 Short-term borrowings 6,802 4,04 1,041 523 $1,506 $5,040 27 Accounts payable 38,080 36,60 33,557 0,451 28,849 30,344 28 Accrued liabilities 18,808 18.180 18.701 18,734 18,112 15,725 29 Accrued income taxes 2,211 1.164 157 1,347 677 1,000 30 Long-term debt due within one year ,587 1.975 .655 4.050 5.848 ,913 31 Obligations under capital leases due within one year 327 326 336 346 315 316 32 Total current liabilities 71,818 62,300 8,48 55,543 55.390 58,478 33 Long-term debt 18,39 14.070 10.692 33,231 1.349 29,79 Long-term obligations under capital leases 3,023 3,009 3,150 3,170 3.200 3,603 35 Deferred income taxes and other 7,613 .862 6.682 5,508 6,014 5,087 36 Redeemable noncontrolling interest 519 307 2,191 1,939 37 Total liabilities 121,367 117,645 109,416 97,759 98.14 98.906 38 Equity: 39 Common stock 332 347 352 378 39 397 40 Capital in excess of par value 3,620 3,692 3,577 3,803 3,920 3,028 41 Retained earnings 72,978 68,691 3,96 66,357 63,660 57,319 42 Accumulated other comprehensive income (loss) -587 -1,410 646 (70) 12.688 3,864 43 Total Walmart shareholders' equity 76,343 71.315 8,54 70,468 5,285 64,60 44 Noncontrolling interest 5,395 4,446 2,705 2,180 45 Total equity 81,738 75,761 71,247 72,648 65,285 64,608 46 Total liabilities and equity $203,105 $193,406 180,663 170,407 $163,429 * $163,514 77 78 Cash flow statement Income Statement Balance Sheet + Ready1 WMT_statements_without_solution Q . Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut Calibri (Body) 11 . A- A = I Wrap Text General 2 AutoSum Copy Fill Paste Merge & Center $ ~ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter M15 X V fx Consolidated Statements Of Cash Flows (Audited) (USD $) In Millions, unless otherwise specified 2014 2013 2012 2011 2010 Cash flows from operating activities: Income from continuing operations 17,756 16,45 15,959 14,962 13,734 Adjustments to reconcile income from continuing operations to net 6 cash provided by operating activities: 7 Depreciation and amortization 8,501 8,130 7,641 7,157 6,739 8 Deferred income taxes (133) 1,050 651 (504) 581 9 Other operating activities 527 398 1,087 318 752 10 Changes in certain assets and liabilities, net of effects of acquisitions: 11 Receivables, net (614) (796) (733) (297) (101) 12 Inventories 2,759 (3,727 (3,205) 2,213 (184) 13 Accounts payable 1,061 2,687 2,676 1,052 (410 14 Accrued liabilities 271 935 (280) 1,348 2,036 15 |Accrued income taxes 981 994 (153 16 Net cash provided by operating activities 25,591 24,255 23,643 26,249 23,147 17 Cash flows from investing activities: Payments for property and equipment (12,898) (13,510) (12,699) (12,184) (11,499) 19 Proceeds from the disposal of property and equipment 532 580 489 1,002 714 20 Investments and business acquisitions, net of cash acquired 316) 3,548 202) 1,576) 21 Other investing activities 71 (131) 219 (438) 781 22 Net cash used in investing activities (12,611) (16,609) (12,193) (11,620) (10,742) 23 Cash flows from financing activities: 24 Net change in short-term borrowings 2,754 3,019 503 (1,033) (3,745) 25 Proceeds from issuance of long-term debt 211 5.050 11,396 5,546 6,566 26 Payments of long-term debt (1,478) (4,584 (4,080) (6,033) (5,387) 27 Dividends paid (5,36 (5,048) (4,437) (4,217) (3,746) 28 Purchase of Company stock (7,600) (6,298) 14,776) (7,276) (3,521) Other financing activities (498) (597) (1,178) (85) 30 Net cash used in financing activities (11,972) (8,458 (12,028) (14,191) (9,918) 31 Effect of exchange rates on cash and cash equivalents 223 (33) 66 194 (781 32 Net increase (decrease) in cash and cash equivalents 1,231 (845) (512) 632 1,706 33 Cash and cash equivalents at beginning of year 6,550 7,395 7,907 7,275 5,569 34 Cash and cash equivalents at end of period 7,781 6,550 7,395 7,907 7,275 35 Income Taxes Paid, Ne 7,304 5,895 6,984 7,389 6,596 16 Interest Paid 2,262 2,346 2,163 2,141 1,787 37 38 39 40 41 42 43 Cash flow statement Income Statement Balance Sheet + Ready + 100%