1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Homework Help: Using Monte Carlo simulation to calculate Value At Risk

  1. Jun 10, 2016 #1
    1. The problem statement, all variables and given/known data
    Calculate 5-day 1% Value at Risk of a portfolio using Monte Carlo simulation.

    2. Relevant equations

    3. The attempt at a solution
    I've found an article explaining how to perform Monte Carlo simulation on portfolio returns therefore calculating the Value At Risk (pdf attachment). I've followed all the instructions and implemented it in Excel (zip attachment).
    There are 3 main methods to estimate the VaR of a portfolio - historical simulation, parametric approach and Monte Carlo simulation. Historical simulation gives 5-day VaR=566.59, parametric approach gives 5-day VaR=486.92, and here Monte Carlo simulation gives 5-day VaR equaling around 360. I doubt the Monte Carlo result is accurate (seems way too low). I'm afraid there might be some errors in my excel implementation. I'd appreciate it if someone could kindly help me spot them.

    Attached Files:

  2. jcsd
  3. Jun 15, 2016 #2
    Thanks for the post! This is an automated courtesy bump. Sorry you aren't generating responses at the moment. Do you have any further information, come to any new conclusions or is it possible to reword the post?
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted