Chrome File Edit View History Bookmarks Profiles Tab Window Help OOO AutoSave OFF A6. U = Budget project Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View Share Co A % Conditional Formatting v Format as Table Paste Font Alignment Number Cells Cell Styles Editing Ideas Sensitivity Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? Yes B123 * x v fx A E F G 227 228 229 Problem 4: Performance Measurement (NEW Problem INFORMATION!!) Weather Accessories, Inc., has four divisions-Winter, Spring, Summer and Fall. The company is looking into the performance of each investment centers. Calculate the Return on Investment and Residual Income for each division and explain the results. (CLEARLY SHOW 230 AND LABEL ALL CALCULATIONS). 231 Winter Spring Summer Fall 232 Sales $207,600 $263,600 $269,600 $289,800 233 Net Income $81,720 $115,420 $122,090 $121,090 234 235 Avg Operating Assets (investment) $756,600 $837,300 $831,700 $788,200 236 237 238 a. Calculate the Return on Investment (ROI) for each division. 239 Winter Spring Summer Fall 240 Retum on Investment: Poin 241 Po 242 243 244 245 246 247 b. Calculate the Residual Income for each division if the cost of capital is 12% 248 249 Winter Spring Summer Fall Point 250 Po 251 252 253 254 c. Which division is doing the best? Explain using your data and be sure to explain the meaning of Return on Investment and Residual 255 Income. Point 256 Poi 257 258 259 A Project Settings iT + 9,545 DEC 32 459 9 MacBook Air