Monte Carlo Simulation - Example
In the previous post, we learned the algorithm to compute VaR using Monte Carlo Simulation. Let us compute VaR for one share to illustrate the algorithm. We apply the algorithm to compute the monthly VaR for one stock. We will only consider the share price and thus work with the assumption we have only one share in our portfolio. Therefore the value of the portfolio corresponds to the value of one share.
In the previous post, we learned the algorithm to compute VaR using Monte Carlo Simulation. Let us compute VaR for one share to illustrate the algorithm.
We apply the algorithm to compute the monthly VaR for one stock. We will only consider the share price and thus work with the assumption we have only one share in our portfolio. Therefore the value of the portfolio corresponds to the value of one share.
The following assumptions are made:
| Current share price | $20 |
| Drift | 10% |
| Volatility | 20% |
Members can download the attached spreadsheet below that shows the calculation of VaR using Monte Carlo Simulation.
Downloads
Resources
Value at Risk - Excel Spreadsheets Bundle
This bundle contains two spreadsheets to help calculate value-at-risk in excel. Monte Carlo Simulation - Single Asset Template: This spreadsheet provides a step-by-step example of how to calculate the VaR of an asset using Monte Carlo Simulation. Parametric VaR Spreadsheet: This spreadsheet helps you calculate the VaR of a two-asset and a three-asset portfolio using the Parametric VaR method.
