{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Immunizzazione classica","Regressione","Misurazione struttura","Arbitraggi","Pagina Iniziale","Insensibilità","Calcolo duration","Duration"],"not_rendered":{"charts":8,"images":8,"macros":1,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"Immunizzazione classica","index":0,"n_rows":119,"n_cols":11,"rows_kept":119}
[]
[null,"Costruzione di un Portafoglio Immunizzato"]
[]
[]
[null,"tasso mkt",{"$f":"EXP(0.1)-1","v":{"v":0.10517091807564771,"d":"0.1052"}}]
[]
[null,null,"attività finanziarie"]
[]
[null,"epoche",0,1,2,3,4,5,6,7,8]
[null,"titolo 1",{"$f":"NPV($C$5,D10:K10)","v":{"v":90.48374180359595,"d":"90.5"}},100]
[null,"titolo 2",{"$f":"NPV($C$5,D11:K11)","v":{"v":99.1087570189376,"d":"99.1"}},10,110]
[null,"titolo 3",{"v":246.43863917956585,"d":"246.4"},100,100,100]
[null,"titolo 4",{"v":45.04372596860621,"d":"45.0"},20,0,20,0,20]
[null,"titolo 5",{"v":128.2489129690498,"d":"128.2"},15,15,15,50,50,50]
[null,"titolo 6",{"v":97.52487075343458,"d":"97.5"},10,10,10,10,10,10,110]
[null,"titolo 7",{"v":97.29252642718801,"d":"97.3"},10,10,10,10,10,10,10,110]
[]
[null,null,"passività finanziarie"]
[]
[null,"epoche",0,1,2,3,4,5,6,7,8]
[null,null,{"$f":"NPV($C$5,D21:K21)","v":{"v":514.7234976452038,"d":"514.7"}},0,200,0,200,0,350,50,0]
[]
[null,null,"quote di composizione"]
[]
[null,null,"titolo 1",{"v":0.7095119110391369,"d":"0.7095"}]
[null,null,"titolo 2",{"v":0.7395583731072103,"d":"0.7396"}]
[null,null,"titolo 3",{"v":-0.3605375115123864,"d":"-0.3605"}]
[null,null,"titolo 4",{"v":1.924882152375422,"d":"1.9249"}]
[null,null,"titolo 5",{"v":1.022652443648028,"d":"1.0227"}]
[null,null,"titolo 6",{"v":1.2585215013320301,"d":"1.2585"}]
[null,null,"titolo 7",{"v":1.2897474899379826,"d":"1.2897"}]
[]
[null,null,"flussi del portafoglio di attività"]
[]
[null,"epoche",0,1,2,3,4,5,6,7,8]
[null,null,{"$f":"NPV($C$5,D36:K36)","v":{"v":514.7234968998216,"d":"514.7"}},{"$f":"+$D$25*D10+$D$26*D11+$D$27*D12+$D$28*D13+$D$29*D14+$D$30*D15+$D$31*D16","v":{"v":121.61314329867614,"d":"121.6"}},{"v":86.12014645797504,"d":"86.1"},{"v":43.266368463690355,"d":"43.3"},{"v":76.61531209510153,"d":"76.6"},{"v":115.11295514260996,"d":"115.1"},{"v":76.61531209510153,"d":"76.6"},{"v":151.33484004590315,"d":"151.3"},{"v":141.87222389317807,"d":"141.9"}]
[]
[null,null,"flussi del portafoglio complessivo"]
[]
[null,"epoche",0,1,2,3,4,5,6,7,8]
[null,null,{"$f":"NPV($C$5,D41:K41)","v":{"v":-7.4538214527559744E-7,"d":"-0.0"}},{"$f":"+D36-D21","v":{"v":121.61314329867614,"d":"121.6"}},{"v":-113.87985354202496,"d":"-113.9"},{"v":43.266368463690355,"d":"43.3"},{"v":-123.38468790489847,"d":"-123.4"},{"v":115.11295514260996,"d":"115.1"},{"v":-273.38468790489844,"d":"-273.4"},{"v":101.33484004590315,"d":"101.3"},{"v":141.87222389317807,"d":"141.9"}]
[]
[]
[null,null,"Calcolo delle Duration"]
[null,null,"attività"]
[null,null,{"$f":"NPV($C$5,D46:K46)","v":{"v":2190.0581373609966,"d":"2,190.1"}},{"$f":"+D36*D35","v":{"v":121.61314329867614,"d":"121.6"}},{"$f":"+E36*E35","v":{"v":172.24029291595008,"d":"172.2"}},{"v":129.79910539107107,"d":"129.8"},{"v":306.4612483804061,"d":"306.5"},{"v":575.5647757130498,"d":"575.6"},{"v":459.6918725706092,"d":"459.7"},{"v":1059.343880321322,"d":"1,059.3"},{"v":1134.9777911454246,"d":"1,135.0"}]
[]
[null,null,"Duration Attività",null,{"$f":"+C46/C36","v":{"v":4.254824484508113,"d":"4.255"}}]
[]
[null,null,"passività"]
[null,null,{"$f":"NPV($C$5,D51:K51)","v":{"v":2190.0576301841525,"d":"2,190.1"}},{"$f":"+D21*D20","v":0},{"$f":"+E21*E20","v":{"v":400,"d":"400.0"}},0,{"v":800,"d":"800.0"},0,{"v":2100,"d":"2,100.0"},{"v":350,"d":"350.0"},0]
[]
[null,null,"Duration Passività",null,{"$f":"+C51/C21","v":{"v":4.254823493008177,"d":"4.255"}}]
[]
[]
[null,null,"Calcolo delle Dispersioni"]
[null,null,"attività"]
[null,null,{"$f":"NPV($C$5,D58:K58)","v":{"v":12523.661359080663,"d":"12,523.7"}},{"$f":"+D35^2*D36","v":{"v":121.61314329867614,"d":"121.6"}},{"$f":"+E35^2*E36","v":{"v":344.48058583190016,"d":"344.5"}},{"v":389.3973161732132,"d":"389.4"},{"v":1225.8449935216245,"d":"1,225.8"},{"v":2877.8238785652493,"d":"2,877.8"},{"v":2758.151235423655,"d":"2,758.2"},{"v":7415.407162249255,"d":"7,415.4"},{"v":9079.822329163397,"d":"9,079.8"}]
[]
[null,null,"Dispersione Attività",null,{"$f":"+C58/C36","v":{"v":24.330852262448957,"d":"24.331"}}]
[]
[null,null,"passività"]
[null,null,{"$f":"NPV($C$5,D63:K63)","v":{"v":10931.669358850113,"d":"10,931.7"}},{"$f":"+D20^2*D21","v":0},{"$f":"+E20^2*E21","v":{"v":800,"d":"800.0"}},0,{"v":3200,"d":"3,200.0"},0,{"v":12600,"d":"12,600.0"},{"v":2450,"d":"2,450.0"},0]
[]
[null,null,"Dispersione Passività",null,{"$f":"+C63/C21","v":{"v":21.237945049839663,"d":"21.238"}}]
[]
[]
[null,null,"Zona Risolutore"]
[]
[null,null,"F.O."]
[null,null,"Min costo",{"$f":"MMULT(TRANSPOSE(D25:D31),C10:C16)","v":{"v":514.7234968998216,"d":"514.7"}}]
[]
[null,null,"Vincoli"]
[null,null,"Bilancio",{"$f":"+C41","v":{"v":-7.4538214527559744E-7,"d":"-0.0"}}]
[null,null,"Duration",{"$f":"+E48","v":{"v":4.254824484508113,"d":"4.255"}},{"$f":"E53","v":{"v":4.254823493008177,"d":"4.255"}}]
[null,null,"Dispersione",{"$f":"+E60","v":{"v":24.330852262448957,"d":"24.331"}},{"$f":"E65","v":{"v":21.237945049839663,"d":"21.238"}}]
[]
[null,"Tassi","Valore Att."]
[null,null,"Portafoglio"]
[null,{"v":0,"d":"0.00%"},{"$f":"NPV(B80,$D$41:$K$41)","v":{"v":12.550301492235803,"d":"12.550"}}]
[null,{"$f":"+B80+0.01","v":{"v":0.01,"d":"1.00%"}},{"$f":"NPV(B81,$D$41:$K$41)","v":{"v":9.715471085609712,"d":"9.715"}}]
[null,{"$f":"+B81+0.01","v":{"v":0.02,"d":"2.00%"}},{"v":7.361521978433184,"d":"7.362"}]
[null,{"v":0.03,"d":"3.00%"},{"v":5.429303987595401,"d":"5.429"}]
[null,{"v":0.04,"d":"4.00%"},{"v":3.86664688446557,"d":"3.867"}]
[null,{"v":0.05,"d":"5.00%"},{"v":2.6275183680064087,"d":"2.628"}]
[null,{"v":0.060000000000000005,"d":"6.00%"},{"v":1.6712879179046471,"d":"1.671"}]
[null,{"v":0.07,"d":"7.00%"},{"v":0.9620825646602794,"d":"0.962"}]
[null,{"v":0.08,"d":"8.00%"},{"v":0.4682225471589663,"d":"0.468"}]
[null,{"v":0.09,"d":"9.00%"},{"v":0.16172648088357927,"d":"0.162"}]
[null,{"v":0.09999999999999999,"d":"10.00%"},{"v":0.01787707436841918,"d":"0.018"}]
[null,{"v":0.10999999999999999,"d":"11.00%"},{"v":0.01483964372132382,"d":"0.015"}]
[null,{"v":0.11999999999999998,"d":"12.00%"},{"v":0.13332671531321846,"d":"0.133"}]
[null,{"v":0.12999999999999998,"d":"13.00%"},{"v":0.35630290061113506,"d":"0.356"}]
[null,{"v":0.13999999999999999,"d":"14.00%"},{"v":0.6687249961758213,"d":"0.669"}]
[null,{"$f":"+B94+0.01","v":{"v":0.15,"d":"15.00%"}},{"v":1.0573129243189907,"d":"1.057"}]
[null,{"v":0.16,"d":"16.00%"},{"v":1.510347701272785,"d":"1.510"}]
[null,{"v":0.17,"d":"17.00%"},{"v":2.017493113088183,"d":"2.017"}]
[null,{"v":0.18000000000000002,"d":"18.00%"},{"v":2.5696382059906155,"d":"2.570"}]
[null,{"v":0.19000000000000003,"d":"19.00%"},{"v":3.15875806705971,"d":"3.159"}]
[null,{"v":0.20000000000000004,"d":"20.00%"},{"v":3.777790690942749,"d":"3.778"}]
[null,{"v":0.21000000000000005,"d":"21.00%"},{"v":4.420528005743583,"d":"4.421"}]
[null,{"v":0.22000000000000006,"d":"22.00%"},{"v":5.0815193721334,"d":"5.082"}]
[null,{"v":0.23000000000000007,"d":"23.00%"},{"v":5.755986079136751,"d":"5.756"}]
[null,{"v":0.24000000000000007,"d":"24.00%"},{"v":6.439745542261087,"d":"6.440"}]
[null,{"v":0.25000000000000006,"d":"25.00%"},{"v":7.129144068353407,"d":"7.129"}]
[null,{"v":0.26000000000000006,"d":"26.00%"},{"v":7.820997189949223,"d":"7.821"}]
[null,{"v":0.2700000000000001,"d":"27.00%"},{"v":8.512536692652382,"d":"8.513"}]
[null,{"v":0.2800000000000001,"d":"28.00%"},{"v":9.20136356458632,"d":"9.201"}]
[null,{"v":0.2900000000000001,"d":"29.00%"},{"v":9.885406189208835,"d":"9.885"}]
[null,{"v":0.3000000000000001,"d":"30.00%"},{"v":10.562883183519435,"d":"10.563"}]
[null,{"v":0.3100000000000001,"d":"31.00%"},{"v":11.232270354411279,"d":"11.232"}]
[null,{"v":0.3200000000000001,"d":"32.00%"},{"v":11.89227130792604,"d":"11.892"}]
[null,{"v":0.3300000000000001,"d":"33.00%"},{"v":12.541791300580922,"d":"12.542"}]
[null,{"v":0.34000000000000014,"d":"34.00%"},{"v":13.179913969721285,"d":"13.180"}]
[null,{"v":0.35000000000000014,"d":"35.00%"},{"v":13.805880621854866,"d":"13.806"}]
[null,{"v":0.36000000000000015,"d":"36.00%"},{"v":14.419071794870554,"d":"14.419"}]
[null,{"v":0.37000000000000016,"d":"37.00%"},{"v":15.018990842572569,"d":"15.019"}]
[null,{"v":0.38000000000000017,"d":"38.00%"},{"v":15.605249318619615,"d":"15.605"}]
[null,{"v":0.3900000000000002,"d":"39.00%"},{"v":16.177553962227655,"d":"16.178"}]

{"sheet":"Regressione","index":1,"n_rows":45,"n_cols":9,"rows_kept":45}
["OUTPUT RIEPILOGO"]
[]
["Statistica della regressione"]
["R multiplo",0.9939294179759018]
["R al quadrato",0.987895687917915]
["R al quadrato corretto",0.8071073238221492]
["Errore standard",1.6570535923314256]
["Osservazioni",14]
[]
["ANALISI VARIANZA"]
[null,"gdl","SQ","MQ","F","Significatività F"]
["Regressione",8,1344.6069040247771,168.07586300309714,61.211389867833795,1.4509336409425434E-4]
["Residuo",6,16.474959647150893,2.7458266078584823]
["Totale",14,1361.081863671928]
[]
[null,"Coefficienti","Errore standard","Stat t","Valore di significatività","Inferiore 95%","Superiore 95%","Inferiore 95,0%","Superiore 95,0%"]
["Intercetta",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Variabile X 1",{"v":0.9610574896969096,"d":"0.96106"},0.01653273924870721,58.130565978173294,1.7412214297170259E-9,0.9206033045128161,1.0015116748810031,0.9206033045128161,1.0015116748810031]
["Variabile X 2",{"v":0.8879747803468526,"d":"0.88797"},0.010828219431964738,82.00561375082266,2.2142445380325155E-10,0.8614790625154016,0.9144704981783036,0.8614790625154016,0.9144704981783036]
["Variabile X 3",{"v":0.8436903517847296,"d":"0.84369"},0.010999115331910381,76.70529186443154,3.3051397920878673E-10,0.8167764664445796,0.8706042371248797,0.8167764664445796,0.8706042371248797]
["Variabile X 4",{"v":0.7765182652698118,"d":"0.77652"},0.011084032844942802,70.05737678088042,5.690988552695032e-10,0.7493965941086972,0.8036399364309265,0.7493965941086972,0.8036399364309265]
["Variabile X 5",{"v":0.721669971258707,"d":"0.72167"},0.01527933016658608,47.23178067301052,6.0372019169201866E-9,0.6842827698549038,0.7590571726625103,0.6842827698549038,0.7590571726625103]
["Variabile X 6",{"v":0.6814798575036194,"d":"0.68148"},7.279200641362225E-3,93.62015021694576,1.0007085612122552E-10,0.6636682821616284,0.6992914328456104,0.6636682821616284,0.6992914328456104]
["Variabile X 7",{"v":0.6435265632438902,"d":"0.64353"},0.010954834554568638,58.743613154386885,1.6351565464932808E-9,0.6167210291418339,0.6703320973459466,0.6167210291418339,0.6703320973459466]
["Variabile X 8",{"v":0.612066928367395,"d":"0.61207"},0.011241849478169193,54.44539437714246,2.5776957422566682E-9,0.5845590935337256,0.6395747632010643,0.5845590935337256,0.6395747632010643]
[]
[]
[]
["OUTPUT RESIDUI"]
[]
["Osservazione","Y prevista","Residui"]
[1,{"v":96.10574896969096,"d":"96.11"},0.13234626840426245]
[2,{"v":107.28780073512289,"d":"107.29"},1.0679944131250778]
[3,{"v":103.58973619503536,"d":"103.59"},-0.9356481447209006]
[4,{"v":103.2180935312724,"d":"103.22"},0.5851409700752868]
[5,{"v":101.36906126122864,"d":"101.37"},-0.41668030884770246]
[6,{"v":96.73265140602186,"d":"96.73"},2.091025601632083]
[7,{"v":101.93651273666931,"d":"101.94"},-1.91077269411862]
[8,{"v":109.8851948510838,"d":"109.89"},0.1615052270149704]
[9,{"v":116.87189290896825,"d":"116.87"},-1.6060945613074438]
[10,{"v":136.29597150072388,"d":"136.30"},0.8910676293768631]
[11,{"v":108.47999455722518,"d":"108.48"},-0.996630563761812]
[12,{"v":106.68732576253876,"d":"106.69"},0.9971052266772062]
[13,{"v":97.97459808157099,"d":"97.97"},0.504948285604101]
[14,{"v":108.39436571141263,"d":"108.39"},-0.5097573168955876]

{"sheet":"Misurazione struttura","index":2,"n_rows":32,"n_cols":10,"rows_kept":32}
[]
[null,"Misurazione della struttura a termine dei tassi"]
[null,"la stima di un modello parametrico"]
[]
["Scadenzario",0,1,2,3,4,5,6,7,8]
[]
["titolo 1",{"v":96.23809523809523,"d":"96.24"},100,0,0,0,0,0,0,0]
["titolo 2",{"v":108.35579514824796,"d":"108.36"},10,110,0,0,0,0,0,0]
["titolo 3",{"v":102.65408805031446,"d":"102.65"},8,108,0,0,0,0,0,0]
["titolo 4",{"v":103.80323450134769,"d":"103.80"},7,7,107,0,0,0,0,0]
["titolo 5",{"v":100.95238095238093,"d":"100.95"},6,6,107,0,0,0,0,0]
["titolo 6",{"v":98.82367700765394,"d":"98.82"},5.5,5.5,5.5,105.5,0,0,0,0]
["titolo 7",{"v":100.0257400425507,"d":"100.03"},7,7,7,107,0,0,0,0]
["titolo 8",{"v":110.04670007809877,"d":"110.05"},9,9,9,9,109,0,0,0]
["titolo 9",{"v":115.2657983476608,"d":"115.27"},10,10,10,10,10,110,0,0]
["titolo 10",{"v":137.18703913010074,"d":"137.19"},0,0,0,0,0,200,0,0]
["titolo 11",{"v":107.48336399346337,"d":"107.48"},8,8,8,8,8,8,108,0]
["titolo 12",{"v":107.68443098921597,"d":"107.68"},7.5,7.5,7.5,7.5,7.5,7.5,109,0]
["titolo 13",{"v":98.47954636717509,"d":"98.48"},6,6,6,6,6,6,6,106]
["titolo 14",{"v":107.88460839451704,"d":"107.88"},8,8,8,8,8,8,8,105]
[]
[]
[]
["t","v(0,t)","i(0,t)","i(0,t-1,t)"]
[1,{"v":0.9610574896969096,"d":"0.96106"},{"$f":"+(1/B25)^(1/A25)-1","v":{"v":0.04052047949324211,"d":"0.041"}},{"$f":"1/B25-1","v":{"v":0.04052047949324211,"d":"0.041"}}]
[{"$f":"+A25+1","v":2},{"v":0.8879747803468526,"d":"0.88797"},{"$f":"+(1/B26)^(1/A26)-1","v":{"v":0.061205969447551745,"d":"0.061"}},{"$f":"+B25/B26-1","v":{"v":0.08230268580545741,"d":"0.082"}}]
[{"$f":"+A26+1","v":3},{"v":0.8436903517847296,"d":"0.84369"},{"v":0.058292306935809224,"d":"0.058"},{"$f":"+B26/B27-1","v":{"v":0.05248895933021447,"d":"0.052"}}]
[4,{"v":0.7765182652698118,"d":"0.77652"},{"v":0.06527584874226933,"d":"0.065"},{"v":0.08650419380872898,"d":"0.087"}]
[5,{"v":0.721669971258707,"d":"0.72167"},{"v":0.06741247232682057,"d":"0.067"},{"v":0.07600190695954923,"d":"0.076"}]
[6,{"v":0.6814798575036194,"d":"0.68148"},{"v":0.06600153325400782,"d":"0.066"},{"v":0.058974763982476475,"d":"0.059"}]
[7,{"v":0.6435265632438902,"d":"0.64353"},{"v":0.06499518915420932,"d":"0.065"},{"v":0.05897704372670187,"d":"0.059"}]
[8,{"v":0.612066928367395,"d":"0.61207"},{"v":0.06328609810428931,"d":"0.063"},{"v":0.05139901115129608,"d":"0.051"}]

{"sheet":"Arbitraggi","index":3,"n_rows":14,"n_cols":8,"rows_kept":14}
[]
[null,"Costruzione di un Arbitraggio"]
[]
[null,null,"matrice dei coefficienti",{"$nulls":4},"termini noti"]
[]
["titolo 1",null,100,0,10,0,null,0]
["titolo 2",null,0,100,10,0,null,99.62]
["titolo 3",null,0,0,110,10,null,-10]
["titolo 4",null,0,0,0,110,null,-110]
[]
["Quota titolo 1",null,{"$f":"MMULT(MINVERSE(C6:F9),H6:H9)","v":{"v":-1.734723475976807e-18,"d":"-0"}}]
["Quota titolo 2",null,{"v":0.9962000000000002,"d":"0.9962"}]
["Quota titolo 3",null,0]
["Quota titolo 4",null,-1]

{"sheet":"Pagina Iniziale","index":4,"n_rows":9,"n_cols":2,"rows_kept":9}
[]
[]
[null,"Manuale di"]
[null,"Matematica finanziaria"]
[]
[]
[null,"Marco Micocci - Giovanni Masala"]
[]
[null,"Capitoli 5-6"]

{"sheet":"Insensibilità","index":5,"n_rows":91,"n_cols":11,"rows_kept":91}
[]
[]
[null,"Calcolo Valore Capitale di un Titolo e ruolo Duration"]
[]
[]
[]
[]
[]
[null,"Importi",null,30,30,30,30,30,30,30,130]
[null,"tempi",0,1,2,3,4,5,6,7,8]
[]
[]
[null,"i(0;t)",null,{"v":0.17,"d":"0.1700"},{"$f":"+D13","v":{"v":0.17,"d":"0.1700"}},{"$f":"+E13","v":{"v":0.17,"d":"0.1700"}},{"v":0.17,"d":"0.1700"},{"v":0.17,"d":"0.1700"},{"v":0.17,"d":"0.1700"},{"v":0.17,"d":"0.1700"},{"v":0.17,"d":"0.1700"}]
[null,"i(0;t-1;t)",null,{"$f":"+D13","v":{"v":0.17,"d":"0.1700"}},{"$f":"+(1+E13)^E10/(1+D13)^D10-1","v":{"v":0.16999999999999993,"d":"0.1700"}},{"$f":"+(1+F13)^F10/(1+E13)^E10-1","v":{"v":0.16999999999999993,"d":"0.1700"}},{"v":0.16999999999999993,"d":"0.1700"},{"v":0.16999999999999993,"d":"0.1700"},{"v":0.16999999999999993,"d":"0.1700"},{"v":0.16999999999999993,"d":"0.1700"},{"v":0.16999999999999993,"d":"0.1700"}]
[]
[null,"v(0;t)",null,{"$f":"+(1+D13)^-D10","v":{"v":0.8547008547008548,"d":"0.8547"}},{"$f":"+(1+E13)^-E10","v":{"v":0.7305135510263716,"d":"0.7305"}},{"v":0.6243705564327963,"d":"0.6244"},{"v":0.5336500482331593,"d":"0.5337"},{"v":0.4561111523360336,"d":"0.4561"},{"v":0.3898385917401997,"d":"0.3898"},{"v":0.33319537755572626,"d":"0.3332"},{"v":0.28478237397925327,"d":"0.2848"}]
[]
[null,"D(0;X)",null,{"$f":"SUMPRODUCT(D9:K9,D10:K10,D16:K16)/SUMPRODUCT(D9:K9,D16:K16)","v":{"v":4.489117198465431,"d":"4.4891"}}]
[]
[null,"VAN(t;X)",{"$f":"NPV($D$13,D9:$K$9)","v":{"v":154.69311257805717,"d":"154.69"}},{"$f":"NPV($D$13,E9:$K$9)","v":{"v":150.99094171632686,"d":"150.99"}},{"$f":"NPV($D$13,F9:$K$9)","v":{"v":146.65940180810244,"d":"146.66"}},{"$f":"NPV($D$13,G9:$K$9)","v":{"v":141.59150011547982,"d":"141.59"}},{"$f":"NPV($D$13,H9:$K$9)","v":{"v":135.6620551351114,"d":"135.66"}},{"$f":"NPV($D$13,I9:$K$9)","v":{"v":128.72460450808032,"d":"128.72"}},{"$f":"NPV($D$13,J9:$K$9)","v":{"v":120.60778727445395,"d":"120.61"}},{"$f":"NPV($D$13,K9:$K$9)","v":{"v":111.11111111111111,"d":"111.11"}},0]
[null,"ACC(t;X)",{"$f":"NPV($D$13,$C$9:C9)*(1+$D$13)^C10","v":0},{"$f":"NPV($D$13,$C$9:D9)*(1+$D$13)^D10","v":{"v":30,"d":"30.00"}},{"$f":"NPV($D$13,$C$9:E9)*(1+$D$13)^E10","v":{"v":65.1,"d":"65.10"}},{"$f":"NPV($D$13,$C$9:F9)*(1+$D$13)^F10","v":{"v":106.167,"d":"106.17"}},{"$f":"NPV($D$13,$C$9:G9)*(1+$D$13)^G10","v":{"v":154.21538999999999,"d":"154.22"}},{"$f":"NPV($D$13,$C$9:H9)*(1+$D$13)^H10","v":{"v":210.43200629999993,"d":"210.43"}},{"$f":"NPV($D$13,$C$9:I9)*(1+$D$13)^I10","v":{"v":276.20544737099993,"d":"276.21"}},{"$f":"NPV($D$13,$C$9:J9)*(1+$D$13)^J10","v":{"v":353.1603734240699,"d":"353.16"}},{"$f":"NPV($D$13,$C$9:K9)*(1+$D$13)^K10","v":{"v":543.1976369061617,"d":"543.20"}}]
[]
[null,"W(t;X)",{"$f":"+C20+C21","v":{"v":154.69311257805717,"d":"154.69"}},{"$f":"+D20+D21","v":{"v":180.99094171632686,"d":"180.99"}},{"v":211.75940180810244,"d":"211.76"},{"v":247.75850011547982,"d":"247.76"},{"v":289.8774451351114,"d":"289.88"},{"v":339.15661080808025,"d":"339.16"},{"v":396.8132346454539,"d":"396.81"},{"v":464.271484535181,"d":"464.27"},{"v":543.1976369061617,"d":"543.20"}]
[]
[null,null,0,1,2,3,4,5,6,7,8]
[null,0.05,{"v":261.58031898565633,"d":"261.58"},{"v":274.6593349349392,"d":"274.66"},{"v":288.3923016816861,"d":"288.39"},{"v":302.81191676577043,"d":"302.81"},{"v":317.95251260405894,"d":"317.95"},{"v":333.850138234262,"d":"333.85"},{"v":350.54264514597503,"d":"350.54"},{"v":368.0697774032738,"d":"368.07"},{"v":386.47326627343745,"d":"386.47"}]
[null,{"$f":"+B26+0.01","v":{"v":0.060000000000000005,"d":"0.06"}},{"v":249.0350514632692,"d":"249.04"},{"v":263.9771545510654,"d":"263.98"},{"v":279.8157838241293,"d":"279.82"},{"v":296.6047308535771,"d":"296.60"},{"v":314.4010147047918,"d":"314.40"},{"v":333.2650755870793,"d":"333.27"},{"v":353.2609801223041,"d":"353.26"},{"v":374.4566389296424,"d":"374.46"},{"v":396.92403726542085,"d":"396.92"}]
[null,{"$f":"+B27+0.01","v":0.07},{"v":237.33986564291584,"d":"237.34"},{"v":253.95365623792,"d":"253.95"},{"v":271.7304121745744,"d":"271.73"},{"v":290.7515410267946,"d":"290.75"},{"v":311.10414889867025,"d":"311.10"},{"v":332.8814393215772,"d":"332.88"},{"v":356.1831400740876,"d":"356.18"},{"v":381.1159598792737,"d":"381.12"},{"v":407.79407707082277,"d":"407.79"}]
[null,0.08,{"v":226.42605676195654,"d":"226.43"},{"v":244.54014130291307,"d":"244.54"},{"v":264.1033526071461,"d":"264.10"},{"v":285.23162081571786,"d":"285.23"},{"v":308.0501504809753,"d":"308.05"},{"v":332.69416251945336,"d":"332.69"},{"v":359.30969552100964,"d":"359.31"},{"v":388.05447116269045,"d":"388.05"},{"v":419.0988288557057,"d":"419.10"}]
[null,0.09,{"v":216.2312014096873,"d":"216.23"},{"v":235.69200953655917,"d":"235.69"},{"v":256.9042903948495,"d":"256.90"},{"v":280.025676530386,"d":"280.03"},{"v":305.22798741812073,"d":"305.23"},{"v":332.69850628575165,"d":"332.70"},{"v":362.64137185146933,"d":"362.64"},{"v":395.27909531810155,"d":"395.28"},{"v":430.85421389673064,"d":"430.85"}]
[null,{"v":0.09999999999999999,"d":"0.10"},{"v":206.69852395805322,"d":"206.70"},{"v":227.36837635385857,"d":"227.37"},{"v":250.10521398924442,"d":"250.11"},{"v":275.1157353881689,"d":"275.12"},{"v":302.62730892698585,"d":"302.63"},{"v":332.8900398196844,"d":"332.89"},{"v":366.17904380165294,"d":"366.18"},{"v":402.7969481818183,"d":"402.80"},{"v":443.076643,"d":"443.08"}]
[null,{"v":0.10999999999999999,"d":"0.11"},{"v":197.7763324576145,"d":"197.78"},{"v":219.53172902795208,"d":"219.53"},{"v":243.68021922102685,"d":"243.68"},{"v":270.4850433353398,"d":"270.49"},{"v":300.23839810222717,"d":"300.24"},{"v":333.26462189347217,"d":"333.26"},{"v":369.9237303017542,"d":"369.92"},{"v":410.61534063494713,"d":"410.62"},{"v":455.78302810479147,"d":"455.78"}]
[null,{"v":0.11999999999999998,"d":"0.12"},{"v":189.41751580309452,"d":"189.42"},{"v":212.1476176994659,"d":"212.15"},{"v":237.6053318234018,"d":"237.61"},{"v":266.11797164221,"d":"266.12"},{"v":298.05212823927525,"d":"298.05"},{"v":333.8183836279883,"d":"333.82"},{"v":373.876589663347,"d":"373.88"},{"v":418.7417804229486,"d":"418.74"},{"v":468.99079407370243,"d":"468.99"}]
[null,{"v":0.12999999999999998,"d":"0.13"},{"v":181.57909500555212,"d":"181.58"},{"v":205.18437735627384,"d":"205.18"},{"v":231.85834641258947,"d":"231.86"},{"v":261.999931446226,"d":"262.00"},{"v":296.0599225342354,"d":"296.06"},{"v":334.5477124636859,"d":"334.55"},{"v":378.03891508396504,"d":"378.04"},{"v":427.1839740448805,"d":"427.18"},{"v":482.71789067071495,"d":"482.72"}]
[null,{"v":0.13999999999999999,"d":"0.14"},{"v":174.22182230277014,"d":"174.22"},{"v":198.61287742515793,"d":"198.61"},{"v":226.41868026468012,"d":"226.42"},{"v":258.1172955017353,"d":"258.12"},{"v":294.2537168719783,"d":"294.25"},{"v":335.4492372340553,"d":"335.45"},{"v":382.4121304468231,"d":"382.41"},{"v":435.9498287093784,"d":"435.95"},{"v":496.9828047286915,"d":"496.98"}]
[null,0.15,{"v":167.30982261538333,"d":"167.31"},{"v":192.40629600769083,"d":"192.41"},{"v":221.26724040884443,"d":"221.27"},{"v":254.45732647017104,"d":"254.46"},{"v":292.62592544069673,"d":"292.63"},{"v":336.51981425680117,"d":"336.52"},{"v":386.9977863953213,"d":"387.00"},{"v":445.04745435461945,"d":"445.05"},{"v":511.8045725078123,"d":"511.80"}]
[null,0.16,{"v":160.81027253017325,"d":"160.81"},{"v":186.539916135001,"d":"186.54"},{"v":216.3863027166011,"d":"216.39"},{"v":251.0081111512573,"d":"251.01"},{"v":291.1694089354585,"d":"291.17"},{"v":337.7565143651318,"d":"337.76"},{"v":391.7975566635529,"d":"391.80"},{"v":454.48516572972136,"d":"454.49"},{"v":527.2027922464766,"d":"527.20"}]
[null,0.17,{"v":154.69311257805717,"d":"154.69"},{"v":180.99094171632686,"d":"180.99"},{"v":211.75940180810244,"d":"211.76"},{"v":247.75850011547982,"d":"247.76"},{"v":289.8774451351114,"d":"289.88"},{"v":339.15661080808025,"d":"339.16"},{"v":396.8132346454539,"d":"396.81"},{"v":464.271484535181,"d":"464.27"},{"v":543.1976369061617,"d":"543.20"}]
{"$rows_empty":22}
[null,null,0,1,2,3,4,5,6,7,8]
[null,0.05,{"v":154.69311257805717,"d":"154.69"},{"v":274.6593349349392,"d":"274.66"},{"v":288.3923016816861,"d":"288.39"},{"v":302.81191676577043,"d":"302.81"},{"v":317.95251260405894,"d":"317.95"},{"v":333.850138234262,"d":"333.85"},{"v":350.54264514597503,"d":"350.54"},{"v":368.0697774032738,"d":"368.07"},{"v":386.47326627343745,"d":"386.47"}]
[null,{"$f":"+B62+0.01","v":{"v":0.060000000000000005,"d":"0.06"}},{"v":154.69311257805717,"d":"154.69"},{"v":263.9771545510654,"d":"263.98"},{"v":279.8157838241293,"d":"279.82"},{"v":296.6047308535771,"d":"296.60"},{"v":314.4010147047918,"d":"314.40"},{"v":333.2650755870793,"d":"333.27"},{"v":353.2609801223041,"d":"353.26"},{"v":374.4566389296424,"d":"374.46"},{"v":396.92403726542085,"d":"396.92"}]
[null,{"$f":"+B63+0.01","v":0.07},{"v":154.69311257805717,"d":"154.69"},{"v":253.95365623792,"d":"253.95"},{"v":271.7304121745744,"d":"271.73"},{"v":290.7515410267946,"d":"290.75"},{"v":311.10414889867025,"d":"311.10"},{"v":332.8814393215772,"d":"332.88"},{"v":356.1831400740876,"d":"356.18"},{"v":381.1159598792737,"d":"381.12"},{"v":407.79407707082277,"d":"407.79"}]
[null,0.08,{"v":154.69311257805717,"d":"154.69"},{"v":244.54014130291307,"d":"244.54"},{"v":264.1033526071461,"d":"264.10"},{"v":285.23162081571786,"d":"285.23"},{"v":308.0501504809753,"d":"308.05"},{"v":332.69416251945336,"d":"332.69"},{"v":359.30969552100964,"d":"359.31"},{"v":388.05447116269045,"d":"388.05"},{"v":419.0988288557057,"d":"419.10"}]
[null,0.09,{"v":154.69311257805717,"d":"154.69"},{"v":235.69200953655917,"d":"235.69"},{"v":256.9042903948495,"d":"256.90"},{"v":280.025676530386,"d":"280.03"},{"v":305.22798741812073,"d":"305.23"},{"v":332.69850628575165,"d":"332.70"},{"v":362.64137185146933,"d":"362.64"},{"v":395.27909531810155,"d":"395.28"},{"v":430.85421389673064,"d":"430.85"}]
[null,{"v":0.09999999999999999,"d":"0.10"},{"v":154.69311257805717,"d":"154.69"},{"v":227.36837635385857,"d":"227.37"},{"v":250.10521398924442,"d":"250.11"},{"v":275.1157353881689,"d":"275.12"},{"v":302.62730892698585,"d":"302.63"},{"v":332.8900398196844,"d":"332.89"},{"v":366.17904380165294,"d":"366.18"},{"v":402.7969481818183,"d":"402.80"},{"v":443.076643,"d":"443.08"}]
[null,{"v":0.10999999999999999,"d":"0.11"},{"v":154.69311257805717,"d":"154.69"},{"v":219.53172902795208,"d":"219.53"},{"v":243.68021922102685,"d":"243.68"},{"v":270.4850433353398,"d":"270.49"},{"v":300.23839810222717,"d":"300.24"},{"v":333.26462189347217,"d":"333.26"},{"v":369.9237303017542,"d":"369.92"},{"v":410.61534063494713,"d":"410.62"},{"v":455.78302810479147,"d":"455.78"}]
[null,{"v":0.11999999999999998,"d":"0.12"},{"v":154.69311257805717,"d":"154.69"},{"v":212.1476176994659,"d":"212.15"},{"v":237.6053318234018,"d":"237.61"},{"v":266.11797164221,"d":"266.12"},{"v":298.05212823927525,"d":"298.05"},{"v":333.8183836279883,"d":"333.82"},{"v":373.876589663347,"d":"373.88"},{"v":418.7417804229486,"d":"418.74"},{"v":468.99079407370243,"d":"468.99"}]
[null,{"v":0.12999999999999998,"d":"0.13"},{"v":154.69311257805717,"d":"154.69"},{"v":205.18437735627384,"d":"205.18"},{"v":231.85834641258947,"d":"231.86"},{"v":261.999931446226,"d":"262.00"},{"v":296.0599225342354,"d":"296.06"},{"v":334.5477124636859,"d":"334.55"},{"v":378.03891508396504,"d":"378.04"},{"v":427.1839740448805,"d":"427.18"},{"v":482.71789067071495,"d":"482.72"}]
[null,{"v":0.13999999999999999,"d":"0.14"},{"v":154.69311257805717,"d":"154.69"},{"v":198.61287742515793,"d":"198.61"},{"v":226.41868026468012,"d":"226.42"},{"v":258.1172955017353,"d":"258.12"},{"v":294.2537168719783,"d":"294.25"},{"v":335.4492372340553,"d":"335.45"},{"v":382.4121304468231,"d":"382.41"},{"v":435.9498287093784,"d":"435.95"},{"v":496.9828047286915,"d":"496.98"}]
[null,0.15,{"v":154.69311257805717,"d":"154.69"},{"v":192.40629600769083,"d":"192.41"},{"v":221.26724040884443,"d":"221.27"},{"v":254.45732647017104,"d":"254.46"},{"v":292.62592544069673,"d":"292.63"},{"v":336.51981425680117,"d":"336.52"},{"v":386.9977863953213,"d":"387.00"},{"v":445.04745435461945,"d":"445.05"},{"v":511.8045725078123,"d":"511.80"}]
[null,0.16,{"v":154.69311257805717,"d":"154.69"},{"v":186.539916135001,"d":"186.54"},{"v":216.3863027166011,"d":"216.39"},{"v":251.0081111512573,"d":"251.01"},{"v":291.1694089354585,"d":"291.17"},{"v":337.7565143651318,"d":"337.76"},{"v":391.7975566635529,"d":"391.80"},{"v":454.48516572972136,"d":"454.49"},{"v":527.2027922464766,"d":"527.20"}]
[null,0.17,{"v":154.69311257805717,"d":"154.69"},{"v":180.99094171632686,"d":"180.99"},{"v":211.75940180810244,"d":"211.76"},{"v":247.75850011547982,"d":"247.76"},{"v":289.8774451351114,"d":"289.88"},{"v":339.15661080808025,"d":"339.16"},{"v":396.8132346454539,"d":"396.81"},{"v":464.271484535181,"d":"464.27"},{"v":543.1976369061617,"d":"543.20"}]
[]
[]
[]
[{"$nulls":3},1,2,3,4,5,6,7,8]
[null,null,0.05,{"$f":"(D62/$C62)^(1/D$61)-1","v":{"v":0.7755110771098346,"d":"77.55%"}},{"v":0.36538882043369836,"d":"36.54%"},{"v":0.2509328423405264,"d":"25.09%"},{"v":0.197354693253166,"d":"19.74%"},{"v":0.16631568575646583,"d":"16.63%"},{"v":0.146071326077724,"d":"14.61%"},{"v":0.13182656481897137,"d":"13.18%"},{"v":0.12125930449464906,"d":"12.13%"}]
[null,null,{"$f":"+C79+0.01","v":{"v":0.060000000000000005,"d":"0.06"}},{"v":0.7064570629662918,"d":"70.65%"},{"v":0.34493289302636554,"d":"34.49%"},{"v":0.24232635513914125,"d":"24.23%"},{"v":0.19399701281366188,"d":"19.40%"},{"v":0.16590661204357948,"d":"16.59%"},{"v":0.1475477926637696,"d":"14.75%"},{"v":0.1346116079160351,"d":"13.46%"},{"v":0.12500525935769802,"d":"12.50%"}]
[null,null,{"$f":"+C80+0.01","v":0.07},{"v":0.6416610410484602,"d":"64.17%"},{"v":0.3253593150243643,"d":"32.54%"},{"v":0.2340999908241319,"d":"23.41%"},{"v":0.1908545112968545,"d":"19.09%"},{"v":0.16563806295809091,"d":"16.56%"},{"v":0.1491244450370992,"d":"14.91%"},{"v":0.13747243174102142,"d":"13.75%"},{"v":0.12881102363842745,"d":"12.88%"}]
[null,null,0.08,{"v":0.5808082029477535,"d":"58.08%"},{"v":0.3066265186286301,"d":"30.66%"},{"v":0.22624024059697634,"d":"22.62%"},{"v":0.1879211422139606,"d":"18.79%"},{"v":0.165506877446008,"d":"16.55%"},{"v":0.15079948724559933,"d":"15.08%"},{"v":0.14040797265090665,"d":"14.04%"},{"v":0.13267596142545446,"d":"13.27%"}]
[null,null,0.09,{"v":0.5236102345385965,"d":"52.36%"},{"v":0.28869513681361814,"d":"28.87%"},{"v":0.21873408949797657,"d":"21.87%"},{"v":0.18519099689748053,"d":"18.52%"},{"v":0.16550992087966288,"d":"16.55%"},{"v":0.15257110737376833,"d":"15.26%"},{"v":0.14341713339774786,"d":"14.34%"},{"v":0.13659939583753689,"d":"13.66%"}]
[null,null,{"v":0.09999999999999999,"d":"0.10"},{"v":0.46980284102260805,"d":"46.98%"},{"v":0.27152787036889947,"d":"27.15%"},{"v":0.2115689952045814,"d":"21.16%"},{"v":0.18265830120360182,"d":"18.27%"},{"v":0.1656440861021693,"d":"16.56%"},{"v":0.15443747978183708,"d":"15.44%"},{"v":0.14649878563724217,"d":"14.65%"},{"v":0.14058061149747858,"d":"14.06%"}]
[null,null,{"v":0.10999999999999999,"d":"0.11"},{"v":0.41914352468134464,"d":"41.91%"},{"v":0.25508936430689766,"d":"25.51%"},{"v":0.20473286819320324,"d":"20.47%"},{"v":0.1803174125550535,"d":"18.03%"},{"v":0.1659062945997769,"d":"16.59%"},{"v":0.15639676741785125,"d":"15.64%"},{"v":0.14965177249487205,"d":"14.97%"},{"v":0.1446188570594622,"d":"14.46%"}]
[null,null,{"v":0.11999999999999998,"d":"0.12"},{"v":0.371409587433426,"d":"37.14%"},{"v":0.2393460928753668,"d":"23.93%"},{"v":0.1982140531460097,"d":"19.82%"},{"v":0.17816281727968764,"d":"17.82%"},{"v":0.16629349777430358,"d":"16.63%"},{"v":0.15844712418113027,"d":"15.84%"},{"v":0.15287491117131524,"d":"15.29%"},{"v":0.148713347773608,"d":"14.87%"}]
[null,null,{"v":0.12999999999999998,"d":"0.13"},{"v":0.32639633359719933,"d":"32.64%"},{"v":0.22426625248139365,"d":"22.43%"},{"v":0.19200131149406574,"d":"19.20%"},{"v":0.17618912820344268,"d":"17.62%"},{"v":0.1668026782895875,"d":"16.68%"},{"v":0.16058669731661768,"d":"16.06%"},{"v":0.1561669955695364,"d":"15.62%"},{"v":0.15286326807210315,"d":"15.29%"}]
[null,null,{"v":0.13999999999999999,"d":"0.14"},{"v":0.28391545114808614,"d":"28.39%"},{"v":0.2098196618954491,"d":"20.98%"},{"v":0.1860838049974649,"d":"18.61%"},{"v":0.17439108245967705,"d":"17.44%"},{"v":0.16743085146771075,"d":"16.74%"},{"v":0.1628136298208369,"d":"16.28%"},{"v":0.15952679892686938,"d":"15.95%"},{"v":0.1570677741619253,"d":"15.71%"}]
[null,null,{"$f":"+C88+0.01","v":0.15},{"v":0.2437935522863297,"d":"24.38%"},{"v":0.19597766915995507,"d":"19.60%"},{"v":0.18045108027171564,"d":"18.05%"},{"v":0.1727635394801239,"d":"17.28%"},{"v":0.16817506671263138,"d":"16.82%"},{"v":0.16512606284147346,"d":"16.51%"},{"v":0.16295307643637735,"d":"16.30%"},{"v":0.16132599660997093,"d":"16.13%"}]
[null,null,{"$f":"+C89+0.01","v":0.16},{"$f":"(D73/$C73)^(1/D$61)-1","v":{"v":0.20587085634387337,"d":"20.59%"}},{"v":0.18271306467752058,"d":"18.27%"},{"v":0.17509305417769805,"d":"17.51%"},{"v":0.17130147913589,"d":"17.13%"},{"v":0.16903240894076754,"d":"16.90%"},{"v":0.16752213805397687,"d":"16.75%"},{"v":0.166444567842859,"d":"16.64%"},{"v":0.16563704290728176,"d":"16.56%"}]
[null,null,{"$f":"+C90+0.01","v":0.17},{"$f":"(D74/$C74)^(1/D$61)-1","v":{"v":0.16999999999999993,"d":"17.00%"}},{"v":0.16999999999999993,"d":"17.00%"},{"v":0.16999999999999993,"d":"17.00%"},{"v":0.16999999999999993,"d":"17.00%"},{"v":0.16999999999999993,"d":"17.00%"},{"v":0.16999999999999993,"d":"17.00%"},{"v":0.16999999999999993,"d":"17.00%"},{"v":0.16999999999999993,"d":"17.00%"}]

{"sheet":"Calcolo duration","index":6,"n_rows":18,"n_cols":13,"rows_kept":18}
{"$rows_empty":8}
[null,"Importi",null,30,30,30,30,30,30,30,130,0,0]
[null,"tempi",0,1,2,3,4,5,6,7,8,9,10]
[]
[null,"i(0;t)=0,06-0,01*t/4"]
[null,"i(0;t)",null,{"$f":"0.06-0.01*D10/4","v":{"v":0.057499999999999996,"d":"0.0575"}},{"v":0.055,"d":"0.0550"},0.0525,{"v":0.049999999999999996,"d":"0.0500"},0.0475,{"v":0.045,"d":"0.0450"},{"v":0.042499999999999996,"d":"0.0425"},{"v":0.039999999999999994,"d":"0.0400"},0.0375,{"v":0.034999999999999996,"d":"0.0350"}]
[null,"i(0;t-1;t)",null,{"$f":"+D13","v":{"v":0.057499999999999996,"d":"0.0575"}},{"$f":"+(1+E13)^E10/(1+D13)^D10-1","v":{"v":0.05250591016548456,"d":"0.0525"}},{"v":0.04751775847352935,"d":"0.0475"},{"v":0.04253557306683131,"d":"0.0425"},{"v":0.03755938225480615,"d":"0.0376"},{"v":0.032589214514688214,"d":"0.0326"},{"v":0.02762509849265138,"d":"0.0276"},{"v":0.022667063004906618,"d":"0.0227"},{"v":0.017715137038845086,"d":"0.0177"},{"v":0.012769349754154335,"d":"0.0128"}]
[]
[null,"v(0;t)",null,{"$f":"+(1+D13)^-D10","v":{"v":0.9456264775413711,"d":"0.9456"}},{"$f":"+(1+E13)^-E10","v":{"v":0.8984524157139329,"d":"0.8985"}},{"v":0.8576965960206551,"d":"0.8577"},{"v":0.822702474791882,"d":"0.8227"},{"v":0.7929208572178289,"d":"0.7929"},{"v":0.7678957382781668,"d":"0.7679"},{"v":0.7472528059158319,"d":"0.7473"},{"v":0.7306902050019838,"d":"0.7307"}]
[]
[null,"D(0;X)",null,{"$f":"SUMPRODUCT(D9:K9,D10:K10,D16:K16)/SUMPRODUCT(D9:K9,D16:K16)","v":{"v":5.305084383570265,"d":"5.3051"}}]

{"sheet":"Duration","index":7,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[null,"Calcolo della Duration"]
[]
[]
[null,"tempi t","flussi Ft","tassi i(0,t-1,t)","v(0,t)",null,"V.A. Ft","V.A. Ft * t"]
[]
[null,1,{"v":20.5,"d":"20.50"},{"v":0.1,"d":"0.1000"},{"$f":"1/(1+D7)","v":{"v":0.9090909090909091,"d":"0.9091"}},null,{"$f":"+C7*E7","v":{"v":18.636363636363637,"d":"18.64"}},{"$f":"+G7*B7","v":{"v":18.636363636363637,"d":"18.64"}}]
[null,2.5,{"v":30,"d":"30.00"},{"v":0.125,"d":"0.1250"},{"$f":"+E7/(1+D8)","v":{"v":0.8080808080808081,"d":"0.8081"}},null,{"$f":"+C8*E8","v":{"v":24.242424242424242,"d":"24.24"}},{"$f":"+G8*B8","v":{"v":60.60606060606061,"d":"60.61"}}]
[null,3,{"v":37.1,"d":"37.10"},0.1133,{"$f":"+E8/(1+D9)","v":{"v":0.7258428169233883,"d":"0.7258"}},null,{"$f":"+C9*E9","v":{"v":26.928768507857704,"d":"26.93"}},{"$f":"+G9*B9","v":{"v":80.7863055235731,"d":"80.79"}}]
[null,4.5,{"v":50,"d":"50.00"},{"v":0.11,"d":"0.1100"},{"$f":"+E9/(1+D10)","v":{"v":0.6539124476787281,"d":"0.6539"}},null,{"$f":"+C10*E10","v":{"v":32.69562238393641,"d":"32.70"}},{"$f":"+G10*B10","v":{"v":147.13030072771386,"d":"147.13"}}]
[null,5,{"v":45.2,"d":"45.20"},{"v":0.105,"d":"0.1050"},{"$f":"+E10/(1+D11)","v":{"v":0.5917759707499802,"d":"0.5918"}},null,{"$f":"+C11*E11","v":{"v":26.74827387789911,"d":"26.75"}},{"$f":"+G11*B11","v":{"v":133.74136938949556,"d":"133.74"}}]
[]
[{"$nulls":6},{"$f":"SUM(G7:G11)","v":{"v":129.25145264848112,"d":"129.25"}},{"$f":"SUM(H7:H11)","v":{"v":440.9003998832068,"d":"440.90"}}]
[null,"Duration",{"$f":"+H13/G13","v":{"v":3.4111833240458975,"d":"3.41"}}]
[]
[]
[]
[null,null,"Duration",{"$f":"SUMPRODUCT(B7:B11,C7:C11,E7:E11)/SUMPRODUCT(C7:C11,E7:E11)","v":{"v":3.4111833240458966,"d":"3.41"}}]