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 25^th of September 2021.

1. How much money should your dad have paid originally for these bonds assuming he purchased them at PAR. (1pt)
2. What is the market value of your dad's investments if the market interest rate is 10%? (5pt)
3. If interest rates were to increase by 1% (i.e.: the new rate = 11%) how much will your dad lose on ABC bonds? (3.5pt)
4. If interest rates increase by 1% (i.e.: the new rate = 11%) how much will your dad lose on XYZ bonds? (3.5pt)
5. 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? (1pt)
6. If interest rates decrease by 1% (i.e.: the new rate = 9%) how much will your dad gain on ABC bonds? (3.5pt)
7. If interest rates decrease by 1% (i.e.: the new rate = 9%) how much will your dad gain on XYZ bonds? (3.5pt)
8. 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? (1pt)
9. Which bond has higher sensitivity to interest rates fluctuations (support your answer with numbers)? (3pt)
10. On the same Excel sheet, draw bond ABC and XYZ price as the YTM moves from 1% to 30% (in 1% increments). (5pt)