please use Excel and show all calculations, thank you!

Here is the table with the information needed for the question

Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 123100%ofassetF35%ofassetFand65%ofassetG50%ofassetFand50%ofassetH a. Calculate the expected return over the 4-year period for each of the three alternative b. Calculate the standard deviation of returns over the 4year period for each of the three alternatives. c. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives. d. On the basis of your findings, which of the three investment alternatives do you recommend? Why? 4. Asset Z has an expected return of 11.8 percent and a beta of 1.10. If the risk-free rate is 3.3 percent, complete the following table for portfolios of Asset W and a risk-free asset. Illustrate the relationship between portfolio expected return and portfolio beta by plotting the expected returns against the betas. What is the slope of the line that results? % of Portfolio in Z Portfolio Expected Return Portfolio Beta 0 25 501 100 125 150 \begin{tabular}{|r|r|r|r|} \hline Year & Asset F & Asset G & Asset H \\ \hline 2018 & 7 & 12 & 12 \\ \hline 2019 & 10 & 9 & 9 \\ \hline 2020 & 15 & 21 & 4 \\ \hline 2021 & 6.5 & 6 & 12.5 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline Year & Asset F & Asset G & Asset H \\ \hline 2018 & 7 & 12 & 12 \\ \hline 2019 & 10 & 9 & 9 \\ \hline 2020 & 15 & 21 & 4 \\ \hline 2021 & 6.5 & 6 & 12.5 \\ \hline \end{tabular} Using these assets, you have isolated the three investment alternatives shown in the following table. Alternative Investment 123100%ofassetF35%ofassetFand65%ofassetG50%ofassetFand50%ofassetH a. Calculate the expected return over the 4-year period for each of the three alternative b. Calculate the standard deviation of returns over the 4year period for each of the three alternatives. c. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives. d. On the basis of your findings, which of the three investment alternatives do you recommend? Why? 4. Asset Z has an expected return of 11.8 percent and a beta of 1.10. If the risk-free rate is 3.3 percent, complete the following table for portfolios of Asset W and a risk-free asset. Illustrate the relationship between portfolio expected return and portfolio beta by plotting the expected returns against the betas. What is the slope of the line that results? % of Portfolio in Z Portfolio Expected Return Portfolio Beta 0 25 501 100 125 150 \begin{tabular}{|r|r|r|r|} \hline Year & Asset F & Asset G & Asset H \\ \hline 2018 & 7 & 12 & 12 \\ \hline 2019 & 10 & 9 & 9 \\ \hline 2020 & 15 & 21 & 4 \\ \hline 2021 & 6.5 & 6 & 12.5 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline Year & Asset F & Asset G & Asset H \\ \hline 2018 & 7 & 12 & 12 \\ \hline 2019 & 10 & 9 & 9 \\ \hline 2020 & 15 & 21 & 4 \\ \hline 2021 & 6.5 & 6 & 12.5 \\ \hline \end{tabular}