excel work process

1. Firm A's outstanding bonds have a $1,000 face value, and they mature in 12 years. Their yield to maturity is 8.56%, they pay interest semiannually, and they sell at a price of $835. What is the bond's coupon rate? 2. Firm B has a 17-year, 6.6 percent annual coupon bond outstanding with a $1,000 par value. The bond has a yield to maturity of 8.1 percent. What is the \% price change if the yield suddenly increases to 9.3 percent? 3. Firm C's bonds have a face value of $1,000 and are currently sold for 78.6% of the par. The bonds have a 5.7 percent coupon rate. What is the current yield on these bonds? 4. Firm D's zero-coupon bonds have a market price of $432.87, a face value of $1,000, and a yield to maturity of 7.26 percent. How many years is it until these bonds mature? (Hint: use semiannual in your calculation.) 1. Firm A's outstanding bonds have a $1,000 face value, and they mature in 12 years. Their yield to maturity is 8.56%, they pay interest semiannually, and they sell at a price of $835. What is the bond's coupon rate? 2. Firm B has a 17-year, 6.6 percent annual coupon bond outstanding with a $1,000 par value. The bond has a yield to maturity of 8.1 percent. What is the \% price change if the yield suddenly increases to 9.3 percent? 3. Firm C's bonds have a face value of $1,000 and are currently sold for 78.6% of the par. The bonds have a 5.7 percent coupon rate. What is the current yield on these bonds? 4. Firm D's zero-coupon bonds have a market price of $432.87, a face value of $1,000, and a yield to maturity of 7.26 percent. How many years is it until these bonds mature? (Hint: use semiannual in your calculation.)