Answered step by step
Verified Expert Solution
Link Copied!

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?

  1. Choose 3 domestic indexes from the Data tab on the template. Compute the following for each index and the 3-month US TBill Index:
    1. mean, wealth index, annualized return (4 each)
    2. variance, standard deviation, Sharpe ratio, semi-deviation (4 each) (not for the 3-mo Bill always assume variance of TBill = 0)
    3. correlation matrix (12)
    4. 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)
      1. 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:
        1. Weights, expected return, and standard deviation for the Minimum Variance Portfolio (6)
        2. Weights, expected return, standard deviation, and Reward-to-Risk ratio for the Optimal Risky Portfolio (6)
        3. 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)
        4. 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).
      2. 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Wall Street Journal Complete Personal Finance Guidebook

Authors: Jeff D. Opdyke

1st Edition

030733600X, 978-0274804573

More Books

Students also viewed these Finance questions