Given the three annual asset return series (S&P 500, AAA Bonds, and BO) in “Three Asset Returns” Tab and the “Example of Portfolio Optimization of 3 funds.xlsx” template:

1. Run the regression of AAA Bonds as y and SP500 as x and report regression output in a separate sheet.
2. Run the regression of BO as y and SP500 as x and report regression output in a separate sheet.
3. The Equity risk premium is 5.2% and the Risk-free rate is 3.5%. Follow the “Solver” Tab in the “Example of Portfolio Optimization of 3 funds.xlsx” template, generate the optimal portfolio (mean, St. Dev, three portfolio weights, Sharpe Ratio)
   Assume that no short selling allowed. The optimal portfolio consists of at least 2 assets. Find the optimal portfolio with mean return ranges from 0.050 to 0.090 at a 0.005 increment. Note that this is a portfolio optimization problem with 3 assets, S&P 500 is the market index and also 1 of the 3 assets that the optimal portfolio consists.
   Part II: Fama and French Three Factor (40 Points)
   Givent the multifactor data in “Fama and French Factors” and AAPL daily return data.
4. Estimate a Fama-French three factor model and report the regression output in a seperate sheet.
5. Interprate the regression output. Comment on the statistical significance of the three factors.
6. How much is the Adjusted R Square and comment on the magnitude of Adjusted R Square.