Please answer in excel format, WILL GIVE THUMBS UP

lain Co. has 6 percent coupon bonds with the following characteristics on the market that sell for $1,083. The company wants to issue a new bond with the same characteristics for some much-needed expansion projects. (Hints: You would get required rate of returns for the new bond issue from the old bond issue) Settlement date 1/1/20 00 1/1/20 18 Maturity date Annual coupon rate 6.0% Bond price 1,083. 00 I 1/1/20 11 Next call date: a. What is the yield to maturity of the bond? What coupon rate should the company set on its new bonds if it wants them to sell at par? b. Please explain the rationale behind the coupon rate the company set on c. What is the effective annual yield of the new bond? d. Now assume that the bond is callable on January 01, 2011. i. What is the yield to call? ii. What is the expected call premium in dollar? lain Co. has 6 percent coupon bonds with the following characteristics on the market that sell for $1,083. The company wants to issue a new bond with the same characteristics for some much-needed expansion projects. (Hints: You would get required rate of returns for the new bond issue from the old bond issue) Settlement date 1/1/20 00 1/1/20 18 Maturity date Annual coupon rate 6.0% Bond price 1,083. 00 I 1/1/20 11 Next call date: a. What is the yield to maturity of the bond? What coupon rate should the company set on its new bonds if it wants them to sell at par? b. Please explain the rationale behind the coupon rate the company set on c. What is the effective annual yield of the new bond? d. Now assume that the bond is callable on January 01, 2011. i. What is the yield to call? ii. What is the expected call premium in dollar