Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please, Can anybody help me with this template? I have to see the formulas, please? Choose 3 domestic indexes from the Data tab on the
Please, Can anybody help me with this template? I have to see the formulas, please?
- Choose 3 domestic indexes from the Data tab on the template. Compute the following for each index and the 3-month US TBill Index:
- mean, wealth index, annualized return (4 each)
- variance, standard deviation, Sharpe ratio, semi-deviation (4 each) (not for the 3-mo Bill always assume variance of TBill = 0)
- correlation matrix (12)
- Graph the Growth of $1 for all four indices from 2000-2019. Label axes, legend, last point (ending wealth per $1). You must include proper labelling for full credit. (8). 2. Choose 2 of your 3 indexes. Enter the expected return, standard deviation, Sharpe, correlation, and covariance for them in the space provided. Compute the portfolio expected return, standard deviation, and reward-to-risk ratio for the listed weights on the template. (14)
- Graph the efficient frontier of the combinations from Part 2. Label axes and data points. You must include proper labelling for full credit. (8). 3. For a portfolio containing your two indexes, calculate:
- Weights, expected return, and standard deviation for the Minimum Variance Portfolio (6)
- Weights, expected return, standard deviation, and Reward-to-Risk ratio for the Optimal Risky Portfolio (6)
- Standard deviation for a portfolio with a target expected return equal to the expected return of the 50/50 weighted portfolio (assuming the risk-free asset is not available) (6)
- Weights and standard deviation for a Complete Portfolio with the same target expected return as in the Part 3c 50/50 portfolio (assume the risk-free asset is available for lending and borrowing) (8).
-
You can either use a formula to get the weights for 3a, b, and d, or use the Excel Add-in Solver to do optimization.
-
- Graph the efficient frontier of the combinations from Part 2. Label axes and data points. You must include proper labelling for full credit. (8). 3. For a portfolio containing your two indexes, calculate:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started