Determine the profit margin, total asset turnover, return on assets, equity multiplier and return on equity for the years 2017, 2018 and 2019 from the following data:
Target.xlsx - LibreOffice Calc File Edit View Insert Format Sheet Data Tools Window Help X YO QAb OA Calibri 11 a a a a E ti $ % 0.0 .00 !! J27 f(x) = C D E F I K L B WALMART in ($000,000) INCOME STATEMENT Total Revenue Cost of Revenue Gross Profit $ 1/31/2019 514,405 $ 385,301 129,104 1/31/2018 500,343 $ 373,396 126,947 1/31/2017 485,873 361,256 124,617 Operating Expenses Research Development Selling General and Administrative f(x) 107,147 106,510 101,853 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Operating Income or Loss Interest Expense Total Other Income/Expenses Net Income Before Tax Income Tax Expense Income from Continuing Operations Noncontrolling interest Net Income Reported EPS Basic Diluted Weighted average shares outstanding Basic Diluted 21,957 2,129 8,368 11,460 4,281 7,179 -509 6,670 20,437 2,178 3,136 15,123 4,600 10,523 -661 9,862 22,764 2,267 0 20,497 6,204 14,293 -650 13,643 $ $ 2.28 $ 2.26 $ 3.29 $ 3.28 $ 2.995 4.40 4.38 3.101 2.929 2.945 3.101 3.112 WALMART in ($000,000) Target Walmart Sheet 2 of 2 Sum=0 100% PageStyle_Walmart Target.xlsx - LibreO... Menu [Determine The Pro... (target anlysis.png) O % 1019:03 ) Target.xlsx - LibreOffice Calc File Edit View Insert Format Sheet Data Tools Window Help X YO QAb OA Calibri 11 a a a E. $ % 0.0 .00 152 f(x) = A C D E F H 1 K L 1/31/2019 1/31/2018 1/31/2017 IN $ 7,722 $ 6,283 44,269 3,623 61,897 6,756 $ 5,614 43,783 3,511 59,664 6,867 5,835 43,046 1,941 57,689 f(x) 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 B WALMART in ($000,000) BALANCE SHEET Assets Current Assets Cash And Cash Equivalents Net Receivables Inventory Other Current Assets Total Current Assets Non-current assets Property, plant and equipment Gross property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Intangible Assets Other long-term assets Total non-current assets 198,570 -87,175 111,395 197,857 -83,039 114,818 191,129 -76,951 114,178 31,181 18,242 17,037 14,822 157,398 11,798 144,858 9,921 141,136 Total Assets 219,295 204,522 198,825 Liabilities and stockholders' equity Liabilities Current Liabilities Short Term Borrowings 5,225 5,257 1,099 Target Walmart Sheet 2 of 2 Sum=0 PageStyle_Walmart Target.xlsx - LibreO... 100% $190 19:03 :) Menu 3R 3 [Determine The Pro... (target anlysis.png) Target.xlsx - LibreOffice Calc File Edit View Insert Format Sheet Data Tools Window Help X YO QAb OA Calibri 11 a a a $ % 0.0 .00 152 f(x) = C D E F K L 5,225 47,060 428 22,159 5,257 46,092 645 22,122 1,099 41,433 921 20,654 IN 52 53 54 55 56 57 58 59 60 61 2,605 77,477 4,405 78,521 2,821 66,928 f(x) 43,520 11,981 30,045 8,354 36,015 9,344 62 63 64 65 66 67 68 B Short Term Borrowings Accounts Payable Taxes payable Accrued liabilities Deferred revenues Other Current Liabilities Total Current Liabilities Non-current liabilities Long Term Debt Deferred taxes liabilities Deferred revenues Other long-term liabilities Total non-current liabilities Total Liabilities Stockholders' Equity Common Stock Capital in excess of par value Retained Earings Accumulated other comprehensive income Total stockholders' equity Non controlling interest Total Equity 6,683 62,184 139,661 6,780 45,179 123,700 6,003 51,362 118,290 69 70 71 72 73 74 75 76 77 288 2,965 80,785 -11,542 72,496 7,138 79,634 295 2,648 85,107 -10,181 77,869 2,953 80,822 305 2,371 89,354 -14,232 77,798 2,737 80,535 Total liabilities and stockholders' equity 219,295 204,522 198,825 Target Walmart Sheet 2 of 2 Sum=0 PageStyle_Walmart Target.xlsx - LibreO... 100% $190 19:03 :) Menu [Determine The Pro... (target anlysis.png)
