Please answer the following questions using Excel and submit your assignment $($Excel file$)$ via

Canvas. You can work in groups of three on the case assignments $($please write the names of all

group members$).$

$1)$ This is your first week as an analyst at a mutual fund. Your boss asked you to evaluate the

price risk of two $30-$year bonds, Bonds A and B$.$ You must complete the following tasks

to prepare a report by $3/19/2024(11$:$59$ p$.$m$.).$

Bond A has a coupon rate of $4\%,$ while bond B has a coupon rate of $13\%.$ Both bonds pay

their coupons semi$-$annually