want the answer in excel sheet. (Typed)

Everything is as clear as mirror.

a. Given the above characteristics compute the price of each bond. Assume that coupns are paid once annually.

b. Represent, on a graph, the price-yield relationship for each bond for values of the yield varying from 0.5% to 12.00%. What do you observe? In other words, discuss the effect of the coupon rate and the maturity on the price-yield relationship. Do you observe anything else?

Bond 1

Bond

2 1000

Bond 3

Bond

6

Bond 7

Bond

8

Bond

9

4

1000

1000

1000

1000

1000

1000

1000

8%

8%

5%

5%

5%

0%

0%

0%

Face 1000

Value Coupon

8%

Rate

Yield Maturity 15

6%

6%

6%

6%

6%

6%

6%

6%

6%

10

5

15

10

5

15

10

5

Q1. You observe the following bonds a. Given the above characteristics compute the price of each bond. Assume that coupns are paid once annually. b. Represent, on a graph, the price-yield relationship for each bond for values of the yield varying from 0.5% to 12.00%. What do you observe? In other words, discuss the effect of the coupon rate and the maturity on the price-yield relationship. Do you observe anything else? Q1. You observe the following bonds a. Given the above characteristics compute the price of each bond. Assume that coupns are paid once annually. b. Represent, on a graph, the price-yield relationship for each bond for values of the yield varying from 0.5% to 12.00%. What do you observe? In other words, discuss the effect of the coupon rate and the maturity on the price-yield relationship. Do you observe anything else