please fill out just 4.a) on the excel sheet thanks!

Current New Project Total 39 40 Part 4a 41 42 43 44 45 46 47 Residual income 48 PROBLEM 11-21 Return on Investment and Residual Income 103, 104 Faced with headquarters' desire to add a new product line, Stefan Grenier, manager of Bilti Products' East Division, felt that he had to see the numbers before he made a move. His division's Rol has led the company for three years, and he doesn't want any letdown Bilti Products is a decentralized wholesale with four autonomous divisions. The divisions are evaluated on the basis of ROL with yearend bonuses given to divisional managers who have the highest ROL Operating results for the company's East Division for last year are given below: Sales Variable expenses Contribution margin Fixed expenses Operating income Divisional operating assets $21,000,000 13.400,000 7,600,000 5,920,000 S 1.680,000 $ 5.250,000 32. W Page 3 The company had an overall ROI of 18% last year (considering all divisions). The new product line that headquarters wants Grenier's East Division to add would require an investment of $3,000,000. The cost and revenue characteristics of the new product line per year would be as follows Sales Variable expenses Fixed expenses $9,000,000 65% of sales $2,520,000 Required: 1. Compute the East Division's ROI for last year, also compute the Rol as it would appear if the new product line were added. 2. If you were in Grenier's position, would you accept or reject the new product line? Explain. 3. Why do you suppose headquarters is anxious for the East Division to add the new product line? 4. Suppose that the company's minimum required rate of return on operating assets is 18% and that performance is evaluated using residual income Compute East Division's residual income for last year, also compute the residual income as it would appear if the new product line were added Under these circumstances, if you were in Grenier's position, would you accept or reject the new product line? Explain