Your browser is out of date

This browser version is too old for Quizara to display the page correctly. Update to the latest version and refresh to continue.

Practical Implementation of Simulation Approaches

Updated · 2027 Level I · Quantitative Methods · Module 9 · Lesson 9 · 4 min lesson

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.

Review Module 9 formulas in Quizara →

Try a practice question

Choose an answer, then check it to read the explanation for every option.

Practice question

A share priced at EUR 50 is simulated one step ahead with geometric Brownian motion, using a volatility of 20% a year, a risk-free rate of 5% as the drift, a time step of one year and a standard normal draw of Z=1.25Z = 1.25. The simulated next price is closest to:

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.