Advanced Search

Journal Navigation

Journal Home

Subscriptions

Archive

Contact Us

Table of Contents

Sign In to gain access to subscriptions and/or personal tools.
SIMULATION
This Article
Right arrow Full Text (PDF)
Right arrow References
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Services
Right arrow Email this article to a friend
Right arrow Similar articles in this journal
Right arrow Alert me to new issues of the journal
Right arrow Add to Saved Citations
Right arrow Download to citation manager
Right arrowRequest Permissions
Right arrow Request Reprints
Right arrow Add to My Marked Citations
Citing Articles
Right arrow Citing Articles via HighWire
Right arrow Citing Articles via Google Scholar
Right arrow Citing Articles via Scopus
Google Scholar
Right arrow Articles by Seila, A. F.
Right arrow Articles by Banks, J.
Right arrow Search for Related Content
Social Bookmarking
Add to CiteULike   Add to Complore   Add to Connotea   Add to Del.icio.us   Add to Digg   Add to Reddit   Add to Technorati   Add to Twitter  
What's this?

Other

Spreadsheet risk analysis using simulation

Andrew F. Seila

University of Georgia Athens, GA

Jerry Banks

Georgia Institute of Technology Atlanta, GA

For many financial models implemented in electronic spreadsheets, input data values frequently are random variables because they are actually estimates of unknown quantities. As a result, the bottom-line performance measure of the model is a random variable, and risk is associated with decisions based upon it due to the uncer tainty in its value. We describe in detail how to evaluate this risk using simulation in a spreadsheet and illustrate the procedure with an example. Formulas for generating random variates from many common distributions using LOTUS 1-2-3 are given, and data analysis considerations are also discussed.

SIMULATION, Vol. 55, No. 3, 163-170 (1990)
DOI: 10.1177/003754979005500307
Add to CiteULike CiteULike   Add to Complore Complore   Add to Connotea Connotea   Add to Del.icio.us Del.icio.us   Add to Digg Digg   Add to Reddit Reddit   Add to Technorati Technorati   Add to Twitter Twitter    What's this?


This article has been cited by other articles:


Home page
 SIMULATIONHome page
A. Greasley
An Example of a Discrete-Event Simulation on a Spreadsheet
SIMULATION, March 1, 1998; 70(3): 148 - 162.
[Abstract] [PDF]

Home page
 SIMULATIONHome page
L. A. Leon and Z. H. Przasnyski
Spreadsheet Analysis of Linear Programs With Uncertainty
SIMULATION, February 1, 1995; 64(2): 113 - 125.
[Abstract] [PDF]

Home page
 SIMULATIONHome page
Z. H. Przasnyski
Spreadsheet Simulation Model For Inventory Management
SIMULATION, July 1, 1994; 63(1): 32 - 43.
[Abstract] [PDF]