Consider the following newly issued bonds$-$a coupon$-$bearing bond, a zero$-$coupon bond, and a perpetuity.

Required:

Using any necessary data above, calculate the Macaulay Duration of each bond. Then, use the Macaulay Duration to solve for the

Modified Duration.Consider the following newly issued bonds $-$ a coupon$-$bearing bond, a zero$-$coupon bond, and a perpetuity.

Required:

Note: Use cells A$2$ to B$12$ from the given information to complete this question.

Using any necessary data above, calculate the Macaulay Duration of each bond. Then, use the Macaulay

Duration to solve for the Modified Duration.