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.

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 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 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 2738 14 683 27.305 Shareholders' Equity Common stock Capital in excess of par value Retained earings 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.209 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 tumover 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.096 -2.495 0.833 5.612 65.06 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 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 NIA N/A 9.947 36.695 23.68 N/A 5.46 66 849 -1.79 Solvency Debt-to-capital ratio Debt-to-equity ratio Earnings coverage Financial leverage Index Cash flow adequacy ratio 0.726 2654 9.74 26 1.226 0.699 233 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 Target Ratios Wal-Mart Ratios 2019 2018 2017 2016 Wal-Mart Stores Income Statements in millions of dollars) Revenues Net sales Other Incoment Total revenues Costs of sales Gross profit Operating expenses Operating income Net interest CoM Other gains) losses Income before income taxes Total income tax Net income 510329 4016 514 405 385 295 129. 104 107.147 21.957 2.12 26.750 4 52 5003 27 120 106510 20.437 2.17 23 481 317 4556 465.873 261254 124.617 11S 22.764 2267 20.497 204 478,614 3516 482.130 0.984 121146 97041 24.105 2467 g 21.638 5.550 15.080 11.400 4281 7.179 4.600 10.523 2019 2013 2017 2016 6.796 5.614 4780 8.867 5.805 43,046 Wal-Mart Stores Balance Sheets (in millions of dollars) Assis Cash and cash equivalents Receivables Inventories Prepaid expenses and other Total current Property and plant, cost Less: accumulated depreciation Net property, plant, & equip Property under capital ease Less: accumulated amortization Net property under capital leases Goodwill Other sets and deferred charges Total assets 7.722 6.285 44.205 3.622 61.87 185 810 11.690 104317 12.760 52 7078 31,181 576 129492 11.782 107.710 11 637 59.564 185.154 -2779 107,675 12.700 -5.500 2.143 18.242 11 204522 8.705 5.624 44.469 TH 50,239 176.958 4787 110,171 19.000 4751 6345 16.695 5.131 19951 5.468 17.037 9.921 9825 210.295 1,099 5.225 47.000 22.15 5.257 ON 22.122 645 2.750 Labtes and Shareholders' Equity Current fiables Short-term borrowings Accounts payable Accrued bites Accrued income taxes Long-term date due within one year Other current lines Total current Long term debit Long term obligations under capital bases Deferred income taxes and other Other long-term abilities Total long-term bles 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 1.875 220 77477 43520 6683 11.30 52.184 TE 521 30045 750 2.700 38 487 19 607 521 2.745 551 54,519 38.214 5.816 7321 0 51.351 20.654 921 2.256 SES 6.928 16.015 8.003 344 2 5132 45.170 2.54 10 2.965 80.75 -115 72495 7.132 29534 210.295 317 1.805 90.021 11.597 80 546 3065 83.611 199 581 2.311 9.354 -1422 77,790 2737 20535 198.825 77 2.95 80822 204522 Cash Flow Data Cash flow from operations Faedasse purchase Cash dividends 2019 27.753 10.40 6.102 2017 31530 10,619 6216 2016 27.9 11 477 6.294 10.051