Dom's Actuarial Tools
  • Home
  • About
  • Actuarial Tools
    • Development Factors
    • Reinsurance Experience Rating Tool
    • Aggregate Loss Generator
    • General Experience Rater
    • Portal File
    • Data Loader
  • Actuarial Articles
    • Why Excel?
    • The First Step in Mastering Excel
    • Clean Up Your Lookups
    • Is Excel Distributable?
    • From Excel to SQL Server and Back Again
  • Contact

Reinsurance Experience Rating



The Reinsurance Experience Rating tool can be used to evaluate multiple layers of reinsurance using standard Excel formulas. The user can enter aggregated losses and individual losses as appropriate, in addition to trend rates, loss development factors, and historic rate changes. The model calculates trend factors, on-level factors, and interpolated loss development factors, and applies them to the data in a format that's easy to use.

As always, the tool is 100% Excel, and 100% free, so download it and start using it immediately!
Download Tool
Powered by Create your own unique website with customizable templates.