Value at Risk (VaR) has become a benchmark methodology among investors and banks for measuring market risk. Commercially available modelling packages can be both expensive and inflexible, thereby restricting their use by academic researchers and teachers. Using nonparametric methodology, this paper provides a step-by-step teaching study on how to use Excel to construct a VaR spreadsheet for an individual asset as well as for a portfolio. This can benefit financial modelling teachers by providing them with a readily useable teaching study on how to model VaR, as well as benefit researchers by showing them how to construct an inexpensive and flexible VaR model.



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.