Bond X is a premium bond making semiannual payments. The bond pays a 9 percent coupon, has a YTM of 7 percent, and has 13 years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a 7 percent coupon, has a YTM of 9 percent, and also has 13 years to maturity.

What is the dollar price of each bond? If interest rates remain unchanged, what do you expect the price of these bonds to be one year from now? In 3 years? In 8 years? in 12 years?

**PLEASE PROVIDE THE INPUTS BASED ON THE CELLS USING THE YIELD FORMULA IN EXCEL** (WHICH CELLS NEED TO BE ENTERED INTO THE YEILD EXCEL FORMULA)

Bond X
Coupon rate	9%
YTM	7%			Price of Bond X			Price of Bond Y
Settlement date	1/1/2000			Maturing (years)			Maturing (years)
Maturity date	1/1/2013			13			13
Maturity date	1/1/2012			12			12
Maturity date	1/1/2010			10			10
Maturity date	1/1/2005			5			5
Maturity date	1/1/2001			1			1
Redemption/FV	100
# of coupons per year	2
Bond Y:
Coupon rate	7%
YTM	9%