financial profitability
Selina Watkins
CompanyRatio.xlsxNike
| Nike's Performance Measures | ||||||
| Performance Measures | 2019 | 2018 | 2017 | 2016 | Source (Link) | |
| Market value added ($ millions) | Market value of equity – book value of equity | 117099.28 | 114214.84 | 78047.32 | 86378.37 | https://www.macrotrends.net/stocks/charts/NKE/nike/financial-ratios |
| Market to book ratio | Market value of equity ÷ book value of equity | 13.95 | 12.64 | 7.29 | 8.05 | |
| Profitability Measures | ||||||
| Return on assets (ROA) % | After tax operating income/total assets | 16.99 | 8.58 | 18.23 | 17.59 | |
| Return on capital (ROC) | After tax operating income / (long-term debt + equity) | 32.22% | 14.56% | 26.70% | 26.38% | |
| Return on equity (ROE) | Net income/equity | 44.57 | 19.7 | 34.17 | 30.67 | |
| EVA ($ millions) | After tax operating income – cost of capital x capital | |||||
| EBITDA | Net Income + interest + taxes + depreciation + amortization | 5492 | 5219 | 5465 | 5164 | |
| Efficiency Measures | ||||||
| Asset turnover | Sales/total assets at start of year | 1.65 | 1.61 | 1.48 | 1.51 | |
| Receivables turnover | Sales/receivables at start of year | 9.17 | 10.41 | 9.34 | 9.99 | |
| Average collection period (days) | Receivables at start of year/daily sales | 39.86 | 35.08 | 39.07 | 36.54 | |
| Inventory turnover | Cost of goods sold/inventory at start of year | 3.85 | 3.89 | 3.77 | 3.6 | |
| Days in inventory | Inventories at start of year/daily cost of goods sold | 88.72 | 90.26 | 92.76 | 90.95 | |
| Profit margin | Net income/sales | 10.3 | 5.31 | 12.34 | 11.61 | |
| Operating profit margin | After tax operating income/sales | 10.30% | 5.31% | 12.34% | 11.61% | |
| Leverage Measures | ||||||
| Long term debt ratio | Long term debt/(long term debt + equity) | 27.70% | 26.11% | 21.86% | 13.98% | |
| Long term debt equity ratio | Long term debt debt/equity | 38.32% | 35.34% | 27.98% | 16.26% | |
| Total debt ratio | Total liabilities/total assets | 61.88% | 56.46% | 46.66% | 42.66% | |
| Times interest earned | EBIT/interest payments | 38.48 | 37.99 | 57.91 | 136.42 | |
| Cash coverage ratio | (EBIT + depreciation)/interest payments | 44.17 | 44.38 | 66.52 | 156.09 | |
| Liquidity Measures | ||||||
| Net working capital to assets | Net working capital/total assets | 52.40% | 60.09% | 65.92% | 64.34% | |
| Current ratio | Current assets/current liabilities | 2.1 | 2.51 | 2.93 | 2.8 | |
| Quick ratio | (cash + marketable securities + receivables)/current liabilities | |||||
| Cash ratio | (cash + marketable securities)/current liabilities | |||||
| Days in Inventory | 365/ Inventory Turnover | 95 | 94 | 97 | 101 | |
| Days in A/R | 365/ A/R Turnover | 40 | 35 | 39 | 37 | |
| Days in A/P | 365/ A/P Turnover | |||||
| Market value of equity | Stock price x share outstanding | 126139.28 | 124026.84 | 90454.32 | 98636.37 | |
| book value of equity | Total assets - total liabilities | 9040 | 9812 | 12407 | 12258 | |
| After tax operating income | 4029 | 1933 | 4240 | 3760 | ||
| long-term debt | 3464 | 3468 | 3471 | 1993 | ||
| equity | 9040 | 9812 | 12407 | 12258 | ||
| cost of capital | ||||||
| capital | long-term debt + eauity | 12504 | 13280 | 15878 | 14251 | |
| Inventories at start of year | 5261 | 5055 | 4838 | 4337 | ||
| cost of goods sold | 21643 | 20441 | 19038 | 17405 | ||
| sales | 39117 | 36397 | 34350 | 32376 | ||
| Total liabilities | 14677 | 12724 | 10852 | 9121 | ||
| total assets | 23717 | 22536 | 23259 | 21379 | ||
| EBIT | 4772 | 4445 | 4749 | 4502 | ||
| interest | 124 | 117 | 82 | 33 | https://www.marketwatch.com/investing/stock/nke/financials | |
| depreciation | 705 | 747 | 706 | 649 | https://www.marketwatch.com/investing/stock/nke/financials | |
| Net working capital | current assets - current liabilities | 8659 | 9094 | 10587 | 9667 | |
| Current assets | 16525 | 15134 | 16061 | 15025 | ||
| current liabilities | 7866 | 6040 | 5474 | 5358 | ||
| cash | 4663 | 5245 | 6179 | 5457 | ||
| receivables | 4270 | 3500 | 3680 | 3240 | ||
| marketable securities | ||||||
| Stock price | 77.96 | 74.76 | 53.46 | 56.59 | ||
| Share outstanding | 1618 | 1659 | 1692 | 1743 | ||
| Cost of capital | [(E/V) * Re] + [(D/V) * Rd * (1-Tc)] | https://www.thebalancesmb.com/calculate-weighted-average-cost-of-capital-393130 |
Under Armour
| Under Armour's Performance Measures | ||||||
| Performance Measures | 2019 | 2018 | 2017 | 2016 | Source (Link) | |
| Market value added ($ millions) | Market value of equity – book value of equity | 7656.31 | 5863.95 | 4344.99 | 10896.35 | https://www.macrotrends.net/stocks/charts/UAA/under-armour/financial-ratios |
| Market to book ratio | Market value of equity ÷ book value of equity | 4.56 | 3.91 | 3.15 | 6.37 | https://www.marketwatch.com/investing/stock/uaa/financials |
| Profitability Measures | ||||||
| Return on assets (ROA) | After tax operating income/total assets | 2.89% | -1.09% | -1.20% | 7.05% | |
| Return on capital (ROC) | After tax operating income / (long-term debt + equity) | 4.21% | -1.70% | -1.73% | 9.11% | |
| Return on equity (ROE) | Net income/equity | 4.29% | -2.30% | -2.39% | 9.75% | |
| EVA ($ millions) | After tax operating income – cost of capital x capital | |||||
| EBITDA | Net Income + interest + taxes + depreciation + amortization | 423.449 | 157.005 | 201.844 | 562.241 | |
| Efficiency Measures | ||||||
| Asset turnover | Sales/total assets at start of year | 124.08% | 129.62% | 136.90% | 168.65% | |
| Receivables turnover | Sales/receivables at start of year | 791.28% | 851.80% | 801.24% | 1114.60% | |
| Average collection period (days) | Receivables at start of year/daily sales | 46.13 | 42.85 | 45.55 | 32.75 | |
| Inventory turnover | Cost of goods sold/inventory at start of year | 274.31% | 246.23% | 298.40% | 330.09% | |
| Days in inventory | Inventories at start of year/daily cost of goods sold | 133.06 | 148.23 | 122.32 | 110.58 | |
| Profit margin | Net income/sales | 1.75% | -0.89% | -0.97% | 4.10% | |
| Operating profit margin | After tax operating income/sales | 2.65% | -0.89% | -0.97% | 5.32% | |
| Leverage Measures | ||||||
| Long term debt ratio | Long term debt/(long term debt + equity) | 35.30% | 25.87% | 27.48% | 28.02% | |
| Long term debt equity ratio | Long term debt debt/equity | 54.57% | 34.90% | 37.90% | 38.92% | |
| Total debt ratio | Total liabilities/total assets | 55.61% | 52.49% | 49.61% | 44.27% | |
| Times interest earned | EBIT/interest payments | 1114.74% | -75.42% | 77.69% | 1690.85% | |
| Cash coverage ratio | (EBIT + depreciation)/interest payments | 1993.64% | 454.18% | 539.60% | 2224.55% | |
| Liquidity Measures | ||||||
| Net working capital to assets | Net working capital/total assets | 26.43% | 30.10% | 31.88% | 35.10% | |
| Current ratio | Current assets/current liabilities | 190.03% | 197.09% | 220.46% | 286.54% | |
| Quick ratio | (cash + marketable securities + receivables)/current liabilities | 127.28% | 119.62% | 111.20% | 152.76% | |
| Cash ratio | (cash + marketable securities)/current liabilities | 77.44% | 69.03% | 53.70% | 61.97% | |
| Market value of equity | Stock price x share outstanding | 9806.4 | 7880.82 | 6363.63 | 12927.25 | |
| book value of equity | Total assets - total liabilities | 2150.087 | 2016.871 | 2018.642 | 2030.9 | |
| After tax operating income | 139.818 | -46.302 | -48.26 | 256.979 | ||
| long-term debt | 1173.322 | 703.834 | 765.046 | 790.388 | ||
| equity | 2150.087 | 2016.871 | 2018.642 | 2030.9 | ||
| cost of capital | ||||||
| capital | long-term debt + eauity | 3323.409 | 2720.705 | 2783.688 | 2821.288 | |
| Inventories at start of year | 1019.496 | 1158.548 | 917.491 | 783.031 | ||
| cost of goods sold | 2796.599 | 2852.714 | 2737.83 | 2584.724 | ||
| sales | 5267.132 | 5193.185 | 4989.244 | 4833.338 | ||
| Total liabilities | 2693.444 | 2228.151 | 1987.725 | 1613.431 | ||
| Total assets | 4843.531 | 4245.022 | 4006.367 | 3644.331 | ||
| EBIT | 236.77 | -25.017 | 27.843 | 417.471 | ||
| interest | 21.24 | 33.17 | 35.84 | 24.69 | ||
| depreciation | 186.679 | 175.67 | 165.55 | 131.77 | ||
| Net working capital | current assets - current liabilities | 1280.2 | 1277.651 | 1277.304 | 1279.337 | |
| Current assets | 2702.209 | 2593.628 | 2337.679 | 1965.153 | ||
| current liabilities | 1422.009 | 1315.977 | 1060.375 | 685.816 | ||
| cash | 788.072 | 557.403 | 312.483 | 250.47 | ||
| receivables | 708.714 | 665.65 | 609.67 | 622.69 | ||
| marketable securities | ||||||
| Stock price | 21.6 | 17.67 | 14.43 | 29.05 | ||
| Share outstanding | 454 | 446 | 441 | 445 | ||
| Net Income | 92.139 | -46.302 | -48.26 | 197.979 | ||
| Total asset at start of year | 4245.022 | 4006.367 | 3644.331 | 2865.97 | ||
| receivables at start of year | 665.65 | 609.67 | 622.69 | 433.64 | ||
| Inventory | 892.258 | 1019.496 | 1158.548 | 917.491 | ||
| Quick assets | current assets - inventory | 1809.951 | 1574.132 | 1179.131 | 1047.662 | |
backup
| Nike's Performance Measures | ||||||
| Performance Measures | 2019 | 2018 | 2017 | 2016 | Source (Link) | |
| Market value added ($ millions) | Market value of equity – book value of equity | 117099.28 | 114214.84 | 78047.32 | 86378.37 | https://www.macrotrends.net/stocks/charts/NKE/nike/financial-ratios |
| Market to book ratio | Market value of equity ÷ book value of equity | 13.95 | 12.64 | 7.29 | 8.05 | |
| Profitability Measures | ||||||
| Return on assets (ROA) | After tax operating income/total assets | 16.99 | 8.58 | 18.23 | 17.59 | |
| Return on capital (ROC) | After tax operating income / (long-term debt + equity) | 32.22% | 14.56% | 26.70% | 26.38% | |
| Return on equity (ROE) | Net income/equity | 44.57 | 19.7 | 34.17 | 30.67 | |
| EVA ($ millions) | After tax operating income – cost of capital x capital | |||||
| EBITDA | Net Income + interest + taxes + depreciation + amortization | 5492 | 5219 | 5465 | 5164 | |
| Efficiency Measures | ||||||
| Asset turnover | Sales/total assets at start of year | 1.65 | 1.61 | 1.48 | 1.51 | |
| Receivables turnover | Sales/receivables at start of year | 9.17 | 10.41 | 9.34 | 9.99 | |
| Average collection period (days) | Receivables at start of year/daily sales | 39.86 | 35.08 | 39.07 | 36.54 | |
| Inventory turnover | Cost of goods sold/inventory at start of year | 3.85 | 3.89 | 3.77 | 3.6 | |
| Days in inventory | Inventories at start of year/daily cost of goods sold | 88.72 | 90.26 | 92.76 | 90.95 | |
| Profit margin | Net income/sales | 10.3 | 5.31 | 12.34 | 11.61 | |
| Operating profit margin | After tax operating income/sales | 10.30% | 5.31% | 12.34% | 11.61% | |
| Leverage Measures | ||||||
| Long term debt ratio | Long term debt/(long term debt + equity) | 27.70% | 26.11% | 21.86% | 13.98% | |
| Long term debt equity ratio | Long term debt debt/equity | 38.32% | 35.34% | 27.98% | 16.26% | |
| Total debt ratio | Total liabilities/total assets | 61.88% | 56.46% | 46.66% | 42.66% | |
| Times interest earned | EBIT/interest payments | 38.48 | 37.99 | 57.91 | 136.42 | |
| Cash coverage ratio | (EBIT + depreciation)/interest payments | 44.17 | 44.38 | 66.52 | 156.09 | |
| Liquidity Measures | ||||||
| Net working capital to assets | Net working capital/total assets | 52.40% | 60.09% | 65.92% | 64.34% | |
| Current ratio | Current assets/current liabilities | 2.1 | 2.51 | 2.93 | 2.8 | |
| Quick ratio | (cash + marketable securities + receivables)/current liabilities | |||||
| Cash ratio | (cash + marketable securities)/current liabilities | |||||
| Market value of equity | Stock price x share outstanding | 126139.28 | 124026.84 | 90454.32 | 98636.37 | |
| book value of equity | Total assets - total liabilities | 9040 | 9812 | 12407 | 12258 | |
| After tax operating income | 4029 | 1933 | 4240 | 3760 | ||
| long-term debt | 3464 | 3468 | 3471 | 1993 | ||
| equity | 9040 | 9812 | 12407 | 12258 | ||
| cost of capital | ||||||
| capital | long-term debt + eauity | 12504 | 13280 | 15878 | 14251 | |
| Inventories at start of year | 5261 | 5055 | 4838 | 4337 | ||
| cost of goods sold | 21643 | 20441 | 19038 | 17405 | ||
| sales | 39117 | 36397 | 34350 | 32376 | ||
| Total liabilities | 14677 | 12724 | 10852 | 9121 | ||
| total assets | 23717 | 22536 | 23259 | 21379 | ||
| EBIT | 4772 | 4445 | 4749 | 4502 | ||
| interest | 124 | 117 | 82 | 33 | https://www.marketwatch.com/investing/stock/nke/financials | |
| depreciation | 705 | 747 | 706 | 649 | https://www.marketwatch.com/investing/stock/nke/financials | |
| Net working capital | current assets - current liabilities | 8659 | 9094 | 10587 | 9667 | |
| Current assets | 16525 | 15134 | 16061 | 15025 | ||
| current liabilities | 7866 | 6040 | 5474 | 5358 | ||
| cash | 4663 | 5245 | 6179 | 5457 | ||
| receivables | 4270 | 3500 | 3680 | 3240 | ||
| marketable securities | ||||||
| Stock price | 77.96 | 74.76 | 53.46 | 56.59 | ||
| Share outstanding | 1618 | 1659 | 1692 | 1743 | ||
| Cost of capital | [(E/V) * Re] + [(D/V) * Rd * (1-Tc)] | https://www.thebalancesmb.com/calculate-weighted-average-cost-of-capital-393130 |
