please do in excel

1. Calculate the value of a bond that will mature in 20 years. The annual coupon interest rate is 7.75%, and the investor's required rate of return is 8.25%. 2. You own a bond that pays 12% in annual coupon interest. It matures in 15 years. Calculate the value of the bond if your required rate of return on the bonds is (a) 8%, (b) 12%, and () 15%, respectively. 3. Assume the market price of a 5-year bond for Margaret Inc. is $900. The bond has an annual coupon interest rate of 6%. What is the bond's expected rate of return (Yield to Maturity)? 4. National Steel 15-year bonds pay 8% coupon interest annually. a. The market price of the bonds is $1,085. Compute the bond's expected rate of return (Yield to Maturity). b. Your required rate of return is 10%. Determine the value of the bond to you. c. Should you purchase the bond? Why? 1. Calculate the value of a bond that will mature in 20 years. The annual coupon interest rate is 7.75%, and the investor's required rate of return is 8.25%. 2. You own a bond that pays 12% in annual coupon interest. It matures in 15 years. Calculate the value of the bond if your required rate of return on the bonds is (a) 8%, (b) 12%, and () 15%, respectively. 3. Assume the market price of a 5-year bond for Margaret Inc. is $900. The bond has an annual coupon interest rate of 6%. What is the bond's expected rate of return (Yield to Maturity)? 4. National Steel 15-year bonds pay 8% coupon interest annually. a. The market price of the bonds is $1,085. Compute the bond's expected rate of return (Yield to Maturity). b. Your required rate of return is 10%. Determine the value of the bond to you. c. Should you purchase the bond? Why