can you please do these in excel

1. The 8 percent, $1,000 face value bonds of Glenmore Foods are currently selling at $1,027. These bonds have 16 years left until maturity. What is the current yield?

		7.71 percent
		7.79 percent
		8.00 percent
		8.23 percent
		8.28 percent

2. Keyser Materials has 8 percent coupon bonds on the market with 19 years to maturity. The bonds make semiannual payments and currently sell for 102 percent of par. What is the current yield on Keyser Materials bonds? The YTM? The effective annual yield?

		7.84 percent; 7.80 percent; 7.95 percent
		7.84 percent; 7.92 percent; 7.95 percent
		7.84 percent; 7.92 percent; 7.97 percent
		7.80 percent; 7.84 percent; 7.92 percent
		7.80 percent; 7.92 percent; 7.95 percent