While you are an analyst at Investment Counselors, Inc., the senior portfolio manager at your firm makes a decision to increase sporting goods apparel manufacturer stocks in the firm’s managed funds. You are assigned to recommend one stock as an initial investment to meet this long-run objective. You diligently analyze and evaluate all communication stocks and narrow the decision to two athletic shoe manufacturing companies: Nike and Reebok. The senior portfolio manager requests that you analyze the internal sources of earnings growth for each company. You decide to disaggregate and evaluate the internal growth components for each company to explain any trends in your variable of interest, return on common equity. You identify the key components driving ROCE and develop the following spreadsheet:

Required:
a. Describe and interpret how the recent five-year trend in the components of ROCE determine the ROCE for both Nike and Reebok.
b. Recommend a “buy” on one of these companies based on your analysis. Support your recommendation with reference to your analysis ina.

Transcribed Image Text:

Year 5 Year 4 Year 3 Year Year 1 Nike Retum on equity (ROCE) Retum on net operating assets (R NOA). . Financial leverage (LEV) Spread Sales growth.. . Gross profit margin. SG&A expense/Sales NOPAT/Sales Tax expense/Pretax income.. 12.1% 15.5% 24.8% (13.9%) 18.1% 14.2% 32.8% 11.9% 18.5% 13.3% 46.0% 11.3% 2.49% 39.9% 31.5% 6.8% 37.0% 17.8% 13.4% 41.3% 10.6% 19.2% 16.6% 4.26% 39.3% 31.4% 7.0% 34.3% . . . . : -14.55% 8.13% 5.49% 42.9% -32.7% 41.0% 31.9% 71% 34.1% 39.0% 30.6% 6.6% 36.0% : 34.8% Year 5 Year 3 Year 4 2.19 66.33 83.50 Year 2 Year 1 NOA turnover.. .. Receivables turnover Average collection period .. 62.62 63.19 61.37 63.09 85.04 4.67 12.83 2846 15.0% 12.1% 53.8% 90.54 Average inventory days outstanding Long-term operating asset turnover6.56 Accounts payable turnover Average payable days outstanding 82.07 10.48 34.84 15.7% 12.7% 36.7% 82% 10.62 34.36 11.72 31.13 15.1% 12.3% 44.5% 63% 30.78 Return on equity (ROCE) Return on net operating assets (RNOAL-- . . Financial leverage (LEV) Spread 78.8% 4.2% (1.19%) 37.9% 33.6% 101.0% (6.0%) (10.07%) 38.5% 35.2% 3.2% 36.0% 11.43% 38.4% 322% Sales growth Gross profit margin SG&A expense/Sales... NOPAT/Sales.. Tax expense/Pretax income NOA turnover Receivables turnover Reebok Average collection period Inventory tumover.. Average inventory days outstanding Long-term operating asset turnover.. Accounts payable turnover... Average payable days outstanding 4.51% 4.45% 36.7% . 38.3% 32.4% 4.8% 31.0% 4.3% 31.0% 36.1% 6.20 46.98 49.22 53.58 58.86 63.95 82.88 72.10 12.62 13.16 9.03 12.66 28.83 27.37 36.54