Question
In this file, the expected monthly return for each stock is calculated using excel function AVERAGE (), for each stock, the variance of monthly returns
In this file, the expected monthly return for each stock is calculated using excel function AVERAGE (), for each stock, the variance of monthly returns is calculated using Excel function VAR (), and the covariance between the returns of each pair of stocks is calculated using Excel function COVAR (). Assume that the yearly risk free rate is 2% (A monthly risk free rate of 0.001652).
(d) What would be the capital allocation between the risk free asset and the optimal risky investment portfolio for an individual with risk aversion coefficient of 3? If the initial investment is $100,000, how much money should the investor allocate to each of the 5 assets (risk free asset and 4 risky assets).
Expected Monthly Return | ||
Expected Monthly Return | ||
PG | 0.010848 | |
Microsoft | 0.014854 | |
BAC | 0.011589 | |
Exxon | 0.012043 | |
Variance | ||
Variance | ||
PG | 0.004478 | |
Microsoft | 0.012820 | |
BAC | 0.005611 | |
Exxon | 0.002820 | |
Covariance | ||
Cov(PG, Microsoft) | -0.000649 | |
Cov(PG, BAC) | 0.000683 | |
Cov(PG, Exxon) | 0.000433 | |
Cov(Microsoft, BAC) | 0.001681 | |
Cov(Microsoft, Exxon) | 0.000804 | |
Cov(BAC, Exxon) | 0.000757 |
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