I need help with my homework. Please find attached my problem I need help with.

Bond Valuation A 20-year, 8% semiannual coupon bond with a par value of $1,000 sells for $1,100. (Assume that the bond has just been issued.) Basic Input Data: Years to maturity: Periods per year: Periods to maturity: Coupon rate: Par value: Periodic payment: Current price 20 2 8% $1,000 $1,100 a. What is the bond's yield to maturity? Peridodic YTM = Annualized YTM = b. What is the bond's current yield? Current yield = Current yield = Current yield = Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) / c. What is the bond's capital gain or loss yield? Cap. Gain/loss yield = Cap. Gain/loss yield = Cap. Gain/loss yield = - Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) d. What would be the price of the bond if market interest rates change to: Nominal market rate, r: Value of bond : 12% 6% 10%