1. You are considering the following bonds to include in your portfolio: Price Face Value Coupon Rate Frequency Maturity (Years) Required Return Bond 1 Bond 2 Bond 3 $900.00 $1,100.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 7.00% 10.00% 9.00% 2 4 15 20 30 9.00% 8.00% 9.00% 1 a) Determine the price you would be willing to pay for each of these bonds using the PV function. b) Compare the price calculated in a) with the price stated in the chart above for each bond. State whether the bond is fairly priced, overpriced or underpriced. c) Determine the yield to maturity or (effective rate) on these bonds using the RATE function assuming that you purchase them at the price (per the chart above)