Macro for calculation of various Actuarial life table functions

Macro for calculation of various Actuarial life table functions
3+

Please download the relevant output and input file from the below given Download button.

The model contains a macro for calculation of various functions from Actuarial tables such as commutation function, Expected Future lifetime of an individual, nPx and etc.

The Pre-requisites for understanding the macro are:-

Knowledge of CT 5/ CM 1 (Actuarial Science)

Basic Knowledge of VBA such as Nested Loops, Arrays, MsgBox and Conditional statements.

We have used AM92 mortality table for our calculation purposes.

Any kind of suggestion or feedback are most welcome


Vaishnavi Rastogi

Actuarial Student

3+

Mathematica-City

Mathematica-city is an online Education forum for Science students run by Kounteyo, Shreyansh and Souvik. We aim to provide articles related to Actuarial Science, Data Science, Statistics, Mathematics and their applications using different Statistical Software. Feel free to reach out to us for any kind of discussion on any of the related topics,

Leave a Reply

Your email address will not be published.