i am looking for lic premium calculator in excel for all types of plans if excel sheet is with formulas it would be great
From India, Mumbai
Acknowledge(0)
Amend(0)
1From India, Mumbai
Acknowledge(0)Amend(0)
I understand that you are looking for an LIC premium calculator in Excel format, preferably with formulas. Unfortunately, it's not possible to provide a ready-made Excel calculator as the premium rates for LIC policies can change based on various factors such as age, policy term, sum assured, and type of policy.
However, I can guide you on how you can create a simple premium calculator by yourself:
1. Open a new Excel sheet.
2. Label the following columns: 'Age', 'Policy Term', 'Sum Assured', and 'Premium'.
3. Under 'Age', enter the insured person's age.
4. Under 'Policy Term', enter the duration of the policy.
5. Under 'Sum Assured', enter the total amount to be paid upon policy maturity or death.
6. Under 'Premium', you'll need to calculate based on the policy's terms and conditions.
Here's a simplified example of how to calculate premium for a term insurance plan:
Premium = (Sum Assured / Policy Term) * Premium Rate
The Premium Rate can be obtained from LIC's premium charts, which are available on their official website http://www.licindia.in/.
Please note, this is a simplified version, and actual premium calculation can be more complex and varies across different policies. For accurate calculations, it is always advisable to consult with an LIC agent or visit the LIC official website.
Remember to always update your Excel sheet as LIC may revise their premium rates periodically.
I hope this helps! Please feel free to reach out if you have any more queries.
From India, Gurugram
Acknowledge(0)Amend(0)
However, I can guide you on how you can create a simple premium calculator by yourself:
1. Open a new Excel sheet.
2. Label the following columns: 'Age', 'Policy Term', 'Sum Assured', and 'Premium'.
3. Under 'Age', enter the insured person's age.
4. Under 'Policy Term', enter the duration of the policy.
5. Under 'Sum Assured', enter the total amount to be paid upon policy maturity or death.
6. Under 'Premium', you'll need to calculate based on the policy's terms and conditions.
Here's a simplified example of how to calculate premium for a term insurance plan:
Premium = (Sum Assured / Policy Term) * Premium Rate
The Premium Rate can be obtained from LIC's premium charts, which are available on their official website http://www.licindia.in/.
Please note, this is a simplified version, and actual premium calculation can be more complex and varies across different policies. For accurate calculations, it is always advisable to consult with an LIC agent or visit the LIC official website.
Remember to always update your Excel sheet as LIC may revise their premium rates periodically.
I hope this helps! Please feel free to reach out if you have any more queries.
From India, Gurugram
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Bonus-calculati on-excel-sheet. xls