Macro For Expected Present Value of Whole Life and Term Annuities (Both Arrear and Advance)
Please Download the Input Data and Output file from the below given Download Button.
The Pre-requisites for understanding the model:-
Knowledge of CT 5/ CM 1 (Actuarial Science)
Basic Knowledge of VBA such as Nested Loops, Arrays, MsgBox and Conditional statements.
This is our second article on Macro,VBA.
It contains a macro button to Calculate the Expected Present Value of different types of Annuities.
We have used AM92 mortality table for the calculation of the Expected Present Value of the Annuities.
Our Next posts will include macro (VBA) for Expected Present Value of Annuities, Assurances, Reserves for different types of Insurance policies such as Term, Pure Endowment, Whole Life and etc.
Any kind of suggestion or feedback are most welcome.