could you please follow the steps

2- Using excel calculate the duration of a Twenty -year bond with a face value of $1,000 and a coupon rate of 11%. Assume that the current interest rates are 9%. What will your answer be if the current interest rates fall to 8%? Show all your calculations. t CR FV t CF PV OFCF weight t*(pv of bond price 1 2 3 Total 0.00 0.0 0.00 3. Using the data provided in the previous problem, calculate the percentage change in price difference using the duration formula