This project seeks to teach students, teachers, researchers and industry practitioners how to build parametric and nonparametric Value at Risk (VaR) models, using innovative Excel techniques.
Value at Risk (VaR) is a widely used method by banks and investors for measuring market risk. Commercially purchased modelling packages can be expensive and inflexible, which restricts their use by teachers and researchers. This project provides step by step teaching studies on how to use Excel to construct VaR spreadsheets for individual assets as well as portfolios. This benefits financial modelling teachers by providing them with easy to use teaching studies on how to model VaR, and benefits researchers and industry practitioners by showing them how to easily construct VaR models.
To date two studies have been undertaken. The first is a nonparametric teaching study which uses two nonparametric methods: the historical simulation method and the historical bootstrap method. The study includes details of constructing VaR histograms. The second is a parametric teaching study using a parametric normal distribution approach and Monte Carlo simulation, including the incorporation of a self-contended pseudo-random number generator.
Study publications can be downloaded from the Australasian Accounting, Business and Finance Journal website.
This project commenced January 2012 and is ongoing.
Please leave a comment about your rating so we can better understand how we might improve the page.