Financial Management

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%).
Mini Case
You have finally saved $10,000 and are ready to make your first investment. You have the three following alternatives for investing that money:
•Capital Cities ABC, Inc. bonds with a par value of $1,000, that pays an 8.75 percent on its par value in interest, sells for $1,314, and matures in 12 years.
•Southwest Bancorp preferred stock paying a dividend of $2.50 and selling for $25.50.
•Emerson Electric common stock selling for $36.75, with a par value of $5. The stock recently paid a $1.32 dividend and the firm- earnings per share has increased from $1.49 to $3.06 in the past five years. The firm expects to grow at the same rate for the foreseeable future.
Your required rates of return for these investments are 6 percent for the bond, 7 percent for the preferred stock, and 15 percent for the common stock. Using this information, answer the following questions.
a.Calculate the value of each investment based on your required rate of return.
b.Which investment would you select? Why?
c.Assume Emerson Electric- 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?
I need all calculations for each response