Using the EDGAR database at SECs website, download the Balance Sheet and Income Statement of Walmart, Inc. and Target, Corp., for 2010-2020.
Part 1: Calculate Profit Margin, Total Asset Turnover, Equity Multiplier, and Return on Equity for each year and each company. Display your results in a summary table.
Part 2: Calculate the average, maximum and minimum values of each financial ratio for each company. Display your results in a summary table.
Part 3: Using DuPont Analysis, compare and explain the difference between the Return on Equity figures of these companies in 2020. In other words, evaluate the ROE figure and explain the difference through the areas of profitability, asset management, and use of leverage.
Part 4: Prepare a graph displaying the value of Return on Equity over the years, for each company. Include a discussion on the trend.
Below are the balance sheet and income statement for the year 2020 for Walmart inc. Can someone show me how to complete the questions? Thank you
Jan. 31, 2020 Jan. 31, 2019 $ 9,465 6,284 44,435 1,622 61,806 105,208 17,424 4,417 $ 7,722 6,283 44,269 3,623 61,897 104,317 0 0 7,078 31,181 14,822 219,295 0 31,073 16,567 236,495 575 5,225 47,060 22,159 428 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term operating lease obligations Long-term finance lease obligations Long-term capital lease and financing obligations Deferred income taxes and other 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 46,973 22,296 280 5,362 1,793 511 1,876 0 0 0 77,790 43,714 16,171 4,307 729 77,477 43,520 0 0 0 6,683 11,981 12,961 284 3,247 83,943 (12,805) 74,669 6,883 81,552 $ 236,495 288 2,965 80,785 (11,542) 72,496 7,138 79,634 $ 219,295 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2020 Jan. 31, 2018 $ 519,926 4,038 523,964 $ 510,329 4,076 514,405 $ 495,761 4,582 500,343 394,605 108,791 20,568 385,301 107,147 21,957 373,396 106,510 20,437 2,262 337 (189) 2,410 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 Finance, 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 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 (in shares) Diluted (in shares) Dividends declared per common share 1,978 352 (152) 2,178 3,136 0 1,975 371 (217) 2,129 0 8,368 11,460 4,281 7,179 (509) $6,670 (1,958) 20,116 4,915 15,201 (320) $ 14,881 0 15,123 4,600 10,523 (661) $9,862 $ 5.22 $ 5.19 $ 2.28 $ 2.26 $ 3.29 $ 3.28 2,850 2,868 $ 2.12 2,929 2,945 $ 2.08 2,995 3,010 $ 2.04 Jan. 31, 2020 Jan. 31, 2019 $ 9,465 6,284 44,435 1,622 61,806 105,208 17,424 4,417 $ 7,722 6,283 44,269 3,623 61,897 104,317 0 0 7,078 31,181 14,822 219,295 0 31,073 16,567 236,495 575 5,225 47,060 22,159 428 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term operating lease obligations Long-term finance lease obligations Long-term capital lease and financing obligations Deferred income taxes and other 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 46,973 22,296 280 5,362 1,793 511 1,876 0 0 0 77,790 43,714 16,171 4,307 729 77,477 43,520 0 0 0 6,683 11,981 12,961 284 3,247 83,943 (12,805) 74,669 6,883 81,552 $ 236,495 288 2,965 80,785 (11,542) 72,496 7,138 79,634 $ 219,295 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2020 Jan. 31, 2018 $ 519,926 4,038 523,964 $ 510,329 4,076 514,405 $ 495,761 4,582 500,343 394,605 108,791 20,568 385,301 107,147 21,957 373,396 106,510 20,437 2,262 337 (189) 2,410 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 Finance, 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 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 (in shares) Diluted (in shares) Dividends declared per common share 1,978 352 (152) 2,178 3,136 0 1,975 371 (217) 2,129 0 8,368 11,460 4,281 7,179 (509) $6,670 (1,958) 20,116 4,915 15,201 (320) $ 14,881 0 15,123 4,600 10,523 (661) $9,862 $ 5.22 $ 5.19 $ 2.28 $ 2.26 $ 3.29 $ 3.28 2,850 2,868 $ 2.12 2,929 2,945 $ 2.08 2,995 3,010 $ 2.04
