Using the Bond Screener at the Yahoo! Finance Web site (http://

bonds.yahoo.com/search.html), find a AAA rated corporate bond with at least 12 years to maturity. Click the link to get more detailed information on your chosen bond, and then set up a worksheet to answer the following questions. Note that since we are using corporate bonds, the basis should be set to 0 (30/360).

a. Using the coupon rate, settlement date, maturity date, and the given yield to maturity, calculate the value of the bond using the PRICE function.

b. Using the coupon rate, settlement date, maturity date, and the given price of the bond, calculate the current yield.

c. Using the coupon rate, settlement date, maturity date, and the given price of the bond, calculate the yield to maturity using the YIELD function. L01