1. Using the FINRA Advanced Bond Search tool (finra-markets.morningstar.com/BondCenter/Screener.jsp?type=advanced), find a AA to AAA-rated noncallable corporate bond with at least 12 years to maturity. Click the link to get more detailed information on your bond, and then set up a worksheet to answer the following questions. Note that because we are using corporate bonds, the basis should be 0 (30/360). a. Calculate the value of the bond using the PRICE function. b. Calculate the current yield. Calculate the yield to maturity using the YIELD function. d. Calculate the duration of the bond using the DURATION function, and the modified duration using MDURATION. If interest rates rise by 1%, how much will the price change? c. 1. Using the FINRA Advanced Bond Search tool (finra-markets.morningstar.com/BondCenter/Screener.jsp?type=advanced), find a AA to AAA-rated noncallable corporate bond with at least 12 years to maturity. Click the link to get more detailed information on your bond, and then set up a worksheet to answer the following questions. Note that because we are using corporate bonds, the basis should be 0 (30/360). a. Calculate the value of the bond using the PRICE function. b. Calculate the current yield. Calculate the yield to maturity using the YIELD function. d. Calculate the duration of the bond using the DURATION function, and the modified duration using MDURATION. If interest rates rise by 1%, how much will the price change? c