1. Basics Company is evaluating three investment alternatives to replace aging machinery in their production area. The initial investment and annual cash flow amounts for the projects are in the spreadsheet. Basics weighted average cost of capital (discount rate) is 10%. Required: a. Show calculations for net present value, internal rate of return, residual income, and return on investment for each of the projects. Perform the calculations in the spreadsheet using formulas as much as possible. b. Which, if any, of the projects will be the best alternative for Basics? Explain your reasoning