Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the P/E Ratio, Dividend Payout and Earnings per common share for 2019. Show calculations. As of January 31, 2019 2018 S 7,722 6,283 44,269

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedCalculate the P/E Ratio, Dividend Payout and Earnings per common share for 2019. Show calculations.

As of January 31, 2019 2018 S 7,722 6,283 44,269 3,623 61,897 6,756 5,614 43,783 3,511 59,664 (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net 185,810 (81,493) 104,317 185,154 (77,479) 107,675 12,760 (5,682) 7,078 12,703 (5,560) 7,143 Goodwill Other long-term assets Total assets 31,181 14,822 219,295 18,242 11,798 204,522 $ $ $ LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities 5,225 47,060 22,159 428 1,876 729 5,257 46,092 22,122 645 3,738 667 78,521 77.477 Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other 43,520 6,683 11,981 30,045 6,780 8,354 Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 204,522 $ $ Fiscal Years Ended January 31, 2018 2019 2017 7,1795 10,523 $ 14,293 10,678 10,529 10,080 3,516 4,850 (499) 761 (Amounts in millions) Cash flows from operating activities: Consolidated net income Adjustments to reconcile consolidated net income to net cash provided by operating activities: Depreciation and amortization Unrealized (gains) and losses (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities (304) 3,136 1.210 1,734 206 (368) (1,311) 1,831 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 183 (40) 27,753 (10,051) (10,344) 519 876 378 1,046 Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Purchase of available for sale securities Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities (10,619) 456 662 (1,901) (2,463) (31) (13,896) (14,656) (431) (24,036) (375) (77) (9,079) (53) 15,872 (3,784) (1,673) 137 (2,055) Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Premiums paid to extinguish debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities (6,102) (7,410) (431) 4,148 7,476 (13,061) (3,059) (6,124) (8,296) (690) (8) (261) (19,875) (6,216) (8,298) (479) (90) (398) (19,072) (629) (2,537) Effect of exchange rates on cash, cash equivalents and restricted cash (438) 487 742 Net increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of period (452) (1,747) 8,891 7,144 7 (130) ,144 7,014 7. 014 7,756 S $ Supplemental disclosure of cash flow information: Income taxes paid Interest paid 3,982 2,348 6,179 2,450 4,507 2,351 Common Stock Shares Amount Capital in Excess of Par Value 1,805 Retained Earnings 90,021 13,643 Accumulated Other Comprehensive Income (Loss) $ (11,597) Total Walmart Shareholders' Equity $ 80,546 13,643 Noncontrolling Interest $ Total Equity 83,611 14,293 $ 650 (2,635) (210) (2,845) - (120) - (12) (6,216) (8,090) (2,635) (6,216) (8,276) (174) (6,216) (8,276) (519) - - (Amounts in millions) Balances as of February 1, 2016 Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.00 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Other Balances as of January 31, 2017 Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.04 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Other Balances as of January 31, 2018 Adoption of new accounting standards on February 1, 2018, net of income taxes 6 3,048 740 2,371 - 305 (519) (249) 2,737 (14,232) 736 77,798 9,862 89,354 9,862 487 80,535 10,523 661 169 4,051 4,051 4,220 (6,124) (7,975) (6,124) (8,204) (103) (10) (6,124) (8,204) (219) (687) (687) 2052 559 496 2,648 (10) 85,107 486 77,869 73 2,953 2,952 295 (10,181) 80,822 2,361 (1,436) 925 (1) 924 6,670 6,670 509 75 (188) Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.08 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Noncontrolling interest of acquired entity (6,102) (7,234) (6,102) (7,487) 7,179 (113) (6,102) (7,487) (488) (80) (245) - (488) - - - 4,345 4,345 6 1 554 Other Balances as of January 31, 2019 562 2,965 (17) 80,785 546 72,496 2,878 288 $ $ $ (11,542) $ $ 7,138 $ 79,634 Fiscal Years Ended January 31, 2018 2019 2017 $ $ 510,329 4,076 514,405 495,761 4,582 500,343 481,317 4,556 485,873 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 (Amounts in millions, except per share data) 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 Loss on extinguishment of debt 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 1,978 352 1,975 371 (217) 2,129 2,044 323 (100) 2,267 (152) 2,178 3,136 8,368 11,460 4,281 7,179 (509) 6,670 15.123 4,600 10,523 (661) 9,862 20,497 6,204 14,293 (650) 13,643 $ $ $ Net income per common share: Basic net income per common share attributable to Walmart Diluted net income per common share attributable to Walmart $ $ 2.28 2.26 3.29 3.28 4.40 4.38 Weighted average common shares outstanding: Basic Diluted 2,929 2,945 2,995 3,010 3,101 3,112 Dividends declared per common share 2.08 $ 2.04 $ 2.00 As of January 31, 2019 2018 S 7,722 6,283 44,269 3,623 61,897 6,756 5,614 43,783 3,511 59,664 (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net 185,810 (81,493) 104,317 185,154 (77,479) 107,675 12,760 (5,682) 7,078 12,703 (5,560) 7,143 Goodwill Other long-term assets Total assets 31,181 14,822 219,295 18,242 11,798 204,522 $ $ $ LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities 5,225 47,060 22,159 428 1,876 729 5,257 46,092 22,122 645 3,738 667 78,521 77.477 Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other 43,520 6,683 11,981 30,045 6,780 8,354 Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 204,522 $ $ Fiscal Years Ended January 31, 2018 2019 2017 7,1795 10,523 $ 14,293 10,678 10,529 10,080 3,516 4,850 (499) 761 (Amounts in millions) Cash flows from operating activities: Consolidated net income Adjustments to reconcile consolidated net income to net cash provided by operating activities: Depreciation and amortization Unrealized (gains) and losses (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities (304) 3,136 1.210 1,734 206 (368) (1,311) 1,831 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 183 (40) 27,753 (10,051) (10,344) 519 876 378 1,046 Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Purchase of available for sale securities Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities (10,619) 456 662 (1,901) (2,463) (31) (13,896) (14,656) (431) (24,036) (375) (77) (9,079) (53) 15,872 (3,784) (1,673) 137 (2,055) Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Premiums paid to extinguish debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities (6,102) (7,410) (431) 4,148 7,476 (13,061) (3,059) (6,124) (8,296) (690) (8) (261) (19,875) (6,216) (8,298) (479) (90) (398) (19,072) (629) (2,537) Effect of exchange rates on cash, cash equivalents and restricted cash (438) 487 742 Net increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of period (452) (1,747) 8,891 7,144 7 (130) ,144 7,014 7. 014 7,756 S $ Supplemental disclosure of cash flow information: Income taxes paid Interest paid 3,982 2,348 6,179 2,450 4,507 2,351 Common Stock Shares Amount Capital in Excess of Par Value 1,805 Retained Earnings 90,021 13,643 Accumulated Other Comprehensive Income (Loss) $ (11,597) Total Walmart Shareholders' Equity $ 80,546 13,643 Noncontrolling Interest $ Total Equity 83,611 14,293 $ 650 (2,635) (210) (2,845) - (120) - (12) (6,216) (8,090) (2,635) (6,216) (8,276) (174) (6,216) (8,276) (519) - - (Amounts in millions) Balances as of February 1, 2016 Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.00 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Other Balances as of January 31, 2017 Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.04 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Other Balances as of January 31, 2018 Adoption of new accounting standards on February 1, 2018, net of income taxes 6 3,048 740 2,371 - 305 (519) (249) 2,737 (14,232) 736 77,798 9,862 89,354 9,862 487 80,535 10,523 661 169 4,051 4,051 4,220 (6,124) (7,975) (6,124) (8,204) (103) (10) (6,124) (8,204) (219) (687) (687) 2052 559 496 2,648 (10) 85,107 486 77,869 73 2,953 2,952 295 (10,181) 80,822 2,361 (1,436) 925 (1) 924 6,670 6,670 509 75 (188) Consolidated net income Other comprehensive income (loss), net of income taxes Cash dividends declared ($2.08 per share) Purchase of Company stock Cash dividend declared to noncontrolling interest Noncontrolling interest of acquired entity (6,102) (7,234) (6,102) (7,487) 7,179 (113) (6,102) (7,487) (488) (80) (245) - (488) - - - 4,345 4,345 6 1 554 Other Balances as of January 31, 2019 562 2,965 (17) 80,785 546 72,496 2,878 288 $ $ $ (11,542) $ $ 7,138 $ 79,634 Fiscal Years Ended January 31, 2018 2019 2017 $ $ 510,329 4,076 514,405 495,761 4,582 500,343 481,317 4,556 485,873 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 (Amounts in millions, except per share data) 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 Loss on extinguishment of debt 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 1,978 352 1,975 371 (217) 2,129 2,044 323 (100) 2,267 (152) 2,178 3,136 8,368 11,460 4,281 7,179 (509) 6,670 15.123 4,600 10,523 (661) 9,862 20,497 6,204 14,293 (650) 13,643 $ $ $ Net income per common share: Basic net income per common share attributable to Walmart Diluted net income per common share attributable to Walmart $ $ 2.28 2.26 3.29 3.28 4.40 4.38 Weighted average common shares outstanding: Basic Diluted 2,929 2,945 2,995 3,010 3,101 3,112 Dividends declared per common share 2.08 $ 2.04 $ 2.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

Introductory Econometrics For Finance

Authors: Chris Brooks

2nd Edition

052169468X, 9780521694681

More Books

Students also viewed these Finance questions

Question

Did you print a proof to view color and image consistency?

Answered: 1 week ago