Kindly use Microsoft Excel to generate the answers at below.

Question 8

a. Shelly Inc. bonds have a 6 percent coupon rate. The interest is paid semiannually, and the bonds mature in 8 years. Their par value is $1,000. If your required rate of return is 4 percent, what is the value of the bond? What is the value if the interest is paid annually?

b. Sharp Co. bonds are selling in the market for $1,045. These 15-year bonds pay 7 percent interest annually on a $1,000 par value. If they are purchased at the market price, what is the expected rate of return? Determine the expected rate of return if coupon payment is paid semi-annually?