accounting

can you please in excel and upload it.Thank you

Essendon Pty Limited manufactures guidance systems for rockets that are used to launch commercial satellites. The company's Sattware Business Division reported the following data for the last year: Sales revenue $4,000,000 Sales retums $220,000 Cost of goods sold $2,400,000 Operating expenses $1,100,000 Total assets at year-beginning $3,800,000 Total assets at year-end $3.980,000 Total current liabilities at year-beginning S110,000 Total current liabilities at year-end S122,000 14C Mostly cloudy hp . The company's required rate of return is 9.25 percent. Additional information: The total assets at year-end include a piece of vacant land valued at $640,000. It is identified as a non-productive anset by the corporate management, The divisional manager manages all current linbilities. The use of average balances is recommended . In an attempt to improve its return on investment (ROI). Essendon company is planning to speed up the collection of all account receivables by $70,000. write-off und discard $57,000 of obsolete inventory. sponsor a competition for teams of local universities' students to design and build small satellite with budget up to $120,000 Required: a. Calculate the Software Business Division's return on investment (ROI) and residual income (RI) Discuss the results from your calculations Note: Textbook Chapter 13 "Learning objecten 13.5-Meustering Profil and Invested capital will be a good guide to define profit and invested capital in the ROI and RI calculations b. Explain should the above plans be adopted in order to improve its Rol for Software Business Division I profit and sales remain the same in the coming year, but the investment turnover increases to 132. calculate the new ROL 14'C Mostly cloudy