ExperienceStudy (PDF)




File information


Title: ExperienceStudy.xlsm
Author: jboyles

This PDF 1.6 document has been generated by PScript5.dll Version 5.2.2 / Acrobat Distiller 9.5.0 (Windows), and has been sent on pdf-archive.com on 13/10/2012 at 05:11, from IP address 24.4.x.x. The current document download page has been viewed 821 times.
File size: 207.2 KB (13 pages).
Privacy: public file
















File preview


Max
Min

100

Cumulative Deaths by Age for Males and Females in Status R I B A

#N/A
600

500 Deaths by Age for Males and Females in Status R I B A
Cumulative
Deaths by Age for Males and Females in Status R I B A

Deaths

400

Actual

300

Current
Proposed
200

100

0
39

44

49

54

59

64

69

74

79

84

89

94

99

Age

Deaths by Age for Males and Females in Status R I B A
120
100

Deaths

80
Current

60

Actual
40

Proposed

20
0
45 and below

46-50

51-55

56-60

61-65

66-70

71-75

76-80

Age

Active
Vested
Retired
Beneficiary
Disabled

Old
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!

Proposed
2000RPWhiteCollar!-5>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RpRetiree!>G2000 s(BBM)

81-85

86-90

91-95

96-100

101+

Max
Min

85

Cumulative Deaths by Age for Males and Females in Status A

#N/A
70

60
Cumulative Deaths by Age for Males and Females in Status A
Deaths by Age for Males and Females in Status A
50

Deaths

40
Actual
Current

30

Proposed

20

10

0
39

44

49

54

59

64

69

74

79

84

89

94

Age

Deaths by Age for Males and Females in Status A
12
10

Deaths

8
Current

6

Actual
4

Proposed

2
0
25 and below

26-30

31-35

36-40

41-45

46-50

51-55
Age

Active
Vested
Retired
Beneficiary
Disabled

Old
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!

Proposed
2000RPWhiteCollar!-5>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RpRetiree!>G2000 s(BBM)

56-60

61-65

66-70

71-75

76+

Mortality Table Comparison with k = 20
BLEND OF 30% MMH2000RpCombined Projected 12 years with 100% BBM **AND** 70% MFH2000RpCombined Projected 12 years with 100% BBF
BLEND OF 30% MMH2000RPWhiteCollar-5 Projected 12 years with 100% BBM **AND** 70% MFH2000RPWhiteCollar-5 Projected 12 years with 100% BBF
0.060000

67.9

77.3

85.6

92.0

96.7

0.050000

73.8

83.2

91.3

97.5

102.2

P[ek = x]

0.040000

0.030000

0.020000

0.010000

0.000000
20

25

30

35

40

45

50

55

60

65

Age

70

75

80

85

90

95

100

105

110

BLEND OF 30% MMH2000RpCombined Projected 12 years with 100% BBM **AND** 70% MFH2000RpCombined Projected 12 years with 100% BBF
BLEND OF 30% MMH2000RPWhiteCollar-5 Projected 12 years with 100% BBM **AND** 70% MFH2000RPWhiteCollar-5 Projected 12 years with 100% BBF
0.450000

0.400000

0.350000

Rate of Mortality

0.300000

0.250000

0.200000

0.150000

0.100000

0.050000

0.000000
20

25

30

35

40

45

50

55

60

65

Age

70

75

80

85

90

95

100

105

110

BLEND OF 30% MMH2000RPWhiteCollar-5 Projected 12 years with 100% BBM **AND** 70% MFH2000RPWhiteCollar-5 Projected 12 years with 100% BBF
BLEND OF 30% MMH2000RpCombined Projected 12 years with 100% BBM **AND** 70% MFH2000RpCombined Projected 12 years with 100% BBF
0.010000

0.000000
2

7

12

17

22

27

32

37

42

47

52

57

62

-0.010000

Rate Difference

-0.020000

-0.030000

-0.040000

-0.050000

-0.060000

-0.070000

-0.080000

-0.090000

Age

67

72

77

82

87

92

97

102

107

112

117

Max
Min

100
50

Cumulative Deaths by Age for Males and Females in Status R B

500

450
Cumulative Deaths by Age for Males and Females in Status R B
400
Deaths
by Age for Males and Females in Status R B
350

Deaths

300

250

Actual
Current

200

Proposed

150

100

50

0
50

55

60

65

70

75

-50

80

85

90

95

100

Age

Deaths by Age for Males and Females in Status R B
120
100

Deaths

80
Current

60

Actual
40

Proposed

20
0
60 and below

61-65

66-70

71-75

76-80

81-85
Age

Active
Vested
Retired
Beneficiary
Disabled

Old
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!

Proposed
2000RPWhiteCollar!-5>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RpRetiree!>G2000 s(BBM)

86-90

91-95

96-100

101+

Mortality Table Comparison with k = 55
BLEND OF 25% MMH2000RpCombined Projected 12 years with 100% BBM **AND** 75% MFH2000RpCombined Projected 12 years with 100% BBF
BLEND OF 25% MMH2000RPWhiteCollar Projected 12 years with 100% BBM **AND** 75% MFH2000RPWhiteCollar Projected 12 years with 100% BBF
0.060000

70.4

78.3

86.1

92.3

97.0

0.050000

71.2

79.2

86.8

92.8

97.4

P[ek = x]

0.040000

0.030000

0.020000

0.010000

0.000000
55

60

65

70

75

80

85

Age

90

95

100

105

110

BLEND OF 25% MMH2000RpCombined Projected 12 years with 100% BBM **AND** 75% MFH2000RpCombined Projected 12 years with 100% BBF
BLEND OF 25% MMH2000RPWhiteCollar Projected 12 years with 100% BBM **AND** 75% MFH2000RPWhiteCollar Projected 12 years with 100% BBF
0.450000

0.400000

0.350000

Rate of Mortality

0.300000

0.250000

0.200000

0.150000

0.100000

0.050000

0.000000
55

60

65

70

75

80

85

Age

90

95

100

105

110

BLEND OF 25% MMH2000RPWhiteCollar Projected 12 years with 100% BBM **AND** 75% MFH2000RPWhiteCollar Projected 12 years with 100% BBF
BLEND OF 25% MMH2000RpCombined Projected 12 years with 100% BBM **AND** 75% MFH2000RpCombined Projected 12 years with 100% BBF
0.000000
30

35

40

45

50

55

60

65

-0.001000

Rate Difference

-0.002000

-0.003000

-0.004000

-0.005000

-0.006000

-0.007000

Age

70

75

80

85

90

95

Max
Min

95
39

Cumulative Deaths by Age for Males and Females in Status I

30

25
Cumulative Deaths by Age for Males and Females in Status I
Deaths by Age for Males and Females in Status I

20

15
Deaths

Actual
Current
Proposed

10

5

0
39

44

49

54

59

64

69

-5

74

79

84

89

94

Age

Deaths by Age for Males and Females in Status I
8
7
6

Deaths

5
Current

4

Actual

3

Proposed

2
1
0
45 and below

46-50

51-55

56-60

61-65

66-70

71-75
Age

Active
Vested
Retired
Beneficiary
Disabled

Old
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!>G2000 s(BBM)
2000RPCombined!

Proposed
2000RPWhiteCollar!-5>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RPWhiteCollar!>G2000 s(BBM)
2000RpRetiree!>G2000 s(BBM)

76-80

81-85

86-90

91-95

96+

BLEND OF 15% MMH2000RpCombined **AND** 85% MFH2000RpCombined vs. BLEND OF 15% MMD2000RpRetiree Projected 12 years with 100% BBM **AND** 85% MFD2000RpRetiree Projected 12 years
with 100% BBF

Mortality Table Comparison with k = 45
BLEND OF 15% MMH2000RpCombined **AND** 85% MFH2000RpCombined
BLEND OF 15% MMD2000RpRetiree Projected 12 years with 100% BBM **AND** 85% MFD2000RpRetiree Projected 12 years with 100% BBF
0.060000

68.4

0.050000

53.8

76.8

62.8

84.8

75.0

91.1

85.4

96.0

92.9

P[ek = x]

0.040000

0.030000

0.020000

0.010000

0.000000
45

50

55

60

65

70

75

80

Age

85

90

95

100

105

110

BLEND OF 15% MMH2000RpCombined **AND** 85% MFH2000RpCombined vs. BLEND OF 15% MMD2000RpRetiree Projected 12 years with 100% BBM **AND** 85% MFD2000RpRetiree Projected 12 years
with 100% BBF

BLEND OF 15% MMH2000RpCombined **AND** 85% MFH2000RpCombined
BLEND OF 15% MMD2000RpRetiree Projected 12 years with 100% BBM **AND** 85% MFD2000RpRetiree Projected 12 years with 100% BBF
0.450000

0.400000

0.350000

Rate of Mortality

0.300000

0.250000

0.200000

0.150000

0.100000

0.050000

0.000000
45

50

55

60

65

70

75

80

Age

85

90

95

100

105

110

BLEND OF 15% MMH2000RpCombined **AND** 85% MFH2000RpCombined vs. BLEND OF 15% MMD2000RpRetiree Projected 12 years with 100% BBM **AND** 85% MFD2000RpRetiree Projected 12 years
with 100% BBF

BLEND OF 15% MMD2000RpRetiree Projected 12 years with 100% BBM **AND** 85% MFD2000RpRetiree Projected 12 years with 100% BBF
BLEND OF 15% MMH2000RpCombined **AND** 85% MFH2000RpCombined
0.025000

0.020000

0.015000

Rate Difference

0.010000

0.005000

0.000000
0

5

10

15

20

25

30

35

40

45

50

-0.005000

-0.010000

-0.015000

-0.020000

Age

55

60

65

70

75

80

85

90

95

100






Download ExperienceStudy



ExperienceStudy.pdf (PDF, 207.2 KB)


Download PDF







Share this file on social networks



     





Link to this page



Permanent link

Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..




Short link

Use the short link to share your document on Twitter or by text message (SMS)




HTML Code

Copy the following HTML code to share your document on a Website or Blog




QR Code to this page


QR Code link to PDF file ExperienceStudy.pdf






This file has been shared publicly by a user of PDF Archive.
Document ID: 0000059320.
Report illicit content