[Abstract]

In this article we discuss the implementation of Cholesky Decomposition and Monte Carlo simulation in a VBA framework to build a flexible model to value some of the most complex types of share option schemes.We alse discuss how world events have let to the techniques of Quantitative Finance inreasingly becoming a key component of the financial reporting cycle for companies.