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)

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


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. We also provide freelancing services on the aforementioned topics. Feel free to reach out to us for any kind of discussion on any of the related topics.

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

  1. I as well as my pals were actually examining the great recommendations from your web site and immediately I got a horrible feeling I never expressed respect to the blog owner for those secrets. The ladies became for that reason glad to study all of them and now have in fact been enjoying them. Thank you for simply being considerably accommodating as well as for opting for such wonderful themes most people are really desirous to be aware of. My very own honest apologies for not expressing appreciation to sooner.

  2. My husband and i felt really thrilled Chris could complete his studies through the precious recommendations he received through the weblog. It’s not at all simplistic to simply choose to be handing out tactics which people today could have been making money from. And now we acknowledge we need the blog owner to thank because of that. The specific explanations you’ve made, the simple web site navigation, the relationships you can help to create – it’s many exceptional, and it’s leading our son in addition to our family imagine that that content is exciting, and that’s rather pressing. Thanks for all the pieces!

  3. I would like to express appreciation to the writer for bailing me out of this scenario. As a result of checking throughout the world-wide-web and finding proposals which were not productive, I was thinking my entire life was over. Being alive without the approaches to the problems you’ve fixed as a result of the blog post is a crucial case, and the ones that might have in a negative way affected my career if I had not discovered your blog. Your own personal know-how and kindness in maneuvering all the stuff was very helpful. I don’t know what I would’ve done if I had not discovered such a subject like this. I can at this point relish my future. Thank you so much for this skilled and result oriented guide. I will not hesitate to propose your blog to anyone who should receive support on this area.

Leave a Reply

Your email address will not be published.