{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["q_cap_cost","rate_cost","tassi_variabili","Sheet1"],"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":"q_cap_cost","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["AMMORTAMENTO A RATE POSTICIPATE",null,null,null,"PIANO D'AMMORTAMENTO"]
["QUOTE CAPITALI COSTANTI"]
[null,null,null,null,"h","Rh","Ch","Ih","Dh"]
["DATI:",null,null,null,0,null,null,null,{"$f":"+C6","v":80000}]
[null,null,null,null,1,4250.9799999999996,2666.67,1584.31,77333.33]
["Somma finanziata:","S=",80000,null,2,4198.17,2666.67,1531.5,74666.67]
["tasso annuo di interesse:","i=",0.04,null,3,4145.3599999999997,2666.67,1478.69,72000]
["periodicita rate (1=annue, 2=sem., …)","k=",2,null,4,4092.55,2666.67,1425.88,69333.33]
["durata in anni","n=",15,null,5,4039.74,2666.67,1373.07,66666.67]
[null,null,null,null,6,3986.93,2666.67,1320.26,64000]
["INSERIRE I DATI ED ESEGUIRE LA MACRO \"q_cap_cost\"",null,null,null,7,3934.12,2666.67,1267.45,61333.33]
[null,null,null,null,8,3881.31,2666.67,1214.6400000000001,58666.67]
["tasso periodale equivalente","j=",1.9803902718557032E-2,null,9,3828.5,2666.67,1161.83,56000]
[null,null,null,null,10,3775.69,2666.67,1109.02,53333.33]
[null,null,null,null,11,3722.87,2666.67,1056.21,50666.67]
[null,null,null,null,12,3670.06,2666.67,1003.4,48000]
[null,null,null,null,13,3617.25,2666.67,950.59,45333.33]
[null,null,null,null,14,3564.44,2666.67,897.78,42666.67]
[null,null,null,null,15,3511.63,2666.67,844.97,40000]
[null,null,null,null,16,3458.82,2666.67,792.16,37333.33]
[null,null,null,null,17,3406.01,2666.67,739.35,34666.67]
[null,null,null,null,18,3353.2,2666.67,686.54,32000]
[null,null,null,null,19,3300.39,2666.67,633.72,29333.33]
[null,null,null,null,20,3247.58,2666.67,580.91,26666.67]
[null,null,null,null,21,3194.77,2666.67,528.1,24000]
[null,null,null,null,22,3141.96,2666.67,475.29,21333.33]
[null,null,null,null,23,3089.15,2666.67,422.48,18666.669999999998]
[null,null,null,null,24,3036.34,2666.67,369.67,16000]
[null,null,null,null,25,2983.53,2666.67,316.86,13333.33]
[null,null,null,null,26,2930.72,2666.67,264.05,10666.67]
[null,null,null,null,27,2877.91,2666.67,211.24,8000]
[null,null,null,null,28,2825.1,2666.67,158.43,5333.33]
[null,null,null,null,29,2772.29,2666.67,105.62,2666.67]
[null,null,null,null,30,2719.48,2666.67,52.81,0]

{"sheet":"rate_cost","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["AMMORTAMENTO A RATE POSTICIPATE",null,null,null,"PIANO D'AMMORTAMENTO"]
["COSTANTI"]
[null,null,null,null,"h","Rh","Ch","Ih","Dh"]
["DATI:",null,null,null,0,null,null,null,{"$f":"+C6","v":120000}]
[null,null,null,null,1,11173.66,5773.66,5400,114226.34]
["Somma finanziata:","S=",120000,null,2,11173.66,6033.47,5140.1899999999996,108192.87]
["tasso annuo di interesse:","i=",4.4999999999999998E-2,null,3,11173.66,6304.98,4868.68,101887.89]
["periodicita rate (1=annue, 2=sem., …)","k=",1,null,4,11173.66,6588.7,4584.96,95299.19]
["durata in anni","n=",15,null,5,11173.66,6885.19,4288.46,88414]
[null,null,null,null,6,11173.66,7195.03,3978.63,81218.97]
["INSERIRE I DATI ED ESEGUIRE LA MACRO \"rate_cost\"",null,null,null,7,11173.66,7518.8,3654.85,73700.17]
[null,null,null,null,8,11173.66,7857.15,3316.51,65843.02]
["tasso periodale equivalente","j=",4.4999999999999929E-2,null,9,11173.66,8210.7199999999993,2962.94,57632.3]
[null,null,null,null,10,11173.66,8580.2000000000007,2593.4499999999998,49052.09]
[null,null,null,null,11,11173.66,8966.31,2207.34,40085.78]
[null,null,null,null,12,11173.66,9369.7999999999993,1803.86,30715.98]
[null,null,null,null,13,11173.66,9791.44,1382.22,20924.55]
[null,null,null,null,14,11173.66,10232.049999999999,941.6,10692.49]
[null,null,null,null,15,11173.66,10692.49,481.16,0]

{"sheet":"tassi_variabili","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["AMMORTAMENTO A RATE POSTICIPATE A TASSI VARIABILI",null,null,null,"PIANO D'AMMORTAMENTO"]
["Calcolo delle rate secondo lo schema dell'ammortamento francese"]
[null,null,null,null,"h","j(h-1, h)","Rh","Ch","Ih","Dh"]
["INSERIRE I DATI (NB inserire i tassi di tutti i periodi),",null,null,null,0,null,null,null,null,{"$f":"+C9","v":120000}]
["POSIZIONARSI SU UNA QUALUNQUE CELLA CONTENTE I TASSI,",null,null,null,1,4.4999999999999998E-2,15165.46,9765.4599999999991,5400,110234.54]
["ESEGUIRE LA MACRO \"tassi_var\"",null,null,null,2,4.2999999999999997E-2,15029.13,10289.049999999999,4740.09,99945.5]
[null,null,null,null,3,4.5999999999999999E-2,15214.67,10617.18,4597.49,89328.320000000007]
["DATI:",null,null,null,4,4.7E-2,15270.29,11071.86,4198.43,78256.460000000006]
["Somma finanziata:","S=",120000,null,5,4.7E-2,15270.29,11592.23,3678.05,66664.23]
["Tassi di interesse",null,null,null,6,4.8000000000000001E-2,15312.73,12112.84,3199.88,54551.39]
["    di ciascun periodo di ammortamento:",null,null,null,7,0.05,15384.14,12656.57,2727.57,41894.82]
[null,null,null,null,8,5.5E-2,15528.49,13224.27,2304.2199999999998,28670.55]
[1,null,4.4999999999999998E-2,null,9,0.05,15419.16,13985.63,1433.53,14684.92]
[2,null,4.2999999999999997E-2,null,10,4.9000000000000002E-2,15404.48,14684.92,719.56,0]
["..."]

{"sheet":"Sheet1","index":3,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["S =",115000,null,"somma finanziata"]
["i =",4.2000000000000003E-2,null,"tasso annuo d'interesse"]
["k =",2,null,"n. di rate in un anno"]
["m =",40,null,"n. di rate"]
["j =",2.0784012413987529E-2,null,"tasso periodale equivalente"]
[]
["Epoca","Rata","Quota capitale","Quota interesse","Debito residuo"]
[0,null,null,null,115000]
[1,4261.93,1871.77,2390.16,113128.23]
[2,4261.93,1910.67,2351.2600000000002,111217.56]
[3,4261.93,1950.38,2311.5500000000002,109267.18]
[4,4261.93,1990.92,2271.0100000000002,107276.26]
[5,4261.93,2032.3,2229.63,105243.97]
[6,4261.93,2074.54,2187.39,103169.43]
[7,4261.93,2117.65,2144.27,101051.78]
[8,4261.93,2161.67,2100.2600000000002,98890.11]
[9,4261.93,2206.6,2055.33,96683.520000000004]
[10,4261.93,2252.46,2009.47,94431.06]
[11,4261.93,2299.27,1962.66,92131.79]
[12,4261.93,2347.06,1914.87,89784.73]
[13,4261.93,2395.84,1866.09,87388.89]
[14,4261.93,2445.64,1816.29,84943.25]
[15,4261.93,2496.4699999999998,1765.46,82446.78]
[16,4261.93,2548.35,1713.57,79898.429999999993]
[17,4261.93,2601.3200000000002,1660.61,77297.11]
[18,4261.93,2655.38,1606.54,74641.73]
[19,4261.93,2710.57,1551.35,71931.149999999994]
[20,4261.93,2766.91,1495.02,69164.240000000005]
[21,4261.93,2824.42,1437.51,66339.820000000007]
[22,4261.93,2883.12,1378.81,63456.7]
[23,4261.93,2943.04,1318.88,60513.66]
[24,4261.93,3004.21,1257.72,57509.45]
[25,4261.93,3066.65,1195.28,54442.8]
[26,4261.93,3130.39,1131.54,51312.41]
[27,4261.93,3195.45,1066.48,48116.959999999999]
[28,4261.93,3261.86,1000.06,44855.09]
[29,4261.93,3329.66,932.27,41525.43]
[30,4261.93,3398.86,863.07,38126.57]
[31,4261.93,3469.51,792.42,34657.07]
[32,4261.93,3541.62,720.31,31115.45]
[33,4261.93,3615.22,646.70000000000005,27500.23]
[34,4261.93,3690.36,571.57000000000005,23809.86]
[35,4261.93,3767.06,494.86,20042.8]
[36,4261.93,3845.36,416.57,16197.44]
[37,4261.93,3925.28,336.65,12272.16]
[38,4261.93,4006.86,255.06,8265.2999999999993]
[39,4261.93,4090.14,171.79,4175.1499999999996]
[40,4261.93,4175.1499999999996,86.78,0]