Problem 11.2: Please show your calculations of the questions. Please lay out your input information separately and label it clearly. Do all the calculations with excel. (Excel part: 10 points)

Consider the following information:

State of Economy	Probability of State of Economy	Rate of Return if State Occurs
Stock A	Market	Stock C
Boom	.15	.35	.45	.25
Good	.60	.19	.16	.10
Poor	.20	.03	.06	.05
Bust	.05	.13	.31	.08

a.	Your portfolio is invested 28 percent each in A and C, and 44 percent in the market. What is the expected return of the portfolio? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
b-1.	What is the variance of this portfolio? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .16161.)
b-2.	What is the standard deviation? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
c	Bonus question (optional): Do you think that Stock A has a high beta (i.e., greater than 1.0) or a low beta (i.e., less than 1.0)? Please provide a brief explanation to justify your response. You may provide your explanation using either a general discussion or by actually calculating the beta of Stock A. Write your response in the excel file for this question. (5 points)

please do the calculations in excel.