PLS HELP ASAP AND PLS INCLUDE THE FOMULAS FOR THE YELLOW AREAS BOT JUST NUMBER THANK U!!!

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 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 results to be automatically recalculat 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 give information (currently in cells C12:C15 ) and see the resulting changes in ROI and residual income. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. 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 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 10 you will be able to modify the given information (currently in cells C12C15 ) and see the resulting changes in ROI and residual income. \begin{tabular}{ll} Net income & = \\ Sales & = \\ Investment & = \\ Desired ROI & = \\ \hline \end{tabular} \begin{aligned} ROI & = Margin \\ ROI & =SalesNetincomeInvestmentSales ROI & \( =r\end{aligned} \) Graded Worksheet Calibri (Body) 11 A1 Accessibility tab summary: The financial information of Waldon Corporation is present 10. you wil be able to modiry the given intormation (currentiy in cells (12:C15) and see the resulting changes in ROI and residual income. 11 12. \begin{tabular}{ll} Net income & = \\ Sales & =r \\ Investment & = \\ Desired ROI & = \end{tabular} \begin{aligned} \( \mathrm{ROI} & = \) Margin \\ \( \mathrm{ROI} & =\frac{\text { Net income }}{\text { Sales }} \times \frac{\text { Turnover }}{\text { Sales }} \\ \mathrm{ROI} & = \\ \mathrm{ROI} & =\end{aligned} \) \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Residual income & & Earned Income & \begin{tabular}{ll} - \\ \end{tabular} & Investment & x & Desired ROI & 1) \\ \hline Residual income & = & & - & & x & & 1 \\ \hline Residual income & = & & - & & & & \\ \hline Residual income & = & & & & & & \\ \hline \end{tabular}