1. You are considering the following bonds to include in your portfolio: Bond 1 Bond 2 $900.00 $1,100.00 $1,000.00 $1,000.00 7.00% 10.00% 1 15 2 20 8.00% 9.00% Price Face Value Coupon Rate Frequency Maturity (Years) Required Return a. Determine the highest price you would be willing to pay for each of these bonds using the PV function. Also find whether the bond is undervalued, overvalued, or fairly valued. b. Determine the yield to maturity on these bonds using the RATE function assuming that you purchase them at the given price. Also determine the current yield of each bond. c. Determine the yield to call of each bond using the RATE function if the time to first call and the call premium are the following: Bond 1 Bond 2 3.00% 4.00% 5 Bond 3 $1,000.00 $1,000.00 9.00% 4 30 9.00% Call Premium % Years to first call d. Assume the following settlement dates for each bond: Bond 1 Settlement Date 1/1/2012 Bond 2 6/1/2012 Bond 3 15.00% 3 Bond 3 9/1/2012

1. You are considering the following bonds to include in your portfolio: a. Determine the highest price you would be willing to pay for each of these bonds using the PV function. Also find whether the bond is undervalued, overvalued, or fairly valued. b. Determine the yleld to maturity on these bonds using the RATE function assuming that you purchase them at the given price. Also determine the current yield of each bond. c. Determine the vield to call of each bond using the RATE function if the time to first call and the call premium are the following