Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete a Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years (2020 & 2021), assuming a 10% growth rate
Complete a Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years (2020 & 2021), assuming a 10% growth rate in sales and Cost of Goods Sold (COGS) for each of the next two years. I am attaching the financial reports from the WALMART (US) 2019 annual report. Help with this is greatly appreciated!
As of January 31, 2019 2018 S 6,756 5,614 7,722 6,283 44,269 3,623 61,897 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 77,477 5,257 46,092 22,122 645 3,738 667 78,521 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 $ $ Walmart Inc. Consolidated Statements of Shareholders' Equity Common Stock Shares Amount 3,162 $ 317 Capital in Excess of Par Value $ 1,805 - - Retained Earnings $ 90,021 13,643 - Accumulated Total Other Walmart Comprehensive Shareholders' Income (Loss) Equity $ (11,597) S 80,546 13,643 (2,635) (2,635) Noncontrolling Interest $ 3,065 650 (210) Total Equity $ 83,611 14,293 (2,845) - - (120) - - (6,216) - (6,216) - (174) (6,216) (8,090) (8,276) (8,276) (519) - - (519) 740 2,371 3,048 (14,232) 89,354 9,862 736 77,798 9,862 (249) 2,737 661 487 80,535 10,523 - - 4,051 4,051 169 4,220 (6,124) (6,124) (8,204) (103) (219) - (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 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 Other Balances as of January 31, 2019 - - 496 2,648 (6,124) (7,975) - (10) 85,107 - 486 77,869 (8,204) (687) (687) 73559 2,953 80,822 2,952 295 (10,181) 2,361 (1,436) 925 (1) 924 - - 6,670 6,670 | 5097,179 (188) (113) 75 | - (80) - - - (6,102) (7,487) (245) (7,234) - (8) - (6,102) (7,487) (488) (488) - 6 2,878 - 1 288 - 562 2,965 - (17) 80,785 - 546 72,496 4,345 8 7,138 4,345 554 79,634 $ S $ $ (11,542) $ $ $ See accompanying notes. Walmart Inc. Consolidated Statements of Cash Flows Fiscal Years Ended January 31, 2018 2019 2017 $ 7,179 $ 10,523 $ 14,293 10,529 10,080 10,678 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 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 (10,344) 519 876 (10,051) 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) (375) (77) (9,079) (24,036) (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) (629) (2,537) (398) (19,072) Effect of exchange rates on cash, cash equivalents and restricted cash (438) 487 (452) 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 7,014 7.756 (130) 7,144 7,014 (1,747) 8,891 7.144 S Supplemental disclosure of cash flow information: Income taxes paid Interest paid 3,982 2,348 6,179 2,450 4,507 2,351 Document Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, 2019 2018 2017 $510,329 $495,761 $481,317 4,076 4,582 4,556 514,405 500,343485,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,975 371 (217 2,129 1,978 352 (152 2,178 3,136 2,044 323 ) (100 2,267 ) 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 $2.08 $2.04 $2.00 Dividends declared per common share See accompanying notes. Document Walmart Inc. Consolidated Statements of Comprehensive Income Fiscal Years Ended January 31, (Amounts in millions) Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart 2019 2018 2017 $7,179 $10,523 $14,293 (509 ) (661 ) (650 ) 6,670 9,862 13,643 Other comprehensive income (loss), net of income taxes Currency translation and other Net investment hedges Cash flow hedges Minimum pension liability Unrealized gain on available-for-sale securities Other comprehensive income (loss), net of income taxes Other comprehensive (income) loss attributable to noncontrolling interest Other comprehensive income (loss) attributable to Walmart (226 272 (290 131 - (113 188 75 ) 2,540 (3,027 ) (405 ) 413 ) 437 21 147 (397 ) 1,501145 ) 4,220 (2,845 ) (169 ) 210 4,051 (2,635 ) Comprehensive income, net of income taxes Comprehensive (income) loss attributable to noncontrolling interest Comprehensive income attributable to Walmart See accompanying notes. 7,066 14,743 11,448 (321 ) (830 (440 ) $6,745 $13,913 $11,008 49 As of January 31, 2019 2018 S 6,756 5,614 7,722 6,283 44,269 3,623 61,897 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 77,477 5,257 46,092 22,122 645 3,738 667 78,521 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 $ $ Walmart Inc. Consolidated Statements of Shareholders' Equity Common Stock Shares Amount 3,162 $ 317 Capital in Excess of Par Value $ 1,805 - - Retained Earnings $ 90,021 13,643 - Accumulated Total Other Walmart Comprehensive Shareholders' Income (Loss) Equity $ (11,597) S 80,546 13,643 (2,635) (2,635) Noncontrolling Interest $ 3,065 650 (210) Total Equity $ 83,611 14,293 (2,845) - - (120) - - (6,216) - (6,216) - (174) (6,216) (8,090) (8,276) (8,276) (519) - - (519) 740 2,371 3,048 (14,232) 89,354 9,862 736 77,798 9,862 (249) 2,737 661 487 80,535 10,523 - - 4,051 4,051 169 4,220 (6,124) (6,124) (8,204) (103) (219) - (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 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 Other Balances as of January 31, 2019 - - 496 2,648 (6,124) (7,975) - (10) 85,107 - 486 77,869 (8,204) (687) (687) 73559 2,953 80,822 2,952 295 (10,181) 2,361 (1,436) 925 (1) 924 - - 6,670 6,670 | 5097,179 (188) (113) 75 | - (80) - - - (6,102) (7,487) (245) (7,234) - (8) - (6,102) (7,487) (488) (488) - 6 2,878 - 1 288 - 562 2,965 - (17) 80,785 - 546 72,496 4,345 8 7,138 4,345 554 79,634 $ S $ $ (11,542) $ $ $ See accompanying notes. Walmart Inc. Consolidated Statements of Cash Flows Fiscal Years Ended January 31, 2018 2019 2017 $ 7,179 $ 10,523 $ 14,293 10,529 10,080 10,678 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 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 (10,344) 519 876 (10,051) 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) (375) (77) (9,079) (24,036) (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) (629) (2,537) (398) (19,072) Effect of exchange rates on cash, cash equivalents and restricted cash (438) 487 (452) 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 7,014 7.756 (130) 7,144 7,014 (1,747) 8,891 7.144 S Supplemental disclosure of cash flow information: Income taxes paid Interest paid 3,982 2,348 6,179 2,450 4,507 2,351 Document Walmart Inc. Consolidated Statements of Income Fiscal Years Ended January 31, 2019 2018 2017 $510,329 $495,761 $481,317 4,076 4,582 4,556 514,405 500,343485,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,975 371 (217 2,129 1,978 352 (152 2,178 3,136 2,044 323 ) (100 2,267 ) 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 $2.08 $2.04 $2.00 Dividends declared per common share See accompanying notes. Document Walmart Inc. Consolidated Statements of Comprehensive Income Fiscal Years Ended January 31, (Amounts in millions) Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart 2019 2018 2017 $7,179 $10,523 $14,293 (509 ) (661 ) (650 ) 6,670 9,862 13,643 Other comprehensive income (loss), net of income taxes Currency translation and other Net investment hedges Cash flow hedges Minimum pension liability Unrealized gain on available-for-sale securities Other comprehensive income (loss), net of income taxes Other comprehensive (income) loss attributable to noncontrolling interest Other comprehensive income (loss) attributable to Walmart (226 272 (290 131 - (113 188 75 ) 2,540 (3,027 ) (405 ) 413 ) 437 21 147 (397 ) 1,501145 ) 4,220 (2,845 ) (169 ) 210 4,051 (2,635 ) Comprehensive income, net of income taxes Comprehensive (income) loss attributable to noncontrolling interest Comprehensive income attributable to Walmart See accompanying notes. 7,066 14,743 11,448 (321 ) (830 (440 ) $6,745 $13,913 $11,008 49Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started