Macro For Expected Present Value of Whole Life and Term Annuities (Both Arrear and Advance)

Macro For Expected Present Value of Whole Life and Term Annuities  (Both Arrear and Advance)
1+

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.

Shreyansh Agarwal
Shreyansh Agarwal

Actuarial Intern at Lux


1+

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.