This calculator allows you to determine:

1. Paid-up value

2. Guaranteed Surrender value

3. Special Surrender value

of any non-ULIP insurance policy. The numbers should be exact for LIC policies since it uses their surrender value factors. This can be used as a crude estimate for other insurers provided a lower average bonus rate is used.

The above numbers are calculated with (a) no bonus, (b) bonus rates for each year of policy (up to 20 years) if known or (c) with an average bonus rate.

It tells if your surrender value is taxable or not.

It allows you to compare paid-up and surrender options. it has some useful notes on bonus rates and some info on when to do what (along the lines of the blog post). Relevant interesting links are also included.

**Download the Insurance Policy Surrender Value and Paid-up Value Calculator**

**Also Read:**

**Insurance Policy Surrender Value & Paid-up Value Calculator****OMG! Just Realized My Insurance Policies are Worthless! What do I do?**

link to download has http at end so clicking gives 404 error

Fixed. Thanks

Pattu it’s great..I am also doing a similar post and would refer to your calculator..

Man you saved me lot of hard work!

Thanks a lot!

pattu sir,if you make policy paid up,whether we will get paid up value plus bonus amount whatever acquired till now?or we will get only paidup value?

Dear Dilip,

All bonuses applicable up to date of making it paid-up will be paid along with paid-up value during date of maturity. Unfortunately if the paid-up date is far away from maturity date the money will simple be idle and not earn any interest

Thank you sir! I have paid 5yrs premium and stopped paying premium. still 15yrs there for maturity.so it’s better to take money and invest somewhere else.

Great! Thanks Dilip. Good luck.

There is no monthly option available for premium payment mode.

Thanks for commenting. I am not sure of how surrender values of calculated if premiums are no calculated for whole years (eg. 2.5). In such cases I would enter 2. Trouble is this kind of information is not available in the public domain. Why would it be? No company wants policy holders to surrender!

Thanks for your quick response. The file is really useful. If I input quarterly premiums (simply by multiplying monthly premium with 3), the SV quoted by LIC is just 3k lower than the amount arrived as per your sheet.

Thank you! This is the kind of feedback I was expecting for this calculator! May I know if you given the correct bonus amt as inputs?

Hi,

I have downloaded the calculator, but I am getting the correct SV what was told by the LIC employee. My SA is 500000, PPT is 10 years, its a whole life money back policy (Jeevan Rekha) which gives back 10% of SA every 5 years. I have paid 8 premiums. And premium is 31526. Please let me know, when will be my break even when I surrender this policy. Currect SV is 151000.

1. I am not sure about how SV is calculated in case of money-back policies. You must have got some amt after 5 yrs. Perhaps this should be deducted from the result seen in the excel file.

2. When use the excel file did you use the correct bonus amounts?

In your case, if I understand you write, your annual premium is 31256, policy term is 10 yr and you have paid 8 yrs.

My advice: kindly do not surrender. Please pay the remaining premiums let the policy run to maturity.

if you have bonus amounts and the SV obtained from LIC website, kindly send it to me. I will use it to check the calculator.

I have a Reliance money multiplier plan

Premium is Rs 50236 yearly and term is 10 years. BSA is Rs 341774.

Company person promised me that on surrendering the policy after paying 3 premiums and on completion of 4th year i will get

GSV (30 %) + SSV (40 % of Paid up value on Maturity) + Paid up value for 3 years.

Is it correct .

.

Thats sounds like a little too much. In traditional policies SSV is all you get. I don’t remember the exact formula now (I am out of town currently) but it is there in the excel file.

If you are considering stopping premium payment. Make it paid-up instead of surrendering. In this article

http://freefincal.wordpress.com/2013/04/26/omg-just-realized-my-insurance-policies-are-worthless-what-do-i-do/

I have listed the advantages.

Excellent tool, really useful. Thanks a ton..

Thank you.

I have Jeevan saral with monthly premium, your calculator sheet does not have monthly premium input option? please told how can I use your calculator for monthly premium option?

Hi Animesh,

convert monthly premium to annual premium to get an estimate of paid up and surrender values. Note that in most cases making a policy paid-up is the simplest and best option.

Hello Sir,

Thanks for the various templates shared! I have downloaded many of them, but this is the first one that I have used. I have a question – my situation is very similar to the illustration you have given here – 4.25 years completed. Now it’s not 5, but I have claimed the 80C deduction every fin year. However, I also see that my policy has been issued in Oct 2009, so it’s before 2003. So, finally if I surrender it, will the returns be taxable? Your template says no, but I am posting this comment to confirm it.

Thanks in advance for your time and reply.

Hi Kunal, Thank you. My understanding is that you should wait until 5 years are completed before surrendering. If you surrender before 5 years, the 80C deductions become invalid and you will need pay on those in the FY year of surrender.

Hello Mr. Pattu,

I am shiva and i have gone for jeevan anand policy.

I am 23 years old as of now. Intially when i took the policy a year back, it seemed very lucrative but now it feels really difficult for me to pay the premiums

I took this policy in the month of may 2013 and i have so far payed 59,268 in 2 installments of 29,634 each. I dont want to for surrender option because i know i would be paid peanuts for the total amount i will be paying.

I wish to go for paid up option. I also understand that i will have to pay money for atleast 3 years to go for paid up option.

So in 3 years i will be paying 1,77,804 ( 59268 * 3). Assuming my bonus rate to be 50, kindly let me know how much i will be getting after 21 years which is my policy term

PS: I tried using your calculator but sorry i couldnt understand anything properly

What do u suggest ?

If make the policy paidup the amt you will receive after 21 years will only be a little higher than the surrender value since further bonuses will stop. If you take inflation into account, you will practically get nothing.

If you can stomach this 59K loss now and stop premiums, you will not get the addition loss of 59K x 2. So my advice is to stop your losses now. You are only 23. Invest in equity mutual funds aggressively. You will easily make up the loss.

yes