Use Excel

Bond P is a premium bond with a 9 percent coupon. Bond D is a 5 percent coupon 9 bond currently selling at a discount. Both bonds make annual payments, have a YTM of 7 percent, and have five years to maturity. What is the current yield for Bond P? For Bond D? If interest rates remain unchanged, what is the expected capital gains yield over the next year for Bond P? For Bond D? What is the holding period return for each bond? Explain your answers and the interrelationship among the various types of yields