. . . Project The point of the Project is to create portfolios, the fist is just to get comfortable with the data and Solver. The second is to introduce additional constraints and the last ones. These portfolios will be created with real data using Solver in Excel. Google how to install Solver in Excel. You need to create the following portfolios: I. Basic Statistics for Securities and Portfolio: Due with the first exam Special Securities and Portfolio of Special Securities Work with two samples: a) Jun-98 to Dec-08 and b) Jan-09 to Jun-20; I will create an example for the full sample. You want to create portfolios with 5% volatility (standard deviation) The following are the securities that will be in your portfolio, they are funds in those asset classes. Go to Google finance and look them up (the tickers are in parenthesis): RIK (IWB) Russell 1000, Stocks GOLD (GLD) Gold, Commodities TY20 (TLT) US Treasuries (20 years or more); negative correlation with equities BDEM (EMB) Emerging Market Bonds BDUS (LQD) US Bonds BDMOBA (MBB) | Mortgage Backed Securities (Review Chapter 2 or Google) II. Basic Statistics and Portfolios, DJIA: Due with the second exam Dow Jones Industrial Average, 30 stocks III. Basic Statistics and Portfolio S&P 100: Due with the third exam Standard and Poor's 100, long only 120 Levered portfolio with 20% borrowing . . . . . Project The point of the Project is to create portfolios, the fist is just to get comfortable with the data and Solver. The second is to introduce additional constraints and the last ones. These portfolios will be created with real data using Solver in Excel. Google how to install Solver in Excel. You need to create the following portfolios: I. Basic Statistics for Securities and Portfolio: Due with the first exam Special Securities and Portfolio of Special Securities Work with two samples: a) Jun-98 to Dec-08 and b) Jan-09 to Jun-20; I will create an example for the full sample. You want to create portfolios with 5% volatility (standard deviation) The following are the securities that will be in your portfolio, they are funds in those asset classes. Go to Google finance and look them up (the tickers are in parenthesis): RIK (IWB) Russell 1000, Stocks GOLD (GLD) Gold, Commodities TY20 (TLT) US Treasuries (20 years or more); negative correlation with equities BDEM (EMB) Emerging Market Bonds BDUS (LQD) US Bonds BDMOBA (MBB) | Mortgage Backed Securities (Review Chapter 2 or Google) II. Basic Statistics and Portfolios, DJIA: Due with the second exam Dow Jones Industrial Average, 30 stocks III. Basic Statistics and Portfolio S&P 100: Due with the third exam Standard and Poor's 100, long only 120 Levered portfolio with 20% borrowing