2019 7.722 6,283 44,269 3,623 61,897 104,317 7,078 31,181 14,822 219,295 Walmart Inc Consolidated Balance Sheets As of January 31, (Amounts in millions) 2020 ASSETS Current assets: Cash and cash equivalents 9,465 Receivables, net 6,284 Inventories 44,435 Prepaid expenses and other 1,622 Total current assets 61,806 Property and equipment, net 105,208 Operating lease right-of-use assets 17,424 Finance lease right-of-use assets, net 4,417 Property under capital lease and financing obligations, net Goodwill 31,073 Other long-term assets 16,567 Total assets 236,495 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings 575 Accounts payable 46,973 Accrued liabilities 22,296 Accrued Income taxes 280 Long-term debt due within one year 5,362 Operating lease obligations due 1,793 Within one year Finance lease obligations 511 Within one year Capital lease and financing obligations due Within one year Total current liabilities 77,790 Long-term debt 43,714 Long-term operating lease obligations 16,171 Long-term finance lease obligations 4,307 Long-term capital lease and Financing obligations Deferred income taxes and other 12,961 Commitments and contingencies Total abilities 154,943 Common stock 284 Capital in excess of par value 3,247 Retained earnings 83,943 Accumulated other comprehensive loss (12,805) Total Walmart shareholders' equity 74,669 Noncontrolling Interest 5,883 Total equity 81,552 Total liabilities and equity 236,495 Required: Perform a bort 5,225 47,060 22,159 428 1,876 - 1 729 77,477 43,520 6,683 11,981 139,661 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 575 428 Cash and cash equivalents RE Recolvablen met 62283 inventorles 4435 40200 3,62 Prepaid expenses and other Total current assets 51,800 61,897 105,208 Property and equipment net 104,317 Operating lease right-of-use assets 17424 Finance lease right-of-use assets, net 4,417 Property under capital lease and 7.078 financing obligations, net Goodwill 31,073 31,181 Other long-term assets 16,567 14,822 Total assets 236,495 219,295 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings 5,225 Accounts payable 46,973 47,060 Accrued liabilities 22,296 22,159 Accrued Income taxes 280 Long-term debt due within one year 5,362 1,876 Operating lease obligations due 1,793 Within one year Finance lease obligations 511 Within one year Capital lease and financing obligations due 729 Within one year Total current liabilities 77,790 77,477 Long-term debt 43,714 43,520 Long-term operating lease obligations 16,171 Long-term finance lease obligations 4,307 Long-term capital lease and 6,683 Financing obligations Deferred Income taxes and other 12,961 11,981 Commitments and contingencies Total Liabilities 154,943 139,661 Common stock 284 288 Capital in excess of par value 3,247 2,965 Retained earnings 83,943 80,78S Accumulated other comprehensive loss (12,805) (11,542) Total Walmart shareholders' equity 74,669 72.496 Noncontrolling interest 6,883 7,138 Total equity 81,552 79,634 Total liabilities and equity 236,495 219,295 Required: Perform a horizontal ana'ysis on the Balance Sheet showing the percentage of change between years for the following: Cash: Total Current Assets; Total Assets; Total Current Liabilities; Total Liabilities, and Total Equity. Walmart Inc. Consolidated Statements of Income (Amounts in millions, 2020 2019 Revenues: Net sales 519,926 510,329 Membership and othe 4,038 4,076 Total revenues 523,964 514,405 Costs and expenses: Cost of sales 394,605 385,301 Operating, selling, gen 108,791 107,147 Operating income 20,568 21,957 Interest: Debt 2,262 1,975 Finance, capital lease: 337 371 Interest income (189) (217) Interest, net 2,410 2,129 Loss on extinguishmer Other (gains) and losse (1,958) 8,368 Income before income 20,116 11,460 Provision for income t 4,915 4,281 Consolidated net inco 15,201 7,179 Consolidated net incor (320) (509) To noncontrolling interest Consolidated net inco 14,881 6,670 Required: b. Perform a vertical analysis on the Income Statement for Operating Income; Income before Income Taxes; and Consolidated Net Income. Target Wal-Mart Jan 31, 2020 5741125 523.964 SUS 34605 16,231 108,793 2.357 4650 20,558 2410 (1.55 20.116 4915 1.259 15.20 $32815 15.202 56.42 $ Feb. 01, 2020 Jan 31, 2020 5 2.577 L.992 Consolidated Statements of Operations - USDS in Million Total revenue Cost of sales Selling general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cont of sales) Operating Income Net interest expense Net other (income) /expense Earnings from continuing operations before Income taxe Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Neteaming Basic net income per share Consolidated Statements of Financial Position - USD ($) $ in Millions Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment, net Operating lease assets Other noncurrent assets Total assets Liabilities and shareholders investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowing Total current liabilities Long-term debt and other borrowing Noncurrent operating lease liabilities Deferred Income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders' Investment Common stock Additional paid in capital Retained earning Accumulated other comprehensive loss Total shareholders' Investment Totalties and shareholder investment Complete the following rates for both companies 1) Net Working Capital Current Assets - Currenties 2) Current Ratio - Current Assets/Current Liebe 2) Aod test Ratio Current Assets - Inventory-predense/Current 12.902 2620 2.236 9.465 44,435 7.905 68206 105.30 17,494 52057 42,779 46.97 S.920 4.405 160 14,487 7.566 77,730 2.275 1.724 16.459 BLO 0779 & beceivable turnove ka e tollection period y tur Aire 1) D 105 200 17424 52.657 236.495 46.972 23,151 7,665 77,790 43,714 16,171 17.961 4,307 77.153 284 3,247 83,94 (12,805) 74,669 229,512 Property and equipment, net 26,283 Operating lease assets 7236 Other noncurrent assets 1,358 Total assets 42,779 Labilities and shareholders' Investment Accounts payable 9,920 Accrued and other current liabilities Current portion of long-term debt and other borrowings 161 Total current liabilities 14,487 Long-term debt and other borrowings 11,333 Noncurrent operating lease liabilities 2,275 Deferred income taxes 1,122 Other noncurrent liabilities 1,724 Total noncurrent liabilities 16,459 Shareholders' Investment Common stock 42 Additional paid-in capital 5,226 Retained earnings 6,433 Accumulated other comprehensive loss (868) Total shareholders' Investment 11,833 Total liabilities and shareholders' Investment 42,779 Complete the following ratios for both companies: 1) Net Working Capital - Current Assets - Current liabilities 2) Current Ratio - Current Assets / Current Liabilities 3) Acid test Ratio - (Current Assets - Inventory - prepaid expenses) / Current Liabilities Net sales 5) Receivables turnover Accounts receivable 365 5) Average collection period Receivables turnover Cost of goods sold 6) Inventory turnover Inventories 365 7) Average days in inventory (sale period) Inventory 8) Operating cycle - Average sale period / Average collection period 9) Total asset turnover Net Sales / Average total assets 10) Profit Margin on Sales - Net Income / Net Sales Rate of Return on Assets - Net Income / Average Total Assets 12) Debt to equity ratio - Total liabilities / Stockholder's equity 13) Rate of return on shareholders' equity Net Income / Shareholders' equity 14) Net Profit Margin percentage - Net Income / Sales 15) Equity Multiplier Shareholders' equity - Total Assets / Shareholders' equity Which company would be a better Investment?; explain your choice of companies. Property and Operating lease right-of-use assets 17,424 Finance lease right-of-use assets, net 4,417 Property under capital lease and 7,078 financing obligations, net Goodwill 31,073 31,181 Other long-term assets 16,567 14,822 Total assets 236,495 219,295 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings 575 5,225 Accounts payable 46,973 47,060 Accrued liabilities 22,296 22,159 Accrued income taxes 280 428 Long-term debt due within one year 5,362 1,876 Operating lease obligations due 1,793 Within one year Finance lease obligations 511 Within one year Capital lease and financing obligations due 729 Within one year Total current liabilities 77,790 77,477 Long-term debt 43,714 43,520 Long-term operating lease obligations 16,171 Long-term finance lease obligations 4,307 Long-term capital lease and 6,683 Financing obligations Deferred income taxes and other 12,961 11,981 Commitments and contingencies Total Liabilities 154,943 139,661 Common stock 284 288 Capital in excess of par value 3,247 2,965 Retained earnings 83,943 80,785 Accumulated other comprehensive loss (12,805) (11,542) Total Walmart shareholders' equity 74,669 72,496 Noncontrolling interest 6,883 7,138 Total equity 81,552 79,634 Total liabilities and equity 236,495 219,295 Required: Performa horizontalanalusis on the Balance Shoot showing the nercontent Page 013 46.973 23,151 7,656 77.710 41,734 16.171 12,961 4,307 72.151 Page Liabetes and shareholders vestment Accounts payable 9.920 Accrued and other current liabilities 4,406 Current portion of long-term debt and other borrowing 161 Total current liabilities 14487 Long-term debt and other borrowings 11.336 Noncurrent operating lease bites 2.225 Deferred income taxes 1,122 Other noncurrent abilities 1,724 Total noncurrent liabilities 16,4959 Shareholders' Investment Common stock Additional paid in captal 6,226 Retained earnings Accumulated other comprehensive loss (86) Total shareholders investment 11 13 Total liabilities and shareholders' Investment 42.779 Complete the following ratios for both companies 1) Net Working Capital Current Assets - Current abilities 2) Current Ratio - Current Assets / Current Labrities 3) Acd test Ratio (Current Assets - Inventory-prepaid expenses/Current Liabilities Net sales 41 Receivables tornaver Mocount receivable 365 5) Aves collection period Movables 284 3,247 83,93 112 005) 74.469 229,612 CI Twentor turnover cost of goods sold Inventories 365 tatory tu 7) Average days in inventory (sale period 82 Operating cyce Average sale period / Average collection period 91 Total asset turnoverNet Sales/Average total assets 201 Proft Margin on Sales Net Income / Net Sales 11) Rate of Return on Assets Net Income / Average Total Assets 12) Debt to equity ratio Total abilities/Stockholder's guity 13) Rate of return on shareholders' equity - Net Income / Shareholders' equity 34) Net Profit Margin percentage Net Income Sales 15) Iquity Multiplier Shareholders' equity - Total Ass/Shareholders equity Which company would be a better investment, explain your choice of companies Ma-Root Brn 2019 7.722 6,283 44,269 3,623 61,897 104,317 7,078 31,181 14,822 219,295 Walmart Inc Consolidated Balance Sheets As of January 31, (Amounts in millions) 2020 ASSETS Current assets: Cash and cash equivalents 9,465 Receivables, net 6,284 Inventories 44,435 Prepaid expenses and other 1,622 Total current assets 61,806 Property and equipment, net 105,208 Operating lease right-of-use assets 17,424 Finance lease right-of-use assets, net 4,417 Property under capital lease and financing obligations, net Goodwill 31,073 Other long-term assets 16,567 Total assets 236,495 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings 575 Accounts payable 46,973 Accrued liabilities 22,296 Accrued Income taxes 280 Long-term debt due within one year 5,362 Operating lease obligations due 1,793 Within one year Finance lease obligations 511 Within one year Capital lease and financing obligations due Within one year Total current liabilities 77,790 Long-term debt 43,714 Long-term operating lease obligations 16,171 Long-term finance lease obligations 4,307 Long-term capital lease and Financing obligations Deferred income taxes and other 12,961 Commitments and contingencies Total abilities 154,943 Common stock 284 Capital in excess of par value 3,247 Retained earnings 83,943 Accumulated other comprehensive loss (12,805) Total Walmart shareholders' equity 74,669 Noncontrolling Interest 5,883 Total equity 81,552 Total liabilities and equity 236,495 Required: Perform a bort 5,225 47,060 22,159 428 1,876 - 1 729 77,477 43,520 6,683 11,981 139,661 288 2,965 80,785 (11,542) 72,496 7,138 79,634 219,295 575 428 Cash and cash equivalents RE Recolvablen met 62283 inventorles 4435 40200 3,62 Prepaid expenses and other Total current assets 51,800 61,897 105,208 Property and equipment net 104,317 Operating lease right-of-use assets 17424 Finance lease right-of-use assets, net 4,417 Property under capital lease and 7.078 financing obligations, net Goodwill 31,073 31,181 Other long-term assets 16,567 14,822 Total assets 236,495 219,295 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings 5,225 Accounts payable 46,973 47,060 Accrued liabilities 22,296 22,159 Accrued Income taxes 280 Long-term debt due within one year 5,362 1,876 Operating lease obligations due 1,793 Within one year Finance lease obligations 511 Within one year Capital lease and financing obligations due 729 Within one year Total current liabilities 77,790 77,477 Long-term debt 43,714 43,520 Long-term operating lease obligations 16,171 Long-term finance lease obligations 4,307 Long-term capital lease and 6,683 Financing obligations Deferred Income taxes and other 12,961 11,981 Commitments and contingencies Total Liabilities 154,943 139,661 Common stock 284 288 Capital in excess of par value 3,247 2,965 Retained earnings 83,943 80,78S Accumulated other comprehensive loss (12,805) (11,542) Total Walmart shareholders' equity 74,669 72.496 Noncontrolling interest 6,883 7,138 Total equity 81,552 79,634 Total liabilities and equity 236,495 219,295 Required: Perform a horizontal ana'ysis on the Balance Sheet showing the percentage of change between years for the following: Cash: Total Current Assets; Total Assets; Total Current Liabilities; Total Liabilities, and Total Equity. Walmart Inc. Consolidated Statements of Income (Amounts in millions, 2020 2019 Revenues: Net sales 519,926 510,329 Membership and othe 4,038 4,076 Total revenues 523,964 514,405 Costs and expenses: Cost of sales 394,605 385,301 Operating, selling, gen 108,791 107,147 Operating income 20,568 21,957 Interest: Debt 2,262 1,975 Finance, capital lease: 337 371 Interest income (189) (217) Interest, net 2,410 2,129 Loss on extinguishmer Other (gains) and losse (1,958) 8,368 Income before income 20,116 11,460 Provision for income t 4,915 4,281 Consolidated net inco 15,201 7,179 Consolidated net incor (320) (509) To noncontrolling interest Consolidated net inco 14,881 6,670 Required: b. Perform a vertical analysis on the Income Statement for Operating Income; Income before Income Taxes; and Consolidated Net Income. Target Wal-Mart Jan 31, 2020 5741125 523.964 SUS 34605 16,231 108,793 2.357 4650 20,558 2410 (1.55 20.116 4915 1.259 15.20 $32815 15.202 56.42 $ Feb. 01, 2020 Jan 31, 2020 5 2.577 L.992 Consolidated Statements of Operations - USDS in Million Total revenue Cost of sales Selling general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cont of sales) Operating Income Net interest expense Net other (income) /expense Earnings from continuing operations before Income taxe Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax Neteaming Basic net income per share Consolidated Statements of Financial Position - USD ($) $ in Millions Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment, net Operating lease assets Other noncurrent assets Total assets Liabilities and shareholders investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowing Total current liabilities Long-term debt and other borrowing Noncurrent operating lease liabilities Deferred Income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders' Investment Common stock Additional paid in capital Retained earning Accumulated other comprehensive loss Total shareholders' Investment Totalties and shareholder investment Complete the following rates for both companies 1) Net Working Capital Current Assets - Currenties 2) Current Ratio - Current Assets/Current Liebe 2) Aod test Ratio Current Assets - Inventory-predense/Current 12.902 2620 2.236 9.465 44,435 7.905 68206 105.30 17,494 52057 42,779 46.97 S.920 4.405 160 14,487 7.566 77,730 2.275 1.724 16.459 BLO 0779 & beceivable turnove ka e tollection period y tur Aire 1) D 105 200 17424 52.657 236.495 46.972 23,151 7,665 77,790 43,714 16,171 17.961 4,307 77.153 284 3,247 83,94 (12,805) 74,669 229,512 Property and equipment, net 26,283 Operating lease assets 7236 Other noncurrent assets 1,358 Total assets 42,779 Labilities and shareholders' Investment Accounts payable 9,920 Accrued and other current liabilities Current portion of long-term debt and other borrowings 161 Total current liabilities 14,487 Long-term debt and other borrowings 11,333 Noncurrent operating lease liabilities 2,275 Deferred income taxes 1,122 Other noncurrent liabilities 1,724 Total noncurrent liabilities 16,459 Shareholders' Investment Common stock 42 Additional paid-in capital 5,226 Retained earnings 6,433 Accumulated other comprehensive loss (868) Total shareholders' Investment 11,833 Total liabilities and shareholders' Investment 42,779 Complete the following ratios for both companies: 1) Net Working Capital - Current Assets - Current liabilities 2) Current Ratio - Current Assets / Current Liabilities 3) Acid test Ratio - (Current Assets - Inventory - prepaid expenses) / Current Liabilities Net sales 5) Receivables turnover Accounts receivable 365 5) Average collection period Receivables turnover Cost of goods sold 6) Inventory turnover Inventories 365 7) Average days in inventory (sale period) Inventory 8) Operating cycle - Average sale period / Average collection period 9) Total asset turnover Net Sales / Average total assets 10) Profit Margin on Sales - Net Income / Net Sales Rate of Return on Assets - Net Income / Average Total Assets 12) Debt to equity ratio - Total liabilities / Stockholder's equity 13) Rate of return on shareholders' equity Net Income / Shareholders' equity 14) Net Profit Margin percentage - Net Income / Sales 15) Equity Multiplier Shareholders' equity - Total Assets / Shareholders' equity Which company would be a better Investment?; explain your choice of companies. Property and Operating lease right-of-use assets 17,424 Finance lease right-of-use assets, net 4,417 Property under capital lease and 7,078 financing obligations, net Goodwill 31,073 31,181 Other long-term assets 16,567 14,822 Total assets 236,495 219,295 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings 575 5,225 Accounts payable 46,973 47,060 Accrued liabilities 22,296 22,159 Accrued income taxes 280 428 Long-term debt due within one year 5,362 1,876 Operating lease obligations due 1,793 Within one year Finance lease obligations 511 Within one year Capital lease and financing obligations due 729 Within one year Total current liabilities 77,790 77,477 Long-term debt 43,714 43,520 Long-term operating lease obligations 16,171 Long-term finance lease obligations 4,307 Long-term capital lease and 6,683 Financing obligations Deferred income taxes and other 12,961 11,981 Commitments and contingencies Total Liabilities 154,943 139,661 Common stock 284 288 Capital in excess of par value 3,247 2,965 Retained earnings 83,943 80,785 Accumulated other comprehensive loss (12,805) (11,542) Total Walmart shareholders' equity 74,669 72,496 Noncontrolling interest 6,883 7,138 Total equity 81,552 79,634 Total liabilities and equity 236,495 219,295 Required: Performa horizontalanalusis on the Balance Shoot showing the nercontent Page 013 46.973 23,151 7,656 77.710 41,734 16.171 12,961 4,307 72.151 Page Liabetes and shareholders vestment Accounts payable 9.920 Accrued and other current liabilities 4,406 Current portion of long-term debt and other borrowing 161 Total current liabilities 14487 Long-term debt and other borrowings 11.336 Noncurrent operating lease bites 2.225 Deferred income taxes 1,122 Other noncurrent abilities 1,724 Total noncurrent liabilities 16,4959 Shareholders' Investment Common stock Additional paid in captal 6,226 Retained earnings Accumulated other comprehensive loss (86) Total shareholders investment 11 13 Total liabilities and shareholders' Investment 42.779 Complete the following ratios for both companies 1) Net Working Capital Current Assets - Current abilities 2) Current Ratio - Current Assets / Current Labrities 3) Acd test Ratio (Current Assets - Inventory-prepaid expenses/Current Liabilities Net sales 41 Receivables tornaver Mocount receivable 365 5) Aves collection period Movables 284 3,247 83,93 112 005) 74.469 229,612 CI Twentor turnover cost of goods sold Inventories 365 tatory tu 7) Average days in inventory (sale period 82 Operating cyce Average sale period / Average collection period 91 Total asset turnoverNet Sales/Average total assets 201 Proft Margin on Sales Net Income / Net Sales 11) Rate of Return on Assets Net Income / Average Total Assets 12) Debt to equity ratio Total abilities/Stockholder's guity 13) Rate of return on shareholders' equity - Net Income / Shareholders' equity 34) Net Profit Margin percentage Net Income Sales 15) Iquity Multiplier Shareholders' equity - Total Ass/Shareholders equity Which company would be a better investment, explain your choice of companies Ma-Root Brn