0% ont trouvé ce document utile (0 vote)
0 vues22 pages

Model Excel Result

Le document présente des projections originales concernant les salaires, les bénéfices annuels et les taux de rendement net (NRR) pour différentes catégories de grades de Paterson. Il inclut également une analyse de sensibilité sur les bénéfices et le NRR, ainsi que des calculs de seuil de rentabilité et de valeur actuelle des flux de bénéfices (PVFB) pour des taux d'intérêt et de croissance spécifiques. Les données sont organisées par grade et fournissent des informations détaillées sur les gains annuels et les différences de PVFB à différents âges de retraite.

Transféré par

nyathishaun21
Copyright
© All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats DOCX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
0 vues22 pages

Model Excel Result

Le document présente des projections originales concernant les salaires, les bénéfices annuels et les taux de rendement net (NRR) pour différentes catégories de grades de Paterson. Il inclut également une analyse de sensibilité sur les bénéfices et le NRR, ainsi que des calculs de seuil de rentabilité et de valeur actuelle des flux de bénéfices (PVFB) pour des taux d'intérêt et de croissance spécifiques. Les données sont organisées par grade et fournissent des informations détaillées sur les gains annuels et les différences de PVFB à différents âges de retraite.

Transféré par

nyathishaun21
Copyright
© All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats DOCX, PDF, TXT ou lisez en ligne sur Scribd

ORIGINAL PROJECTION: BENEFIT AND NRR( g = 6%, i = 4%)

Salary at Annual Benefit


Paterson Grade Monthly Salary Annual 65 Salary at 70 Annual Benefit at 65 at 70 NRR at 65 NRR at 70
34,126.2 22,
A1 370.00 4,440.00 3 45,668.59 15,356.80 834.29 45% 50%
34,402.9 23,
A2 373.00 4,476.00 2 46,038.87 15,481.32 019.44 45% 50%
34,587.3 23,
A3 375.00 4,500.00 9 46,285.73 15,564.33 142.87 45% 50%
35,767.9 23,
B1 387.80 4,653.60 7 47,865.62 16,095.59 932.81 45% 50%
36,856.3 24,
B2 399.60 4,795.20 2 49,322.07 16,585.35 661.04 45% 50%
37,944.6 25,
B3 411.40 4,936.80 7 50,778.53 17,075.10 389.27 45% 50%
39,033.0 26,
B4 423.20 5,078.40 2 52,234.99 17,564.86 117.49 45% 50%
40,121.3 26,
B5 435.00 5,220.00 7 53,691.45 18,054.62 845.72 45% 50%
44,050.5 29,
C1 477.60 5,731.20 0 58,949.51 19,822.73 474.75 45% 50%
45,397.1 30,
C2 492.20 5,906.40 0 60,751.56 20,428.70 375.78 45% 50%
46,743.7 31,
C3 506.80 6,081.60 1 62,553.62 21,034.67 276.81 45% 50%
48,090.3 32,
C4 521.40 6,256.80 1 64,355.68 21,640.64 177.84 45% 50%
49,436.9 33,
C5 536.00 6,432.00 1 66,157.74 22,246.61 078.87 45% 50%
69,967.9 46,
D1 758.60 9,103.20 9 93,632.95 31,485.59 816.47 45% 50%
D2 793.20 9,518.40 73,159.2 97,903.58 32,921.66 48, 45% 50%
5 951.79
76,350.5 51,
D3 827.80 9,933.60 1 102,174.21 34,357.73 087.10 45% 50%
79,541.7 53,
D4 862.40 10,348.80 7 106,444.84 35,793.80 222.42 45% 50%
82,733.0 55,
D5 897.00 10,764.00 4 110,715.47 37,229.87 357.73 45% 50%

ORIGINAL PROJECTION: BREAK EVEN AND PVFB

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%)

Monthly Annual Benefit at Annual Benefit


Paterson Grade Salary Annual Salary at 65 Salary at 70 65 at 70 NRR at 65 NRR at 70
45,668. 15,356 22,
A1 370.00 4,440.00 34,126.23 59 .80 834.29 45% 50%
46,038. 15,481 23,
A2 373.00 4,476.00 34,402.92 87 .32 019.44 45% 50%
46,285. 15,564 23,
A3 375.00 4,500.00 34,587.39 73 .33 142.87 45% 50%
47,865. 16,095 23,
B1 387.80 4,653.60 35,767.97 62 .59 932.81 45% 50%
49,322. 16,585 24,
B2 399.60 4,795.20 36,856.32 07 .35 661.04 45% 50%
50,778. 17,075 25,
B3 411.40 4,936.80 37,944.67 53 .10 389.27 45% 50%
52,234. 17,564 26,
B4 423.20 5,078.40 39,033.02 99 .86 117.49 45% 50%
53,691. 18,054 26,
B5 435.00 5,220.00 40,121.37 45 .62 845.72 45% 50%
58,949. 19,822 29,
C1 477.60 5,731.20 44,050.50 51 .73 474.75 45% 50%
60,751. 20,428 30,
C2 492.20 5,906.40 45,397.10 56 .70 375.78 45% 50%
62,553. 21,034 31,
C3 506.80 6,081.60 46,743.71 62 .67 276.81 45% 50%
64,355. 21,640 32,
C4 521.40 6,256.80 48,090.31 68 .64 177.84 45% 50%
66,157. 22,246 33,
C5 536.00 6,432.00 49,436.91 74 .61 078.87 45% 50%
93,632. 31,485 46,
D1 758.60 9,103.20 69,967.99 95 .59 816.47 45% 50%
97,903. 32,921 48,
D2 793.20 9,518.40 73,159.25 58 .66 951.79 45% 50%
102,174. 34,357 51,
D3 827.80 9,933.60 76,350.51 21 .73 087.10 45% 50%
106,444. 35,793 53,
D4 862.40 10,348.80 79,541.77 84 .80 222.42 45% 50%
110,715. 37,229 55,
D5 897.00 10,764.00 82,733.04 47 .87 357.73 45% 50%

Break - even and PVFB ( i=2 % , g = 6%)

Annual Break PVFB PVFB at PVFB at entry


Paterson Grade Lost pension gain Even a_65 a_70 PVFB at 65 PVFB at 70 Difference entry (T=35) (T= 40)
7,47 380,624. 148,52 172
A1 170,631.13 7.49 23 19.342 16.669 297,031.25 84 83,593.59 3.83 ,381.34
7,53 383,710. 149,72 173
A2 172,014.62 8.12 23 19.342 16.669 299,439.61 99 84,271.38 8.08 ,779.03
7,57 385,768. 150,53 174
A3 172,936.95 8.54 23 19.342 16.669 301,045.19 42 84,723.23 0.91 ,710.82
7,83 398,935. 155,66 180
B1 178,839.87 7.22 23 19.342 16.669 311,320.86 98 87,615.12 9.03 ,674.28
8,07 411,074. 160,40 186
B2 184,281.62 5.69 23 19.342 16.669 320,793.75 83 90,281.08 5.73 ,171.85
8,31 423,213. 165,14 191
B3 189,723.37 4.16 23 19.342 16.669 330,266.64 68 92,947.04 2.44 ,669.42
8,55 435,352. 169,87 197
B4 195,165.12 2.63 23 19.342 16.669 339,739.53 52 95,612.99 9.15 ,166.99
8,79 447,491. 174,61 202
B5 200,606.87 1.11 23 19.342 16.669 349,212.42 37 98,278.95 5.85 ,664.55
9,65 491,314. 191,71 222
C1 220,252.50 2.03 23 19.342 16.669 383,411.15 66 107,903.51 6.16 ,511.70
C2 226,985.52 9,94 23 19.342 16.669 395,131.85 506,333. 111,202.07 197,57 229
7.09 91 6.83 ,313.78
10,24 521,353. 203,43 236
C3 233,718.53 2.14 23 19.342 16.669 406,852.54 16 114,500.63 7.50 ,115.85
10,53 536,372. 209,29 242
C4 240,451.54 7.20 23 19.342 16.669 418,573.23 41 117,799.18 8.17 ,917.93
10,83 551,391. 215,15 249
C5 247,184.55 2.26 23 19.342 16.669 430,293.92 67 121,097.74 8.84 ,720.00
15,33 780,383. 304,51 353
D1 349,839.93 0.88 23 19.342 16.669 608,994.35 80 171,389.45 3.99 ,428.34
16,03 815,977. 318,40 369
D2 365,796.24 0.13 23 19.342 16.669 636,770.78 37 179,206.58 2.97 ,548.33
16,72 851,570. 332,29 385
D3 381,752.56 9.37 23 19.342 16.669 664,547.22 93 187,023.71 1.96 ,668.31
17,42 887,164. 346,18 401
D4 397,708.87 8.62 23 19.342 16.669 692,323.66 50 194,840.85 0.95 ,788.30
18,12 922,758. 360,06 417
D5 413,665.19 7.87 23 19.342 16.669 720,100.09 07 202,657.98 9.93 ,908.28

Break - even and PVFB ( i=6 % , g = 6%)


Paters PVFB PVFB at PVFB
on Lost Annual Break PVFB at PVFB at Differenc PVFB at entry entry (T= Differenc
Grade pension gain Even a_65 a_70 65 70 e (T=35) 40) e2

170,6 7,4 189,87 257,79 67 24,703. 25,063.8


A1 31.13 77.49 23 12.364 11.290 1.49 9.18 ,927.68 27 0 360.53

172,0 7,5 191,41 259,88 68 24,903. 25,267.0


A2 14.62 38.12 23 12.364 11.290 0.99 9.44 ,478.45 57 2 363.45

172,9 7,5 192,43 261,28 68 25,037. 25,402.5


A3 36.95 78.54 23 12.364 11.290 7.32 2.95 ,845.63 10 0 365.40

178,8 7,8 199,00 270,20 71 25,891. 26,269.5


B1 39.87 37.22 23 12.364 11.290 5.85 1.41 ,195.56 70 7 377.87

184,2 8,0 205,06 278,42 73 26,679. 27,068.9


B2 81.62 75.69 23 12.364 11.290 1.21 3.11 ,361.90 53 0 389.37

189,7 8,3 211,11 286,64 75 27,467. 27,868.2


B3 23.37 14.16 23 12.364 11.290 6.57 4.81 ,528.24 37 4 400.87

195,1 8,5 217,17 294,86 77 28,255. 28,667.5


B4 65.12 52.63 23 12.364 11.290 1.93 6.52 ,694.58 20 7 412.37

200,6 8,7 223,22 303,08 79 29,043. 29,466.9


B5 06.87 91.11 23 12.364 11.290 7.30 8.22 ,860.93 04 0 423.86

220,252.50 9,6 245,08 332,76 87 31,887. 32,352.6


C1 52.03 23 12.364 11.290 8.18 9.96 ,681.79 25 2 465.37
C2 226,9 9,9 23 12.364 11.290 252,58 342,94 90 32,862.
85.52 47.09 0.40 2.58 ,362.18 03 33,341.6 479.60
3

233,7 10,2 260,07 353,11 93 33,836. 34,330.6


C3 18.53 42.14 23 12.364 11.290 2.63 5.20 ,042.57 81 3 493.83

240,4 10,5 267,56 363,28 95 34,811. 35,319.6


C4 51.54 37.20 23 12.364 11.290 4.85 7.81 ,722.96 58 4 508.05

247,1 10,8 275,05 373,46 98 35,786. 36,308.6


C5 84.55 32.26 23 12.364 11.290 7.08 0.43 ,403.35 36 4 522.28

349,8 15,3 389,28 528,55 139 50,648. 51,387.5


D1 39.93 30.88 23 12.364 11.290 7.88 7.99 ,270.11 38 6 739.18

365,7 16,0 407,04 552,66 145 52,958. 53,731.3


D2 96.24 30.13 23 12.364 11.290 3.43 5.70 ,622.27 47 7 772.89

381,7 16,7 424,79 576,77 151 55,268. 56,075.1


D3 52.56 29.37 23 12.364 11.290 8.98 3.40 ,974.43 56 7 806.61

397,7 17,4 442,55 600,88 158 57,578. 58,418.9


D4 08.87 28.62 23 12.364 11.290 4.53 1.11 ,326.58 65 8 840.32

413,6 18,1 460,31 624,98 164 59,888. 60,762.7


D5 65.19 27.87 23 12.364 11.290 0.08 8.82 ,678.74 74 8 874.04
SENSITIVITY ANALYSIS: BENEFIT AND NRR ( i=6 % , g = 6%)

Paterson Monthly Annual Benefit Annual NRR at


Grade Salary Annual Salary at 65 Salary at 70 at 65 Benefit at 70 65 NRR at 70
34,126.2 45,668.5 15, 2
A1 370.00 4,440.00 3 9 356.80 2,834.29 45% 50%
34,402.9 46,038.8 15, 2
A2 373.00 4,476.00 2 7 481.32 3,019.44 45% 50%
34,587.3 46,285.7 15, 2
A3 375.00 4,500.00 9 3 564.33 3,142.87 45% 50%
35,767.9 47,865.6 16, 2
B1 387.80 4,653.60 7 2 095.59 3,932.81 45% 50%
36,856.3 49,322.0 16, 2
B2 399.60 4,795.20 2 7 585.35 4,661.04 45% 50%
37,944.6 50,778.5 17, 2
B3 411.40 4,936.80 7 3 075.10 5,389.27 45% 50%
39,033.0 52,234.9 17, 2
B4 423.20 5,078.40 2 9 564.86 6,117.49 45% 50%
40,121.3 53,691.4 18, 2
B5 435.00 5,220.00 7 5 054.62 6,845.72 45% 50%
44,050.5 58,949.5 19, 2
C1 477.60 5,731.20 0 1 822.73 9,474.75 45% 50%
45,397.1 60,751.5 20, 3
C2 492.20 5,906.40 0 6 428.70 0,375.78 45% 50%
46,743.7 62,553.6 21, 3
C3 506.80 6,081.60 1 2 034.67 1,276.81 45% 50%
48,090.3 64,355.6 21, 3
C4 521.40 6,256.80 1 8 640.64 2,177.84 45% 50%
49,436.9 66,157.7 22, 3
C5 536.00 6,432.00 1 4 246.61 3,078.87 45% 50%
69,967.9 93,632.9 31, 4
D1 758.60 9,103.20 9 5 485.59 6,816.47 45% 50%
73,159.2 97,903.5 32, 4
D2 793.20 9,518.40 5 8 921.66 8,951.79 45% 50%
76,350.5 102,174.2 34, 5
D3 827.80 9,933.60 1 1 357.73 1,087.10 45% 50%
79,541.7 106,444.8 35, 5
D4 862.40 10,348.80 7 4 793.80 3,222.42 45% 50%
82,733.0 110,715.4 37, 5
D5 897.00 10,764.00 4 7 229.87 5,357.73 45% 50%

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%

PVFB & BREAK EVEN [i=4% and g=3%]

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%

80,63 2,09 13.9 110,6 130,24 19,58 28,0 27,127 (9 -


C1 4.04 0.63 39 15.248 33 55.71 1.44 5.73 41.87 .87 14.00) 3.26%
83,09 2,15 13.9 114,0 134,22 20,18 28,8 27,957 (9 -
C2 8.99 4.54 39 15.248 33 38.40 2.86 4.46 99.09 .15 41.94) 3.26%
85,56 2,21 13.9 117,4 138,20 20,78 29,7 28,786 (9 -
C3 3.93 8.45 39 15.248 33 21.09 4.28 3.18 56.32 .44 69.88) 3.26%
88,02 2,28 13.9 120,8 142,18 21,38 30,6 29,615 (9 -
C4 8.87 2.36 39 15.248 33 03.78 5.69 1.91 13.55 .72 97.83) 3.26%
90,49 2,34 13.9 124,1 146,16 21,98 31,4 30,445 (1,0 -
C5 3.82 6.27 39 15.248 33 86.47 7.11 0.64 70.77 .01 25.77) 3.26%
128,07 3,32 13.9 175,7 206,87 31,10 44,5 43,088 (1,4 -
D1 5.76 0.67 39 15.248 33 60.93 0.10 9.16 40.54 .77 51.76) 3.26%
133,91 3,47 13.9 183,7 216,30 32,52 46,5 45,054 (1,5 -
D2 7.34 2.13 39 15.248 33 77.45 5.51 8.06 72.05 .07 17.98) 3.26%
139,75 3,62 13.9 191,7 225,74 33,94 48,6 47,019 (1,5 -
D3 8.92 3.59 39 15.248 33 93.96 0.92 6.96 03.56 .36 84.20) 3.26%
145,60 3,77 13.9 199,8 235,17 35,36 50,6 48,984 (1,6 -
D4 0.50 5.04 39 15.248 33 10.48 6.34 5.86 35.07 .65 50.41) 3.26%
151,44 3,92 13.9 207,8 244,61 36,78 52,6 50,949 (1,7 -
D5 2.08 6.50 39 15.248 33 26.99 1.75 4.76 66.57 .95 16.63) 3.26%
SALARY GROWTH (BENEFIT & NRR (i=4% and g= 9%))

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 & BREAK EVEN [i=4% and g=9%]

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

584,982 37,358.3 802,783. 1,221,662.7 203,43


C1 .66 9 16 15.248 13.573 41 6 52.178% 7.74 254,458.97
38,500.4 827,324. 1,259,008.4 209,65
C2 602,865.30 2 16 15.248 13.573 11 0 52.178% 6.73 262,237.66
39,642.4 851,864. 1,296,354.0 215,87
C3 620,747.94 5 16 15.248 13.573 81 3 52.178% 5.72 270,016.34
40,784.4 876,405. 1,333,699.6 222,09
C4 638,630.57 8 16 15.248 13.573 51 7 52.178% 4.71 277,795.03
41,926.5 900,946. 1,371,045.3 228,31
C5 656,513.21 1 16 15.248 13.573 21 1 52.178% 3.71 285,573.72
59,338.5 1,275,107. 1,940,438.3 323,13
D1 929,162.16 2 16 15.248 13.573 82 8 52.178% 2.05 404,172.06
62,044.9 1,333,265. 2,028,942.4 337,87
D2 971,541.56 7 16 15.248 13.573 92 2 52.178% 0.21 422,606.48
64,751.4 1,391,424. 2,117,446.4 352,60
D3 1,013,920.96 2 16 15.248 13.573 01 7 52.178% 8.37 441,040.90
67,457.8 1,449,582. 2,205,950.5 367,34
D4 1,056,300.36 7 16 15.248 13.573 10 1 52.178% 6.53 459,475.32
70,164.3 1,507,740. 2,294,454.5 382,08
D5 1,098,679.75 2 16 15.248 13.573 20 5 52.178% 4.69 477,909.75
SENSITIVITY TEST : 10% IMPROVEMENT IN MORTALITY (BENEFIT & NRR (i=4% and g= 6%))

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

220,25 9,652 272,031. 68,


C1 2.50 .03 23 13.723 12.216 22 360,054.74 32.36% 936.92 74,995.46 8
9,947 280,347. 71,
C2 226,985.52 .09 23 13.723 12.216 09 371,061.44 32.36% 044.29 77,288.03 8
10,242 288,662. 73,
C3 233,718.53 .14 23 13.723 12.216 95 382,068.14 32.36% 151.66 79,580.61 8
10,537 296,978. 75,
C4 240,451.54 .20 23 13.723 12.216 81 393,074.84 32.36% 259.03 81,873.18 8
10,832 305,294. 77,
C5 247,184.55 .26 23 13.723 12.216 67 404,081.54 32.36% 366.39 84,165.76 8
15,330 432,083. 109,4
D1 349,839.93 .88 23 13.723 12.216 10 571,896.00 32.36% 96.54 119,119.67 8
16,030 451,790. 114,4
D2 365,796.24 .13 23 13.723 12.216 55 597,980.37 32.36% 90.71 124,552.76 8
16,729 471,498. 119,4
D3 381,752.56 .37 23 13.723 12.216 00 624,064.73 32.36% 84.89 129,985.85 8
17,428 491,205. 124,4
D4 397,708.87 .62 23 13.723 12.216 46 650,149.10 32.36% 79.06 135,418.94 8
18,127 510,912. 129,4
D5 413,665.19 .87 23 13.723 12.216 91 676,233.47 32.36% 73.24 140,852.02 8
SENSITIVITY MORTALITY REDUCTION: (BENEFIT & NRR (i=4% and g= 6%))

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%))

Paterson Break PVFB at entry PVFB at entry (T=


Grade Lost pension Annual gain Even a_65 a_70 PVFB at 65 PVFB at 70 % (T=35) 40)
65,273 71,
A1 170,631.13 7,477.49 23 16.773 14.930 257,576.56 340,922.86 32.36% .88 010.50
65,803 71,
A2 172,014.62 7,538.12 23 16.773 14.930 259,665.02 343,687.10 32.36% .13 586.26
66,155 71,
A3 172,936.95 7,578.54 23 16.773 14.930 261,057.32 345,529.92 32.36% .96 970.10
68,414 74,
B1 178,839.87 7,837.22 23 16.773 14.930 269,968.08 357,324.01 32.36% .09 426.68
70,495 76,
B2 184,281.62 8,075.69 23 16.773 14.930 278,182.68 368,196.69 32.36% .80 691.34
72,577 78,
B3 189,723.37 8,314.16 23 16.773 14.930 286,397.29 379,069.36 32.36% .50 955.99
74,659 81,
B4 195,165.12 8,552.63 23 16.773 14.930 294,611.89 389,942.04 32.36% .21 220.65
76,740 83,
B5 200,606.87 8,791.11 23 16.773 14.930 302,826.49 400,814.71 32.36% .92 485.31
84,256 91,
C1 220,252.50 9,652.03 23 16.773 14.930 332,482.61 440,066.91 32.36% .24 661.12
86,831 94,
C2 226,985.52 9,947.09 23 16.773 14.930 342,646.44 453,519.54 32.36% .91 463.15
89,407 97,
C3 233,718.53 10,242.14 23 16.773 14.930 352,810.27 466,972.17 32.36% .58 265.19
91,983 100,
C4 240,451.54 10,537.20 23 16.773 14.930 362,974.10 480,424.80 32.36% .25 067.22
94,558 102,
C5 247,184.55 10,832.26 23 16.773 14.930 373,137.93 493,877.44 32.36% .93 869.26
133,829. 145,
D1 349,839.93 15,330.88 23 16.773 14.930 528,101.56 698,984.00 32.36% 11 590.71
139,933. 152,
D2 365,796.24 16,030.13 23 16.773 14.930 552,188.45 730,864.89 32.36% 10 231.15
146,037. 158,
D3 381,752.56 16,729.37 23 16.773 14.930 576,275.34 762,745.79 32.36% 09 871.59
152,141. 165,
D4 397,708.87 17,428.62 23 16.773 14.930 600,362.23 794,626.68 32.36% 08 512.03
158,245. 172,
D5 413,665.19 18,127.87 23 16.773 14.930 624,449.12 826,507.58 32.36% 07 152.47

Vous aimerez peut-être aussi