tablas 1 (administración del riesgo)

2
Financieras: Demográficas: Tasas Tasa descuento Mortalidad Invalidez Rotación Antes del retiro 8.00% EMSSA 97 H SS Rot ER Posterior al retiro 3.50% 15 0.0004300 0.0002200 0.3740000 0.0000000 Tasa de Incremento de salarios 4.00% 16 0.0004600 0.0002400 0.3440000 0.0000000 Tasa de Inflación 3.50% 17 0.0004900 0.0002500 0.3140000 0.0000000 Tasa de Incremento de salarios mínimos 3.50% 18 0.0005300 0.0002600 0.2840000 0.0000000 Tasa de Rendimiento de Activos 8.00% 19 0.0005800 0.0002800 0.2540000 0.0000000 20 0.0006300 0.0003000 0.2240000 0.0000000 21 0.0006900 0.0003100 0.2090000 0.0000000 22 0.0007600 0.0003400 0.1940000 0.0000000 23 0.0008300 0.0003600 0.1790000 0.0000000 24 0.0009000 0.0004000 0.1640000 0.0000000 25 0.0009700 0.0004300 0.1490000 0.0000000 26 0.0010600 0.0004700 0.1400000 0.0000000 27 0.0011400 0.0005100 0.1310000 0.0000000 28 0.0012300 0.0005500 0.1220000 0.0000000 29 0.0013200 0.0005900 0.1130000 0.0000000 30 0.0014100 0.0006400 0.1040000 0.0000000 31 0.0015100 0.0006800 0.0980000 0.0000000 32 0.0016100 0.0007500 0.0920000 0.0000000 33 0.0017200 0.0008100 0.0860000 0.0000000 34 0.0018300 0.0009000 0.0800000 0.0000000 35 0.0019400 0.0009800 0.0740000 0.0000000 36 0.0020600 0.0010800 0.0670000 0.0000000 37 0.0021900 0.0011900 0.0610000 0.0000000 38 0.0023200 0.0013100 0.0550000 0.0000000 39 0.0024600 0.0014300 0.0490000 0.0000000 40 0.0026100 0.0015800 0.0430000 0.0000000 41 0.0027600 0.0017400 0.0400000 0.0000000 42 0.0029300 0.0019300 0.0360000 0.0000000 43 0.0031100 0.0021300 0.0330000 0.0000000 44 0.0033000 0.0023400 0.0300000 0.0000000 45 0.0035100 0.0025900 0.0270000 0.0000000 46 0.0037400 0.0028700 0.0230000 0.0000000 47 0.0039900 0.0032200 0.0200000 0.0000000 48 0.0042600 0.0036000 0.0160000 0.0000000 49 0.0045600 0.0040100 0.0130000 0.0000000 50 0.0048900 0.0044800 0.0090000 0.0000000 51 0.0052500 0.0050200 0.0060000 0.0000000 52 0.0056400 0.0056800 0.0020000 0.0000000 53 0.0060900 0.0064800 0.0000000 0.0000000 54 0.0065800 0.0074400 0.0000000 0.0000000 55 0.0071200 0.0084500 0.0000000 0.0000000 56 0.0077200 0.0094100 0.0000000 0.0000000 57 0.0083900 0.0102600 0.0000000 0.0000000 58 0.0091200 0.0108400 0.0000000 0.0000000 59 0.0099400 0.0114300 0.0000000 0.0000000 60 0.0108500 0.0120400 0.0000000 0.5000000 61 0.0118600 0.0126300 0.0000000 0.0000000 62 0.0129800 0.0132000 0.0000000 0.0000000 63 0.0142200 0.0139000 0.0000000 0.0000000 64 0.0156000 0.0146300 0.0000000 0.0000000 65 0.0171300 0.0154000 0.0000000 1.0000000 66 0.0188300 0.0162200 0.0000000 67 0.0207100 0.0171000 0.0000000 68 0.0227900 0.0180400 0.0000000 69 0.0251000 0.0190200 0.0000000 70 0.0276500 0.0000000 0.0000000 71 0.0304800 0.0000000 72 0.0336100 0.0000000 73 0.0370700 0.0000000 74 0.0408800 0.0000000 75 0.0450900 0.0000000 76 0.0497300 0.0000000 77 0.0548400 0.0000000 78 0.0604600 0.0000000 79 0.0666400 0.0000000 Retiro Anticipado

Upload: jordan-bravo

Post on 19-Dec-2015

6 views

Category:

Documents


2 download

DESCRIPTION

Índíce de precios y cotizaciones y otras emisoras.

TRANSCRIPT

Datos Participantes (2)NombreSexoFecha de NacimientoFecha de IngresoSalario Base MensualSalario Integrado MensualFecha de Valuacineaantigedadeier1er2sf1sf2Empleado 1F3/20/712/17/97$11,000$12,6501/1/1342162664652223Empleado 2M2/25/718/13/97$20,000$23,0001/1/1342152664652223Empleado 3F9/24/823/25/09$6,000$6,9001/1/133042664653435Empleado 4F12/24/722/1/91$17,000$19,5501/1/1340221864652425Empleado 5M9/20/5310/5/00$11,200$12,8801/1/13591247646556Empleado 6M9/20/731/1/99$14,985$17,2331/1/1339142564652526Empleado 7M9/1/5510/14/99$28,600$32,8901/1/13571344646578Empleado 8M8/2/6512/25/96$15,000$17,2501/1/1347163164651718Empleado 9M1/7/921/16/09$18,000$20,7001/1/132141764654344Empleado 10F7/10/846/27/12$5,500$6,3251/1/132812864653637Empleado 11M12/2/695/18/95$11,500$13,2251/1/1343182564652122Empleado 12M11/29/5111/19/05$34,500$39,6751/1/1361754646534Empleado 13M1/5/4510/20/89$26,900$30,9351/1/136823456465-4-3Empleado 14F5/13/497/1/75$78,000$89,7001/1/13643826646501Empleado 15M7/3/553/6/91$35,600$40,9401/1/13582236646567Empleado 16M9/20/644/23/87$25,000$28,7501/1/1348262364651617Empleado 17F8/6/8510/24/11$8,005$9,2061/1/132712664653738Empleado 18F6/30/496/6/99$25,020$28,7731/1/13641450646501Empleado 19F3/21/6610/26/05$12,500$14,3751/1/134774064651718Empleado 20F2/28/7510/27/00$16,800$19,3201/1/1338122664652627Empleado 21F7/22/562/28/89$50,000$57,5001/1/13562433646589Empleado 22M7/1/631/1/13$35,500$40,8251/1/135005064651415Empleado 23M10/24/5910/30/83$36,500$41,9751/1/1353292464651112Empleado 24M9/9/8511/13/03$7,800$8,9701/1/132791864653738Empleado 25M5/14/893/18/11$8,000$9,2001/1/132422264654041

HiptesisHiptesis Actuariales:Financieras:Demogrficas:TasasTasa descuentoMortalidadMortalidadInvalidezRotacinRetiro AnticipadoAntes del retiro8.00%EMSSA 97 HEMSSA 97 MSSRotERPosterior al retiro3.50%150.00043000.00015000.00022000.37400000.00000001,000.00Tasa de Incremento de salarios4.00%160.00046000.00015000.00024000.34400000.0000000625.59Tasa de Inflacin3.50%170.00049000.00016000.00025000.31400000.0000000410.10Tasa de Incremento de salarios mnimos3.50%180.00053000.00017000.00026000.28400000.0000000281.12Tasa de Rendimiento de Activos8.00%190.00058000.00018000.00028000.25400000.0000000201.12200.00063000.00019000.00030000.22400000.0000000149.91210.00069000.00021000.00031000.20900000.0000000116.22220.00076000.00022000.00034000.19400000.000000091.84230.00083000.00024000.00036000.17900000.000000073.94240.00090000.00025000.00040000.16400000.000000060.63250.00097000.00026000.00043000.14900000.000000050.62260.00106000.00027000.00047000.14000000.000000043.02270.00114000.00028000.00051000.13100000.000000036.94280.00123000.00030000.00055000.12200000.000000032.05290.00132000.00031000.00059000.11300000.000000028.09300.00141000.00033000.00064000.10400000.000000024.87310.00151000.00035000.00068000.09800000.000000022.24320.00161000.00038000.00075000.09200000.000000020.01330.00172000.00041000.00081000.08600000.000000018.13340.00183000.00044000.00090000.08000000.000000016.53350.00194000.00048000.00098000.07400000.000000015.16360.00206000.00053000.00108000.06700000.000000014.00370.00219000.00060000.00119000.06100000.000000013.02380.00232000.00067000.00131000.05500000.000000012.19390.00246000.00075000.00143000.04900000.000000011.47400.00261000.00085000.00158000.04300000.000000010.87410.00276000.00095000.00174000.04000000.000000010.36420.00293000.00107000.00193000.03600000.00000009.90430.00311000.00119000.00213000.03300000.00000009.50440.00330000.00134000.00234000.03000000.00000009.14450.00351000.00149000.00259000.02700000.00000008.81460.00374000.00165000.00287000.02300000.00000008.52470.00399000.00185000.00322000.02000000.00000008.27480.00426000.00206000.00360000.01600000.00000008.05490.00456000.00229000.00401000.01300000.00000007.86500.00489000.00254000.00448000.00900000.00000007.69510.00525000.00281000.00502000.00600000.00000007.55520.00564000.00310000.00568000.00200000.00000007.43530.00609000.00343000.00648000.00000000.00000007.33540.00658000.00378000.00744000.00000000.00000007.24550.00712000.00417000.00845000.00000000.00000007.14560.00772000.00459000.00941000.00000000.0000000570.00839000.00505000.01026000.00000000.0000000580.00912000.00555000.01084000.00000000.0000000590.00994000.00610000.01143000.00000000.0000000600.01085000.00672000.01204000.00000000.5000000610.01186000.00740000.01263000.00000000.0000000620.01298000.00815000.01320000.00000000.0000000630.01422000.00859000.01390000.00000000.0000000640.01560000.00991000.01463000.00000000.0000000ERROR:#REF!650.01713000.01092000.01540000.00000001.0000000660.01883000.01205000.01622000.0000000670.02071000.01329000.01710000.0000000680.02279000.01467000.01804000.0000000690.02510000.01619000.01902000.0000000700.02765000.01787000.00000000.0000000710.03048000.01972000.0000000720.03361000.02177000.0000000730.03707000.02402000.0000000740.04088000.02652000.0000000750.04509000.02726000.0000000760.04973000.03228000.0000000770.05484000.03561000.0000000780.06046000.03927000.0000000790.06664000.04330000.0000000800.07341000.04772000.0000000810.08083000.05256000.0000000820.08895000.05787000.0000000830.09781000.06368000.0000000840.10747000.07003000.0000000850.11789000.07700000.0000000860.12910000.08464000.0000000870.14114000.09303000.0000000880.15403000.10221000.0000000890.16780000.11226000.0000000900.18247000.12325000.0000000910.19805000.13526000.0000000920.21457000.14844000.0000000930.23201000.16262000.0000000940.25038000.17815000.0000000950.29666000.19500000.0000000960.28983000.21323000.0000000970.31086000.23303000.0000000980.33273000.25435000.0000000990.35536000.27728000.00000001000.37871000.30188000.00000001010.40271000.32818000.00000001020.42728000.35919000.00000001030.45233000.38589000.00000001040.47775000.41723000.00000001050.50346000.45014000.00000001060.52933000.48450000.00000001070.55525000.52012000.00000001080.58111000.55679000.00000001090.60677000.59423000.00000001101.00000001.00000000.0000000