(Please show your work and organize/structure your responses appropriately in Excel) Starship Inc. is in the process of measuring its financial performance. They are interested in the performance of the three divisions. From information collected, below are their financial results: Sales Operating income Average investment Divisions Canada USA Europe $330,200 $477,500 $653,345 55,045 97,482 124,445 99,000 290,000 176,000 Required: A. Calculate the return on investment for each division and also report their sales performance (ROS) and how well their investments are performing (investment turnover). B. What is the residual income for each division if the required rate of return is 15%? C. Currently, Starship has an internal required rate of return on all new investments of 15%. Their bonus structure, for all divisions, is based on the division reaching an ROS of 20% or higher. If each division manager had the chance to invest in a project that required $10,000 of investment and returned $1,700 in operating income, should they invest in it based on the company-wide policy? Would they invest in it? D. What would you advise and/or recommend to the decision-makers based on the information you've calculated