Need to use excel or Matlab:

1 Interest Rates 1 Let's suppose that there is a coupon bond that sells for 90 cents on the dollar that has 10 years left to maturity with a coupon rate of 10%. You will need to use excel or matlab to solve the problems below. 1. What is the yield to maturity of this bond? 2. Suppose instead a perpetuity that has no maturity but constant fixed payments of 10 cents forever. Suppose that the price of this bond is 90 cents. What is the yield to maturity of this bond? Is it a good enough approximation for the yield to maturity of the 10 year bond? Why? 3. Suppose that there is an alternative bond with a shorter time to maturity (5 years) with a coupon rate of 5%. If investors do not care about maturity but only care about rates of return i.e., no arbitrage in the bond market), what would be the price of the 10 year bond? Is it greater/smaller than the 10 year bond? Explain intuitively. 4. Suppose that the yield to maturity goes down across the board to, say, 4%. What would be the rate of change in the price of the 30 year bond? What about the 10 year bond? Which bond price is more sensitive to interest rate changes and why