Modeling of Economic Series Coordinated with Interest Rate Scenarios

Research Projects – Finance/Investment

The SOA’s Committee on Finance Research is pleased to make available the results of this research project, jointly sponsored by the SOA and CAS, that explores economic series and provides an Excel-based tool for generating future economic scenarios.

The research was conducted by the team of Kevin Ahlgrim of lllinois State University, and Stephen D’Arcy and Richard Gorvett, both of University of Illinois.

Materials

Modeling of Economic Series Coordinated with Interest Rate Scenarios

Appendix C - Simulated Financial Scenario Data

Appendix D - Financial Scenario Model

Please note the Financial Scenario Model in Appendix D requires @RISK, an Excel add–in, to operate properly. @RISK can be purchased from the following web site: www.palisade.com

For those who do not wish to purchase @RISK, Appendix C contains hundreds of scenarios (i.e., simulation paths) of financial and economic variables, generated as output from the Financial Scenario Model. This data can be used directly, in lieu of actually running the model and requiring @RISK; the “ pre–simulated” scenario paths can be used as an input to a user’s application or model.

Questions Or Comments?

If you have comments or questions, please send an email to research@soa.org.