30 Jun Equity Beta and Wacc – Walmart Inc. Valuation Worksheet Assignme
Equity Beta and Wacc – Walmart Inc. Valuation Worksheet Assignment
All interaction on Studypool is 100% anonymous. Username has been changed to protect this user’s privacy
Anonymous
label
Business Finance
timer
2 months ago
account_balance_wallet
$15
Question Description
(1) Estimate the equity beta and WACC.
(2) Estimate the capital structure.
(3) Estimate WMT’ price per share, based on the set of assumptions about the future, as of the end of Feb. 2018. Submit a copy of the finalized worksheet (the first 10 years only).
Tags: walmart capital structure WACC equity beta WMT price per share Inc Valuation Worksheet
copy_of_wmt_2018v0_1__8.xls
Unformatted Attachment Preview
A B C D E F G H I J K Walmart, Inc. 1 L M N O P Q R S T U V W X Y Z 0.00 0.00 AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW BX BY Amazon.com 2 3 Balance Sheet, standardized ($million) Fiscal Year Ending ASSETS Cash & Equivalents Receivables – Total (Net) 8 Inventories – Total 9 Prepaid Expenses & Other current assets 10 Current Assets – Total Plant, Property & Equip (Gross) 11 Accumulated Depreciation 12 13 Plant, Property & Equip (Net) 4 C=not meaningful 2012 2013 2014 2015 2016 2017 2012 2013 2014 2015 2016 2017 7,781 6,768 43,803 1,588 59,940 171,724 55,043 116,681 7,281 6,677 44,858 2,369 61,185 178,678 60,771 117,907 9,135 6,778 45,141 2,224 63,278 182,634 65,979 116,655 8,705 5,624 44,469 1,441 60,239 188,054 71,538 116,516 6,867 5,835 43,046 1,941 57,689 191,129 76,951 114,178 6,756 5,614 43,783 3,511 59,664 197,857 83,039 114,818 11,448 2,600 6,031 1,217 21,296 9,582 2,522 7,060 12,447 3,000 7,411 1,767 24,625 14,809 3,860 10,949 17,416 3,300 8,299 2,312 31,327 22,730 5,763 16,967 19,808 4,400 10,243 2,023 36,474 30,053 8,215 21,838 25,981 6,561 11,461 1,778 45,781 42,441 13,327 29,114 32,315 9,692 16,047 2,143 60,197 68,573 19,707 48,866 0 20,497 5,987 203,105 0 19,510 6,149 204,751 0 18,102 5,671 203,706 0 16,695 6,131 199,581 17,037 9,921 198,825 18,242 11,798 204,522 140 3,277 782 32,555 127 3,300 1,158 40,159 209 4,083 1,919 54,505 280 4,521 2,331 65,444 467 4,638 3,402 83,402 737 16,721 4,789 131,310 38,080 6,805 18,117 2,211 5,914 691 71,818 37,415 7,670 17,976 966 4,412 906 69,345 38,410 1,592 18,337 1,021 5,097 815 65,272 38,487 2,708 18,863 521 3,296 744 64,619 41,433 1,099 19,911 921 2,821 743 66,928 46,092 5,257 19,375 645 4,405 2,747 78,521 13,318 0 15,133 0 16,459 0 20,397 0 25,309 0 0 1,134 4,550 19,002 0 1,736 6,111 22,980 0 3,600 8,030 28,089 0 3,364 10,138 33,899 0 5,197 13,310 43,816 0 6,221 17,046 57,883 41,417 4,373 3,240 519 121,367 44,559 5,110 2,907 1,491 123,412 43,692 4,671 4,134 0 117,769 44,030 3,357 3,964 0 115,970 42,018 4,333 5,011 0 118,290 36,825 3,831 4,523 0 123,700 3,830 1,531 0 24,363 5,181 571 1,681 0 30,413 12,489 1,021 2,165 0 43,764 14,183 1,084 2,894 0 52,060 15,213 392 4,696 0 64,117 37,926 990 6,802 0 103,601 0 332 3,620 72,391 0 76,343 5,395 81,738 203,105 0 323 2,362 73,570 0 76,255 5,084 81,339 204,751 0 323 2,462 78,609 0 81,394 4,543 85,937 203,706 0 317 1,805 78,424 0 80,546 3,065 83,611 199,581 0 305 2,371 75,122 0 77,798 2,737 80,535 198,825 0 295 2,648 74,926 0 77,869 2,953 80,822 204,522 0 5 8,347 1,677 1,837 8,192 0 8,192 32,555 0 5 9,573 2,005 1,837 9,746 0 9,746 40,159 0 5 11,135 1,438 1,837 10,741 0 10,741 54,505 0 5 13,394 1,822 1,837 13,384 0 13,384 65,444 0 5 17,186 3,931 1,837 19,285 0 19,285 83,402 0 5 21,389 8,152 1,837 27,709 0 27,709 131,310 2012 467,231 343,987 123,244 5 6 7 14 15 16 17 18 19 20 21 22 23 24 25 Investments Intangibles & Goodwill Deferred Charges & Other Long term Assets TOTAL ASSETS LIABILITIES Accounts Payable Notes Payable Accrued Expenses Tax payable Debt (Long-Term) Due In One Year Other Current Liabilities & Tax payable Total Current Liabilities Long Term Debt Deferred Taxes (Balance Sheet) Liabilities – Other Non-controlling interest-redeemable TOTAL LIABILITIES 31 SHAREHOLDERS’ EQUITY 32 Preferred Stock 33 Common Stock 34 Capital Surplus 35 Retained Earnings (Net Other) 36 Less: Treasury Stock 37 Shareholders Equity – Parent 38 Non-contrlling interest-nonredeemable 39 TOTAL SHAREHOLDERS EQUITY 40 TOTAL LIABILITIES AND EQUITY 26 27 28 29 30 34,616 0 41 42 ANNUAL INCOME STATEMENT 43 Fiscal Year Ending Sales (Net) Cost of Goods Sold Gross Profit 2013 474,259 349,199 125,060 2014 483,521 355,913 127,608 2015 479,962 351,530 128,432 2016 482,154 351,176 130,978 2017 496,785 362,867 133,918 2012 61,093 44,271 16,822 2013 74,452 51,681 22,771 2014 88,988 59,152 29,836 2015 107,006 66,751 40,255 2016 135,987 81,865 54,122 2017 177,866 103,134 74,732 88,716 34,528 8,501 26,027 90,920 34,140 8,870 25,270 92,996 34,612 9,173 25,439 96,915 31,517 9,454 22,063 101,384 29,594 10,080 19,514 104,736 29,182 10,529 18,653 14,287 2,535 1,863 672 19,412 3,359 2,668 691 25,925 3,911 3,781 130 32,951 7,304 5,128 2,176 43,369 10,753 6,687 4,066 61,612 13,120 9,166 3,954 51 Interest Expense 52 Interest Income 53 Other Non-Operating Income/Expense 54 Special Items 55 Pretax Income 2,325 102 2,090 (157) 25,737 2,413 113 2,119 (433) 24,656 2,520 81 2,221 (422) 24,799 2,587 181 2,107 (126) 21,638 2,403 100 3,220 66 20,497 2,330 152 3,171 (4,523) 15,123 92 40 (231) 389 141 38 (153) 0 435 210 39 (33) 0 (74) 459 50 (221) 0 1,546 484 100 114 0 3,796 848 202 494 0 3,802 Income Taxes – Total Minority Interest 58 Income Before EI&DO 59 Extraordinary Items 60 Discontinued Operations 61 Net Income (Loss) 7,981 757 16,999 0 0 16,999 8,105 633 15,918 0 104 16,022 7,985 632 16,182 0 181 16,363 6,558 386 14,694 0 0 14,694 6,204 650 13,643 0 0 13,643 4,600 661 9,862 0 0 9,862 428 0 (39) 0 0 (39) 161 0 274 0 0 274 167 0 (241) 0 0 (241) 950 0 596 0 0 596 1,425 0 2,371 0 0 2,371 769 0 3,033 0 0 3,033 0 16,999 0 3,033 44 45 46 47 48 49 50 Selling, General, & Admin Expenses Operating Income Before Depreciation Depreciation, Depletion, & Amortiz Operating Income After Depreciation 56 57 0 15,918 0 16,182 0 14,694 0 13,643 0 9,862 0 (39) 0 274 0 (241) 0 596 0 2,371 EARNINGS PER SHARE EPS – Primary, Including EI&DO EPS – Fully Diluted, Including EI&DO 67 COMMON SHARES 68 Common Shares for Primary EPS Calculation 69 Common Shares for Fully Diluted EPS 70 Com.Shares Outstanding at Fiscal Yr End 71 Stock price–fiscal year end 5.04 5.02 4.87 4.85 5.01 4.99 4.58 4.57 4.40 4.38 3.29 3.28 (0.09) (0.09) 0.60 0.59 (0.52) (0.52) 1.28 1.25 5.01 4.90 6.32 6.15 3,374 3,389 3,314 70 3,269 3,283 3,233 75 3,230 3,243 3,228 85 3,207 3,217 3,162 66 3,101 3,112 3,048 67 2,995 3,010 2,952 107 453 453 454 251 457 465 459 399 462 462 465 310 467 477 471 676 474 484 477 750 480 493 484 1169 72 73 2012 2013 2014 2015 2016 2017 2012 2013 2014 2015 2016 2017 (39) 2,159 0 (265) 62 63 Preferred Dividends Adjusted Available for Common 64 65 66 74 75 76 77 78 79 80 81 82 83 84 85 86 87 Statement of Cashflows INDIRECT OPERATING ACTIVITIES Income Before Extraordinary Items Depreciation and Amortizations Extr. Items and Disc. Operations Deferred Taxes Equity in Net Loss (Earnings) Sale of PPEq and Investments – Loss (Gain) Funds from Operations – Other Receivables – Decrease(Increase) Inventory – Decrease (Increase) Accounts/P and Accrued Liabs – Inc(Dec) Income Taxes – Accrued – Increase(Decrease) Other Assets and Liabilities – Net Change Operating Actiities – Net Cash Flow 17,756 8,501 0 (133) 16,551 8,870 0 (279) 16,814 9,173 0 (503) 15,080 9,454 0 (672) 14,293 10,080 0 761 10,523 10,529 0 (304) 0 527 (614) (2,759) 1,332 981 0 25,591 0 938 (566) (1,667) 634 (1,224) 0 23,257 0 785 (569) (1,229) 3,927 166 0 28,564 0 1,410 (19) (703) 3,311 (472) 0 27,389 0 206 (402) 1,021 5,079 492 0 31,530 0 4,346 (1,074) (140) 5,014 (557) 0 28,337 274 3,253 0 (156) (241) 4,746 0 (316) 596 6,281 0 81 2,371 8,116 0 (246) 3,033 11,478 0 (29) (9) 811 1 1,336 (3) 1,682 5 2,400 0 2,286 0 4,125 (999) (1,410) (1,193) (2,187) (1,426) 0 2,522 4,180 0 2,177 5,475 0 2,167 6,842 0 4,744 11,920 0 5,342 16,443 (3,583) 7,175 0 (3,765) 18,434 3,302 4,237 2,826 2,306 2,542 3,349 4,091 3,025 0 0 (3,789) 11,955 0 (12,075) (27,819) INVESTING ACTIVITIES Investments – Increase Sale of Investments Short term Investments – Change 92 Capital Expenditures 93 Sale of Property Plant and Equipment 94 Acquisitions 95 Investing Activities – Other 96 Investing Activites – Net Cash Flow 0 0 12,898 532 0 0 13,115 727 0 0 0 12,174 570 0 0 0 11,477 635 0 0 10,619 456 (245) (12,611) 90 (12,298) 479 (11,125) 167 (10,675) (3,824) (13,987) 0 0 0 10,051 378 375 988 (9,060) FINANCING ACTIVITIES Sale of Common and Preferred Stock Purchase of Common and Preferred Stock 100 Cash Dividends 101 Long Term Debt – Issuance 102 Long Term Debt – Reduction 103 Current Debt – Changes 104 Financing Activities – Other 105 Financing Activities – Net Cash Flow 0 7,600 5,361 211 1,478 2,754 (498) (11,972) 0 6,683 6,139 7,072 4,968 911 (1,210) (11,017) 0 1,015 6,185 5,174 3,904 (6,288) (2,853) (15,071) 0 4,112 6,294 39 4,432 1,235 (2,558) (16,122) 0 8,298 6,216 137 2,055 (1,673) (824) (18,929) 0 8,296 6,124 7,476 13,061 4,148 (4,018) (19,875) 223 1,231 (442) (500) (514) 1,854 (1,022) (430) (452) (1,838) 487 (111) (29) 2,815 2013 2014 2015 2016 2017 AMZN 2012 88 89 90 91 97 98 99 106 Exchange Rate Effect 107 Cash and Cash Equivalents – Change 3,785 0 3,444 0 4,893 0 4,589 0 0 (3,023) 6,737 (745) (3,595) (312) (4,276) (979) (5,065) (795) (6,450) (116) (9,876) 0 960 0 0 0 0 0 0 0 0 0 0 0 0 0 588 1,011 1,933 3,378 2,259 394 (539) 6,359 4,432 (3,882) (3,763) 267 (2,911) 9,860 9,860 (86) 574 (310) 5,899 (374) 1,333 (212) 3,444 713 1,188 2013 2014 2015 2016 2017 0 0 0 4,007 108 109 Financial Ratios 110 Fiscal Year 111 Sales Growth Rate WMT 112 Gross Margin 113 S&A/Sales (excluding depreciation) 114 S&A/Sales (including depreciation) 115 EBITDA/Sales 116 Operating Margin 117 EBIT 118 EBIT Margin ratio 119 Reported tax rate 120 LT standard Tax rate 121 NOPAT –Operating ($) 122 NOPAT Margin Ratio 123 Asset Turnover 124 ROA 125 Net Assets (Invested Capital) 126 Net Asset Turnover 127 128 RONA (ROIC) 129 ROE 130 Receivable Days 131 INV Days 132 Payable Days (incl. other) 133 Payable Days 134 PPE Turnovers 135 Current Ratio 136 i- Debt 137 i-Debt-to-Equity 138 i-Debt-to-Equity (Mkt) 139 Interest Coverage 140 CapEx/Depr 141 OCF/Sales 142 NI/Sales 143 OCF/Share 144 cash/sales 145 P/E ratio 146 Piotroski F 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BZ CA CB CC CD CE CF CG CH CI CJ CK CL CM CN CO CP CQ CR CS CT CU CV CW CX CY CZ DA DB DC DD DE DF DG DH DI DJ DK DL DM DN DO DP DQ DR DS DT DU DV DW DX DY DZ EA EB EC ED EE EF EG EH EI EJ EK EL EM EN EO EP EQ ER ES ET EU EV EW EX EY EZ FA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 FB FC FD FE FF FG FH FI FJ FK FL FM FN FO FP FQ FR FS FT FU FV FW FX FY FZ GA GB GC GD GE GF GG GH GI GJ GK GL GM GN GO GP GQ GR GS GT GU GV GW GX GY GZ HA HB HC HD HE HF HG HH HI HJ HK HL HM HN HO HP HQ HR HS HT HU HV HW HX HY HZ IA IB IC 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ID IE IF IG IH II IJ 0.00 0.00 IK 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 0.00 0.00 0.00 0.00 0.00 0.00 Students: Please fill in this column. Walmart Inc. Quarterly Income Statement (as reported by the company) (Amounts in millions, except per share data) Fiscal Quarter Revenues: Net sales Membership and other income Total revenues Costs and expenses: Cost of sales Operating, selling, general and administrative expenses Operating income Interest: Debt Capital lease and financing obligations Interest income Interest, net Other (gains) and losses Income before income taxes Provision for income taxes Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Net income per common share: Basic net income per common share attributable to Walmart Diluted net income per common share attributable to Walmart Weighted-average common shares outstanding: Basic Diluted Apr-18 Q1 Expected Jan-19 4 Jul-18 2 Apr-18 1 Jan-18 4 Oct-17 3 Jul-17 2 Apr-17 1 123,897 997 124,894 127,059 969 128,028 121,630 1,060 122,690 135,150 1,117 136,267 122,136 1,043 123,179 121,949 1,406 123,355 116,526 1,016 117,542 93,116 26,792 4,986 95,571 26,707 5,750 91,707 25,829 5,154 102,640 29,160 4,467 91,547 26,868 4,764 91,521 25,865 5,969 87,688 24,617 5,237 Oct-18 3 501 92 (59) 534 1,876 2,576 759 1,817 (107) 1,710 0.58 $ 0.58 2,924 2,941 460 94 (51) 503 4,849 398 1,125 (727) (134) (861) (0.29) $ (0.29) 2,946 2,946 437 93 (43) 487 1,845 2,822 546 2,276 (142) 2,134 0.72 0.72 2,950 2,967 448 88 (37) 499 1,004 2,964 601 2,363 (188) 2,175 0.74 $ 0.73 2,959 2,978 502 81 (42) 541 1,344 2,879 975 1,904 (155) 1,749 0.59 $ 0.58 2,981 2,996 522 91 (38) 575 788 4,606 1,502 3,104 (205) 2,899 0.96 $ 0.96 3,008 3,021 506 92 (35) 563 0 4,674 1,522 3,152 (113) 3,039 1.00 1.00 3,035 3,047 Jan-17 4 Jul-16 2 Apr-16 1 Jan-16 4 Oct-15 3 Jul-15 2 129,750 1,186 130,936 117,176 1,003 118,179 119,405 1,449 120,854 114,986 918 115,904 128,684 983 129,667 116,598 810 117,408 119,330 899 120,229 97,743 26,988 6,205 87,484 25,576 5,119 89,485 25,204 6,165 86,544 24,085 5,275 96,999 26,026 6,642 87,446 24,248 5,714 90,056 24,104 6,069 508 77 (30) 555 0 5,650 1,664 3,988 (229) 3,757 $ Oct-16 3 1.23 $ 1.22 3,065 3,077 528 81 (24) 585 509 79 (22) 566 499 86 (24) 561 472 93 (17) 548 509 64 (21) 552 523 44 (24) 543 4,534 1,332 3,202 (168) 3,034 5,599 1,710 3,889 (116) 3,773 4,714 1,498 3,216 (137) 3,079 6,094 1,346 4,748 (174) 4,574 5,162 1,748 3,414 (110) 3,304 5,526 1,891 3,635 (160) 3,475 0.98 $ 0.98 3,089 3,100 1.21 $ 1.21 3,109 3,119 0.98 $ 0.98 3,144 3,154 1.23 $ 1.22 3,186 3,195 1.03 $ 1.03 3,210 3,219 1.08 1.08 3,221 3,231 Jul-16 Apr-15 Apr-17 Apr-16 1 119,405 1,449 120,854 114,002 824 114,826 116,526 1,016 117,542 114,986 918 115,904 89,485 25,204 6,165 86,483 22,663 5,680 87,688 24,617 5,237 86,544 24,085 5,275 509 79 (22) 566 0 5,599 1,710 3,889 (116) 3,773 $ 1.21 $ 1.21 3,109 3,119 523 320 (19) 824 4,856 1,573 3,283 58 3,341 1.03 $ 1.03 3,231 3,243 506 92 (35) 563 499 86 (24) 561 4,674 1,522 3,152 (113) 3,039 4,714 1,498 3,216 (137) 3,079 1.00 $ 1.00 3,035 3,047 0.98 0.98 3,144 3,154 Walmart Quarterly Sales and EPS History Fiscal Data Year and Quarter 2005Q1 2005Q2 2005Q3 2005Q4 2006Q1 2006Q2 2006Q3 2006Q4 2007Q1 2007Q2 2007Q3 2007Q4 2008Q1 2008Q2 2008Q3 2008Q4 2009Q1 2009Q2 2009Q3 2009Q4 2010Q1 2010Q2 2010Q3 2010Q4 2011Q1 2011Q2 2011Q3 2011Q4 2012Q1 2012Q2 2012Q3 2012Q4 2013Q1 Sales ($million) 70,755 76,697 75,397 89,252 79,675 85,430 84,467 99,078 86,378 92,827 91,794 107,289 94,940 102,342 98,345 108,747 94,214 100,876 99,373 113,622 99,811 103,726 101,952 116,360 104,189 109,366 110,226 123,169 113,010 114,065 113,800 127,776 114,070 Diluted Earnings Per ShareExcluding Basic Earnings Per Extraordinary Share- Excluding items Extraordinary items 0.60 0.60 0.68 0.68 0.58 0.58 0.87 0.87 0.64 0.64 0.72 0.72 0.62 0.62 0.95 0.95 0.68 0.68 0.75 0.75 0.70 0.70 1.03 1.03 0.76 0.77 0.86 0.86 0.77 0.77 0.96 0.97 0.77 0.77 0.89 0.89 0.82 0.82 1.26 1.27 0.87 0.88 0.97 0.97 0.95 0.95 1.41 1.42 0.98 0.98 1.09 1.09 0.97 0.97 1.51 1.52 1.09 1.10 1.18 1.19 1.07 1.08 1.67 1.68 1.14 1.14 2013Q2 116,830 1.24 2013Q3 115,688 1.14 2013Q4 129,706 1.34 2014Q1 114,960 1.10 2014Q2 120,125 1.21 2014Q3 119,001 1.15 2014Q4 131,565 1.53 2015Q1 114,826 1.03 2015Q2 120,229 1.08 2015Q3 117,408 1.03 2015Q4 129,667 1.43 2016Q1 115,904 0.98 2016Q2 120,319 1.21 2016Q3 118,179 0.98 2016Q4 130,936 1.22 2017Q1 117,542 1.00 2017Q2 122,968 0.96 2017Q3 123,179 0.58 2017Q4 136,267 0.73 2018Q1 122,690 0.72 2018Q2 128,028 (0.29) 2018Q3 123,897 0.58 2018Q4 Not available as of the press date 2019Q1E 1.24 1.14 1.34 1.10 1.22 1.15 1.54 1.03 1.08 1.03 1.44 0.98 1.21 0.98 1.23 1.00 0.96 0.59 0.74 0.72 (0.29) 0.58 <---Please update this on your own. date this on your own. Data Year - Fiscal 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Ticker Symbol WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT Sales 6,400.8 8,451.5 11,909.1 15,959.3 20,649.0 25,810.7 32,601.6 43,886.9 55,483.8 67,344.6 82,494.0 93,627.0 104,859.0 117,958.0 137,634.0 165,639.0 192,003.0 218,529.0 245,308.0 257,157.0 286,103.0 313,335.0 345,977.0 375,376.0 402,298.0 406,103.0 420,016.0 444,948.0 467,231.0 474,259.0 483,521.0 479,962.0 482,154.0 496,785.0 Operating Income After Depreciati on 497.0 605.0 848.2 1,078.1 1,324.3 1,670.9 1,949.6 2,416.5 2,988.2 3,567.6 4,050.0 4,112.0 4,408.0 5,212.0 6,546.0 8,935.0 10,198.0 10,794.0 12,427.0 13,501.0 15,205.0 16,211.0 17,824.0 18,467.0 19,841.0 22,099.0 23,709.0 24,622.0 26,027.0 25,270.0 25,439.0 22,063.0 19,514.0 18,653.0 Capital Expenditu Data Year res - Fiscal 324.9 532.2 586.6 658.5 592.8 954.6 1,388.3 1,805.3 3,756.4 3,643.7 3,734.0 3,566.0 1995 2,643.0 1996 2,636.0 1997 3,734.0 1998 6,183.0 1999 8,042.0 2000 8,383.0 2001 9,355.0 2002 10,308.0 2003 12,893.0 2004 14,563.0 2005 15,666.0 2006 14,937.0 2007 11,499.0 2008 ...
Purchase answer to see full attachment
Studypool values your privacy. Only questions posted as Public are visible on our website.
Tutor Answer
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.