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.