SOLVE USING EXCEL, BOND VALUATION !!!

$20=fx Todayis May 1, 2023. are currently priced at $880. The coupen en the bonds is 2.5W and the bonds have a face value of $1000. 1. What is the yeld to maturity for an investor who purchases the bonds today? 2. What is the capial gains yield for an investor who purchayes the bonds today? Assume now that the bonds pay interest annually. Recalculate your VTM with that assumption as you willi need that for the following 3. Calculate the modfied duration for the bondx. Calculate what would happen to the price of the bonds If interest rates increased by 0.5% immediately (today). Recalculate the price with the new YTM. Compare that to the price change that duration 12 would predict. Why are they different? $20=fx Todayis May 1, 2023. are currently priced at $880. The coupen en the bonds is 2.5W and the bonds have a face value of $1000. 1. What is the yeld to maturity for an investor who purchases the bonds today? 2. What is the capial gains yield for an investor who purchayes the bonds today? Assume now that the bonds pay interest annually. Recalculate your VTM with that assumption as you willi need that for the following 3. Calculate the modfied duration for the bondx. Calculate what would happen to the price of the bonds If interest rates increased by 0.5% immediately (today). Recalculate the price with the new YTM. Compare that to the price change that duration 12 would predict. Why are they different