On this page
What this lesson covers
Spreadsheet simulations use different scenario-generation functions while applying the valuation and aggregation rules required by each simulation method.
The lesson builds historical, bootstrap and Monte Carlo workflows with spreadsheet functions. It covers log returns, percentiles, sampling with replacement, standard normal draws and geometric Brownian motion price paths.
How do you simulate the next stock price?
Advance the stock price by multiplying it by the exponential of the adjusted drift and volatility-scaled random shock for one time step.
Next price = current price × exp[(drift − 0.5 × volatility²) × time step + volatility × sqrt(time step) × Z]
- Current price
- Annual drift
- Annual volatility
- Time step in years
- Standard normal draw
For example, assume geometric Brownian motion with a current share price of SEK 100, annual volatility 14%, annual drift 2%, a time step of 1/252 year and standard normal draw Z = −1.5. The exponent is (0.02 − 0.5 × 0.14²) / 252 + 0.14 × sqrt(1/252) × (−1.5) ≈ −0.0132, so the next price is approximately 100 × exp(−0.0132) = SEK 98.69.
Try a practice question
Choose an answer, then check it to read the explanation for every option.
Continue studying in Quizara
In Quizara the lesson comes with more practice questions on the topic, explanations for every option and an AI tutor for your follow-up questions.
Written by the Quizara Editorial Team under our editorial standards.