Could you answer in excel with clearly labeled inputs and cells with formulas in them

Could you please make excel calculators for the below questions? Question 1 There is a 46% probability of a below average economy and a 54% probability of an average economy. If there is a below average economy stocks A and B will have returns of 5% and 8%, respectively. If there is an average economy stocks A and B will have returns of 13% and 14%, respectively. Calculate the expected returns and standard deviations of stocks A and B. Stock A Expected Return (4 decimals): Stock B Expected Return (4 decimals): Stock A Standard Deviation (4 decimals): Stock B Standard Deviation (4 decimals): Question 2 There is a 25% probability of an average economy and a 75% probability of an above average economy. You invest 10% of your money in Stock S and 90% of your money in Stock T. In an average economy the expected returns for Stock S and Stock T are 6% and 9%, respectively. In an above average economy the the expected returns for Stock S and T are 15% and 35%, respectively. What is the expected return for this two stock portfolio? Portfolio Expected Return (4 decimals): Question 3 You are invested 16% in growth stocks with a beta of 1.6, 17% in value stocks with a beta of 1.1, and 67% in the market portfolio. What is the beta of your portfolio? Portfolio Beta (1 decimal place): Question 4 An analyst gathered the following information for a stock and market parameters: stock beta = 0.8; expected return on the Market = 12.7%; expected return on Tbills = 4.8%; current stock Price = $8.51; expected stock price in one year = $13.37; expected dividend payment next year = $1.14. Calculate the required return and expected return for this stock. Required Return (4 decimal places): Expected Return (4 decimal places): Question 5 The market risk premium the next period is 8.3% and the riskfree rate is 2.4%. Stock Z has a beta of 0.6 and an expected return of 10.2%. What is the rewardtorisk ratio for the market portfolio and Stock Z? Market's rewardtorisk ratio (3 decimals): Stock Z's rewardtorisk ratio (3 decimals)