Loss Modeling Using Spreadsheet‐Based Simulation

Domingo Castelo Joaquin

Risk Management and Insurance Review, 2007, vol. 10, issue 2, 283-297

Abstract: With the dramatic increase in the speed of personal computers and steep decline in the cost of computing, simulation has become one of the standard tools in the risk manager's toolbox and should now become one of the standard tools in the risk management and insurance student's toolbox. This teaching note aims to facilitate this process by showing how to create and run a simulation in a spreadsheet environment, and interpret simulation results to gain insight and understanding about a real‐world problem. Specifically, this teaching note provides step‐by‐step instruction for simulating the present value of payments for losses occurring within a 1‐year policy period. Losses are covered by an aggregate excess of loss treaty. The uncertainty lies in the frequency and severity of losses as well as in claim processing time, and also in the discount rate for calculating the present value of loss payments.

Date: 2007
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
https://doi.org/10.1111/j.1540-6296.2007.00119.x

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:bla:rmgtin:v:10:y:2007:i:2:p:283-297

Access Statistics for this article

Risk Management and Insurance Review is currently edited by Mary A. Weiss

More articles in Risk Management and Insurance Review from American Risk and Insurance Association
Bibliographic data for series maintained by Wiley Content Delivery ().