Goldman Sachs, a Wall Street firm, predicted in late March when the S&P 500 was at 4,575 that within the next 12 monthsthe S&P 500 will rise 4% in the best-case scenario, stay flat in the moderate-case scenario, and fall 21% in the worst-casescenario. Suppose the probability for each of the three scenarios is 30%, 32% and 38%, respectively. What is the predicted level of S&P 500 a year from now? What is the current S&P 500? You must specify the date when you checked the index.

Please Show Excel Functions and Work