Please help me to calculate the yellow cells.

2.550% Notes due 2060 ("2060 Notes") Pricing a Corporate Bond Face Value of Bond = Coupon Rate on Bond = Frequency of coupons = Timeto Maturity = Yield to Maturity (APR) on Bond = rate=r=YTM=APR nper=T* n pmt =C Price of Bond using formula= price of bond using Excel Estimating Price given Yield to Maturity price of bond as input solve for YTMusing excel YTM =rn EAY =(1+r)n1 EAY in execl To solve for yield to maturity, given price, do the following: 1. Open the solver in Data tab (ifyou do not have solver there, you need to add it as an add-in) 2. Set the value of cell C9 equal to the current price 3. Run the solver 4. Yield to maturity will show up in cell C7 2.550% Notes due 2060 ("2060 Notes") Pricing a Corporate Bond Face Value of Bond = Coupon Rate on Bond = Frequency of coupons = Timeto Maturity = Yield to Maturity (APR) on Bond = rate=r=YTM=APR nper=T* n pmt =C Price of Bond using formula= price of bond using Excel Estimating Price given Yield to Maturity price of bond as input solve for YTMusing excel YTM =rn EAY =(1+r)n1 EAY in execl To solve for yield to maturity, given price, do the following: 1. Open the solver in Data tab (ifyou do not have solver there, you need to add it as an add-in) 2. Set the value of cell C9 equal to the current price 3. Run the solver 4. Yield to maturity will show up in cell C7