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