How to solve in excel

1.[EXCEL] Bond price: BA Corp is issuing a 10-year bond with a coupon rate of 8 percent. The interest rate for similar bonds is currently 6 percent. Assuming annual payments, what is the value of the bond?

2.[EXCEL] Bond price: Pierre Dupont just received a cash gift from his grandfather. He plans to invest in a five-year bond issued by Venice Corp. that pays an annual coupon rate of 5.5 percent. If the current market rate is 7.25 percent, what is the maximum amount Pierre should be willing to pay for this bond?

3.[EXCEL] Bond price: Knight, Inc., has issued a three-year bond that pays a coupon rate of 6.10 percent. Coupon payments are made semiannually. Given the market rate of interest of 5.80 percent, what is the market value of the bond?

4.[EXCEL] Bond price: Regatta Inc. has seven-year bonds outstanding that pay a 12 percent coupon rate. Investors buying these bonds today can expect to earn a yield to maturity of 8.875 percent. What is the current value of these bonds? Assume annual coupon payments.

5.[EXCEL] Bond price: You are interested in investing in a five-year bond that pays a 7.8 percent coupon rate with interest to be received semiannually. Your required rate of return is 8.4 percent. What is the most you would be willing to pay for this bond?

6.[EXCEL] Zero coupon bonds: Diane Carter is interested in buying a five-year zero coupon bond with a face value of $1,000. She understands that the market interest rate for similar investments is 9 percent. Assume annual coupon payments. What is the current value of this bond?

7.[EXCEL] Zero coupon bonds: Ten-year zero coupon bonds issued by the U.S. Treasury have a face value of $1,000 and interest is compounded semiannually. If similar bonds in the market yield 10.5 percent, what is the value of these bonds?

8.[EXCEL] Zero coupon bonds: Northrop Real Estate Company management is planning to fund a development project by issuing 10-year zero coupon bonds with a face value of $1,000. Assuming semiannual compounding, what will be the price of these bonds if the appropriate discount rate is 14 percent?

9.[EXCEL] Yield to maturity: Ruth Hornsby is looking to invest in a three-year bond that makes semiannual coupon payments at a rate of 5.875 percent. If these bonds have a market price of $981.13, what yield to maturity and effective annual yield can she expect to earn?

10.[EXCEL] Yield to maturity: Rudy Sandberg wants to invest in four-year bonds that are currently priced at $868.43. These bonds have a coupon rate of 6 percent and make semiannual coupon payments. What is the current market yield on this bond?

11.[EXCEL] Realized yield: Josh Kavern bought 10-year, 12 percent coupon bonds issued by the U.S. Treasury three years ago at $913.44. If he sells these bonds, for which he paid the face value of $1,000, at the current price of $804.59, what is his realized yield on the bonds? Assume similar coupon-paying bonds make annual coupon payments.

12.[EXCEL] Realized yield: Four years ago, Lisa Stills bought six-year, 5.5 percent coupon bonds issued by the Fairways Corp. for $947.68. If she sells these bonds at the current price of $894.52, what will be her realized yield on the bonds? Assume similar coupon-paying bonds make annual coupon payments.