Consider the following:

Bond A	Bond B
Term to Maturity: 10 years from today	Term to Maturity: 20 years from today
Face Value: $1,000	Face Value: $1,000
Coupon Rate: 10% annual coupons	Coupon Rate: 10% annual coupons
Repayment of Face Value: On last coupon date	Repayment of Face Value: On last coupon date

1) Assume discount rate is 10%. Use the PV function to calculate the prices for these two bonds.

2) Make a Data Table to compare the bond prices when discount rate varies from 1% to 20% incrementing by 1%.

3) Is the longer-term bond's price more sensitive to changes in discount rate? Make a connected scatter chart with both series of bond prices calculated above in the same chart and explain it in a textbox by comparing the slopes.