I need help to solve it. Also, I need the answer in excel doc with question you use. thanks

Consider an A-rated bond maturing in 6- years with $100M face value and an 8% coupon rate. The first coupon payment is one year from now. This is different from the example we did in class where we assumed that the first payment would be paid out immediately. Download the spreadsheet FIN5600_Assignment4_Data.xls from Moodle. The spreadsheet contains information on credit migration for an A-rated bond, the risk-free rate and the spreads. The migration numbers indicate that for all A-rated bonds trading in the beginning of last year, where did they end up at the end of the year. For example, 2 bonds that were trading as A-rated in the beginning of the year were downgraded to a CCC rating at the end of the year. (Note: For this assignment, you can assume that the yield curve is flat.) The recovery rate for the bond in case of default is 50%. Step I: Assuming that the bond retains its current credit rating for the remainder of its life, calculate the duration and convexity of the bond. A. Assuming a 0.5%(50bps) increase in interest rates, what would be the percentage change in the price of the bond (ignoring the correction for convexity)? (10 points) B. What would be the percentage change in the price of the bond when you incorporate both duration and convexity? (10 points) Step II: Using the migration numbers in the spreadsheet calculate the migration (transition) probabilities. (10 points) Step III: Using the migration probabilities calculate the expected price of the bond. Consider an A-rated bond maturing in 6- years with $100M face value and an 8% coupon rate. The first coupon payment is one year from now. This is different from the example we did in class where we assumed that the first payment would be paid out immediately. Download the spreadsheet FIN5600_Assignment4_Data.xls from Moodle. The spreadsheet contains information on credit migration for an A-rated bond, the risk-free rate and the spreads. The migration numbers indicate that for all A-rated bonds trading in the beginning of last year, where did they end up at the end of the year. For example, 2 bonds that were trading as A-rated in the beginning of the year were downgraded to a CCC rating at the end of the year. (Note: For this assignment, you can assume that the yield curve is flat.) The recovery rate for the bond in case of default is 50%. Step I: Assuming that the bond retains its current credit rating for the remainder of its life, calculate the duration and convexity of the bond. A. Assuming a 0.5%(50bps) increase in interest rates, what would be the percentage change in the price of the bond (ignoring the correction for convexity)? (10 points) B. What would be the percentage change in the price of the bond when you incorporate both duration and convexity? (10 points) Step II: Using the migration numbers in the spreadsheet calculate the migration (transition) probabilities. (10 points) Step III: Using the migration probabilities calculate the expected price of the bond