Hi, I need this by tomorrow as a EXCEL forma include the formula send to my personal email.
[email protected]:Compagny A: Walmart. Compagny B : TargetFor Company A and Company B, document the net income for the last 3 years. Calculate the changes and percent changes in net income for each of the years presented for each company. NOTE: If either company has net income from non‐controlling interests, you should use “Net Income Attributable to the company” not “Total Net Income” when you do this and all future analyses. If you don’t understand, please come see me before completing the project. What was Company A’s comprehensive income in the most recent year? Reconcile this with its reported net income including both dollar amounts and descriptions. In the most recent year, how much cash did Company A use/receive (net) from operating activities? In the most recent year, how much cash did Company A use/receive (net) from investing activities? What was the largest investing activity and how much cash did it provide or use? In the most recent year, how much cash did Company A use/receive (net) from financing activities? What was the largest financing activity and how much cash did it provide or use?
Walmart Inc. Consolidated Balance Sheets for the fiscal year ended January 31, 2019 As of January 31, (Amounts in millions) 2019 2018 ASSETS Current assets: Cash and cash equivalents $ 7,722 $ 6,756 Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other 3,623 3,511 Total current assets 61,897 59,664 Property and equipment: Property and equipment 185,810 185,154 Less accumulated depreciation (81,493 ) (77,479 ) Property and equipment, net 104,317 107,675 Property under capital lease and financing obligations: Property under capital lease and financing obligations 12,760 12,703 Less accumulated amortization (5,682 ) (5,560 ) Property under capital lease and financing obligations, net 7,078 7,143 Goodwill 31,181 18,242 Other long-term assets 14,822 11,798 Total assets $ 219,295 $ 204,522 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings $ 5,225 $ 5,257 Accounts payable 47,060 46,092 Accrued liabilities 22,159 22,122 Accrued income taxes 428 645 Long-term debt due within one year 1,876 3,738 Capital lease and financing obligations due within one year 729 667 Total current liabilities 77,477 78,521 Long-term debt 43,520 30,045 Long-term capital lease and financing obligations 6,683 6,780 Deferred income taxes and other 11,981 8,354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value 2,965 2,648 Retained earnings 80,785 85,107 Accumulated other comprehensive loss (11,542 ) (10,181 ) Total Walmart shareholders' equity 72,496 77,869 Noncontrolling interest 7,138 2,953 Total equity 79,634 80,822 Total liabilities and equity $ 219,295 $ 204,522 Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, (Amounts in millions, except per share data) 2019 2018 2017 Revenues: Net sales $ 510,329 $ 495,761 $ 481,317 Membership and other income 4,076 4,582 4,556 Total revenues 514,405 500,343 485,873 Costs and expenses: Cost of sales 385,301 373,396 361,256 Operating, selling, general and administrative expenses 107,147 106,510 101,853 Operating income 21,957 20,437 22,764 Interest: Debt 1,975 1,978 2,044 Capital lease and financing obligations 371 352 323 Interest income (217 ) (152 ) (100 ) Interest, net 2,129 2,178 2,267 Loss on extinguishment of debt — 3,136 — Other (gains) and losses 8,368 — — Income before income taxes 11,460 15,123 20,497 Provision for income taxes 4,281 4,600 6,204 Consolidated net income 7,179 10,523 14,293 Consolidated net income attributable to noncontrolling interest (509 ) (661 ) (650 ) Consolidated net income attributable to Walmart $ 6,670 $ 9,862 $ 13,643 Net income per common share: Basic net income per common share attributable to Walmart $ 2.28 $ 3.29 $ 4.40 Diluted net income per common share attributable to Walmart 2.26 3.28 4.38 Weighted-average common shares outstanding: Basic 2,929 2,995 3,101 Diluted 2,945 3,010 3,112 Dividends declared per common share $ 2.08 $ 2.04 $ 2.00 Walmart Inc. Consolidated Statements of Comprehensive Income Fiscal Years Ended January 31, (Amounts in millions) 2019 2018 2017 Consolidated net income $ 7,179 $ 10,523 $ 14,293 Consolidated net income attributable to noncontrolling interest (509 ) (661 ) (650 ) Consolidated net income attributable to Walmart 6,670 9,862 13,643 Other comprehensive income (loss), net of income taxes Currency translation and other (226 ) 2,540 (3,027 ) Net investment hedges 272 (405 ) 413 Cash flow hedges (290 ) 437 21 Minimum pension liability 131 147 (397 ) Unrealized gain on available-for-sale securities — 1,501 145 Other comprehensive income (loss), net of income taxes (113 ) 4,220 (2,845 ) Other comprehensive (income) loss attributable to noncontrolling interest 188 (169 ) 210 Other comprehensive income (loss) attributable to Walmart 75 4,051 (2,635 ) Comprehensive income, net of income taxes 7,066 14,743 11,448 Comprehensive (income) loss attributable to noncontrolling interest (321 ) (830 ) (440 ) Comprehensive income attributable to Walmart $ 6,745 $ 13,913 $ 11,008 Walmart Inc. Consolidated Statements of Shareholders' Equity Accumulated Total Capital in Other Walmart (Amounts in millions) Common Stock Excess of Retained Comprehensive Shareholders' Noncontrolling Total Shares Amount Par Value Earnings Income (Loss) Equity Interest Equity Balances as of February 1, 2016 3,162 $ 317 $ 1,805 $ 90,021 $ (11,597 ) $ 80,546 $ 3,065 $ 83,611 Consolidated net income — — — 13,643 — 13,643 650 14,293 Other comprehensive income (loss), net of income taxes — — — — (2,635 ) (2,635 ) (210 ) (2,845 ) Cash dividends declared ($2.00 per share) — —