hey kindly provide excel calculations

Lymn Parsons is considering investing in cilher of two outstanding bonds. The bonds both have $1.000 par values and 114 coupon interest rater and pay anrital interest. Bond A has exactly 5 years to maturity, and bond B has 15 years to matiurity. Complefe the steps below using cell references ro given data or pravious calculations. Th some cases, a sinnle cell reference is ail yos reed. To copy'paste a formwla across a row or donin a coltann, an absolufe cell reference ar a mited cell reference miny be prefemed. If a speciffe Excil direfed, we the eapliest appearance of the daka in your formulas, usually the Given Data section To Do 9. Calculate the valse of bond A if the requared retum is (1) 8%, (2) 1196, and (3) 14%. b. Calculate the value of bond B if the required return is (1) 8%6, (2) 115 , and (3) 1496 . c. Discuss the relationship between fime to maturity and changing required returns: d. If Lym wanted to minimize interest rate risk, which bond shotild she purchase? a. Calculate the value of bond A if the required retum is (1) 8%, (2) 11%, and (3) 14%. b. Calculate the value of bond B if the required retim is (1)8%, (2) 11%, and (3)14%. Interest Payment c. Discuss the relationship between time to maturity and changing required returns. The table clearly shows that price sensitivity to changes in interest mes as the years to maturity increase. d. If Lym wanted to minimize interest rate risk, which bond should she purchase? If Lynn wants to minimize interest rate risk. she should choose the Requirements 1 In cell D21, by using cell references, calculate the interest payment for any of the bonds. 2. In cell D24, by using cell references and the function PV, calculate the value of Bond A for the required retum of $%. d. If Lyan wanted to minimize inferest rate risk, which bond should she purchase? If Lynu wants to minimize interest rate risk, she should choose the