I need help completing this project. Can you look it over for me and give me your opinion.

Final Term Project Directions: Read the following Case and answer all the questions. Please submit your work by midnight Sunday CT. Following is a portfolio consisting of 50 bonds with a market value of $ 99,999,999 as of April 29, 2011: Table 1: 50-bond Portfolio Identifier 003723AA 251591AY 381427AA 58551TAA 912810PW 912810QA 912810QK 912828PA 912828PF 00104BAC 02360XAL 165167BS 125896BG 665772CE 797440BM FGB08000 FGB07001 FGB06402 FGB07002 FGB05403 FGB06003 FGB06004 FGB05011 FNA07098 FNA08000 FNA05402 FNA06402 FNA07002 FNA05003 FNA05403 FNA06003 FNA05010 FNA05011 GNB04411 91311QAD 02051PAC 101137AD 12527GAA 582834AM 651715AF Description ABN AMRO BANK NV DEVELOPERS DIVERS REALTY GOLDMAN SACHS CAPITAL II MELLON CAPITAL IV US TREASURY BONDS US TREASURY BONDS US TREASURY BONDS US TREASURY NOTES US TREASURY NOTES AES EASTERN ENERGY AMERENENERGY GENERATING CHESAPEAKE ENERGY CORP CMS ENERGY NORTHERN STATES PWR MINN SAN DIEGO GAS & ELECTRIC FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FHLM Gold Guar Single F. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr FNMA Conventional Long T. 30yr GNMA II Single Family 30yr UNITED UTILITES PLC ALON REFINING KROTZ BOSTON SCIENTIFC CF INDUSTRIES INC MEAD CORP NEWPAGE CORP Sector Corp. Financials Corp. Financials Corp. Financials Corp. Financials Treasury Treasury Treasury Treasury Treasury Corp. Utilities Corp. Utilities Corp. Utilities Corp. Utilities Corp. Utilities Corp. Utilities MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency MBS Agency Corp. Industrials Corp. Industrials Corp. Industrials Corp. Industrials Corp. Industrials Corp. Industrials Market Value 1,422,596 644,344 2,761,546 3,102,915 804,588 7,505,533 4,048,097 3,378,751 20,596,365 1,206,446 737,343 880,013 1,337,697 907,113 856,840 3,040,911 780,262 1,004,579 4,235,068 1,531,707 1,537,027 700,545 690,585 1,014,899 1,883,297 1,854,853 1,311,433 2,563,939 684,085 3,469,103 1,715,870 843,855 1,173,465 2,509,580 848,272 630,655 1,656,030 1,499,778 787,191 1,603,501 723787AG 749685AQ 784635AM 915436AF 962166AV 45950KBJ 45905CAA 46513E5Y 500769BR 500769CH PIONEER NATURAL RESOURCES RPM INTERNATIONAL INC SPX CORPORATION UPM-KYMMENE CORP WEYERHAEUSER CO INTL FINANCE CORPORATION INTERNATL BANK RECON DEV-GLOBA ISRAEL STATE OF-GLOBAL KREDIT FUER WIEDERAUFBAU-GLOBA KREDIT FUER WIEDERAUFBAU-GLOBA Corp. Industrials Corp. Industrials Corp. Industrials Corp. Industrials Corp. Industrials Gov. Related Gov. Related Gov. Related Gov. Related Gov. Related 1,045,275 642,823 766,621 648,265 871,588 1,198,808 1,200,080 1,911,761 1,012,672 941,429 Table 2: Asset Class The benchmark for the manager who has constructed this portfolio is a composite index consisting of one-third each of the Barclays Capital U.S. Treasury index, Barclays Capital U.S. Credit Index, and Barclays Capital U.S. MBS index. First, in regards to the Barclays Capital U.S. Treasury index, this index measures the performance of U.S. Treasury securities. Second, in regards to the Barclays Capital U.S. Credit Index, this index includes both corporate and non-corporate sectors where the corporate sectors are industrial, utility, and finance that include both U.S. and non-U.S. corporations. The non-corporate sectors are sovereign, supranational, foreign agency, and foreign local government. The index is calculated monthly on price-only and total-return basis. All returns are market valueweighted inclusive of accrued interest. Third, in regards to the Barclays Capital U.S. MBS index, this index measures the performance of investment grade fixed-rate mortgagebacked pass-through securities of GNMA, FNMA, and FHLMC. Asset Class Total Treasury Government Related Corporate Industrials Corporate Utilities Corporate Financials MBS Agency Portfolio 100.0 ? ? ? ? ? ? Benchmark 100.0 33.3 6.8 13.9 2.9 9.7 33.3 Table 3.1: Analytics for the 50-bond Portfolio and the Benchmark Table 3.1 provides information about the relative exposure to interest rate risk as measured by duration, spread risk as measured by spread duration, and call/prepayment risk as measured by vega, as well as the convexity. Analytics Duration Spread Duration Convexity Vega Spread(bps) Portfoli o 6.87 6.77 0.47 0.01 355 Benchmark 5.37 5.27 0.00 0.03 55 Difference 1.50 1.50 0.47 0.02 300.00 Table 3.2: Contribution to Duration by Asset Class for the 50-bond Portfolio Table 3.2 provides information about the portfolio's relative risk exposure to interest rate risk. Duration Contribution Total Treasury Government Related Corporate Securitized Portfoli o 6.87 3.62 0.92 1.10 1.23 Benchmark Difference 5.37 1.78 0.41 1.74 1.45 1.50 1.84 0.51 -0.63 -0.22 Table 4: Monthly Tracking Error for Risk Factors Isolated Risk/Tracking Error 40.8 2.5 2.8 5.3 30.6 5.8 Risk Factor Categories Curve Swap Spreads Volatility Spread Government Related Spread Corporate Spread Securitized Table 5: Volatility table. This table provides the breakdown of the standard deviation of the returns for the portfolio and the benchmark Volatility Systematic Idiosyncratic Total Duration Beta Portfoli o 141.9 19.3 143.2 Benchmark 117.4 4.8 ? Tracking Error 37.9 18.7 ? ? Table 6: Detailed Monthly Tracking Error for the 50-Bond Portfolio by Risk Factor Group The \"risk factor group\" table provides information about the portfolio risk across the different categories of risk factors. Shown are the systematic risk and the idiosyncratic risk and six components of systematic risk. The \"contribution to TEV\" column shows the isolated tracking error. The contribution to tracking error for each group of risk factor is shown in the \"liquidation effect on TEV\" column. Risk Factor Group Total Systematic Risk Curve Swap Spreads Volatility Spread Government Related Spread Corporate Spread Securitized Contribution to TEV 42.3 33.2 23.4 0.2 0.5 Liquidation Effect on TEV -42.3 -22.4 -4.3 -0.1 -0.4 TEV Elasticity (%) 1.0 0.8 0.5 0.0 0.0 5.3 0.0 0.3 0.0 30.6 5.8 10.0 -0.8 0.8 1.1 0.2 0.0 Isolated TEV 42.3 37.9 40.8 2.5 2.8 Idiosyncratic Risk 18.7 9.1 -4.2 0.2 Questions The purpose of this project is to describe in detail the risk characteristics of the 50-bond Portfolio. Your instructor drew up the following list of questions that should be covered to be able to discuss the portfolio's risk relative to the benchmark. In your analysis, be sure to discuss where it seems like the manager is taking views on the market. 1. Use the data in Table 1 to calculate the missing weights for each class asset that appear in Table 2. After completing the missing weights, start your analysis of table 2 by comparing the portfolio to that of benchmark in terms of the allocation to the major sectors of the benchmark (i.e., overweighting/underweighting). Discuss your results. 2. Do you think the portfolio manager can use the percentage allocation to each sector (i.e., Asset class table) to evaluate the portfolio's exposure to various risk factors? Explain? 3. Use the data in Table 3.1 and 3.2 to assess the portfolio risk relative to the benchmark? Make sure to discuss the sources of risk (i.e., interest rate risk, spread risk, and call & prepayment risk). Before starting your analysis, explain the differences among interest rate risk, spread risk, and call & repayment risk. 4. What is tracking error? What is meant by tracking error due to systematic risk factors? What is meant by isolated tracking error? Briefly explain what is meant by yield curve risk, swap spread risk, volatility risk, government-related spread risk, corporate spread risk, and securitized spread that are listed in table 4 and the (monthly) volatility of these risk factor categories? 5. Compute the isolated systematic tracking error for the portfolio given the monthly tracking error for each risk factor exposure in Table 4? Discuss the implications of your results for the risk exposure of this portfolio. Make sure to assume a zero correlation between any pair of risk factors when calculating the portfolio isolated systematic tracking error. 6. Why is the tracking error more important than portfolio variance of returns when a portfolio manager's performance is measured versus a benchmark? 7. You are reviewing table 5 that indicates that a portfolio tracking error is 143.2 basis points. It is also reported that the tracking error due to systematic risk is 141.9 basis points and the tracking error due to non-systematic risk is 19.3 basis points. Why doesn't the sum of these two tracking error components total up to 161.2 basis points? 8. Calculate the total risk for the benchmark using the values in the \"volatility\" Table (i.e., Table 5) and portfolio tracking error (volatility of net position). Complete the related blank in Table 5. 9. How can a multi-factor risk model be used to monitor and control portfolio risk? Explain whether you agree or disagree with the following statement \"It is the tracking error not the idiosyncratic risk (as measured by the standard deviation of the idiosyncratic returns) that the manager must consider in portfolio construction and monitoring\". Use Table 5 to support your argument. 10. Compute the duration beta using the values in the \"analytics\" table (Table 3.1). Complete the related blank in Table 5. Explain your answer. 11. Based on the information given in Table 6, what are the major risk exposures of the 50bond portfolio? Explain your