Using the FINRA Advanced Bond Search tool (finra-markets.momingstar.com/BondCenter/Screener.jsp?type=advanced), find an AAA-rated noncallable corporate bond with at least

Question:

Using the FINRA Advanced Bond Search tool
(finra-markets.momingstar.com/BondCenter/Screener.jsp?type=advanced), find an AAA-rated noncallable corporate bond with at least 12 years to 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 set to 0 (30/360).
a. Calculate the value of the bond using the PRICE function.
b. Calculate the current yield.
c. Calculate the yield to 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?
Maturity
Maturity is the date on which the life of a transaction or financial instrument ends, after which it must either be renewed, or it will cease to exist. The term is commonly used for deposits, foreign exchange spot, and forward transactions, interest...