Scribd
Upload
47 views7 pages

1.rpli Premium Cum Profit Calculator

The document is a calculator that allows users to calculate RPLI premiums and profits based on user-entered information like sum assured, date of birth, age at maturity, premium amounts, and more. It provides a table of premium amounts and returns for policies based on standard or non-standard age proofs for policies that mature between ages 35 to 60. However, all values in the tables are currently set to 0 as the calculator requires users to input values first before providing calculations.

Uploaded by

shanku_biet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
47 views7 pages

1.rpli Premium Cum Profit Calculator

The document is a calculator that allows users to calculate RPLI premiums and profits based on user-entered information like sum assured, date of birth, age at maturity, premium amounts, and more. It provides a table of premium amounts and returns for policies based on standard or non-standard age proofs for policies that mature between ages 35 to 60. However, all values in the tables are currently set to 0 as the calculator requires users to input values first before providing calculations.

Uploaded by

shanku_biet
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

RPLI PREMIUM CUM PROFIT CALCULATOR

Developed by…

B.VENKATESAN
PA,CPC,MELAKAVERI HO 612002
KUMBAKONAM DIVISION
TAMILNADU CIRCLE
Email: sbvenkat2008@gmail.com
SUM ASSURED 5000000 D.O.B 11/4/1990

PREMIUM (EXCL.SER.TAX) 0 AGE AT MATURITY 45


PREMIUM (INCL.SER.TAX) 0

PERIOD 28-Dec-21 28-Dec-34

AGE AT ENTRY 32
AMT PAID (EXCL.SER.TAX) 0 TERM 13
APPROX.MATURITY VALUE 0
(BASED ON RS.50/- BONUS)
NET PROFIT 0

NON STANDARD AGE PROOF NON STANDARD AGE PROOF? YES


PREMIUM (EXCL.SER.TAX) 0
PREMIUM (INCL.SER.TAX) 0

* THIS IS FOR EA POLICIES ONLY


* ENSURE CALCULATED AMOUNT YOURSELF

« CPC,MELAKAVERI 612002 »
VALUES TO BE ENTERED

STANDARD AGE PROOF


AGE (19-55; MAX RS.10,00,000)
AGE (ABOVE 45, MAX RS.1,00,000)

NON STANDARD AGE PROOF


AGE (19-45; MAX RS.1,00,000)
SUM ASSURED 0
AGE AT MATURITY 35 40 45
AGE AT ENTRY PREMIUM PAID RETURNS PREMIUM PAID RETURNS PREMIUM PAID
19 0 0 0 0 0 0 0 0
20 0 0 0 0 0 0 0 0
21 0 0 0 0 0 0 0 0
22 0 0 0 0 0 0 0 0
23 0 0 0 0 0 0 0 0
24 0 0 0 0 0 0 0 0
25 0 0 0 0 0 0 0 0
26 0 0 0 0 0 0 0 0
27 0 0 0 0 0 0 0 0
28 0 0 0 0 0 0 0 0
29 0 0 0 0 0 0 0 0
30 0 0 0 0 0 0 0 0
31 0 0 0 0 0 0 0 0
32 0 0 0 0 0 0 0 0
33 0 0 0 0 0 0 0 0
34 0 0 0 0 0 0 0 0
35 0 0 0 0 0 0 0 0
36 0 0 0 0 0 0 0 0
37 0 0 0 0 0 0 0 0
38 0 0 0 0 0 0 0 0
39 0 0 0 0 0 0 0 0
40 0 0 0 0 0 0 0 0
41 0 0 0 0 0 0 0 0
42 0 0 0 0 0 0 0 0
43 0 0 0 0 0 0 0 0
44 0 0 0 0 0 0 0 0
45 0 0 0 0 0 0 0 0
46 0 0 0 0 0 0 0 0
47 0 0 0 0 0 0 0 0
48 0 0 0 0 0 0 0 0
49 0 0 0 0 0 0 0 0
50 0 0 0 0 0 0 0 0
51 0 0 0 0 0 0 0 0
52 0 0 0 0 0 0 0 0
53 0 0 0 0 0 0 0 0
54 0 0 0 0 0 0 0 0
55 0 0 0 0 0 0 0 0
45 50 55 58
RETURNS PREMIUM PAID RETURNS PREMIUM PAID RETURNS PREMIUM PAID RETURNS
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
60
PREMIUM PAID RETURNS
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0

You might also like