{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["sim_f2002","premi TEMP MORTE","premi VITA INTERA","premi CAP DIFF","premi Rend Vit","premi Rend diff"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"sim_f2002","index":0,"n_rows":125,"n_cols":5,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Tavola 1 - Tavole di mortalità della popolazione residente per sesso ed età al 2002"]
["                  Italia "]
[null,"Maschi 2002",null,"Femmine 2002"]
["ETÀ   x","lx","dx","lx","dx"]
[]
[0,100000,468,100000,397]
[1,99532,30,99603,27]
[2,99502,22,99576,20]
[3,99480,17,99556,15]
[4,99463,14,99541,13]
[5,99449,13,99528,11]
[6,99435,13,99517,11]
[7,99422,14,99506,10]
[8,99408,13,99496,9]
[9,99395,13,99488,8]
[10,99382,13,99479,10]
[11,99368,13,99470,10]
[12,99356,15,99459,11]
[13,99341,19,99448,13]
[14,99321,27,99436,14]
[15,99294,37,99422,16]
[16,99258,49,99406,20]
[17,99209,60,99385,23]
[18,99149,70,99363,24]
[19,99079,77,99338,25]
[20,99002,82,99313,26]
[21,98921,86,99287,25]
[22,98835,88,99262,27]
[23,98746,90,99235,26]
[24,98657,92,99209,27]
[25,98565,90,99182,27]
[26,98474,90,99155,27]
[27,98385,89,99128,29]
[28,98296,87,99099,30]
[29,98208,85,99068,31]
[30,98123,87,99037,33]
[31,98036,87,99004,35]
[32,97949,90,98969,37]
[33,97859,95,98932,41]
[34,97765,100,98892,44]
[35,97664,104,98848,48]
[36,97561,108,98800,53]
[37,97453,112,98747,57]
[38,97341,119,98691,62]
[39,97222,128,98629,68]
[40,97095,137,98561,74]
[41,96958,145,98487,80]
[42,96813,157,98407,87]
[43,96656,169,98319,95]
[44,96487,187,98224,105]
[45,96300,204,98119,117]
[46,96096,220,98002,130]
[47,95876,247,97871,141]
[48,95629,267,97730,154]
[49,95362,291,97577,170]
[50,95071,319,97407,183]
[51,94752,353,97225,201]
[52,94398,390,97024,223]
[53,94009,446,96800,250]
[54,93563,472,96551,272]
[55,93091,513,96279,298]
[56,92578,567,95981,324]
[57,92011,642,95657,350]
[58,91369,704,95307,374]
[59,90665,796,94933,410]
[60,89869,856,94523,437]
[61,89013,924,94086,458]
[62,88089,996,93629,497]
[63,87093,1062,93131,529]
[64,86031,1158,92602,583]
[65,84873,1271,92020,656]
[66,83602,1399,91364,733]
[67,82203,1533,90631,799]
[68,80670,1656,89832,872]
[69,79014,1810,88960,959]
[70,77204,1979,88001,1051]
[71,75225,2132,86950,1160]
[72,73093,2304,85790,1286]
[73,70789,2454,84503,1432]
[74,68335,2625,83072,1593]
[75,65709,2806,81479,1791]
[76,62904,2978,79688,2005]
[77,59925,3128,77683,2198]
[78,56797,3294,75485,2441]
[79,53504,3425,73045,2688]
[80,50079,3491,70357,2883]
[81,46588,3454,67474,3046]
[82,43134,3476,64428,3255]
[83,39658,3625,61173,3618]
[84,36033,3922,57555,4169]
[85,32111,4001,53387,4597]
[86,28110,3870,48790,4745]
[87,24240,3610,44045,4715]
[88,20630,3206,39330,4501]
[89,17423,2914,34829,4414]
[90,14509,2621,30415,4283]
[91,11888,2344,26132,4099]
[92,9544,2026,22033,3811]
[93,7518,1719,18223,3469]
[94,5800,1431,14753,3099]
[95,4368,1171,11654,2701]
[96,3197,935,8953,2292]
[97,2262,715,6662,1861]
[98,1547,527,4800,1459]
[99,1020,374,3341,1101]
[100,646,254,2240,797]
[101,393,165,1443,552]
[102,228,102,891,364]
[103,125,60,527,229]
[104,65,33,297,137]
[105,32,17,160,78]
[106,15,8,81,42]
[107,6,4,39,21]
[108,3,2,18,10]
[109,1,1,8,5]
[110,0,0,3,2]
[111,0,0,1,1]
[112,0,0,0,0]
[113,0,0,0,0]
[114,0,0,0,0]
[115,0,0,0,0]
[116,0,0,0,0]
[117,0,0,0,0]
[118,0,0,0,0]
[119,0,0,0,0]

{"sheet":"premi TEMP MORTE","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["ASSICURAZIONE TEMPORANEA CASO MORTE"]
["C =",200000,null,"capitale assicurato"]
["n =",10,null,"durata della polizza"]
["i =",0.02,null,"tasso annuo d'interesse"]
["sesso:","m"]
["x =",45,null,"età dell'assicurato"]
[]
["U =",5894.69,null,"premio unico"]
[]
["anno","p. annuo","p. naturale"]
[0,651.11,415.37]
[1,651.11,448.9]
[2,651.11,505.15]
[3,651.11,547.46]
[4,651.11,598.34]
[5,651.11,657.92]
[6,651.11,732.56]
[7,651.11,808.01]
[8,651.11,930.24]
[9,651.11,989.16]

{"sheet":"premi VITA INTERA","index":2,"n_rows":76,"n_cols":8,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["ASSICURAZIONE CASO MORTE A VITA INTERA"]
["C =",200000,null,"capitale assicurato"]
["n =",10,null,"durata pagamento premi annui"]
["i =",0.02,null,"tasso annuo d'interesse"]
["sesso:","m"]
["x =",45,null,"età dell'assicurato"]
[]
["U =",103489.53,null,"premio unico"]
[]
["anno","p. annuo","p. naturale",null,"pesi: hEx"]
[0,11431.2,415.37,null,1,null,{"$f":"+C11*E11","v":415.37}]
[1,11431.2,448.9,null,0.97831531366440661,null,{"$f":"+C12*E12","v":439.16574430395212}]
[2,11431.2,505.15,null,0.95693684392495426,null,483.39664670869064]
[3,11431.2,547.46,null,0.93575641256904807,null,512.28920562505107]
[4,11431.2,598.34,null,0.91484680702741883,null,547.38943851678584]
[5,11431.2,657.92,null,0.89417169077196168,null,588.29343879268902]
[6,11431.2,732.56,null,0.87369744968749807,null,640.03580374307353]
[7,11431.2,808.01,null,0.85336593707991903,null,689.52821081994534]
[8,11431.2,930.24,null,0.83318563141444624,null,775.06260176697447]
[9,11431.2,989.16,null,0.81297334310325564,null,804.16071206401637]
[10,0,1080.54,null,0.79301187521991756,null,856.88105165012973]
[11,0,1200.9000000000001,null,0.77317823087412796,null,928.50973745674037]
[12,0,1368.12,null,0.75337534349370461,null,1030.7078749406071]
[13,0,1510.79,null,0.73344972776780404,null,1108.0885142143206]
[14,0,1721.48,null,0.71352792423984657,null,1228.3240510204112]
[15,0,1867.64,null,0.6933955427760975,null,1295.0132515103508]
[16,0,2035.39,null,0.67332447784158989,null,1370.4779089539936]
[17,0,2217.0100000000002,null,0.65326963618871947,null,1448.305316126753]
[18,0,2390.9499999999998,null,0.63321890388246083,null,1513.9947382377695]
[19,0,2639.27,null,0.61323286286388012,null,1618.487097970753]
[20,0,2936.34,null,0.59311626121370864,null,1741.5910024522614]
[21,0,3281.19,null,0.57277858602101073,null,1879.3953686662803]
[22,0,3656.66,null,0.55215066750308928,null,2019.0272598318463]
[23,0,4025.11,null,0.53122905379716601,null,2138.2553767295108]
[24,0,4491.63,null,0.51012151244028903,null,2291.2770889221756]
[25,0,5026.1499999999996,null,0.48866273445758274,null,2456.0922027939791]
[26,0,5557.18,null,0.46680064072129329,null,2594.0951846035568]
[27,0,6180.68,null,0.4446772001934261,null,2748.4074776915049]
[28,0,6797.33,null,0.42221599402765209,null,2869.9414426839803]
[29,0,7534.97,null,0.39958753356605486,null,3010.8800777942165]
[30,0,8370.24,null,0.37669808976096558,null,3153.0534188408246]
[31,0,9285.86,null,0.35354658848362286,null,3282.9841241365343]
[32,0,10235.02,null,0.33019938435414026,null,3379.5973028523126]
[33,0,11368.32,null,0.30682690672428942,null,3488.1064602518736]
[34,0,12551.75,null,0.28337016587413622,null,3556.7914795106894]
[35,0,13668.6,null,0.26002993613105102,null,3554.2451850008842]
[36,0,14537.11,null,0.23716008440924913,null,3447.62223466654]
[37,0,15801.19,null,0.21527177496074371,null,3401.5502177919539]
[38,0,17922.849999999999,null,0.19404300623122414,null,3477.8036942312951]
[39,0,21342.09,null,0.17284922468304245,null,3688.9637096157135]
[40,0,24431.19,null,0.15101520375922223,null,3689.4811359302721]
[41,0,26994.79,null,0.12960671890188924,null,3498.7061593455305]
[42,0,29201.45,null,0.1095718802945639,null,3199.657783827693]
[43,0,30481.02,null,9.1425123377210454E-2,null,2786.7310141632192]
[44,0,32794.15,null,7.5698816904809188E-2,null,2482.4783563988485]
[45,0,35420.879999999997,null,6.1802132997056877E-2,null,2189.0859366327918]
[46,0,38661.49,null,4.9644896343514447E-2,null,1919.3456635358202]
[47,0,41623.519999999997,null,3.9074737641393353E-2,null,1626.4281237112889]
[48,0,44807.49,null,3.0176425142168693E-2,null,1352.1298677934722]
[49,0,48411.09,null,2.2824080484559729E-2,null,1104.9386145052645]
[50,0,52565.9,null,1.6851856584948765E-2,null,885.83300805875831]
[51,0,57345.43,null,1.2092263139697173E-2,null,693.43602941908443]
[52,0,61978.81,null,8.387979914378986E-3,null,519.87701339711145]
[53,0,66795.95,null,5.6241244636640693E-3,null,375.66873646868197]
[54,0,71895.42,null,3.6355038549864701E-3,null,261.37607656587136]
[55,0,76792.33,null,2.2573389949262397E-3,null,173.34632102024412]
[56,0,82323.009999999995,null,1.3463458765950527E-3,null,110.83524506239328]
[57,0,88579.29,null,7.6577074256267024E-4,null,67.831428678974106]
[58,0,94117.65,null,4.1159848133958451E-4,null,38.738681807250543]
[59,0,99547.51,null,2.0983451989861168E-4,null,20.888503967952243]
[60,0,104166.67,null,1.0127759633115496E-4,null,10.54974995542063]
[61,0,117647.06,null,4.6543013019832247E-5,null,5.4756486453249851]
[62,0,98039.22,null,1.8252161968561665E-5,null,1.7894277227114501]
[63,0,130718.95,null,8.9471382198831683E-6,null,1.169560513607997]
[64,0,196078.43,null,2.9239013790467868E-6,null,0.57331399187832888]
[null,null,null,null,null,null,{"$f":"SUM(G11:G75)","v":103489.53305461039},{"$f":"+G76-B8","v":3.0546103953383863E-3}]

{"sheet":"premi CAP DIFF","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["ASSICURAZIONE CAPITALE DIFFERITO"]
["C =",50000,null,"capitale assicurato"]
["n =",10,null,"durata della polizza"]
["i =",0.02,null,"tasso annuo d'interesse"]
["sesso:","m"]
["x =",45,null,"età dell'assicurato"]
[]
["U =",39650.589999999997,null,"premio unico"]
[]
["anno","p. annuo","p. naturale"]
[0,4379.71,0]
[1,4379.71,0]
[2,4379.71,0]
[3,4379.71,0]
[4,4379.71,0]
[5,4379.71,0]
[6,4379.71,0]
[7,4379.71,0]
[8,4379.71,0]
[9,4379.71,48772.32]

{"sheet":"premi Rend Vit","index":4,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["ASSICURAZIONE DI RENDITA VITALIZIA ANTICIPATA"]
["R =",15000,null,"rata assicurata"]
["diff =",0,null,"durata del differimento"]
["m =",15,null,"durata pagamento premi annui"]
["i =",0.02,null,"tasso annuo d'interesse"]
["sesso:","m"]
["x =",45,null,"età dell'assicurato"]
[]
["U =",369152.55,null,"premio unico"]
[]
["anno","p. annuo","p. naturale",null,"pesi: hEx",null,"CONTROLLO"]
[0,28795.52,15000,null,1,null,{"$f":"+E12*C12","v":15000}]
[1,28795.52,15000,null,0.97831531366440661,null,{"$f":"+E13*C13","v":14674.729704966099}]
[2,28795.52,15000,null,0.95693684392495426,null,14354.052658874314]
[3,28795.52,15000,null,0.93575641256904807,null,14036.346188535721]
[4,28795.52,15000,null,0.91484680702741883,null,13722.702105411283]
[5,28795.52,15000,null,0.89417169077196168,null,13412.575361579426]
[6,28795.52,15000,null,0.87369744968749807,null,13105.461745312472]
[7,28795.52,15000,null,0.85336593707991903,null,12800.489056198785]
[8,28795.52,15000,null,0.83318563141444624,null,12497.784471216693]
[9,28795.52,15000,null,0.81297334310325564,null,12194.600146548835]
[10,28795.52,15000,null,0.79301187521991756,null,11895.178128298763]
[11,28795.52,15000,null,0.77317823087412796,null,11597.67346311192]
[12,28795.52,15000,null,0.75337534349370461,null,11300.630152405569]
[13,28795.52,15000,null,0.73344972776780404,null,11001.74591651706]
[14,28795.52,15000,null,0.71352792423984657,null,10702.918863597699]
[15,0,15000,null,0.6933955427760975,null,10400.933141641462]
[16,0,15000,null,0.67332447784158989,null,10099.867167623848]
[17,0,15000,null,0.65326963618871947,null,9799.0445428307921]
[18,0,15000,null,0.63321890388246083,null,9498.2835582369116]
[19,0,15000,null,0.61323286286388012,null,9198.4929429582025]
[20,0,15000,null,0.59311626121370864,null,8896.7439182056296]
[21,0,15000,null,0.57277858602101073,null,8591.6787903151617]
[22,0,15000,null,0.55215066750308928,null,8282.2600125463396]
[23,0,15000,null,0.53122905379716601,null,7968.4358069574901]
[24,0,15000,null,0.51012151244028903,null,7651.8226866043351]
[25,0,15000,null,0.48866273445758274,null,7329.9410168637414]
[26,0,15000,null,0.46680064072129329,null,7002.0096108193993]
[27,0,15000,null,0.4446772001934261,null,6670.1580029013912]
[28,0,15000,null,0.42221599402765209,null,6333.2399104147817]
[29,0,15000,null,0.39958753356605486,null,5993.8130034908227]
[30,0,15000,null,0.37669808976096558,null,5650.4713464144834]
[31,0,15000,null,0.35354658848362286,null,5303.1988272543431]
[32,0,15000,null,0.33019938435414026,null,4952.9907653121036]
[33,0,15000,null,0.30682690672428942,null,4602.4036008643416]
[34,0,15000,null,0.28337016587413622,null,4250.5524881120436]
[35,0,15000,null,0.26002993613105102,null,3900.4490419657654]
[36,0,15000,null,0.23716008440924913,null,3557.4012661387369]
[37,0,15000,null,0.21527177496074371,null,3229.0766244111555]
[38,0,15000,null,0.19404300623122414,null,2910.6450934683621]
[39,0,15000,null,0.17284922468304245,null,2592.7383702456368]
[40,0,15000,null,0.15101520375922223,null,2265.2280563883332]
[41,0,15000,null,0.12960671890188924,null,1944.1007835283385]
[42,0,15000,null,0.1095718802945639,null,1643.5782044184584]
[43,0,15000,null,9.1425123377210454E-2,null,1371.3768506581569]
[44,0,15000,null,7.5698816904809188E-2,null,1135.4822535721378]
[45,0,15000,null,6.1802132997056877E-2,null,927.03199495585318]
[46,0,15000,null,4.9644896343514447E-2,null,744.67344515271668]
[47,0,15000,null,3.9074737641393353E-2,null,586.12106462090026]
[48,0,15000,null,3.0176425142168693E-2,null,452.6463771325304]
[49,0,15000,null,2.2824080484559729E-2,null,342.36120726839596]
[50,0,15000,null,1.6851856584948765E-2,null,252.77784877423147]
[51,0,15000,null,1.2092263139697173E-2,null,181.38394709545759]
[52,0,15000,null,8.387979914378986E-3,null,125.81969871568479]
[53,0,15000,null,5.6241244636640693E-3,null,84.361866954961044]
[54,0,15000,null,3.6355038549864701E-3,null,54.532557824797053]
[55,0,15000,null,2.2573389949262397E-3,null,33.860084923893595]
[56,0,15000,null,1.3463458765950527E-3,null,20.195188148925791]
[57,0,15000,null,7.6577074256267024E-4,null,11.486561138440054]
[58,0,15000,null,4.1159848133958451E-4,null,6.1739772200937679]
[59,0,15000,null,2.0983451989861168E-4,null,3.1475177984791753]
[60,0,15000,null,1.0127759633115496E-4,null,1.5191639449673244]
[61,0,15000,null,4.6543013019832247E-5,null,0.69814519529748376]
[62,0,15000,null,1.8252161968561665E-5,null,0.27378242952842496]
[63,0,15000,null,8.9471382198831683E-6,null,0.13420707329824752]
[64,0,15000,null,2.9239013790467868E-6,null,4.3858520685701799E-2]
[null,null,null,null,null,null,{"$f":"SUM(G12:G76)","v":369152.54814262647},{"$f":"+G77-B9","v":-1.8573735142126679E-3},"OK"]

{"sheet":"premi Rend diff","index":5,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["ASSICURAZIONE DI RENDITA VITALIZIA ANTICIPATA"]
["R =",15000,null,"rata assicurata"]
["diff =",15,null,"durata del differimento"]
[]
["i =",0.02,null,"tasso annuo d'interesse"]
["sesso:","m"]
["x =",45,null,"età dell'assicurato"]
[]
["U =",176855.66,null,"premio unico"]
[]
["anno","p. annuo","p. naturale",null,"pesi: hEx",null,"CONTROLLO"]
[0,13795.52,0,null,1,null,{"$f":"+E12*C12","v":0}]
[1,13795.52,0,null,0.97831531366440661,null,{"$f":"+E13*C13","v":0}]
[2,13795.52,0,null,0.95693684392495426,null,0]
[3,13795.52,0,null,0.93575641256904807,null,0]
[4,13795.52,0,null,0.91484680702741883,null,0]
[5,13795.52,0,null,0.89417169077196168,null,0]
[6,13795.52,0,null,0.87369744968749807,null,0]
[7,13795.52,0,null,0.85336593707991903,null,0]
[8,13795.52,0,null,0.83318563141444624,null,0]
[9,13795.52,0,null,0.81297334310325564,null,0]
[10,13795.52,0,null,0.79301187521991756,null,0]
[11,13795.52,0,null,0.77317823087412796,null,0]
[12,13795.52,0,null,0.75337534349370461,null,0]
[13,13795.52,0,null,0.73344972776780404,null,0]
[14,13795.52,0,null,0.71352792423984657,null,0]
[15,0,15000,null,0.6933955427760975,null,10400.933141641462]
[16,0,15000,null,0.67332447784158989,null,10099.867167623848]
[17,0,15000,null,0.65326963618871947,null,9799.0445428307921]
[18,0,15000,null,0.63321890388246083,null,9498.2835582369116]
[19,0,15000,null,0.61323286286388012,null,9198.4929429582025]
[20,0,15000,null,0.59311626121370864,null,8896.7439182056296]
[21,0,15000,null,0.57277858602101073,null,8591.6787903151617]
[22,0,15000,null,0.55215066750308928,null,8282.2600125463396]
[23,0,15000,null,0.53122905379716601,null,7968.4358069574901]
[24,0,15000,null,0.51012151244028903,null,7651.8226866043351]
[25,0,15000,null,0.48866273445758274,null,7329.9410168637414]
[26,0,15000,null,0.46680064072129329,null,7002.0096108193993]
[27,0,15000,null,0.4446772001934261,null,6670.1580029013912]
[28,0,15000,null,0.42221599402765209,null,6333.2399104147817]
[29,0,15000,null,0.39958753356605486,null,5993.8130034908227]
[30,0,15000,null,0.37669808976096558,null,5650.4713464144834]
[31,0,15000,null,0.35354658848362286,null,5303.1988272543431]
[32,0,15000,null,0.33019938435414026,null,4952.9907653121036]
[33,0,15000,null,0.30682690672428942,null,4602.4036008643416]
[34,0,15000,null,0.28337016587413622,null,4250.5524881120436]
[35,0,15000,null,0.26002993613105102,null,3900.4490419657654]
[36,0,15000,null,0.23716008440924913,null,3557.4012661387369]
[37,0,15000,null,0.21527177496074371,null,3229.0766244111555]
[38,0,15000,null,0.19404300623122414,null,2910.6450934683621]
[39,0,15000,null,0.17284922468304245,null,2592.7383702456368]
[40,0,15000,null,0.15101520375922223,null,2265.2280563883332]
[41,0,15000,null,0.12960671890188924,null,1944.1007835283385]
[42,0,15000,null,0.1095718802945639,null,1643.5782044184584]
[43,0,15000,null,9.1425123377210454E-2,null,1371.3768506581569]
[44,0,15000,null,7.5698816904809188E-2,null,1135.4822535721378]
[45,0,15000,null,6.1802132997056877E-2,null,927.03199495585318]
[46,0,15000,null,4.9644896343514447E-2,null,744.67344515271668]
[47,0,15000,null,3.9074737641393353E-2,null,586.12106462090026]
[48,0,15000,null,3.0176425142168693E-2,null,452.6463771325304]
[49,0,15000,null,2.2824080484559729E-2,null,342.36120726839596]
[50,0,15000,null,1.6851856584948765E-2,null,252.77784877423147]
[51,0,15000,null,1.2092263139697173E-2,null,181.38394709545759]
[52,0,15000,null,8.387979914378986E-3,null,125.81969871568479]
[53,0,15000,null,5.6241244636640693E-3,null,84.361866954961044]
[54,0,15000,null,3.6355038549864701E-3,null,54.532557824797053]
[55,0,15000,null,2.2573389949262397E-3,null,33.860084923893595]
[56,0,15000,null,1.3463458765950527E-3,null,20.195188148925791]
[57,0,15000,null,7.6577074256267024E-4,null,11.486561138440054]
[58,0,15000,null,4.1159848133958451E-4,null,6.1739772200937679]
[59,0,15000,null,2.0983451989861168E-4,null,3.1475177984791753]
[60,0,15000,null,1.0127759633115496E-4,null,1.5191639449673244]
[61,0,15000,null,4.6543013019832247E-5,null,0.69814519529748376]
[62,0,15000,null,1.8252161968561665E-5,null,0.27378242952842496]
[63,0,15000,null,8.9471382198831683E-6,null,0.13420707329824752]
[64,0,15000,null,2.9239013790467868E-6,null,4.3858520685701799E-2]
[null,null,null,null,null,null,{"$f":"SUM(G12:G76)","v":176855.66018005184},{"$f":"+G77-B9","v":1.8005183665081859E-4},"OK"]