fill out rest of table please

3. (15 Points) You are given the following data for a set of coupon bonds with different maturity dates in the table below. Also assume the current interest rate (YTM) is 10%, the Face Value of each bond is 51000 , and the coupon rate is 10%. The current price is in the table. Fill in the remaining columns using the information below. Now assume the interest rate (YTM) increases to 12\%. Determine the Price of the bond next period for each bond (UPDATE "N" ONE YEAR). Determine the Rate of Capital Gain or Loss for each bond. Determine the Rate of Return for each bond. (FILL IN THE TABLE). Show your work for the 30-year bond and 20 -year bond for the last 3 columns. NOT how you entered the information into your calculator or an Excel file