I need an answer to the last part of the attached file as well as a review of my answers

Thanks

Name ____ Interest Rates and Bond Valuation Worksheet Part I: Go to the Federal Reserve's Web site to examine historical monthly interest rates on 10-year government bonds at http://www.federalreserve.gov/releases/h15/data/Monthly/H15_TCMNOM_Y10.txt (Historical data on other selected interest rates can be accessed via http://www.federalreserve.gov/releases/h15/data.htm) and answer the following questions: A. What was the nominal rate on 10-year U.S. Treasury bonds at each of the following? dates: 1. At 04/1954: _2.29_______ 2. At 09/1976: _7.59_______ 3. At 09/1981: _15.32_______ 4. For the Latest Month: _2.65_______ B. Assume that a $1000 U.S. Treasury bond was purchased at par on each of first three dates above. Also assume that for each of the three bonds the reported nominal rate that you found above was the coupon rate at issuance. Assuming semi-annual coupon payments, calculate the value of each bond after 5 years based on the then 5-year nominal rates on U.S. Treasuries available at http://www.federalreserve.gov/releases/h15/data/Monthly/H15_TCMNOM_Y5.txt to determine the gain or loss on each of the three bonds after 5 years? 1. At 04/1959: _4.12_______ 2. At 09/1981: _15.93_______ 3. At 09/1986: __6.92______ Which bond would you have preferred to purchase? 04/1954? _1.87_______ 09/1976? _7.13_______ 09/1981? _15.93_______ Why? I would purchase the 09.1981 at 15.93% because it is contains the highest rate for the most gain. Part II: According to the textbook's discussion, the Fisher Equation can be expressed as Nominal Interest Rate Real Rate + Expected Inflation. The textbook further explains that the nominal interest rate on any financial instrument is a function of not only the real rate and expected future inflation, but also interest rate risk, default risk, taxability, and the lack of liquidity. Using again the Federal Reserve's historical data on interest rates at http://www.federalreserve.gov/releases/h15/data.htm, find the following rates recorded for the latest month? Federal Funds 4-Week Treasury bills 6-Month Treasury bills 10-Year Treasury bonds 20-Year Treasury bonds 30-Year Treasury bonds Moody's seasoned1 Corporate Bonds Aaa Baa _0.20______ _0.14_______ __0.18______ __2.50______ __3.41______ __3.74______ _4.58_______ _5.61_______ Provide in the space below an explanation for the determination of the latest monthly rate on Moody's seasoned corporate bonds rated Baa based on the above rates and the factors that determine nominal interest rates. 1 \"Moody's Bond Yields Series are based on seasoned bonds with remaining maturities of at least 20 years...from pricing data on a regularly-replenished population of nearly 90 seasoned corporate bonds in the US market, each with current outstandings over $100 million. The bonds have maturities as close as possible to 30 years,...they are dropped from the list if their remaining life falls below 20 years or if their ratings change.\" Source: http://www.globalfinancialdata.com/index.php3?action=detailedinfo&id=3319#metadata