Book: Keown, A., Martin, J., & Petty, J. (2011). Foundations of finance (7th ed.). Boston, MA: Prentice Hall. ISBN: 9780136113652 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's managers expect an earnings downturn and a resulting decrease in growth of 3 percent. How does this affect your answers to parts A and B? What required rates of return would make you indifferent to all three options?