Pages

Saturday, February 2, 2013

Calculate yield on a complicated life insurance policy


Several people have asked for an Excel spread sheet to calculate the yield of the life insurance policy.

This spreadsheet is now available at the FISCA website, FOR MEMBERS ONLY.  You have to login and download the spread sheet to do the calculation.

The spreadsheet can take care of premiums that are payable over a limited period and also for benefits that are paid out in cash at certain duration of the policy.

It also calculates that amount that you should get, if your premiums earn you a yield of 4% per annum. I consider 4% to be an acceptable yield, for a life insurance policy that provides protection. Any yield lower than 4%, makes the life policy unattractive.

The information page of FISCA is shown here:
http://easyapps.sg/assn/Org/Information.aspx?id=5

0 comments:

Post a Comment