can i have an email to send more information? thanks

Carry out the following calculations in the "Opportunity Set" worksheet. 1. (8 points) Collect the estimates of the mean annual real returns for the 5-year (intermediate-term) T-bond and the large stock indexes for 1926-2016. You can find these estimates in either the Risk Premiums or Correlation worksheets in the Lecture 5 Excel examples workbook. Enter those values in cells B3 and B4, respectively. Also collect the estimates of the standard deviation of annual real returns for these two asset classes and enter in cell c3 for T-bonds and C4 for large stocks. Finally, retrieve the correlation needed to complete the small table in cells B7:08. 2. (12 points) Construct a table of representative portfolios in the portfolio opportunity set that is formed by these two risky asset classes. Specifically, for each row in this table, calculate the standard deviation of portfolio return in column C and the expected portfolio return in column D. 3. (5 points) In column E, calculate the Sharpe ratio for each portfolio in table for the portfolio opportunity set. In your calculations, use the risk-free rate in cell F12. 4. (5 points) In column F, type "optimal" in the row that corresponds to the optimal risky portfolio 5. (5 points) In cells C12 and C13, apply the formulas presented in Lecture 5 for calculating the exact weights on the minimum variance portfolio. 6. (5 points) In columns G and H, report the standard deviation of annual returns and expected annual returns only for portfolios on the efficient frontier. If a portfolio in the table in columns A through D is NOT on the efficient frontier, then leave the corresponding cells in columns G and H blank. 7. (Optional) (10 bonus points) Construct a chart like Chart 6 or Chart 7 in the Lecture 5 Excel examples workbook. For full credit, you must plot the following: the portfolio opportunity set, the efficient frontier, and the points that correspond to the two primary assets (specifically, the large stocks and the 5-year T-bonds). In addition, your chart must be in its own chart sheet and be properly formatted. Advice: to construct this chart, the most straightforward way is to use the scatterplot chart type with a line connecting the markers. I suggest that you create the chart initially by selecting only the data for the portfolio opportunity set. After you set up 7. (Optional) (10 bonus points) Construct a chart like Chart 6 or Chart 7 in the Lecture 5 Excel examples workbook. For full credit, you must plot the following: the portfolio opportunity set, the efficient frontier, and the points that correspond to the two primary assets (specifically, the large stocks and the 5-year T-bonds). In addition, your chart must be in its own chart sheet and be properly formatted. Advice: to construct this chart, the most straightforward way is to use the scatterplot chart type with a line connecting the markers. I suggest that you create the chart initially by selecting only the data for the portfolio opportunity set. After you set up the chart, go back and add a second data series for the efficient frontier, again using the scatterplot chart type with a line connecting the markers. Finally, add a third data series for the primary assets using the scatterplot chart type with markers only. 8. (10 points) In our analysis, we used historical rates of return to estimate the characteristics of the asset classes and the risk-free rate. For making portfolio decisions today for your long-term portfolio, what are the main drawbacks of using historical data to estimate these characteristics? Please write your discussion in the box provided in the "Opportunity Set" worksheet. Carry out the following calculations in the "Opportunity Set" worksheet. 1. (8 points) Collect the estimates of the mean annual real returns for the 5-year (intermediate-term) T-bond and the large stock indexes for 1926-2016. You can find these estimates in either the Risk Premiums or Correlation worksheets in the Lecture 5 Excel examples workbook. Enter those values in cells B3 and B4, respectively. Also collect the estimates of the standard deviation of annual real returns for these two asset classes and enter in cell c3 for T-bonds and C4 for large stocks. Finally, retrieve the correlation needed to complete the small table in cells B7:08. 2. (12 points) Construct a table of representative portfolios in the portfolio opportunity set that is formed by these two risky asset classes. Specifically, for each row in this table, calculate the standard deviation of portfolio return in column C and the expected portfolio return in column D. 3. (5 points) In column E, calculate the Sharpe ratio for each portfolio in table for the portfolio opportunity set. In your calculations, use the risk-free rate in cell F12. 4. (5 points) In column F, type "optimal" in the row that corresponds to the optimal risky portfolio 5. (5 points) In cells C12 and C13, apply the formulas presented in Lecture 5 for calculating the exact weights on the minimum variance portfolio. 6. (5 points) In columns G and H, report the standard deviation of annual returns and expected annual returns only for portfolios on the efficient frontier. If a portfolio in the table in columns A through D is NOT on the efficient frontier, then leave the corresponding cells in columns G and H blank. 7. (Optional) (10 bonus points) Construct a chart like Chart 6 or Chart 7 in the Lecture 5 Excel examples workbook. For full credit, you must plot the following: the portfolio opportunity set, the efficient frontier, and the points that correspond to the two primary assets (specifically, the large stocks and the 5-year T-bonds). In addition, your chart must be in its own chart sheet and be properly formatted. Advice: to construct this chart, the most straightforward way is to use the scatterplot chart type with a line connecting the markers. I suggest that you create the chart initially by selecting only the data for the portfolio opportunity set. After you set up 7. (Optional) (10 bonus points) Construct a chart like Chart 6 or Chart 7 in the Lecture 5 Excel examples workbook. For full credit, you must plot the following: the portfolio opportunity set, the efficient frontier, and the points that correspond to the two primary assets (specifically, the large stocks and the 5-year T-bonds). In addition, your chart must be in its own chart sheet and be properly formatted. Advice: to construct this chart, the most straightforward way is to use the scatterplot chart type with a line connecting the markers. I suggest that you create the chart initially by selecting only the data for the portfolio opportunity set. After you set up the chart, go back and add a second data series for the efficient frontier, again using the scatterplot chart type with a line connecting the markers. Finally, add a third data series for the primary assets using the scatterplot chart type with markers only. 8. (10 points) In our analysis, we used historical rates of return to estimate the characteristics of the asset classes and the risk-free rate. For making portfolio decisions today for your long-term portfolio, what are the main drawbacks of using historical data to estimate these characteristics? Please write your discussion in the box provided in the "Opportunity Set" worksheet