Downloadable Programs, Spreadsheets and Workbooks
- Excel-Based Data Exchange
By Dom Yarnell
The Excel-Based Data Exchange (EBDEx) format is designed to increase the efficiency of processing Microsoft Excel data and ensures consistent formatting of data from multiple sources, while allowing for flexibility of content. Tools that incorporate EBDEx formatting can quickly analyze the properly formatted data using actuarial techniques, generate traditional reinsurance submission exhibits, or run diagnostics on the data to get an overview of the submission and how it differs from previous versions.
The EBDEx format is simple and easy to implement, allowing for reinsurers and brokers to develop custom tools that best address their specific needs. Get started by downloading this simple tool, which includes a video tutorial explaining how to implement the EBDEx format on data in Excel.
- CAS Loss Reserve Database (NAIC Loss Reserving Data)
- Public Access DFA Model
- Actuarial Relativity Program--Student Version
by William P. Rudolph
The student version of the Actuarial Relativity Program can be used to calculate 2-way classification relativities. The program implements the Poisson Multiplicative, Bailey Additive, Least Squares Multiplicative, Chi-Square, and Exponential models. The software is provided as a self-extracting compressed file.
Dependence Models and the Portfolio Effect
by Donald F. Mango, FCAS, MAAA and James C. Sandor, ACAS, MAAA
· Excel spreadsheet with supporting information
· S-Plus Script file
- Mildenhall Aggregate Loss Tools (Only viewable in IE 5.0+)
by Stephen Mildenhall, FCAS, MAAA
- The Cost of Financing Insurance
by Glenn G. Meyers, FCAS, MAAA
Excel spreadsheets supporting the paper
- Risk Load and the Default Rate of Surplus by Donald F. Mango
(Published in the 1999 Discussion Paper Program book)
Excel model upon which the paper is based
- Philbrick Spreadsheet from May Actuarial Review Brainstorms article
- Philbrick Spreadsheet from February Actuarial Review Brainstorms article
- William Scheel's DFA workbooks, as mentioned in Contingencies
- Cat ProActive Price Monitor
by Richard M. Cundy, FCAS
The program is window-based and available in ZIP format and is easily installed when the program is unzipped by running SETUP from Windows. The zipfile size is ~4mb and the additional documentation files add another ~300kb. This a true 32-bit application, thus no Window 3.1 users. The program provides a front-end underwriting tool and back-end monitoring tool for use by underwriters and management to make informed decisions when writing Property Catastrophe Exposures. The tool assumes that the user has acquired the use of a simulation model, such as Catmap, RMS or similar programs that provide expected losses and standard deviations. Reports on the book of business can easily be created by importing the database files into Excel or Lotus.
Documentation for Cat ProActive Price Monitor
- Aggregate Loss Distribution Builder
by Hou-wen Jeng
This software is provided as a zipped file of size 6.5MB. It unpacks into 10 files; double-click setup.exe to run the program. This updated software is designed to build aggregate loss distributions based on the collective risk model. Most calculations can be completed in less than 10 seconds (with a Pentium II 450/64 MB memory). You have the choice of using either Simulation or two approximation methods - Recursion and Fast Fourier Transform - to build your aggregate loss distributions.
The two choices for frequency distributions are Poisson and Negative Binomial while there are five severity distributions -Exponential, Gamma, LogNormal, Weibull, and Pareto- for the user to choose from. The software presents the results in both tabular and graphic forms. The user can print the summary results or export the results to MS Excel. If you need more specific information about the resulting aggregate loss distributions, please contact Hou-wen Jeng at email@example.com.
- Property Per Risk Exposure Rating (162K)
Freeware Excel Spreadsheet that does property per risk exposure rating for Commercial (Lloyds & Hartford Scales) and Homeowners (Salzmann & Hartford Scales).
- Option Trading Strategy Spreadsheets with Profit/Payoff Diagrams
by Thomas P. Hughes
The files listed below are self-extracting ZIP files containing a brief explanatory text file and fourteen spreadsheets demonstrating option strategies as described in Hull's textbook (John C. Hull, "Options, Futures, and Other Derivative Securities," Second Edition, Prentice Hall, Englewood Cliffs, NJ, 1993). Download the version(s) appropriate for your system. The file sizes range from 53k to 124k.
- Software for Fourier Methods of Calculating Aggregate Loss Distributions
by Glenn Meyers
The spreadsheet FFTCalc provides an introduction to Fourier methods for aggregate loss distributions. It provides a step by step explanation of the process. It also illustrates the FFT methodology developed by Shaun Wang to include correlation beween the frequency distribution of two lines of insurance.
- Bond Analytics Program, Version 2.03a
by Thomas P. Hughes
The Bond Analytics Program is a fixed income analytics program for computing bond yields, price-yield volatility metrics and horizon analyses. Options include an external reinvestment rate, tax rates, horizon and call calculations and odd first coupon periods. The program has an easy to use single screen user interface featuring pop-up Help windows and extensive diagnostic messages. A User Guide text file gives more detailed information about the program and bond analytics in general. This is not a .pdf file, it is a zipped file (77KB) containing a .txt file and an executable file.
- Seabury and Smith Experience Analysis System (SSEAS)
SSEAS is a complete loss reserving system able to do side-by-side comparisons using chain-ladder, Bornhuetter-Ferguson and numerous other estimators. It can perform Monte-Carlo simulations extending Stanard's model in PCAS LXXII. It runs under DOS or in a DOS session under OS/2 or Windows 3.1 or higher. This is the complete DOS version of SSEAS, release 7.24, and may be used for study or research with no restrictions. The software is provided as a zipped file of size 1,169,013 bytes. It unpacks into the files sseas.exe and readme.1st; to install, follow the instructions in the latter file.
- Stochastic Reserving Track Readings from 2006 Spring Meeting
Bootstrap Method (E&V) handout (.xls)
This spreadsheet is an example of the bootstrap method described in England & Verrall paper, "Analytic and Bootstrap Estimates of Prediction Errors in Claims Reserving."
Mack Method handout (.xls)
This spreadsheet is an example of Thomas Mack's approach regarding variability of the chain ladder method that is explained in his 1993 paper, "Distribution-Free Calculation of the Standard Error of Chain Ladder Reserve Estimates."
- Copulas Tool
The tool's installation is a windows installer program provided as a zipped file. The tool has functions of correlation calculation, bivariate copulas, FFT, bivariate IC modeling, Simulations, Distributions and their Expected Values, Limited Expected Values, etc.. Hopefully it can bring conveniences and enlightenment to research activities. Please send questions to firstname.lastname@example.org.
- Risk Margins in Fair Value Reserves from the 2008 Fall E-Forum
by Michael Wacek
Template for Calculations Described in Paper (.xls)