Use an Excel spreadsheet. Please provide excel formulas.

mencider the following information on a portfolio of three stocks: o. If your portfolio is invested 42 percent each in A and B and 16 percent in C, what is the pormolio's expected return, the variance, and the standard deviation? Note: Do not round intermediate calculations. Round your variance answer to 5 decimal places, e.9.. 16161 . Enter your other answers as a percent rounded to 2 decimal places, e.9., 32.16. b. If the expected Tibill rate is 4.65 percent, what is the expected risk premium on the portiolio? Note: Do not round intermediate calculations and enter your answer os a percent rounded to 2 decimal places, e.9., 32.16. mencider the following information on a portfolio of three stocks: o. If your portfolio is invested 42 percent each in A and B and 16 percent in C, what is the pormolio's expected return, the variance, and the standard deviation? Note: Do not round intermediate calculations. Round your variance answer to 5 decimal places, e.9.. 16161 . Enter your other answers as a percent rounded to 2 decimal places, e.9., 32.16. b. If the expected Tibill rate is 4.65 percent, what is the expected risk premium on the portiolio? Note: Do not round intermediate calculations and enter your answer os a percent rounded to 2 decimal places, e.9., 32.16