please show steps on excel if you using excel

A zero-coupon bond has a pas value of $1,000 and a yeld-to-raturity of 7 K. You purchase the bond when it has exactly 14 years remaining until maturity. You hold the bond for 6 months and then sollitit if the bond's vicld to maturity is 9 ss when you sell it, what is your percentage return over this 6 -menth hoiding period? When computing bond prices. use a semi-anrual compounding period. Enter your answer as a decimal and shiow 4 decimal places for example. if your anawer is 6.25x enter 0625. A 7$6 covpon bond has a par value of $1,000 and a yield to maturity of 956 . You purchase the bond when it has exactly 18 years remainisg until maturity. You hold the bond for 6 months, collect the coupon payment, and then sell the bond immediately. If the bond's yleld-ta-maturity is os when you sell it, what is your percentage return over this 6 - month Type vour answer. A 78 coupon bond has a parvalue of $1,000 and a yield to-maturity of 7,136 . You purchase the bond when it has exacth 18 years remaining until maturi ty. You hold the bond for 6 months, collect the coupon payment, and then sell the bond immediately. if the bond s yield to maturity doesritchange between the time you buy and sell the bond. what is. your percentage returnover this o-mooth holding period? Eriter your answer as a decimal and stow 4 decimal places. For exaciple it your answer is 6.25%, enter .0625. Type vosur ancwor