1 Partapapeles Fuente Newcin 2 Problem Set 5. (20 points) 3 1. Fill out the blonks in color. If no answer key is needed, just leave the blank 4 2. Each cell MUST include a formula, link, or a working process. (except for the given number from the questions) S 3. Directly typing only the answers on the cell won't get the full credits. (except for given numbers from the questions) 6 4. Sharing answers and files will result in the Zero Grade both giver and receiver. (Plagiarism will be checked) 8 Requirement 1. Consider the following data and fill out all the blanks for the performance evaluation. 9 10 Performance Evaluation. Division A Division B 11 Income (NOPAT) (5) Division C 900,000 Company Total 12 Revenue (5) 13 Invested Capital (5) 10,000,000 40,000,000 14 Return on Sales (%) 18.0% 15 Capital turnover 4.0 10.0% 30 16 Rate of return on invested capital (56) 27.0% 28.0% 17 Cost of capital (56) 14.0% 14.0% 18 Economic profit (5) 400,000 19 20 21 Requirement 2. For each division and company total, analyze the performance results related to Return on Sales and Capital turnover. 22 23 24 25 26 27 28 29 30 Requirement 3. (1) Which division is the best performer? Why? (2) Evaluate each division performance based on the RO AND Economic Profit respectively. (3) Explain the relationships between ROI and Economic Profit 31 32 33 34 30 H Por 39 40 41 The End of the Problem Set 5 Total 20 42 43 44 45