Please, show the solution with excel formulas

Assets Portfolio Expected Expected Rate of Standard Allocation % Return Deviation Risk-Free Assets T-Bills 20% 2.00% 0 Risky Assets Bonds Stocks 50% 30% 6.00% 20.00% 10% 34% 2-2a Risky Portfolio % of Total Weights Expected Rate of Return Expected Standard Deviation Correlation (W%.c)^2 2(Wo)(W.).Cor Bonds Stocks Total Risky Portfolio 0.3000 Variance = Stand. Dev= Standard Deviation = Question 8 2-26(a) and 2-26(b) Assets Portfolio Expected Rate of Allocation % Return S Allocation Expected Profit Weghted Average Expecred Return Risk-Free Assets T-Bills 20% 2.00% Risky Assets Bonds Stocks Total 50% 30% 100% 6.00% 20.00% 100,000 Question 9 Question 10 2-2c Risky Portfolio % of Total Weights Expected Expected Rate of Standard Return Deviation Correlation (W%.0)^2 2(Wo)(Wo).Cor Stocks Total Total Risky Portfolio -1.0000 Variance = Stand. Dev= Standard Deviation = Question 11 Assets Portfolio Expected Expected Rate of Standard Allocation % Return Deviation Risk-Free Assets T-Bills 20% 2.00% 0 Risky Assets Bonds Stocks 50% 30% 6.00% 20.00% 10% 34% 2-2a Risky Portfolio % of Total Weights Expected Rate of Return Expected Standard Deviation Correlation (W%.c)^2 2(Wo)(W.).Cor Bonds Stocks Total Risky Portfolio 0.3000 Variance = Stand. Dev= Standard Deviation = Question 8 2-26(a) and 2-26(b) Assets Portfolio Expected Rate of Allocation % Return S Allocation Expected Profit Weghted Average Expecred Return Risk-Free Assets T-Bills 20% 2.00% Risky Assets Bonds Stocks Total 50% 30% 100% 6.00% 20.00% 100,000 Question 9 Question 10 2-2c Risky Portfolio % of Total Weights Expected Expected Rate of Standard Return Deviation Correlation (W%.0)^2 2(Wo)(Wo).Cor Stocks Total Total Risky Portfolio -1.0000 Variance = Stand. Dev= Standard Deviation = Question 11