Exactly 10 years ago, your dad purchased 100 30-yr ABC bonds and 50 20-yr XYZ bonds. The

coupon rate on bond ABC is 10% and the coupon rate on bond XYZ is 7%. Coupons are paid

semi-annually. The bonds face value is $1,000. Today is the 25th of September 2021.

a)How much money should your dad have paid originally for these bonds assuming he

purchased them at PAR.

b)What is the market value of your dad's investments if the market interest rate is 10%

c)If interest rates were to increase by 1% (i.e.: the new rate = 11%) how much will your

dad lose on ABC bonds?

d)If interest rates increase by 1% (i.e.: the new rate = 11%) how much will your dad lose on

XYZ bonds?

e)If interest rates increase by 1% (i.e.: the new rate = 11%) how much will your dad lose in

total on both ABC and XYZ bonds?

f)If interest rates decrease by 1% (i.e.: the new rate = 9%) how much will your dad gain on

ABC bonds?

g)If interest rates decrease by 1% (i.e.: the new rate = 9%) how much will your dad gain on

XYZ bonds?

h)If interest rates decrease by 1% (i.e.: the new rate = 9%) how much will your dad gain in

total on both ABC and XYZ bonds?

i)Which bond has higher sensitivity to interest rates fluctuations (support your answer with

numbers)?

j)On the same Excel sheet, draw bond ABC and XYZ price as the YTM moves from 1% to

30% (in 1% increments)