junior1505
New Member
Dear Experts,
Have tabulated the premium amount for age range and insured amount.
Wish to apply the formula to find the premium amount based on age and insured amount, table pasted.
please help.
Regards
Have tabulated the premium amount for age range and insured amount.
Wish to apply the formula to find the premium amount based on age and insured amount, table pasted.
please help.
Regards
Age To | ₹ 2,00,000.00 | ₹ 2,50,000.00 | ₹ 3,00,000.00 | ₹ 3,50,000.00 | ₹ 4,00,000.00 | ₹ 4,50,000.00 | ₹ 5,00,000.00 |
40 | ₹ 876.74 | ₹ 1,033.68 | ₹ 1,099.76 | ₹ 1,251.98 | ₹ 1,327.50 | ₹ 1,470.28 | ₹ 1,517.48 |
60 | ₹ 1,168.20 | ₹ 1,378.24 | ₹ 1,466.74 | ₹ 1,668.52 | ₹ 1,770.00 | ₹ 1,959.98 | ₹ 2,022.52 |
100 | ₹ 1,752.30 | ₹ 2,067.36 | ₹ 2,199.52 | ₹ 2,503.96 | ₹ 2,655.00 | ₹ 2,939.38 | ₹ 3,034.96 |
Employee ID | Employee Name | Age | Sum Insured | Premium | |||
50001 | Ramesh K | 58 | ₹ 2,00,000.00 | ₹ 1,168.20 | |||
50002 | Kareena B | 40 | ₹ 2,50,000.00 | ||||
50003 | Sanjay S | 32 | ₹ 4,00,000.00 | ||||
50004 | Sam C | 41 | ₹ 3,50,000.00 | ||||
50005 | Arpita D | 65 | ₹ 5,00,000.00 |