I need an excel file that performs the calculations for the questions below.

Question 1 0 out of 1 points You put 80% of your money in a stock portfolio that has an expected return of 13.25% and a standard deviation of 31%. You put the rest of you money in a risky bond portfolio that has an expected return of 2.95% and a standard deviation of 14%. The stock and bond portfolio have a correlation 0.30. What is the standard deviation of the resulting portfolio? Enter your answer rounded to two decimal places. Do not enter % in the answer box. For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box. Selected Answer: 14.66 Correct Answer: 25.78 Answer range +/- 0.25 (25.53 - 26.03)

Question 2

0 out of 1 points

Using the stock and bond portfolios from problem 1, what is the standard deviation of the minimum variance portfolio formed from this stock and bond portfolio? Enter your answer rounded to two decimal places. Do not enter % in the answer box. For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box.

Selected Answer:

12.46

Correct Answer:

13.83

Answer range +/-

0.25 (13.58 - 14.08)

Question 3 0 out of 1 points Assume the riskfree rate is 1.25%. Using the stock and bond portfolios from problem 1, what is the bond weight in the tangency portfolio formed by creating the optimal risky portfolio from this stock and bond portfolio? Enter your answer rounded to two decimal places. Do not enter % in the answer box. For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box. Selected Answer: 20.26 Correct Answer: 3.24 Answer range +/- 0.25 (2.99 - 3.49) Question 4 0 out of 1 points Using the information from problem

Question 4 0 out of 1 points Using the information from problem 4, what is the Sharpe ratio of the tangency portfolio formed by creating the optimal risky portfolio from this stock and bond portfolio? Enter your answer rounded to two decimal places. For example, if your answer is 12.345 then enter as 12.35 in the answer box. Note that the Sharpe ratio is shown as a decimal not a percentage. Selected Answer: .35 Correct Answer: 0.3871 Answer range +/- 0.01 (0.3771 - 0.3971)