Consider a $1,000 bond with a fixed-rate 10 percent annual coupon (Cpn %) and a maturity (N) of 30 years. The bond currently is trading to a market yield to maturity (YTM) of 10 percent. Complete the following table.

From Par, $ From Par, %

N Cpn % YTM Price Change in Price. Change in Price

30 10% 9%

30 10% 10%

30 10% 11%

Use the information to verify the three principles of interest rate-price relationships for fixed-rate financial assets. Rule Two: The longer is the maturity of a fixed-income financial asset, the greater is the change in price for a given change in interest rates.

Excel please with formulas showing.