Model Excel Result
Model Excel Result
Break PVFB
Paterson Grade Lost pension Annual gain Even a_65 a_70 PVFB at 65 PVFB at 70 Difference
170,631.1 75,769.
A1 3 7,477.49 23 15.248 13.573 234,160.51 309,929.87 36
172,014.6 76,383.
A2 2 7,538.12 23 15.248 13.573 236,059.11 312,442.81 71
172,936.9 76,793.
A3 5 7,578.54 23 15.248 13.573 237,324.84 314,118.11 27
178,839.8 79,414.
B1 7 7,837.22 23 15.248 13.573 245,425.53 324,840.01 48
184,281.6 81,830.
B2 2 8,075.69 23 15.248 13.573 252,893.35 334,724.26 91
189,723.3 84,247.
B3 7 8,314.16 23 15.248 13.573 260,361.17 344,608.51 34
195,165.1 86,663.
B4 2 8,552.63 23 15.248 13.573 267,828.99 354,492.76 77
200,606.8 89,080.
B5 7 8,791.11 23 15.248 13.573 275,296.81 364,377.01 20
220,252.5 97,803.
0 9,652.03 23 15.248 13.573 302,256.92 400,060.83 91
C1
226,985.5 100,793.
C2 2 9,947.09 23 15.248 13.573 311,496.76 412,290.49 73
233,718.5 103,783.
C3 3 10,242.14 23 15.248 13.573 320,736.61 424,520.16 55
240,451.5 106,773.
C4 4 10,537.20 23 15.248 13.573 329,976.46 436,749.82 37
247,184.5 109,763.
C5 5 10,832.26 23 15.248 13.573 339,216.30 448,979.49 18
349,839.9 155,347.
D1 3 15,330.88 23 15.248 13.573 480,092.33 635,440.00 67
365,796.2 162,433.
D2 4 16,030.13 23 15.248 13.573 501,989.50 664,422.63 13
381,752.5 169,518.
D3 6 16,729.37 23 15.248 13.573 523,886.67 693,405.26 59
397,708.8 176,604.
D4 7 17,428.62 23 15.248 13.573 545,783.84 722,387.89 05
413,665.1 183,689.
D5 9 18,127.87 23 15.248 13.573 567,681.02 751,370.52 51
SENSITIVITY ANALYSIS: BENEFIT AND NRR ( i=2 % , g = 6%)
SENSITIVITY TEST: SALARY GROWTH (BENEFIT & NRR (i=4% and g= 3%))
Annual
Monthly Annual Benefit Benefit at
Paterson Grade Salary Annual Salary at 65 Salary at 70 at 65 70 NRR at 65 NRR at 70
5,6
A1 370.00 4,440.00 12,493.55 14,483.45 22.10 7,241.72 45% 50%
5,6
A2 373.00 4,476.00 12,594.85 14,600.88 67.68 7,300.44 45% 50%
5,6
A3 375.00 4,500.00 12,662.38 14,679.17 98.07 7,339.59 45% 50%
5,8
B1 387.80 4,653.60 13,094.59 15,180.22 92.57 7,590.11 45% 50%
6,0
B2 399.60 4,795.20 13,493.03 15,642.12 71.86 7,821.06 45% 50%
6,2
B3 411.40 4,936.80 13,891.48 16,104.03 51.16 8,052.01 45% 50%
6,4
B4 423.20 5,078.40 14,289.92 16,565.93 30.46 8,282.97 45% 50%
B5 5,220.00 14,688.36 17,027.84 6,6 45% 50%
435.00 09.76 8,513.92
7,2
C1 477.60 5,731.20 16,126.81 18,695.39 57.06 9,347.70 45% 50%
7,4
C2 492.20 5,906.40 16,619.80 19,266.90 78.91 9,633.45 45% 50%
7,7
C3 506.80 6,081.60 17,112.79 19,838.41 00.75 9,919.20 45% 50%
7,9
C4 521.40 6,256.80 17,605.77 20,409.92 22.60 10,204.96 45% 50%
8,1
C5 536.00 6,432.00 18,098.76 20,981.43 44.44 10,490.71 45% 50%
11,5
D1 758.60 9,103.20 25,615.15 29,694.98 26.82 14,847.49 45% 50%
12,0
D2 793.20 9,518.40 26,783.47 31,049.38 52.56 15,524.69 45% 50%
12,5
D3 827.80 9,933.60 27,951.78 32,403.78 78.30 16,201.89 45% 50%
13,1
D4 862.40 10,348.80 29,120.10 33,758.18 04.04 16,879.09 45% 50%
13,6
D5 897.00 10,764.00 30,288.42 35,112.57 29.79 17,556.29 45% 50%
Pater Bre
son ak PVFB PVFB at
Grad Lost Annual Eve a_65 a_7 PVFB at PVFB at Differen PVFB at entry PVFB
e pension gain n 0 65 70 ce entry (T=35) (T= 40) Difference2 %2
62,46 1,61 13.9 85,72 100,89 15,17 21,7 21,016 (7 -
A1 7.75 9.63 39 15.248 33 5.74 8.94 3.20 24.23 .14 08.08) 3.26%
62,97 1,63 13.9 86,42 101,71 15,29 21,9 21,186 (7 -
A2 4.24 2.76 39 15.248 33 0.81 7.04 6.23 00.37 .54 13.83) 3.26%
A3 63,31 1,64 39 15.248 13.9 86,88 102,26 15,37 22,0 21,300 (7 -
1.91 1.51 33 4.19 2.44 8.24 17.80 .15 17.65) 3.26%
65,47 1,69 13.9 89,84 105,75 15,90 22,7 22,027 (7 -
B1 2.95 7.54 39 15.248 33 9.84 3.00 3.16 69.34 .19 42.15) 3.26%
67,46 1,74 13.9 92,58 108,97 16,38 23,4 22,697 (7 -
B2 5.17 9.20 39 15.248 33 3.80 0.85 7.06 62.17 .44 64.73) 3.26%
69,45 1,80 13.9 95,31 112,18 16,87 24,1 23,367 (7 -
B3 7.38 0.85 39 15.248 33 7.75 8.71 0.96 54.99 .68 87.31) 3.26%
71,44 1,85 13.9 98,05 115,40 17,35 24,8 24,037 (8 -
B4 9.60 2.50 39 15.248 33 1.71 6.57 4.86 47.82 .92 09.90) 3.26%
73,44 1,90 13.9 100,7 118,62 17,83 25,5 24,708 (8 -
B5 1.81 4.16 39 15.248 33 85.66 4.43 8.76 40.65 .17 32.48) 3.26%
NRR
Paterson at
Grade Monthly Salary Annual Salary at 65 Salary at 70 Annual Benefit at 65 Annual Benefit at 70 65 NRR at 70
A1 370.00 4,440.00 90,638.02 139,457.83 40,787.11 69,728.91 45% 50%
A2 373.00 4,476.00 91,372.92 140,588.56 41,117.81 70,294.28 45% 50%
A3 375.00 4,500.00 91,862.86 141,342.39 41,338.29 70,671.20 45% 50%
B1 387.80 4,653.60 94,998.44 146,166.88 42,749.30 73,083.44 45% 50%
B2 399.60 4,795.20 97,889.06 150,614.45 44,050.08 75,307.23 45% 50%
100,779.6
B3 411.40 4,936.80 8 155,062.02 45,350.85 77,531.01 45% 50%
103,670.2
B4 423.20 5,078.40 9 159,509.60 46,651.63 79,754.80 45% 50%
106,560.9
B5 435.00 5,220.00 1 163,957.17 47,952.41 81,978.59 45% 50%
116,996.5
C1 477.60 5,731.20 3 180,013.67 52,648.44 90,006.83 45% 50%
120,573.0
C2 492.20 5,906.40 6 185,516.60 54,257.88 92,758.30 45% 50%
124,149.5
C3 506.80 6,081.60 9 191,019.53 55,867.31 95,509.76 45% 50%
127,726.1
C4 521.40 6,256.80 1 196,522.46 57,476.75 98,261.23 45% 50%
131,302.6
C5 536.00 6,432.00 4 202,025.39 59,086.19 101,012.69 45% 50%
185,832.4
D1 758.60 9,103.20 3 285,926.23 83,624.59 142,963.12 45% 50%
194,308.3
D2 793.20 9,518.40 1 298,967.42 87,438.74 149,483.71 45% 50%
202,784.1
D3 827.80 9,933.60 9 312,008.62 91,252.89 156,004.31 45% 50%
211,260.0
D4 862.40 10,348.80 7 325,049.81 95,067.03 162,524.90 45% 50%
219,735.9
D5 897.00 10,764.00 5 338,091.00 98,881.18 169,045.50 45% 50%
PVFB at
Paterson Break PVFB at entry (T=
Grade Lost pension Annual gain Even a_65 a_70 PVFB at 65 PVFB at 70 % increase entry 40) %
28,941.8 621,921. 946,430.5 157,60
A1 453,190.09 0 16 15.248 13.573 82 3 52.178% 4.61 197,131.11
29,176.4 626,964. 954,104.2 158,88
A2 456,864.60 7 16 15.248 13.573 43 9 52.178% 2.49 198,729.47
29,332.9 630,326. 959,220.1 159,73
A3 459,314.28 1 16 15.248 13.573 17 3 52.178% 4.40 199,795.04
30,334.1 651,841. 991,961.5 165,18
B1 474,992.21 4 16 15.248 13.573 30 1 52.178% 6.67 206,614.72
31,257.1 671,675. 1,022,144.9 170,21
B2 489,445.29 5 16 15.248 13.573 57 7 52.178% 2.98 212,901.60
32,180.1 691,509. 1,052,328.4 175,23
B3 503,898.38 6 16 15.248 13.573 83 3 52.178% 9.29 219,188.48
33,103.1 711,344. 1,082,511.8 180,26
B4 518,351.47 7 16 15.248 13.573 09 9 52.178% 5.60 225,475.37
34,026.1 731,178. 1,112,695.3 185,29
B5 532,804.56 8 16 15.248 13.573 36 5 52.178% 1.91 231,762.25
NR
Paterso R at
n Grade Monthly Salary Annual Salary at 65 Salary at 70 Annual Benefit at 65 Annual Benefit at 70 65 NRR at 70
370.0 4,440.0 34,126.2 45,668.5 15,356.8 22,834.2 45
A1 0 0 3 9 0 9 % 50%
373.0 4,476.0 34,402.9 46,038.8 15,481.3 23,019.4 45
A2 0 0 2 7 2 4 % 50%
375.0 4,500.0 34,587.3 46,285.7 15,564.3 23,142.8 45
A3 0 0 9 3 3 7 % 50%
387.8 4,653.6 35,767.9 47,865.6 16,095.5 23,932.8 45
B1 0 0 7 2 9 1 % 50%
399.6 4,795.2 36,856.3 49,322.0 16,585.3 24,661.0 45
B2 0 0 2 7 5 4 % 50%
411.4 4,936.8 37,944.6 50,778.5 17,075.1 25,389.2 45
B3 0 0 7 3 0 7 % 50%
423.2 5,078.4 39,033.0 52,234.9 17,564.8 26,117.4 45
B4 0 0 2 9 6 9 % 50%
435.0 5,220.0 40,121.3 53,691.4 18,054.6 26,845.7 45
B5 0 0 7 5 2 2 % 50%
477.6 5,731.2 44,050.5 58,949.5 19,822.7 29,474.7 45
C1 0 0 0 1 3 5 % 50%
492.2 5,906.4 45,397.1 60,751.5 20,428.7 30,375.7 45
C2 0 0 0 6 0 8 % 50%
506.8 6,081.6 46,743.7 62,553.6 21,034.6 31,276.8 45
C3 0 0 1 2 7 1 % 50%
521.4 6,256.8 48,090.3 64,355.6 21,640.6 32,177.8 45
C4 0 0 1 8 4 4 % 50%
536.0 6,432.0 49,436.9 66,157.7 22,246.6 33,078.8 45
C5 0 0 1 4 1 7 % 50%
758.6 9,103.2 69,967.9 93,632.9 31,485.5 46,816.4 45
D1 0 0 9 5 9 7 % 50%
793.2 9,518.4 73,159.2 97,903.5 32,921.6 48,951.7 45
D2 0 0 5 8 6 9 % 50%
827.8 9,933.6 76,350.5 102,174.2 34,357.7 51,087.1 45
D3 0 0 1 1 3 0 % 50%
862.4 10,348.8 79,541.7 106,444.8 35,793.8 53,222.4 45
D4 0 0 7 4 0 2 % 50%
897.0 10,764.0 82,733.0 110,715.4 37,229.8 55,357.7 45
D5 0 0 4 7 7 3 % 50%
10% IMPROVEMENT IN MORTALITY (PVFB & BREAK EVEN (i=4% and g= 6%))
PVF
PVFB at ENT
Paterson Annual Break a_65 % entry INC
Grade Lost pension gain Even a_70 PVFB at 65 PVFB at 70 INCREASE (T=35) PVFB at entry (T= 40) %
7,477 210,744. 53,
A1 170,631.13 .49 23 13.723 12.216 46 278,936.88 32.36% 405.91 58,099.50 8
7,538 212,453. 53,
A2 172,014.62 .12 23 13.723 12.216 20 281,198.53 32.36% 838.93 58,570.57 8
7,578 213,592. 54,
A3 172,936.95 .54 23 13.723 12.216 36 282,706.30 32.36% 127.61 58,884.63 8
B1 178,839.87 7,837 23 13.723 12.216 220,882. 292,356.01 32.36% 55, 60,894.55 8
.22 97 975.16
8,075 227,604. 57,
B2 184,281.62 .69 23 13.723 12.216 01 301,251.83 32.36% 678.38 62,747.46 8
8,314 234,325. 59,
B3 189,723.37 .16 23 13.723 12.216 05 310,147.66 32.36% 381.59 64,600.36 8
8,552 241,046. 61,
B4 195,165.12 .63 23 13.723 12.216 09 319,043.48 32.36% 084.81 66,453.26 8
8,791 247,767. 62,
B5 200,606.87 .11 23 13.723 12.216 13 327,939.31 32.36% 788.02 68,306.17 8
NR
Paterso R at
n Grade Monthly Salary Annual Salary at 65 Salary at 70 Annual Benefit at 65 Annual Benefit at 70 65 NRR at 70
370.0 4,440.0 34,126.2 45,668.5 15,356.8 22,834.2 45
A1 0 0 3 9 0 9 % 50%
373.0 4,476.0 34,402.9 46,038.8 15,481.3 23,019.4 45
A2 0 0 2 7 2 4 % 50%
375.0 4,500.0 34,587.3 46,285.7 15,564.3 23,142.8 45
A3 0 0 9 3 3 7 % 50%
387.8 4,653.6 35,767.9 47,865.6 16,095.5 23,932.8 45
B1 0 0 7 2 9 1 % 50%
399.6 4,795.2 36,856.3 49,322.0 16,585.3 24,661.0 45
B2 0 0 2 7 5 4 % 50%
411.4 4,936.8 37,944.6 50,778.5 17,075.1 25,389.2 45
B3 0 0 7 3 0 7 % 50%
423.2 5,078.4 39,033.0 52,234.9 17,564.8 26,117.4 45
B4 0 0 2 9 6 9 % 50%
435.0 5,220.0 40,121.3 53,691.4 18,054.6 26,845.7 45
B5 0 0 7 5 2 2 % 50%
477.6 5,731.2 44,050.5 58,949.5 19,822.7 29,474.7 45
C1 0 0 0 1 3 5 % 50%
492.2 5,906.4 45,397.1 60,751.5 20,428.7 30,375.7 45
C2 0 0 0 6 0 8 % 50%
506.8 6,081.6 46,743.7 62,553.6 21,034.6 31,276.8 45
C3 0 0 1 2 7 1 % 50%
521.4 6,256.8 48,090.3 64,355.6 21,640.6 32,177.8 45
C4 0 0 1 8 4 4 % 50%
536.0 6,432.0 49,436.9 66,157.7 22,246.6 33,078.8 45
C5 0 0 1 4 1 7 % 50%
758.6 9,103.2 69,967.9 93,632.9 31,485.5 46,816.4 45
D1 0 0 9 5 9 7 % 50%
793.2 9,518.4 73,159.2 97,903.5 32,921.6 48,951.7 45
D2 0 0 5 8 6 9 % 50%
827.8 9,933.6 76,350.5 102,174.2 34,357.7 51,087.1 45
D3 0 0 1 1 3 0 % 50%
862.4 10,348.8 79,541.7 106,444.8 35,793.8 53,222.4 45
D4 0 0 7 4 0 2 % 50%
897.0 10,764.0 82,733.0 110,715.4 37,229.8 55,357.7 45
D5 0 0 4 7 7 3 % 50%
SENSITIVITY MORTALITY REDUCTION: (BREAK EVEN & PVFB (i=4% and g= 6%))