Review the financial information in the Chapter 8 Mini Case on page 232 of your text. Answer the following questions in an Excel document. Solve using Excel formulas (preferred) or clearly write out the steps you took to calculate your answers. Round any dollar amounts to the nearest dollar ($1,500,074) and any percentages to two decimals (9.56%). Calculate the value of each investment based on your required rate of return. Which investment would you select? Why? Assume Emerson Electric