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
This file has been shared publicly by a user of PDF Archive.
Document ID: 0000059320.