solve in excel

Expected return. Bacon and Associates, a famous Northwest think tank, has provided probability estimates for the four potential economic states for the coming year in the following table: The probability of a boom economy is 21%, the probability of a stable growth economy is 42%, the probability of a stagnant economy is 23%, and the probability of a recession is 14%. Estimate the expected retums on the following individual investments for the coming year. What is the expected return of the stock investment? % (Round to two decimal places.) Investment Stock Corporate bond Goverment bond 3% Forecasted Returns for Each Economy Stable Growth Stagnant 10% 7% 6% 6% 5% Boom 21% 9% 8% Recession - 10% 4% 3%