Multivariate Monte-Carlo Simulation and Economic Valuation of Complex Financial Contracts: An Excel Based Implementation

Timothy J Kyng and Otto Konstandatos ()

Published Paper Series from Finance Discipline Group, UTS Business School, University of Technology, Sydney

Abstract: The economic valuation of complex financial contracts is often done using Monte-Carlo simulation. We show how to implement this approach using Excel. We discuss Monte-Carlo evaluation for standard single asset European options and then demonstrate how the basic ideas may be extended to evaluate options with exotic multi-asset multi-period features. Single asset option evaluation becomes a special case. We use a typical Executive Stock Option to motivate the discussion, which we analyse using novel theory developed in our previous works. We demonstrate the simulation of the multivariate normal distribution and the multivariate Log-Normal distribution using the Cholesky Square Root of a covariance matrix for replicating the correlation structure in the multi-asset, multi period simulation required for estimating the economic value of the contract. We do this in the standard Black Scholes framework with constant parameters. Excel implementation provides many pedagogical merits due to its relative transparency and simplicity for students. This approach also has relevance to industry due to the widespread use of Excel by practitioners and for graduates who may desire to work in the finance industry. This allows students to be able to price complex financial contracts for which an analytic approach is intractable.

Pages: 38 pages
Date: 2014-01-01
References: Add references at CitEc
Citations: View citations in EconPapers (1)

Published as: Kyng, T. and Konstandatos, O., 2014, "Multivariate Monte-Carlo Simulation and Economic Valuation of Complex Financial Contracts: An Excel Based Implementation", Spreadsheets in Education, 7(2), 1-38.

Downloads: (external link)
https://epublications.bond.edu.au/ejsie/vol7/iss2/5/ (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:uts:ppaper:2014-6

Access Statistics for this paper

More papers in Published Paper Series from Finance Discipline Group, UTS Business School, University of Technology, Sydney PO Box 123, Broadway, NSW 2007, Australia. Contact information at EDIRC.
Bibliographic data for series maintained by Duncan Ford ().