Find spread (what is NBC??? and how do I find it? Show in excel. Thanks!
Return on Invested Capital Ratios 2021 20.83% 405.9% 26.78% 210.52% 2020 17.61% 217.0% 22.16% 72.81% 2019 11.55% 63.4% 14.24% 14.11% 2018 14.85% 58.7% 20.27% 33.16% 2017 13.80% 48.1% 19.71% 25.39% 2016 12.26% 33.3% 20.13% 15.77% 20.83% 36% 17.61% 28% 11.55% 25% 14.85% 38% 13.80% 37% 12.26% 38% 200.69% 165.65% 44.87% 60.59% 44.77% 29.64% 1 Return on Net operating assets 2 Return on common equity 3 Return on Long term debt and equity 4 Equity Growth Rate 5 Disaggregation of ROCE RNOA LEV Spread Roe (RNOA+ [LEV x Spread] where: NOA NTO (NOA-SL) SE NOPAT NFE (NOPAT-NI) NI 6 Disaggregate of RNOA NOPAT Margin NOA Turnover RNOA (Margin x turnover) 11049 11047.56 1.437 1130000000 -4681000000 5811000000 4296 6193 5065 5617 4294.03 6189.36 5059.13 5610.57 1.972 3.644 5.873 6.434 630300000 396,900,000 643700000 758,570,000 -3637700000 -1910100000 -2792300000 -2305430000 4268000000 2307000000 3436000000 3064000000 19369 19361.35 7.654 16,370,000 -2517630000 2534000000 44% 8.11 3.55 37% 16.79 6.16 18% 11.51 2.04 26% 13.55 3.50 22% 11.58 2.57 21% 3.05 0.63 Common-Size Consolidated Balance Sheet Assets Cash and Short Term Investments Merchandise inventory-net Total current assets Property, less accumulated depreciation Total Assets Liabilities and Shareholders Equity Accounts payable Total Current liabilities Total Debt Total Liabilities Shareholders Equity Shares Outstanding, year end 1/29/2021 5196 16,193 22,326 19,155 46,735 1/31/2020 876 13,179 15,318 18,669 39,471 2/1/2019 729 12,561 14,228 18,432 34,508 2/2/2018 690 11,393 12,772 19,721 35,291 2/3/2017 658 10,458 12,000 19,949 34,408 1/29/2016 712 9,458 10,561 19,577 31,266 10,884 18,730 21,780 45,298 1,437 731 7,659 15,182 19,306 37,499 1,972 763 8,279 14,497 16,223 30,864 3,644 801 6,590 12,096 16,995 29,418 5,873 830 6,651 11,974 15,699 27,974 6,434 866 5,633 10,492 12,649 23,612 7,654 910 9968 Income Statement 2021-2016 Net sales in millions) Gross Margin Serlling, General, Administrative (% to sales) Depreciation and Amortization (% to sales) Operating Margin Interest-Net (% to sales) Net Earnings (% to sales) Weighted Average shares, assuming dilution (in millions) Diluted carnings per common share Adjusted diluted earnings per common share Cash dividends per share 1/29/2021 1/31/2020 2/1/2019 2/2/2018 2/3/2017 1/29/2016 89,597 72,148 71,309 68,619 65,017 59,074 33.01% 31.80% 32.12% 32.69% 33.34% 34.82% 20.68% 21.30% 24.41% 21.04% 22.12% 23.88% 1.56% 1.75% 2.07% 2.05% 2.23% 2.53% 10.77% 8.75% 5.64% 9.60% 8.99% 8.41% 0.95% 0.96% 0.88% 0.92% 0.99% 0.93% 6.51% 5.93% 3.24% 5.02% 4.76% 4.31% 750 778 812 840 881 929 7.75 5.49 2.84 4.09 3.47 2.73 8.86 5.74 4.39 3.99 3.29 2.3 2.13 1.85 1.58 1.33 1.07 5.11 Reference From Wall Street Journal Cost of Goods Sold Operating income 61424 9,647 50467 6,314 49878 4,018 47589 6,586 44042 5,846 38504 4,971 Income Tax Expense 1904 1342 1080 2042 2108 18731
