Compute the listed profitability, liquidity and solvency measures for both Target and Walmart from 2016 to 2019. Analyze your financial metrics. Compile a report not to exceed two pages analyzing Target's profitability, liquidity and solvency. Include a discussion of the four year data trends and how Target has fared against Walmart during the period.

Target Ratios Wal-Mart Ratios BESEDE Etic ww www 1 ERLE 21 . www.com RTLET co Same Stii ca Caso wy Sands S. Target Ratios . Wal-Mart Ratios 11 20 113 STELLIGENCE 29 53 sii isit SEL HEBBEN . - Target Ratios Wal-Mart Ratios 2019 2018 2017 2016 296.751 452 5003 481 317 4.556 455.873 201254 Wal-Mart Stores Income Statements in millions of dollars) Revenues Net sales Other Income.net Total revenues Costs of sales Gross profit Operating expenses Operating income Net interest cout Other gains) lossen Income before income taxes Total income tax Net income 510329 4016 514.805 35 301 129. 104 107.147 21.957 2.12 35 11.400 4281 478.614 3516 482.130 10.084 121.146 97041 24.105 2467 106510 20.437 1015 22.764 25 20.497 204 21,638 5.550 15.080 4.600 10.523 7.179 2009 2013 2017 2016 7.722 6.289 8.750 5.654 8.705 5.624 44.469 Wal-Mart Stores Balance Sheets (in millions of dollars) Asset Cash and cash equivalents Receivables Inventories Prepaid expenses and other Total current asset Property and plant, Cost Less: accumulated depreciation Net property, plant, & equip Property under capital lease Less: accumulated amortization Net property under capitales Goodwill Other sets and deferred charges Total assets 3.623 6189 185 810 8.667 5.835 43,046 1941 S16 179492 71782 107.710 11 637 2.511 59.664 25154 -27479 107.675 12.00 5380 2.143 1842 11. 20452 104317 12.780 80.239 176.958 4787 110,171 11.096 4751 6.345 16.695 5.031 199.581 7.678 31.101 14832 219.295 5.458 17.037 9.821 1980s 5.225 47.000 22.15 Lubiates and Shareholders' Equity Current Rabies Short-term borrowings Accounts payable Accrued bites Accrued income taxes Long term date due within one year Other current liabilities Total current Long term debt Long-term obligations under capitales Deferred income taxes and other Other long-term Kabilities Total long-term labies Shareholders' Equity Common stock Capital in excess of par value Retained earning Other accumulated comprehensive income Walmart shareholders' equity Noncontrolling equity interest Total shareholders' equity Total & shareholders equity ON 22.122 SAS 2730 2 TL521 30045 TO 18 720 77,477 43520 6.683 11.00 1.099 41.433 20.654 921 2.256 S65 36,928 16.015 5003 344 2 $1.32 2.708 38487 19,607 521 2.745 551 54619 38.214 5.816 7.321 2 51351 52.184 45.579 311 2.965 NO. TE -1050 72496 7.132 29534 219 295 2560 35.101 -1081 77.000 305 2.311 9.354 -1422 77,790 2737 80535 198.825 1.805 90.021 -11 597 80 546 2005 83.611 199.585 80822 204522 2018 Cash Flow Data Cash flow from operations Faed asset purchases Cash dividends 2019 27.753 10.344 6.102 2017 31530 10.619 6216 10.051 6.124 2016 27.389 11.477 6.294 Liabilities and Shareholders' Equity Accounts payable Accrued liabilities Other current liabilities Total current liabilities Long-term debt Other long-term liabilities Total long term liabilities Total liabilities 9,761 4.201 1.052 15.014 10.223 4.756 14.979 29.993 8,677 4,254 270 13,201 11,317 2.772 14,089 27,290 7252 3.737 1.719 12.708 11,031 2.739 13.770 26.478 7.418 4.236 968 12.622 11.945 2.738 14,683 27.305 Shareholders' Equity Common stock Capital in excess of par value Retained earnings Other comprehensive income Total shareholders' equity Total liabilities & shareholders' equity 43 6,042 6.017 -805 11.297 41,290 45 5,858 6,553 -747 11.709 38,999 46 5,661 5,884 -638 10.953 37.431 50 5.348 8,188 -629 12.957 40.262 2016 Cash Flow Data Cash flow from operations Fixed asset purchases Cash dividends 2019 5.973 3,516 1.355 2018 6.923 2.533 1,338 2017 5,329 1,547 1,348 5.140 1.438 1.362 2019 2018 2017 2016 Target Financial Measures Profitability Operating profit margin Net profit margin Asset turnover Financial leverage ratio Return on assets Retum on equity 5.4% 3.9% 1.825 3.654 10.0% 26.0% 6.0% 4.1% 1.84 3.33 11.0% 25.0% 7.1% 4.2% 1.857 3.417 13.3% 25.0% 7.5% 4.6% 1.833 3.107 13.7% 26.0% Liquidity Working capital Working capital (current) ratio Inventory tumover Days in inventory Accounts receivable turnover Days in accounts receivable Accounts payable turnover Days in accounts payable Net cash conversion cycle -2.495 0.833 5.612 65.06 NA -637 0.95 5.9 61.86 NIA NIA 5.892 61.969 -0.11 -718 0.94 5.881 62.074 NIA NIA 6.739 54.154 792 1,508 1.119 6.045 60.376 NA NA 9947 36.695 23.68 N/A 5.46 68.849 -1.79 Solvency Debt-to-capital ratio Debt-to-equity ratio Earnings coverage Financial leverage Index Cash flow adequacy ratio 0.726 2.654 9.74 2.6 1.226 0.699 2.33 6.474 2.26 1.789 0.707 2.417 4.949 1.879 1.84 0.678 2.107 9.11 1.89 1.836 Liabilities and Shareholders' Equity Accounts payable Accrued liabilities Other current liabilities Total current liabilities Long-term debt Other long-term liabilities Total long term liabilities Total liabilities 9,761 4.201 1.052 15.014 10.223 4756 14,979 29,993 8,677 4.254 270 13,201 11,317 2.772 14,089 27,290 7.252 3,737 1.719 12.708 11,031 2.739 13.770 26.478 7.418 4.236 968 12.622 11.945 2.738 14 683 27 305 Shareholders' Equity Common stock Capital in excess of par value Retained oamings Other comprehensive income Total shareholders' equity Total liabilities & shareholders' equity 43 6,042 6.017 -805 11.297 41,290 45 5.858 6,553 -747 11.709 38,999 46 5,661 5,884 -63,8 10.953 37.431 50 5.348 8.188 -629 12 957 40.262 2016 Cash Flow Data Cash flow from operations Fixed asset purchases Cash dividends 2019 5.973 3,516 1.355 2018 6.923 2.533 1,338 2017 5,329 1.547 1,348 5.140 1.438 1.362 2019 2018 2017 2016 Target Financial Measures Profitability Operating profit margin Net profit margin Asset turnover Financial leverage ratio Return on assets Return on equity 5.4% 3.9% 1.825 3.654 10.0% 26.0% 6.0% 4.1% 1.84 3.33 11.0% 25.0% 7.1% 4.2% 1.857 3.417 13.3% 25.0% 7.5% 4.6% 1.833 3.107 13.7% 26.0% Liquidity Working capital Working capital (current) ratio Inventory turnover Days in inventory Accounts receivable turnover Days in accounts receivable Accounts payable turnover Days in accounts payable Net cash conversion cycle -2.495 0.833 5.612 65.06 NA N/A 5.46 66 849 -1.79 -637 0.95 5.9 61.86 NIA NIA 5.892 61.969 -0.11 -718 0.94 5.881 62.074 NIA NIA 6.739 54.154 792 1.508 1.119 6.045 60 376 NIA N/A 9.947 36.695 23.68 Solvency Debt-to-capital ratio Debt-to-equity ratio Earnings coverage Financial leverage Index Cash flow adequacy ratio 0.726 2654 9.74 2.6 1.226 0.699 2.33 6.474 2.26 1.788 0.707 2.417 4.949 1.879 1.84 0.678 2.107 9.11 1.89 1.836