Here are data on $1,000 par value bonds issued by Microsoft, GE Capital, and Morgan Stanley at the end of 2012. Assume you are thinking about buying these bonds. Answer the following questions:

1. Assuming interest is paid annually, calculate the values of the bonds if your required rates of return are as follows: Microsoft, 6%; GE Capital, 8%; and Morgan Stanley, 10%, where

	Microsoft	GE Capital	Morgan St
Coupon Rate	7.25%	4.25%	4.75%
YTM	30	10	5

(Please show detailed Excel Formulas for each answer.)

2. At the end of 2012, the bonds were selling for the following amounts: a. Microsoft $1,100 b. GE Capital $1,030 c. Morgan Stanley $1,015 What were the expected rates of return for each bond? (Please show detailed Excel Formulas for each answer.)

3. Identify which bonds are premium bonds and which bonds are discount bonds.

4. How would the value of the bonds change if your required rate of return (1) increased 2 percentage points or (2) decreased 2 percentage points? 4. Should you buy the bonds? Explain. (Please show detailed Excel Formulas for each answer.)