Macro for calculation of various Actuarial life table functions

Macro for calculation of various Actuarial life table functions

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



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,

3 thoughts on “Macro for calculation of various Actuarial life table functions

  1. I want to show my admiration for your kind-heartedness supporting persons that require help on this important theme. Your special dedication to passing the solution all over had become unbelievably valuable and has in most cases permitted most people just like me to achieve their desired goals. Your own warm and helpful guideline implies this much a person like me and still more to my peers. Best wishes; from each one of us.

  2. I am also writing to let you be aware of what a great discovery my cousin’s girl obtained reading through your web page. She realized a lot of issues, including how it is like to have an amazing helping character to have others smoothly know just exactly chosen tortuous issues. You actually did more than readers’ desires. Thank you for showing such precious, trusted, explanatory as well as cool thoughts on the topic to Kate.


Leave a Reply

Your email address will not be published.