I need Help with questions E and F... Please help as soon as possible. thanks!!

3 A 20-year, % semiannual coupon bond with a par value of $1,000 may be called in 5 years at a call price of $1,040. The bond sells for $1,100. (Assume that the bond has just been Issued.) 4 6 Basic Input Data Years to maturity 8 Perlods per year 9 Perlods to maturity: 10 Coupon rate: 11 Par value: $1,000 12 Periodic payment: 13 Current price 14 Call price 15 Years till callable: 16 $1,100 $1,040 18 a. What is the bond's yleld to maturity? 19 3.53% 21 Annualized Nominal YTM = %] Hint: This is a nominal rate, not the effective rate. Nominal rates are generally quo 24 25 b. What is the bond's current yleld? 26 Current yleld Current yleld Current yield Coupon Rate Price of bond Hint: Write formula in words $1,100 Hint: Cell formulas should refer to Input Section 29 30 31 32 c. What is the bond's capital gain or loss yleld? Cap. Galn/loss yieldAnnualized YTM Cap. Galn/loss yield Cap. Galn/loss yleld Current yleld Hnt: wite formula in words 7.06% 7.27% Hint: Cell formulas should refer to Input Section 37 Note that this is an economic loss, not a loss for tax purposes 38 39 d. What Is the bond's yield to call? Here we can again use the Rate function, but with data related to the call 3. 16% Annualized Nominal YTC := This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 46 The YTC is lower than the YTM because it the bond is caled, the buyer will lose the difference between the call price and the current price in 47 just 4 years, and that loss will offiset much of the interest imcome. Note too that the bond is likely to be called and replaced, hence that the 48 YTC will probably be eamed 50 NOW ANSWER THE FOLLOWING NEW QUESTIONS 3 A 20-year, % semiannual coupon bond with a par value of $1,000 may be called in 5 years at a call price of $1,040. The bond sells for $1,100. (Assume that the bond has just been Issued.) 4 6 Basic Input Data Years to maturity 8 Perlods per year 9 Perlods to maturity: 10 Coupon rate: 11 Par value: $1,000 12 Periodic payment: 13 Current price 14 Call price 15 Years till callable: 16 $1,100 $1,040 18 a. What is the bond's yleld to maturity? 19 3.53% 21 Annualized Nominal YTM = %] Hint: This is a nominal rate, not the effective rate. Nominal rates are generally quo 24 25 b. What is the bond's current yleld? 26 Current yleld Current yleld Current yield Coupon Rate Price of bond Hint: Write formula in words $1,100 Hint: Cell formulas should refer to Input Section 29 30 31 32 c. What is the bond's capital gain or loss yleld? Cap. Galn/loss yieldAnnualized YTM Cap. Galn/loss yield Cap. Galn/loss yleld Current yleld Hnt: wite formula in words 7.06% 7.27% Hint: Cell formulas should refer to Input Section 37 Note that this is an economic loss, not a loss for tax purposes 38 39 d. What Is the bond's yield to call? Here we can again use the Rate function, but with data related to the call 3. 16% Annualized Nominal YTC := This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 46 The YTC is lower than the YTM because it the bond is caled, the buyer will lose the difference between the call price and the current price in 47 just 4 years, and that loss will offiset much of the interest imcome. Note too that the bond is likely to be called and replaced, hence that the 48 YTC will probably be eamed 50 NOW ANSWER THE FOLLOWING NEW QUESTIONS