Assuming we are at the end of year 2018. Here are data on $1,000 par value bonds issued by Microsoft, GE Capital, and Morgan Stanley. You work at an investment firm and are thinking about updating your bond portfolio. Answer the following questions:

1. Assuming coupons are paid annually, calculate the intrinsic values of the bonds if your required rates of return for Microsoft, GE Capital, and Morgan Stanley are 6%, 8%, and 10%, respectively. The coupon rates for those bonds are as follows:

2. At the end of 2018, you observed the bonds prices are as follows:
   1. Microsoft $1,100
   2. GE Capital $1,030
   3. Morgan Stanley $1,015

If you purchase those bonds at their corresponding prices, what will be the expected rates of return?

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

4. What would be the values of the bond if your required rate of return (1) increased 2% or (2) decreased 2%? Should you buy the bonds? Explain.

PLEASE demonstrate the detailed calculations (the formula you put in, the variables you key in the financial calculator)

PLEASE (((((NOT))))) the way you input the variables in Excel

Thank you!

Coupon rate Maturity Microsoft GE capital Morgan Stanley 7.25% 4.25% 4.75% 30 10 5 Coupon rate Maturity Microsoft GE capital Morgan Stanley 7.25% 4.25% 4.75% 30 10 5