racemize Posted April 30, 2012 Posted April 30, 2012 I've developed a pretty in-depth spreadsheet for doing reserve triangle analysis. Here's the link: http://dl.dropbox.com/u/14968/reserve%20triangle%20analysis.xls After talking with several people at the FFH meeting, it seemed like folks might be interested. In the triangle, you just have to type in the first year (top left) and the reserve data in the first two triangles. The spreadsheet then uses that data to create a ton of other triangles that are useful. One of the most important ones is generated right below the first two on the first sheet, which is the reserve development triangle by accident year. The second sheet derives the remaining reserves per accident year. The third sheet derives accident year development, both cumulative changes and incremental changes (these are actually used to generate the one on the first sheet). Finally, the third is used to determine tail. This particular sheet is for AIG using the reserve triangles for 2011. From my discussions at the pre-meeting, it seemed like some people missed it when I posted it in the AIG thread a few months back, so I thought I'd leave that data in.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now