Certainty and uncertainty

To complete your simulated stock prices model, you will add stock prices and an expected "certain" stock price. The stock price is based on a random estimate of volatility, while the certainty column is estimated based on expected compounded rate of return (k).

You will use the formula: =Previous Row Stock Price*exp(k*1/252+Volatility*Random Estimate*sqrt(1/252)) to estimate the second day of the random stock prices in column B, and the formula: =Previous Row Certainty*exp(k*1/252) to estimate the second day of certain stocks in column C.