Actuarial and Data Analytics

Providing information and advice on real problems

Need Help With EOY Reserves!

Leave a comment

Go ahead and try out our stripped down beta model of Reserve (ML).  See how it performs on your own data, and whether this simple model still adds value above traditional methods.

Before diving in though, please watch our prior video on how to use the model.

Please adhere to the following format of the data used in uploading (including header names).  Also, as noted in the video, try to include at least 36 months worth of data.  Here is a link to a template for ease.  This template consists of the following:

Incmo,Pdmo,MM, Paid
201501,201501,19600,778642.66
201501,201502,19600,966541.33
201501,201503,19600,157061.33

Incmo = Incurred Month; Pdmo = Paid Month; MM = Member Months; Paid = Claims paid

At this time (for the simple beta version), please do not reflect restated membership by paid month.  Keep all incurred months (no matter the paid month), the same (as illustrated above for 201501, all paid months have the same membership).

Otherwise, have at it!  The password is “Actuary“.

End of year reserves are upon us, we hope this will help you in some way (don’t forget to add MU to whatever method you choose).

Click here to try it out -> Reserve (ML) Model

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s