Tuesday, January 29, 2013

Post Office Calculator for PLI

PLI Calculator:


Features in this File:

  • Automatic calculation of Age at Next Date of Birth of Insurant, (And for spouse and child if applicable).
  • Restriction on Minimum & Maximum Age limits/Sum Assured limits and it's Denomination
  • Premium can be viewed at same time for all the possible maturity ages and for all schemes
  • Calculation of Approximate maturity amounts of EA policy for possible Ages, according to the entered Bonus
  • Automatic deduction of Rebate from Premium applicable for entered Sum assured amount.
  • Unique Rebate structure for Sum assured amount in respect of Yugal suraksha policy is configured.
  • Automatic calculation of equivalent age by Combination of both the spouses date of birth in Joint Life insurance
  • Intimation of Possibilitiy of Taking a children policy by combining Both Parent's and child's Date of Birth
  • Configuration of Policy period for Joint life insurance and Maturity age for Children policy as dropdown lists
  • Display of Warning messages for entry of incorrect data in respect of Minimum/Maximum/Multiples of SA; Minimum enty age; policy period in Yugal suraksha; maturity age in Children policy,etc.,
  • Display of "Help Notes" for all input details at yellow boxes, etc., 

Calculator:
xlsx

POLI Rules 2011:
zip|docx
Premium tables:
zip|docx



POSB Interest & Postal Rate Calculator

POSB Calculator:

Features in this File:

  • Option for Entering Date of Opening of Accounts
  • Their Respective Maturity/Interest Amounts, A/c periods, Date of maturity,etc.,
  • Current status of A/c for Closure/PMC/extn., etc.,
  • Reduced Int. for TD, Bonus, Deductions, PMI details,etc.,
  • KVP discharge value calc,
  • SB,PPF,PMI calc,
  • PPF approx maturity value calc,
  • Easy Initialisation of Interest rates for schemes, if changed...
  • Option to download the latest excel calculator (if any), right from this excel file itself...  
xlsx

Postal Rates:

to download:
xlsx


Source:
https://sites.google.com/site/posbinterestcalculator
https://sites.google.com/site/postalrates

Post Office RPLI Calculator Icon

RPLI Calculator:



Features in this File:

  • Home page is provided in the file to navigate from one type to another type of Policies
  • Premium amount is calculated both for Standard Age Proof and Non-Standard Age Proof policies
  • Premium amount is calculated Seperately for Monthly, Quarterly, Halfyearly & Yearly Premium Policies. 
  • Automatic calculation of Age at Next Date of Birth of Insurant. 
  • Restriction on Minimum & Maximum Age limits/Sum Assured limits and it's Denomination
  • Premium can be viewed at same time for all the possible maturity ages.
  • Calculation of Approximate maturity amounts for possible Ages, according to the entered Bonus,which is editable.
  • Automatic deduction of Rebate from Premium applicable for entered Sum assured amount.
  • Configuration of Policy period for Children policy as drop-down list.
  • Calculation of Total premium, Default Fee and Rebate amount for Monthly premium policy type.
  • Display of Warning messages for entry of incorrect data in respect of Minimum/Maximum/Multiples of SA; Minimum entry age;Maturity age in Children policy,etc.,
  • Display of "Help Notes" for all input details at yellow boxes, etc.,
  • Option is provided in the main page of excel file to Download the Latest Calculator, if any changes/corrections specified by users are made within a week.
  • Feedback Link is provided in Home Page to submit your view about this Calculator, Corrections to be made, etc.,




Source:


https://sites.google.com/site/rplipremiumcalculator