1. The cells below row 21 that show numbers should all be based on formulas. This allows the Waldon Corporation's balance sheet shows that the company has $600,000 invested in operating assets. During Year 2, Waldon earned $120,000 on $960,000 of sales. The company's desired return 3 on investment (ROI) is 12 percent. Required a. Complete the spreadsheet to calculate ROI and residual income using these data. Spreadsheet Tips 1. The cells below row 21 that show numbers should all be based on formulas. This allows the 9 results to be automatically recalculated based on changes in the data in rows 12 to 15 . 3. Explore the power of formulas by copying cells A12:131 into the scratchpad area below. There you will be able to modify the given information (currently in cells C12:C15 ) and see the resulting changes in ROl and residual income