I need help filling in the information in the excel spreadsheets, please show the formulas used to obtain the answers in a excel spreadsheet and set up the spreadsheet as the attached spreadsheets are set up, the initial question is below in the first doc, leave a comment if you have any questions,thank you

Times New Paste Clipboard Font E25 X A B C D E F G a. Duration b. Price at 5.0% B A B YTM Coupon Par Start 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 Price @ 5.0%5. You have two (2) bonds with the following characteristics: Characteristics Bond A Bond B Coupon 2.0% 3.0% Yield to Maturity 4.3114% 4.6467% Years to Maturity 8 9 Par Value $1,000 $1,000 Price $845.00 $880.00 a. What are the bond durations? b. If rates rise to 5.00%, what are the new prices for each bond