Spreadsheet: 213647d1360602038-premium-calculations-premium-calculations
Sheet: Database

Age | 1 | 2 | 3
FINAL PREMIUM CALCULATION |  |  |  |  |  |  | FINAL PREMIUM CALCULATION
1 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | [NAME] | Premium per member for Self/Parent | Premium per member for Dependents | Premium per member for Dependent Parents
2 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | <20 | 2328.7185 | 465.7437 | 931.4874
3 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 21-35 | 2587.698 | 517.5396 | 1035.0792
4 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 36-45 | 3094.1235 | 618.8247000000001 | 1237.6494
5 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 46-55 | 4906.98 | 981.396 | 1962.792
6 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 56-60 | 7011.3195 | 1402.2639 | 2804.5278
7 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 61-70 | 10503.873 | 2100.7746 | 4201.5492
8 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | Above 70 | 14341.383 | 2868.2766 | 5736.5532
9 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | with Service Tax - 12.36%
10 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | <20
11 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 21-35
12 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 36-45
13 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 46-55
14 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 56-60
15 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | 61-70
16 | 2328.7185 | 465.7437 | 931.4874 |  |  |  | Above 70
17 | 2328.7185 | 465.7437 | 931.4874
18 | 2328.7185 | 465.7437 | 931.4874
19 | 2328.7185 | 465.7437 | 931.4874
20 | 2328.7185 | 465.7437 | 931.4874
21 | 2587.698 | 517.5396 | 1035.0792
22 | 2587.698 | 517.5396 | 1035.0792
23 | 2587.698 | 517.5396 | 1035.0792
24 | 2587.698 | 517.5396 | 1035.0792
25 | 2587.698 | 517.5396 | 1035.0792
26 | 2587.698 | 517.5396 | 1035.0792
27 | 2587.698 | 517.5396 | 1035.0792
28 | 2587.698 | 517.5396 | 1035.0792
29 | 2587.698 | 517.5396 | 1035.0792
30 | 2587.698 | 517.5396 | 1035.0792
31 | 2587.698 | 517.5396 | 1035.0792
32 | 2587.698 | 517.5396 | 1035.0792
33 | 2587.698 | 517.5396 | 1035.0792
34 | 2587.698 | 517.5396 | 1035.0792
35 | 2587.698 | 517.5396 | 1035.0792
36 | 3094.1235 | 618.8247000000001 | 1237.6494
37 | 3094.1235 | 618.8247000000001 | 1237.6494
38 | 3094.1235 | 618.8247000000001 | 1237.6494
39 | 3094.1235 | 618.8247000000001 | 1237.6494
40 | 3094.1235 | 618.8247000000001 | 1237.6494
41 | 3094.1235 | 618.8247000000001 | 1237.6494
42 | 3094.1235 | 618.8247000000001 | 1237.6494
43 | 3094.1235 | 618.8247000000001 | 1237.6494
44 | 3094.1235 | 618.8247000000001 | 1237.6494
45 | 3094.1235 | 618.8247000000001 | 1237.6494
46 | 4906.98 | 981.396 | 1962.792
47 | 4906.98 | 981.396 | 1962.792
48 | 4906.98 | 981.396 | 1962.792
49 | 4906.98 | 981.396 | 1962.792
50 | 4906.98 | 981.396 | 1962.792
51 | 4906.98 | 981.396 | 1962.792
52 | 4906.98 | 981.396 | 1962.792
53 | 4906.98 | 981.396 | 1962.792
54 | 4906.98 | 981.396 | 1962.792
55 | 4906.98 | 981.396 | 1962.792
56 | 7011.3195 | 1402.2639 | 2804.5278
57 | 7011.3195 | 1402.2639 | 2804.5278
58 | 7011.3195 | 1402.2639 | 2804.5278
59 | 7011.3195 | 1402.2639 | 2804.5278
60 | 7011.3195 | 1402.2639 | 2804.5278
61 | 10503.873 | 2100.7746 | 4201.5492
62 | 10503.873 | 2100.7746 | 4201.5492
63 | 10503.873 | 2100.7746 | 4201.5492
64 | 10503.873 | 2100.7746 | 4201.5492
65 | 10503.873 | 2100.7746 | 4201.5492
66 | 10503.873 | 2100.7746 | 4201.5492
67 | 10503.873 | 2100.7746 | 4201.5492
68 | 10503.873 | 2100.7746 | 4201.5492
69 | 10503.873 | 2100.7746 | 4201.5492
70 | 10503.873 | 2100.7746 | 4201.5492
71 | 14341.383 | 2868.2766 | 5736.5532
with Service Tax - 12.36%
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71