Using Excel answer the following:

1) Assume that you are looking to buy bonds with a face value of $1,000 and a 6.5% coupon rate

(coupons paid semi-annually). Create a table in Excel showing the price of the bonds for different

levels of required yield to maturity (from 1% to 10% at 0.5% interval) and different lengths of time

to maturity (5 year, 10 year, and 30 year).

2) Using the data from your model in #1 above, create a line chart to show the prices visually.