You have two bonds with the following characteristics

Characteristics	Bond A	Bond B
Coupon	5.0%	5.2%
Years to Maturity	7	7
Par Value	$1,000	$7,000
Price	$788.00	$811.00

Please answer the following 2 questions by filling in the excel sheet posted and show formulas for your answer

Question A) What are the bond durations?

Question B).If rates rise to 5.75%, what are the new prices for each bond?

a. Duration A B B b. Price A YTM Coupon Par Purchase price 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 Price @5.75% a. Duration A B B b. Price A YTM Coupon Par Purchase price 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 Price @5.75%