Learning Center

For your convenience SAFE TOOLBOXES® already comes with some of the most used actuarial tables. At the moment, SAFE TOOLBOXES® comes with the following tables loaded in the database and ready to use:

Table Number

Table Name

Table Kind

Table Description

1

ZEROS

Life table

No mortality: qx = 0 for all ages, except q130 = 1

2

GAM1983F

Life table

1983 Group Annuity Mortality (GAM) Table – Female. Formerly Table 18-B. Minimum Age: 5 Maximum Age: 110

3

GAM1983M

Life table

1983 Group Annuity Mortality (GAM) Table – Male. Formerly Table 18-A. Minimum Age: 5 Maximum Age: 110

4

GAMBASIC1983F

Life table

1983 Group Annuity Mortality (GAM) Basic Table – Female. Formerly Table 17-B. Minimum Age: 5 Maximum Age: 110

5

GAMBASIC1983M

Life table

1983 Group Annuity Mortality (GAM) Basic Table – Male. Formerly Table 17-A. Minimum Age: 5 Maximum Age: 110

6

UP1994F

Life table

1994 Uninsured Pensioner (UP-94) Mortality Table - Female.  Basis: Age Nearest Birthday. Minimum Age: 1. Maximum Age: 120 (formerly called the 1994 GAM Basic Table - Female)

7

UP1994M

Life table

1994 Uninsured Pensioner (UP-94) Mortality Table - Male.  Basis: Age Nearest Birthday. Minimum Age: 1. Maximum Age: 120 (formerly called the 1994 GAM Basic Table - Male)

8

GAM1994F

Life table

1994 Group Annuitant Mortality (GAM) Static – Female.  Basis: Age Nearest Birthday. Minimum Age: 1 Maximum Age: 120

9

GAM1994M

Life table

1994 Group Annuitant Mortality (GAM) Static – Male.  Basis: Age Nearest Birthday. Minimum Age: 1 Maximum Age: 120

10

AT2000F

Life table

Annuity 2000 Basic Table – Female. Minimum Age: 5 Maximum Age: 115

11

AT2000M

Life table

Annuity 2000 Basic Table – Male. Minimum Age: 5 Maximum Age: 115

12

SCALEAA1994F

Scale

1994 Mortality Improvement Projection Scale AA - Female. Minimum Age: 1 Maximum Age: 120

13

SCALEAA1994M

Scale

1994 Mortality Improvement Projection Scale AA - Male. Minimum Age: 1 Maximum Age: 120

14

RP2000EBYM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Employee, 1992 Base Year Rates (Table 3-1).  Minimum Age: 1. Maximum Age: 70

15

RP2000HBYM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Healthy Annuitant, 1992 Base Year Rates (Table 3-1).  Minimum Age: 50.  Maximum Age: 120

16

RP2000CBYM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Combined Healthy Participant, Male RP-200 Rates (Table 4-5). Minimum Age: 1. Maximum Age: 120

17

RP2000DBYM

Disabled life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Disabled Retiree, 1992 Base Year Rates (Table 3-1).  Minimum Age: 21.  Maximum Age: 120

18

RP2000EBYF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Employee, 1992 Base Year Rates (Table 3-1).  Minimum Age: 1. Maximum Age: 70

19

RP2000HBYF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Healthy Annuitant, 1992 Base Year Rates (Table 3-1).  Minimum Age: 50.  Maximum Age: 120

20

RP2000CBYF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Combined Healthy Participant, Female RP-2000 Rates (Table 4-6). Minimum Age: 1. Maximum Age: 120

21

RP2000DBYF

Disabled life table

Retirement Plan (RP) - 2000 Mortality Table Female Aggregate Disabled Retiree, 1992 Base Year Rates (Table 3-1).  Minimum Age: 21.  Maximum Age: 120

22

RP2000WBYM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - White Collar, 1992 Base Year Rates (Table S-2). Minimum Age: 1. Maximum Age: 120

23

RP2000BBYM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Blue Collar, 1992 Base Year Rates (Table S-1). Minimum Age: 1. Maximum Age: 120

24

RP2000WBYF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - White Collar, 1992 Base Year Rates (Table S-2). Minimum Age: 1. Maximum Age: 120

25

RP2000BBYF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Blue Collar, 1992 Base Year Rates (Table S-1). Minimum Age: 1. Maximum Age: 120

26

RP2000EM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Employees (Table 4-5).  Minimum Age: 1. Maximum Age: 70

27

RP2000HM

Life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Healthy Annuitant (Table 4-5).  Minimum Age: 50.  Maximum Age: 120

28

RP2000DM

Disabled life table

Retirement Plan (RP) - 2000 Mortality Table - Male Aggregate - Disabled Retiree, (Table 4-5).  Minimum Age: 21.  Maximum Age: 120

29

RP2000EF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Employee (Table 4-6).  Minimum Age: 1. Maximum Age: 70

30

RP2000HF

Life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Healthy Annuitant (Table 4-6).  Minimum Age: 50.  Maximum Age: 120

31

RP2000DF

Disabled life table

Retirement Plan (RP) - 2000 Mortality Table - Female Aggregate - Disabled Retiree (Table 4-6).  Minimum Age: 21.  Maximum Age: 120

32

RP2014TEM

Life table

RP-2014 Rates-Total Dataset-Employee-Male

33

RP2014THM

Life table

RP-2014 Rates-Total Dataset-Healthy Annuitant-Male

34

RP2014TDM

Disabled life table

RP-2014 Rates-Total Dataset-Disabled Retiree-Male

35

RP2014TEF

Life table

RP-2014 Rates-Total Dataset-Employee-Female

36

RP2014THF

Life table

RP-2014 Rates-Total Dataset-Healthy Annuitant-Female

37

RP2014TDF

Disabled life table

RP-2014 Rates-Total Dataset-Disabled Retiree-Female

38

RP2014BEM

Life table

RP-2014 Rates-Blue Collar-Employee-Male

39

RP2014BHM

Life table

RP-2014 Rates-Blue Collar-Healthy Annuitant-Male

40

RP2014BEF

Life table

RP-2014 Rates-Blue Collar-Employee-Female

41

RP2014BHF

Life table

RP-2014 Rates-Blue Collar-Healthy Annuitant-Female

42

RP2014WEM

Life table

RP-2014 Rates-White Collar-Employee-Male

43

RP2014WHM

Life table

RP-2014 Rates-White Collar-Healthy Annuitant-Male

44

RP2014WEF

Life table

RP-2014 Rates-White Collar-Employee-Female

45

RP2014WHF

Life table

RP-2014 Rates-White Collar-Healthy Annuitant-Female

46

RP2014JM

Life table

RP-2014 Rates-Juvenile Male

47

RP2014JF

Life table

RP-2014 Rates-Juvenile Female

48

MP2014SCALE2015M

Scale

RP-2014 Mortality improvement scales Male (2015 scale)

49

MP2014SCALE2016M

Scale

RP-2014 Mortality improvement scales Male (2016 scale)

50

MP2014SCALE2017M

Scale

RP-2014 Mortality improvement scales Male (2017 scale)

51

MP2014SCALE2018M

Scale

RP-2014 Mortality improvement scales Male (2018 scale)

52

MP2014SCALE2019M

Scale

RP-2014 Mortality improvement scales Male (2019 scale)

53

MP2014SCALE2020M

Scale

RP-2014 Mortality improvement scales Male (2020 scale)

54

MP2014SCALE2021M

Scale

RP-2014 Mortality improvement scales Male (2021 scale)

55

MP2014SCALE2022M

Scale

RP-2014 Mortality improvement scales Male (2022 scale)

56

MP2014SCALE2023M

Scale

RP-2014 Mortality improvement scales Male (2023 scale)

57

MP2014SCALE2024M

Scale

RP-2014 Mortality improvement scales Male (2024 scale)

58

MP2014SCALE2025M

Scale

RP-2014 Mortality improvement scales Male (2025 scale)

59

MP2014SCALE2026M

Scale

RP-2014 Mortality improvement scales Male (2026 scale)

60

MP2014SCALE2027M

Scale

RP-2014 Mortality improvement scales Male (2027 scale)

61

MP2014SCALE2028M

Scale

RP-2014 Mortality improvement scales Male (2028 scale)

62

MP2014SCALE2029M

Scale

RP-2014 Mortality improvement scales Male (2029 scale)

63

MP2014SCALE2030+M

Scale

RP-2014 Mortality improvement scales Male (2030+ scale)

64

MP2014SCALE2015F

Scale

RP-2014 Mortality improvement scales Female (2015 scale)

65

MP2014SCALE2016F

Scale

RP-2014 Mortality improvement scales Female (2016 scale)

66

MP2014SCALE2017F

Scale

RP-2014 Mortality improvement scales Female (2017 scale)

67

MP2014SCALE2018F

Scale

RP-2014 Mortality improvement scales Female (2018 scale)

68

MP2014SCALE2019F

Scale

RP-2014 Mortality improvement scales Female (2019 scale)

69

MP2014SCALE2020F

Scale

RP-2014 Mortality improvement scales Female (2020 scale)

70

MP2014SCALE2021F

Scale

RP-2014 Mortality improvement scales Female (2021 scale)

71

MP2014SCALE2022F

Scale

RP-2014 Mortality improvement scales Female (2022 scale)

72

MP2014SCALE2023F

Scale

RP-2014 Mortality improvement scales Female (2023 scale)

73

MP2014SCALE2024F

Scale

RP-2014 Mortality improvement scales Female (2024 scale)

74

MP2014SCALE2025F

Scale

RP-2014 Mortality improvement scales Female (2025 scale)

75

MP2014SCALE2026F

Scale

RP-2014 Mortality improvement scales Female (2026 scale)

76

MP2014SCALE2027F

Scale

RP-2014 Mortality improvement scales Female (2027 scale)

77

MP2014SCALE2028F

Scale

RP-2014 Mortality improvement scales Female (2028 scale)

78

MP2014SCALE2029F

Scale

RP-2014 Mortality improvement scales Female (2029 scale)

79

MP2014SCALE2030+F

Scale

RP-2014 Mortality improvement scales Female (2030+ scale)

80

ALVAROVINDAS

Disability entrance table

Morbidity table


The list of available actuarial tables is presented in the combo box at the top of the Actuarial Toolbox tab. If the list is empty, you should click on the refresh button next to the combo box. To view a table description and its values click on the "View actuarial table" icon.

You can also add to the database whatever table you want to. To add a new table to the database, just click on the "plus" icon. Every new table must have all fields marked with an asterisk “*” and all its 131 values filled.

If you want to see the full mortality table, simply select the appropriate option in the “Table view” combo box and choose an upper left destination cell to receive the table. SAFE will automatically insert the appropriate formulas in the cells and display the results.

A

B

C

D

E

F

G

1

Actuarial table

6

UP1994F

 

 

 

 

2

 

 

 

 

 

 

 

3

Age (x)

People alive (lx)

Deaths (dx)

Probability of death (qx)

Probability of survival (px)

Expectation of life (ex)

 

4

0

1000000.0

0.0

0.000000

1.000000

83.1

=sActuarialTable($B$1)

5

1

1000000.0

571.0

0.000571

0.999429

82.1

 

6

2

999429.0

371.8

0.000372

0.999628

81.1

 

7

3

999057.2

277.7

0.000278

0.999722

80.1

 

8

4

998779.5

207.7

0.000208

0.999792

79.2

 

9

5

998571.7

187.7

0.000188

0.999812

78.2

 

10

6

998384.0

175.7

0.000176

0.999824

77.2

 

11

7

998208.3

164.7

0.000165

0.999835

76.2

 

12

8

998043.6

146.7

0.000147

0.999853

75.2

 

13

9

997896.9

139.7

0.000140

0.999860

74.2

 

14

10

997757.2

140.7

0.000141

0.999859

73.2

 

...

...

...

...

...

...

...

 

75

71

857608.5

13789.5

0.016079

0.983921

16.0

 

76

72

843819.1

14976.1

0.017748

0.982252

15.3

 

77

73

828843.0

16348.1

0.019724

0.980276

14.5

 

78

74

812494.9

17805.8

0.021915

0.978085

13.8

 

79

75

794689.0

19384.8

0.024393

0.975607

13.1

 

80

76

775304.2

21112.3

0.027231

0.972769

12.4

 

81

77

754191.9

23003.6

0.030501

0.969499

11.8

 

82

78

731188.3

24944.5

0.034115

0.965885

11.1

 

83

79

706243.8

26854.2

0.038024

0.961976

10.5

 

84

80

679389.6

28779.6

0.042361

0.957639

9.9

 

...

...

...

...

...

...

...

 

119

115

6.8

3.4

0.500000

0.500000

1.5

 

120

116

3.4

1.7

0.500000

0.500000

1.4

 

121

117

1.7

0.8

0.500000

0.500000

1.4

 

122

118

0.8

0.4

0.500000

0.500000

1.3

 

123

119

0.4

0.2

0.500000

0.500000

1.0

 

124

120

0.2

0.2

1.000000

0.000000

0.5

 

125

121

0.0

0.0

1.000000

0.000000

0.0

 

126

122

0.0

0.0

1.000000

0.000000

0.0

 

127

123

0.0

0.0

1.000000

0.000000

0.0

 

128

124

0.0

0.0

1.000000

0.000000

0.0

 

129

125

0.0

0.0

1.000000

0.000000

0.0

 

130

126

0.0

0.0

1.000000

0.000000

0.0

 

131

127

0.0

0.0

1.000000

0.000000

0.0

 

132

128

0.0

0.0

1.000000

0.000000

0.0

 

133

129

0.0

0.0

1.000000

0.000000

0.0

 

134

130

0

0

1.000000

0.000000

0.0

 

 

 

 

 

 

 

 

 

© 2016 Safe Quantitative Technologies, ltd. All rights reserved.