{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data","Finanziam.","Leasing","VAN","TIR","Tab 1 dimens","Tab 2 dimens","indici"],"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":"Data","index":0,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"Data"]
[null,"Principali funzioni:"]
[null,"ADESSO()",{"$f":"+NOW()","v":44141.712312962962}]
[null,"OGGI()",{"$f":"+TODAY()","v":"2020-11-06"}]
[]
[null,"DATA.DIFF()"]
[null,null,"1966-12-21","1991-05-02"]
[null,"DATA.DIFF(anni)",{"$f":"+DATEDIF($C$9,$D$9,\"y\")","v":24}]
[null,"DATA.DIFF(mesi)",{"$f":"+DATEDIF($C$9,$D$9,\"m\")","v":292}]
[null,"DATA.DIFF(giorni)",{"$f":"+DATEDIF($C$9,$D$9,\"d\")","v":8898}]
[]
[]
[null,null,"Data in cifre","Data estesa","Numero"]
["A)","Come funziona:"]
[null,"1° data su Excel","1900-01-01","1900-01-01",{"$f":"+D17","v":1}]
[null,"Data oggi",{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+D18","v":44141}]
[]
[]
["B)","Giorni trascorsi da t a oggi:"]
[null,"Data 1/1/2000","2000-01-01","2000-01-01",{"$f":"+D22","v":36526}]
[null,"GG trascorsi da 2000 a oggi",{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+D23-D22","v":7615}]
[]
[]
["C)","Data scadenza da oggi a t:"]
[null,"Data stipula finanziamento (oggi)",{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+D27","v":44141}]
[null,"Data scadenza finanziamento + 90 gg",{"$f":"+C27+90","v":"2021-02-04"},{"$f":"+D27+90","v":"2021-02-04"},{"$f":"+D28","v":44231}]
[]
[]
["D)","Estendere date finanziamento:"]
[null,"Data stipula finanziamento ","2020-01-15","2020-01-15",{"$f":"+D32","v":43845}]
[null,"1° rata","2020-06-15","2020-06-15",{"$f":"+D33","v":43997}]
[null,"2° rata","2021-01-15","2021-01-15",{"$f":"+D34","v":44211}]
[null,"3° rata","2021-06-15","2021-06-15",44362]
[null,"4° rata","2022-01-15","2022-01-15",44576]
[null,"5° rata","2022-06-15","2022-06-15",44727]

{"sheet":"Finanziam.","index":1,"n_rows":129,"n_cols":28,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"Finanziamento"]
[]
[null,"Debt",1000000]
[null,"T",10]
[null,"i",0.05]
[]
[]
["A)","t",0,1,2,3,4,5,6,7,8,9,10]
[null,"Debito",{"$f":"+$C$5","v":1000000},{"$f":"+C11-D12","v":920495.42503454327},{"$f":"+D11-E12","v":837015.62132081378},749361.82742139779,657325.34382701106,560687.03605290491,459216.81289009348,352673.07856914145,240802.15753214183,123337.69044329226,2.0372681319713593E-10]
[null,"Quota Capitale",null,{"$f":"+D14-D13","v":79504.574965456675},{"$f":"+E14-E13","v":83479.803713729518},87653.793899415992,92036.48359438678,96638.307774106128,101470.22316281142,106543.734320952,111870.9210369996,117464.46708884957,123337.69044329206]
[null,"Quota Interessi",null,{"$f":"+C11*$C$7","v":50000},{"$f":"+D11*$C$7","v":46024.771251727165},41850.78106604069,37468.091371069888,32866.267191350555,28034.351802645248,22960.840644504675,17633.653928457072,12040.107876607093,6166.8845221646134]
[null,"Rata",null,{"$f":"-PMT($C$7,$C$6,$C$5,0)","v":129504.57496545668},{"$f":"-PMT($C$7,$C$6,$C$5,0)","v":129504.57496545668},129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668]
[]
[]
["B)","t",0,1,2,3,4,5,6,7,8,9,10]
[null,"Debito",{"$f":"+$C$5","v":1000000},{"$f":"+C18-D19","v":920495.42503454327},{"$f":"+D18-E19","v":837015.62132081378},749361.82742139779,657325.34382701106,560687.03605290491,459216.81289009348,352673.07856914145,{"$f":"+J18-K19","v":240802.15753214183},{"$f":"+K18-L19","v":123337.69044329226},2.0372681319713593E-10]
[null,"Quota Capitale",null,{"$f":"-PPMT($C$7,D17,$C$6,$C$5,0,0)","v":79504.574965456675},{"$f":"-PPMT($C$7,E17,$C$6,$C$5,0,0)","v":83479.803713729503},87653.793899415978,92036.48359438678,96638.307774106128,101470.22316281142,106543.734320952,111870.92103699961,117464.46708884957,123337.69044329206]
[null,"Quota Interessi",null,{"$f":"-IPMT($C$7,D17,$C$6,$C$5,0,0)","v":50000},{"$f":"-IPMT($C$7,E17,$C$6,$C$5,0,0)","v":46024.771251727158},41850.781066040683,37468.091371069888,32866.26719135054,28034.35180264524,22960.840644504668,17633.653928457064,12040.107876607084,6166.8845221646043]
[null,"Rata",null,{"$f":"-PMT($C$7,$C$6,$C$5,0)","v":129504.57496545668},{"$f":"-PMT($C$7,$C$6,$C$5,0)","v":129504.57496545668},129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668,129504.57496545668]
[]
[]
[]
[]
[null,"Fianz. m.l.t.  i fisso"]
[]
[null,"Condizioni applicate"]
[null,"Debito",100000]
[null,"Anni",2]
[null,"Rate/anno",4]
[null,"Spese istruttoria %",5.0000000000000001E-3]
[null,"Spese istruttoria",{"$f":"+C32*C29","v":500}]
[null,"Spese estinzione anticipata",0.02,null,null,null,null,null,null,null,null," "]
[null,"T. Mora",0.14299999999999999]
[null,"TAEG",{"$f":"+C55","v":1.446776945169681E-2}]
[null,"Stipula contratto",{"$f":"+TODAY()","v":"2020-11-06"}]
[null,"Scadenza",{"$f":"+C37+360*C30","v":"2022-10-27"}]
[null,"T. Pre amm.to",0]
[]
[]
[null,"Tempo","T=0",{"$f":"+C37","v":"2020-11-06"},{"$f":"+D42+30","v":"2020-12-06"},{"$f":"+E42+30","v":"2021-01-05"},"2021-02-04","2021-03-06","2021-04-05","2021-05-05","2021-06-04","2021-07-04","2021-08-03","2021-09-02","2021-10-02","2021-11-01","2021-12-01","2021-12-31","2022-01-30","2022-03-01","2022-03-31","2022-04-30","2022-05-30","2022-06-29","2022-07-29","2022-08-28","2022-09-27","2022-10-27"]
[null,"T mesi",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"i Base",0.01]
[null,"i variabile = Euribor m",0]
[null,"TAN",{"$f":"C44+C45","v":0.01}]
[null,"tasso trimestrale",{"$f":"(C46/$C31)","v":2.5000000000000001E-3}]
[]
[null,"Debito residuo",null,{"$f":"+C29","v":100000},{"$f":"D49-E50","v":100000},100000,87608.965358359113,87608.965358359113,87608.965358359113,75186.953130114125,75186.953130114125,75186.953130114125,62733.885871298517,62733.885871298517,62733.885871298517,50249.68594433587,50249.68594433587,50249.68594433587,37734.27551755582,37734.27551755582,37734.27551755582,25187.576564708819,25187.576564708819,25187.576564708819,12609.5108644797,12609.5108644797,12609.5108644797,0]
[null,"Quota capitale",{"$f":"+SUM(D50:AB50)","v":100000},null,0,0,{"$f":"+G52-G51","v":12391.034641640892},0,0,{"$f":"+J52-J51","v":12422.012228244994},0,0,{"$f":"+M52-M51","v":12453.067258815607},0,0,{"$f":"+P52-P51","v":12484.199926962645},0,0,{"$f":"+S52-S51","v":12515.410426780052},0,0,{"$f":"+V52-V51","v":12546.698952847002},0,0,{"$f":"+Y52-Y51","v":12578.065700229119},0,0,{"$f":"+AB52-AB51","v":12609.510864479693}]
[null,"Quota interessi",{"$f":"+SUM(D51:AB51)","v":1128.2771331271299},null,0,0,{"$f":"D49*$C46*(12/$C31)/12","v":250},0,0,{"$f":"G49*$C46*(12/$C31)/12","v":219.02241339589781},0,0,{"$f":"J49*$C46*(12/$C31)/12","v":187.96738282528531},0,0,{"$f":"M49*$C46*(12/$C31)/12","v":156.83471467824629},0,0,{"$f":"P49*$C46*(12/$C31)/12","v":125.62421486083967},0,0,{"$f":"S49*$C46*(12/$C31)/12","v":94.33568879388956},0,0,{"$f":"V49*$C46*(12/$C31)/12","v":62.96894141177205},0,0,{"$f":"Y49*$C46*(12/$C31)/12","v":31.523777161199252}]
[null,"Rata trimestrale",101128.27713312712,null,0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892},0,0,{"$f":"-PMT($C46/$C31,$C31*$C30,$C29)","v":12641.034641640892}]
[]
[null,"Flussi cassa",-1628.2771331271324,{"$f":"+D49-$C33","v":99500},{"$f":"-E52","v":0},{"$f":"-F52","v":0},-12641.034641640892,0,0,-12641.034641640892,0,0,-12641.034641640892,0,0,-12641.034641640892,0,0,-12641.034641640892,0,0,-12641.034641640892,0,0,-12641.034641640892,0,0,-12641.034641640892]
[null,"TIR (TAEG)",{"$f":"+IRR(D54:AB54)*12","v":1.446776945169681E-2}]
[]
[]
[]
[]
[]
[null,"Fianz. m.l.t.  i variabile"]
[]
[null,"Condizioni applicate"]
[null,"Debito",100000]
[null,"Anni",2]
[null,"Rate/anno",4]
[null,"Spese istruttoria %",5.0000000000000001E-3]
[null,"Spese istruttoria",{"$f":"+C67*C64","v":500}]
[null,"Spese estinzione anticipata",0.02,null,null,null,null,null,null,null,null," "]
[null,"T. Mora",0.14299999999999999]
[null,"TAEG",{"$f":"+C95","v":1.1131092649732999E-2}]
[null,"Stipula contratto",{"$f":"+TODAY()","v":"2020-11-06"}]
[null,"Scadenza",{"$f":"+C72+360*C65","v":"2022-10-27"}]
[null,"T. Pre amm.to",0]
[]
[]
[null,"Tempo","T=0",{"$f":"+C72","v":"2020-11-06"},{"$f":"+D77+30","v":"2020-12-06"},{"$f":"+E77+30","v":"2021-01-05"},"2021-02-04","2021-03-06","2021-04-05","2021-05-05","2021-06-04","2021-07-04","2021-08-03","2021-09-02","2021-10-02","2021-11-01","2021-12-01","2021-12-31","2022-01-30","2022-03-01","2022-03-31","2022-04-30","2022-05-30","2022-06-29","2022-07-29","2022-08-28","2022-09-27","2022-10-27"]
[null,"t mesi",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,"i Base",0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"i variabile = Euribor 3 m",-3.3357E-3,-3.3357E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TAN",{"$f":"C79+C80","v":6.6642999999999997E-3},{"$f":"D79+D80","v":6.6642999999999997E-3},0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"tasso trimestrale",{"$f":"(C81/$C66)","v":1.6660749999999999E-3},{"$f":"(D81/$C66)","v":1.6660749999999999E-3},2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3]
[]
[null,"Debito residuo",null,{"$f":"+C64","v":100000},{"$f":"D84-E85","v":100000},100000,{"$f":"F84-G85","v":87572.70877111351},{"$f":"G84-H85","v":87572.70877111351},87572.70877111351,75124.712742992851,75124.712742992851,75124.712742992851,62655.977419889648,62655.977419889648,62655.977419889648,50166.468248583005,50166.468248583005,50166.468248583005,37656.150618283777,37656.150618283777,37656.150618283777,25124.989860538648,25124.989860538648,25124.989860538648,12572.951249134061,12572.951249134061,12572.951249134061,-2.1827872842550278E-11]
[null,"Quota capitale",{"$f":"+SUM(D85:AB85)","v":100000},null,0,0,{"$f":"+G87-G86","v":12427.291228886485},0,0,{"$f":"+J87-J86","v":12447.996028120651},0,0,{"$f":"+M87-M86","v":12468.735323103203},0,0,{"$f":"+P87-P86","v":12489.509171306641},0,0,{"$f":"+S87-S86","v":12510.317630299227},0,0,{"$f":"+V87-V86","v":12531.160757745127},0,0,{"$f":"+Y87-Y86","v":12552.038611404587},0,0,{"$f":"+AB87-AB86","v":12572.951249134083}]
[null,"Quota interessi",{"$f":"+SUM(D86:AB86)","v":751.18983109187036},null,0,0,{"$f":"D84*$C81*(12/$C66)/12","v":166.60749999999999},0,0,{"$f":"G84*$C81*(12/$C66)/12","v":145.90270076583295},0,0,{"$f":"J84*$C81*(12/$C66)/12","v":125.1634057832818},0,0,{"$f":"M84*$C81*(12/$C66)/12","v":104.38955757984264},0,0,{"$f":"P84*$C81*(12/$C66)/12","v":83.581098587257927},0,0,{"$f":"S84*$C81*(12/$C66)/12","v":62.737971141357143},0,0,{"$f":"V84*$C81*(12/$C66)/12","v":41.860117481896928},0,0,{"$f":"Y84*$C81*(12/$C66)/12","v":20.94747975240103}]
[null,"Rata trimestrale",100751.18983109189,null,0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485},0,0,{"$f":"-PMT($C81/$C66,$C66*$C65,$C64)","v":12593.898728886485}]
[]
[null,"Debito residuo",null,{"$f":"+C64","v":100000},{"$f":"D89-E90","v":100000},100000,{"$f":"F89-G90","v":87572.70877111351},{"$f":"G89-H90","v":87572.70877111351},87572.70877111351,75124.712742992851,75124.712742992851,75124.712742992851,62655.977419889648,62655.977419889648,62655.977419889648,50166.468248583005,50166.468248583005,50166.468248583005,37656.150618283777,37656.150618283777,37656.150618283777,25124.989860538648,25124.989860538648,25124.989860538648,12572.951249134061,12572.951249134061,12572.951249134061,-2.1827872842550278E-11]
[null,"Quota capitale",{"$f":"+SUM(D90:AB90)","v":100000},null,0,0,{"$f":"+G85","v":12427.291228886485},0,0,{"$f":"+J85","v":12447.996028120651},0,0,{"$f":"+M85","v":12468.735323103203},0,0,{"$f":"+P85","v":12489.509171306641},0,0,{"$f":"+S85","v":12510.317630299227},0,0,{"$f":"+V85","v":12531.160757745127},0,0,{"$f":"+Y85","v":12552.038611404587},0,0,{"$f":"+AB85","v":12572.951249134083}]
[null,"Quota interessi",{"$f":"+SUM(D91:AB91)","v":1043.7923972763385},null,0,0,{"$f":"D84*D81*(12/$C66)/12","v":166.60749999999999},0,0,{"$f":"G84*G81*(12/$C66)/12","v":218.93177192778379},0,0,{"$f":"J84*J81*(12/$C66)/12","v":187.81178185748215},0,0,{"$f":"M84*M81*(12/$C66)/12","v":156.63994354972414},0,0,{"$f":"P84*P81*(12/$C66)/12","v":125.41617062145751},0,0,{"$f":"S84*S81*(12/$C66)/12","v":94.140376545709444},0,0,{"$f":"V84*V81*(12/$C66)/12","v":62.812474651346612},0,0,{"$f":"Y84*Y81*(12/$C66)/12","v":31.43237812283515}]
[null,"Rata trimestrale",101043.79239727635,null,0,0,{"$f":"+G90+G91","v":12593.898728886485},0,0,{"$f":"+J90+J91","v":12666.927800048436},0,0,{"$f":"+M90+M91","v":12656.547104960686},0,0,{"$f":"+P90+P91","v":12646.149114856365},0,0,{"$f":"+S90+S91","v":12635.733800920685},0,0,{"$f":"+V90+V91","v":12625.301134290836},0,0,{"$f":"+Y90+Y91","v":12614.851086055933},0,0,{"$f":"+AB90+AB91","v":12604.383627256919}]
[]
[null,"Flussi cassa",{"$f":"+SUM(D94:AB94)","v":-1251.189831091895},{"$f":"+D84-$C68","v":99500},{"$f":"-E87","v":0},{"$f":"-F87","v":0},-12593.898728886485,0,0,-12593.898728886485,0,0,-12593.898728886485,0,0,-12593.898728886485,0,0,-12593.898728886485,0,0,-12593.898728886485,0,0,-12593.898728886485,0,0,-12593.898728886485]
[null,"TIR (TAEG)",{"$f":"+IRR(D94:AB94)*12","v":1.1131092649732999E-2}]
[]
[]
[]
[]
[null,"Fianz. b.t. Bullet  i fisso"]
[]
[null,"Condizioni applicate"]
[null,"Debito",100000]
[null,"Anni",1]
[null,"Rate/anno",4]
[null,"Spese istruttoria %",5.0000000000000001E-3]
[null,"Spese istruttoria",{"$f":"+C106*C103","v":500}]
[null,"Spese estinzione anticipata",0.02,null,null,null,null,null,null,null,null," "]
[null,"T. Mora",0.14299999999999999]
[null,"TAEG",{"$f":"+C129","v":1.5028281869589932E-2}]
[null,"Stipula contratto",{"$f":"+TODAY()","v":"2020-11-06"}]
[null,"Scadenza",{"$f":"+C111+360*C104","v":"2021-11-01"}]
[null,"T. Pre amm.to",0]
[]
[]
[null,"Tempo","T=0",{"$f":"+C111","v":"2020-11-06"},{"$f":"+D116+30","v":"2020-12-06"},{"$f":"+E116+30","v":"2021-01-05"},"2021-02-04","2021-03-06","2021-04-05","2021-05-05","2021-06-04","2021-07-04","2021-08-03","2021-09-02","2021-10-02","2021-11-01"]
[null,"T mesi",null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"i Base",0.01]
[null,"i variabile = Euribor m",0]
[null,"TAN",{"$f":"C118+C119","v":0.01}]
[null,"tasso trimestrale",{"$f":"(C120/$C105)","v":2.5000000000000001E-3}]
[]
[null,"Debito residuo",null,{"$f":"+C103","v":100000},{"$f":"D123-E124","v":100000},{"$f":"E123-F124","v":100000},{"$f":"F123-G124","v":100000},{"$f":"G123-H124","v":100000},{"$f":"H123-I124","v":100000},{"$f":"I123-J124","v":100000},{"$f":"J123-K124","v":100000},{"$f":"K123-L124","v":100000},{"$f":"L123-M124","v":100000},{"$f":"M123-N124","v":100000},{"$f":"N123-O124","v":100000},{"$f":"O123-P124","v":0}]
[null,"Quota capitale",{"$f":"+SUM(D124:AB124)","v":100000},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+$C103/C104","v":100000}]
[null,"Quota interessi",{"$f":"+SUM(D125:AB125)","v":1000},null,0,0,{"$f":"D123*$C120*(12/$C105)/12","v":250},0,0,{"$f":"G123*$C120*(12/$C105)/12","v":250},0,0,{"$f":"J123*$C120*(12/$C105)/12","v":250},0,0,{"$f":"M123*$C120*(12/$C105)/12","v":250}]
[null,"Rata trimestrale",101000,null,{"$f":"+E124+E125","v":0},{"$f":"+F124+F125","v":0},250,0,0,250,0,0,250,0,0,100250]
[]
[null,"Flussi cassa",{"$f":"+SUM(D128:P128)","v":-1500},{"$f":"+D123-$C107","v":99500},{"$f":"-E126","v":0},{"$f":"-F126","v":0},-250,0,0,-250,0,0,-250,0,0,-100250]
[null,"TIR (TAEG)",{"$f":"+IRR(D128:P128)*12","v":1.5028281869589932E-2}]

{"sheet":"Leasing","index":2,"n_rows":46,"n_cols":64,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"Leasing"]
[]
[null,"Debt",null,100000]
[null,"T",null,10]
[null,"i",0.02]
[null,"Maxicanone iniziale",0.2,{"$f":"+C8*D5","v":20000}]
[null,"Maxicanone finale",0.01,{"$f":"+C9*D5","v":1000}]
[null,"Canone",null,{"$f":"-PMT($C7,$D6,$D5-$D8-($D9/(1+$C7)^$D6),0)","v":8814.7957013599989}]
[]
["A)","t",0,1,2,3,4,5,6,7,8,9,10]
[null,"Debito",{"$f":"+D5-C16","v":80000},{"$f":"+C13-D14-D16","v":72785.204298640005},{"$f":"+D13-E14-E16","v":65426.11268325281},57919.839235557869,50263.44031890903,42453.91342392721,34488.195991045752,26363.164209506667,18075.631792336804,9622.3487268235422,{"$f":"+L13-M14-M16","v":1.4551915228366852E-11}]
[null,"Quota Capitale",null,{"$f":"+D17-D15","v":7214.7957013599989},{"$f":"+E17-E15","v":7359.0916153871985},{"$f":"+F17-F15","v":7506.2734476949427},7656.3989166488418,7809.5268949818183,7965.7174328814544,8125.0317815390836,8287.5324171698649,8453.283065513262,{"$f":"+M17-M15","v":8622.3487268235276}]
[null,"Quota Interessi",null,{"$f":"+C13*$C7","v":1600},{"$f":"+D13*$C7","v":1455.7040859728002},1308.5222536650563,1158.3967847111574,1005.2688063781807,849.07826847854426,689.76391982091502,527.26328419013339,361.51263584673609,{"$f":"+L13*$C7","v":192.44697453647086}]
[null,"Maxicanone",{"$f":"+D8","v":20000},null,null,null,null,null,null,null,null,null,{"$f":"+$D9","v":1000}]
[null,"Canone",null,{"$f":"+$D$10","v":8814.7957013599989},{"$f":"+$D$10","v":8814.7957013599989},8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989]
[null,"Flusso Cassa",{"$f":"-C13","v":-80000},{"$f":"+D17+D16","v":8814.7957013599989},{"$f":"+E17+E16","v":8814.7957013599989},8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,8814.7957013599989,9814.7957013599989]
[]
[]
[]
[null,"Valore complessivo",null,100000]
[null,"Debito",null,{"$f":"+D22","v":100000}]
[null,"i",null,0.02]
[null,"Anni",null,5]
[null,"Mesi",null,{"$f":"+D25*12","v":60}]
[null,"Canone/anno",12,{"$f":"-PMT(D24/C27,D26,D23-D30-(D31/((1+D24/C27)^(D25*C27-1))))","v":1386.3332757173284},{"$f":"+getformula(D27)","v":"<-=-RATA(D24/C27;D26;D23-D30-(D31/((1+D24/C27)^(D25*C27-1))))"}]
[null,"Canone/anno",null,{"$f":"+D27*C27","v":16635.999308607941}]
[null,"Canone totale",null,{"$f":"+D28*D25","v":83179.996543039713}]
[null,"Maxicanone iniziale",0.2,{"$f":"D22*C30","v":20000}]
[null,"Maxicanone finale ",0.01,{"$f":"D22*C31","v":1000}]
[null,"Spese istruttoria",5.0000000000000001E-3,{"$f":"D22*C32","v":500}]
[null,"RID / canone",1.5,{"$f":"C33*D26","v":90}]
[null,"Totale canoni e altre spese",null,{"$f":"+SUM(D29:D33)","v":104769.99654303971}]
[]
[null,"Anno",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60]
[null,"Mese","Totale",{"$f":"+TODAY()","v":"2020-11-06"},{"$f":"+D37+30","v":"2020-12-06"},{"$f":"+E37+30","v":"2021-01-05"},{"$f":"+F37+30","v":"2021-02-04"},"2021-03-06","2021-04-05","2021-05-05","2021-06-04","2021-07-04","2021-08-03","2021-09-02","2021-10-02","2021-11-01","2021-12-01","2021-12-31","2022-01-30","2022-03-01","2022-03-31","2022-04-30","2022-05-30","2022-06-29","2022-07-29","2022-08-28","2022-09-27","2022-10-27","2022-11-26","2022-12-26","2023-01-25","2023-02-24","2023-03-26","2023-04-25","2023-05-25","2023-06-24","2023-07-24","2023-08-23","2023-09-22","2023-10-22","2023-11-21","2023-12-21","2024-01-20","2024-02-19","2024-03-20","2024-04-19","2024-05-19","2024-06-18","2024-07-18","2024-08-17","2024-09-16","2024-10-16","2024-11-15","2024-12-15","2025-01-14","2025-02-13","2025-03-15","2025-04-14","2025-05-14","2025-06-13","2025-07-13","2025-08-12","2025-09-11","2022-12-01"]
[null,"Debito residuo",{"$f":"+D23","v":100000},{"$f":"+C38-D39-D41","v":80000},{"$f":"+D38-E39-E41","v":78747.000057616009},{"$f":"+E38-F39-F41","v":77491.911781994713},76234.73169258071,74975.45630301768,73714.082121138708,72450.605648956611,71185.02338265421,69917.331812574645,68647.527423211606,67375.606693199632,66101.566095304297,64825.402096412479,63547.111157522508,62266.689733734383,60984.134274239943,59699.441222313013,58412.607015299538,57123.628084607706,55832.500855698054,54539.221748073556,53243.787175269681,51946.193544844471,50646.437258368547,49344.51471141517,48040.422293550197,46734.156388322117,45425.713373251994,44115.089619823419,42802.281493472459,41487.285353577587,40170.097553449552,38850.714440321302,37529.132355337846,36205.34763354608,34879.356603884662,33551.15558917381,32220.740906105104,30888.108865231283,29553.255770956006,28216.177921523606,26876.871609008816,25535.333119306502,24191.55873212135,22845.544720957558,21497.287353108492,20146.782889646343,18794.027585411757,17439.017689003449,16081.749442767792,14722.21908278841,13360.422838875729,11996.356934556527,10630.017587063459,9261.4010073245699,7890.5033999527823,6517.3209632353755,5141.8498891234394,3764.0863632213168,2384.0265647760239,1.6666666666553738]
[null,"Quota capitale*",{"$f":"+SUM(D39:BL39)","v":78998.333333333314},null,{"$f":"+E42-E40","v":1252.9999423839952},{"$f":"+F42-F40","v":1255.0882756213018},{"$f":"+G42-G40","v":1257.180089414004},1259.2753895630271,1261.3741818789656,1263.4764721820973,1265.5822663024007,1267.6915700795714,1269.8043893630374,1271.9207300119758,1274.040597895329,1276.1639988918212,1278.2909388899743,1280.4214237881242,1282.5554594944379,1284.6930519269285,1286.8342070134734,1288.9789306918292,1291.1272289096489,1293.2791076244982,1295.4345728038725,1297.5936304252123,1299.7562864759209,1301.9225469533808,1304.0924178649698,1306.2659052280781,1308.4430150701248,1310.6237534285751,1312.8081263509562,1314.9961398948744,1317.1878001280324,1319.3831131282459,1321.5820849834595,1323.7847217917654,1325.9910296614182,1328.201014710854,1330.4146830687055,1332.63204087382,1334.8530942752764,1337.0778494324018,1339.3063125147892,1341.5384897023137,1343.774387185151,1346.0140111637929,1348.2573678490658,1350.5044634621477,1352.7553042345846,1355.0098964083088,1357.2682462356561,1359.5303599793822,1361.7962439126811,1364.0659043192022,1366.3393474930676,1368.6165797388894,1370.8976073717874,1373.1824367174072,1375.4710741119361,1377.7635259021226,1380.0597984452929,1382.3598981093685]
[null,"Quota interessi",{"$f":"+SUM(D40:BL40)","v":4181.6632097063757},null,{"$f":"D38*$D24/$C27","v":133.33333333333334},131.2450000960267,129.15318630332453,127.05788615430119,124.95909383836279,122.85680353523118,120.75100941492769,118.64170563775701,116.52888635429109,114.41254570535267,112.29267782199939,110.16927682550717,108.04233682735413,105.91185192920419,103.77781622289064,101.6402237903999,99.499068703855016,97.354345025499228,95.206046807679513,93.054168092830096,90.898702913455921,88.739645292116123,86.576989241407446,84.410728763947574,82.240857852358616,80.067370489250337,77.890260647203533,75.70952228875332,73.525149366372361,71.337135822454101,69.145475589295984,66.950162589082581,{"$f":"AJ38*$D24/$C27","v":64.751190733868839},62.548553925563077,60.342246055910131,58.132261006474437,55.918592648623019,53.701234843508509,51.480181442052135,49.255426284926678,47.026963202539342,44.794786015014694,42.558888532177505,40.319264553535582,38.075907868262597,35.828812255180821,33.577971482743905,31.323379309019597,29.065029481672415,26.802915737946321,24.537031804647352,22.267371398126215,19.993928224260877,17.716695978439098,15.435668345540948,13.150838999921305,10.862201605392293,8.5697498152057321,6.2734772720355281,3.9733776079600402]
[null,"Maxicanone",{"$f":"+SUM(D41:BL41)","v":21000},{"$f":"D30","v":20000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D31","v":1000}]
[null,"Rata",{"$f":"+SUM(D42:BL42)","v":3179.9965430396969},{"$f":"-C38+D41","v":-80000},{"$f":"+$D27","v":1386.3332757173284},{"$f":"+$D27","v":1386.3332757173284},{"$f":"+$D27","v":1386.3332757173284},1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284,1386.3332757173284]
[]
[]
[null,"Flussi cassa",{"$f":"+SUM(D45:BL45)","v":4771.4965430396969},{"$f":"-D22+D30+D32+C33","v":-79498.5},{"$f":"+E42+E41+$C33","v":1387.8332757173284},1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,{"$f":"+AK42+AK41+$C33","v":1387.8332757173284},1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,1387.8332757173284,2387.8332757173284]
[null,"TIR (TAEG)",{"$f":"+IRR(D45:BL45)*12","v":2.2911414182005707E-2},{"$f":"+getformula(C46)","v":"<-=+TIR.COST(D45:BL45)*12"}]

{"sheet":"VAN","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"VAN"]
[]
[null,"I t0",100000]
[null,"CF t1",20000]
[null,"r",0.15]
[]
[]
[null,"t",0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"CF",{"$f":"-C5","v":-100000},{"$f":"+$C6","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[null,null,{"$f":"+C11/(1+$C$7)^C10","v":-100000},{"$f":"+D11/(1+$C$7)^D10","v":17391.304347826088},{"$f":"+E11/(1+$C$7)^E10","v":15122.87334593573},{"$f":"+F11/(1+$C$7)^F10","v":13150.324648639767},11435.064911860667,9943.5347059657979,{"$f":"+I11/(1+$C$7)^I10","v":8646.5519182311291},7518.740798461853,6538.0354769233509,5685.2482408029146,4943.6941224373177,4298.8644542933198,3738.1430037333221]
[]
[]
[null,"VAN",{"$f":"+SUM(C12:O12)","v":8412.3799751112492},{"$f":"+getformula(C15)","v":"<-=+SOMMA(C12:O12)"}]
[null,"VAN",{"$f":"+C11+NPV($C$7,D11:O11)","v":8412.3799751112383},{"$f":"+getformula(C16)","v":"<-=+C11+VAN($C$7;D11:O11)"}]
[]
[]
[]
[]
[]
[null,"I t0",100000]
[null,"CF t1",20000]
[null,"r",0.15]
[]
[]
[null,"Tempo","2018-01-01","2019-03-31","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01"]
[null,"t",0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"CF",{"$f":"-C22","v":-100000},{"$f":"+$C23","v":20000},{"$f":"+$C23","v":20000},20000,{"$f":"+$C23","v":20000},20000,20000,20000,20000,20000,20000,20000,20000]
[null,null,{"$f":"+C29/(1+$C24)^C28","v":-100000},{"$f":"+D29/(1+$C24)^(((D27-$C27)/365))","v":16808.612297387899},{"$f":"+E29/(1+$C24)^(((E27-$C27)/365))","v":15122.87334593573},13145.290229233769,11430.687155855454,9939.7279616134383,8643.2417057508155,7512.9850091647322,6533.0304427519422,5680.896037175602,4939.9095975440023,4293.929062319693,3733.8513585388641]
[]
[]
[null,"VAN",{"$f":"+SUM(C30:O30)","v":7785.03420327194},{"$f":"+getformula(C33)","v":"<-=+SOMMA(C30:O30)"}]
[null,"VAN.X",{"$f":"+XNPV($C24,C29:O29,C27:O27)","v":7785.03420327194},{"$f":"+getformula(C34)","v":"<-=+VAN.X($C24;C29:O29;C27:O27)"}]

{"sheet":"TIR","index":4,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"TIR"]
[]
[null,"I t0",100000]
[null,"CF t1",20000]
[null,"r",0.15]
[]
[]
[null,"t",0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"CF",{"$f":"-C5","v":-100000},{"$f":"+$C6","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[null,null,{"$f":"+C11/(1+$C$7)^C10","v":-100000},{"$f":"+D11/(1+$C$7)^D10","v":17391.304347826088},{"$f":"+E11/(1+$C$7)^E10","v":15122.87334593573},{"$f":"+F11/(1+$C$7)^F10","v":13150.324648639767},11435.064911860667,9943.5347059657979,8646.5519182311291,7518.740798461853,6538.0354769233509,5685.2482408029146,4943.6941224373177,4298.8644542933198,3738.1430037333221]
[]
[]
[null,"TIR",{"$f":"+IRR(C11:O11)","v":0.16942550857963279},{"$f":"+getformula(C15)","v":"<-=+TIR.COST(C11:O11)"}]
[]
[]
[]
[]
[]
[]
[null,"I t0",100000]
[null,"CF t1",20000]
[null,"r",0.15]
[]
[]
[null,"Tempo","2018-01-01","2019-03-31","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01"]
[null,"t",0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"CF",{"$f":"-C22","v":-100000},{"$f":"+$C23","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[null,null,{"$f":"+C29/(1+$C24)^C28","v":-100000},{"$f":"+D29/(1+$C24)^(((D27-$C27)/365))","v":16808.612297387899},{"$f":"+E29/(1+$C24)^(((E27-$C27)/365))","v":15122.87334593573},13145.290229233769,11430.687155855454,9939.7279616134383,8643.2417057508155,7512.9850091647322,6533.0304427519422,5680.896037175602,4939.9095975440023,4293.929062319693,3733.8513585388641]
[]
[]
[null,"TIR.X",{"$f":"+XIRR(C29:O29,C27:O27,0)","v":0.16775666503906245},{"$f":"+getformula(C33)","v":"<-=+TIR.X(C29:O29;C27:O27;0)"}]

{"sheet":"Tab 1 dimens","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"tabella 1 dimensione"]
[]
[null,"I t0",1000000]
[null,"CF t1",50000]
[null,"g",0.03]
[null,"WACC",0.15]
[]
[]
[null,"t",0,1,2,3,4,5]
[null,"CF",{"$f":"-C5","v":-1000000},500000,{"$f":"+D12*(1+$C$7)","v":515000},{"$f":"+E12*(1+$C$7)","v":530450},{"$f":"+F12*(1+$C$7)","v":546363.5},562754.40500000003]
[null,{"$f":"+SUM(C13:J13)","v":765149.58509824635},{"$f":"+C12/(1+$C$8)^C11","v":-1000000},{"$f":"+D12/(1+$C$8)^D11","v":434782.60869565222},389413.98865784507,348779.48549354821,312385.10439856927,279788.39785263164]
[]
[]
[null,"VAN",{"$f":"+C12+NPV($C$8,D12:J12)","v":765149.58509824635}]
[null,"TIR",{"$f":"+IRR(C12:J12,0)","v":0.43461526096925374}]
[]
[]
[null,"tabella 1 dimensione"]
[null,null,null,"VAN","TIR"]
[null,"g",null,{"$f":"+C16","v":765149.58509824635},{"$f":"+C17","v":0.43461526096925374}]
[null,null,0,676077.54900570121,0.41041496500941776]
[null,null,0.05,827312.49717424996,0.45067246406856332]
[null,null,0.1,992918.9603475146,0.4905560050228186]
[null,null,0.15,1173913.0434782612,0.5300814102532434]
[null,null,0.2,1371348.1397744035,0.5692634932363918]
[null,null,0.25,1586314.9306990015,0.60811612812209481]
[null,null,0.3,1819941.3859702637,0.64665231730580119]

{"sheet":"Tab 2 dimens","index":6,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"tabella 2 dimensioni"]
[]
[null,"I t0",1000000]
[null,"CF t1",50000]
[null,"g",0.05]
[null,"WACC",0.15]
[]
[]
[null,"t",0,1,2,3,4,5]
[null,"CF",{"$f":"-C5","v":-1000000},500000,{"$f":"+D12*(1+$C$7)","v":525000},{"$f":"+E12*(1+$C$7)","v":551250},{"$f":"+F12*(1+$C$7)","v":578812.5},607753.125]
[null,{"$f":"+SUM(C13:J13)","v":827312.49717424985},{"$f":"+C12/(1+$C$8)^C11","v":-1000000},{"$f":"+D12/(1+$C$8)^D11","v":434782.60869565222},396975.42533081293,362455.8231281336,330937.92546481761,302160.71455483348]
[]
[]
[null,"VAN",{"$f":"+C12+NPV($C$8,D12:J12)","v":827312.49717424996}]
[null,"TIR",{"$f":"+IRR(C12:J12,0)","v":0.45067246406856332}]
[]
[]
[null,"tabella 2 dimensioni"]
[null,null,null,"WACC"]
[null,"g",{"$f":"+C16","v":827312.49717424996},0,0.05,0.1,0.15,0.2,0.25,0.3]
[null,null,0,1500000,1762815.625,2052550,2371190.625,2720800,3103515.625,3521550]
[null,null,0.05,1164738.3353154096,1380952.3809523811,1618767.2635911796,1879754.9326032819,2165546.1018226529,2477830.2495457381,2818355.6185314707]
[null,null,0.1,895393.3847042236,1075295.6361649411,1272727.272727272,1488945.6600704114,1725254.7329727844,1983004.995312043,2263593.5200650715]
[null,null,0.15,676077.54900570121,827312.49717424996,992918.9603475146,1173913.0434782612,1371348.1397744035,1586314.9306990015,1819941.3859702637]
[null,null,0.2,495306.06995884795,623636.88151041674,763860.75745884795,916806.57029642491,1083333.3333333335,1264330.2006976595,1460716.4673353913]
[null,null,0.25,344640,454470.14399999985,574226.94400000013,704592.38400000008,846273.02400000021,1000000,1166529.0240000002]
[null,null,0.3,217784.87609515921,312520.5363419184,415607.08120002248,527610.10172559111,649115.38865532074,780728.93240648182,923076.92307692301]

{"sheet":"indici","index":7,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FINANZA PRATICA"]
[null,"Indici"]
[]
[null,"Indici rotazione capitale circolante"]
[null,"Indici di liquidità"]
[null,"Indici struttura finanziaria"]
[null,"Indici redditività"]
[null,"Indici mercato e multipli borsa"]
[]
[null,"Nome indice","Sintesi","Formula",{"$f":"+CONCATENATE(C11,\" ; \",B11,\" ; \",D11)","v":"Sintesi ; Nome indice ; Formula"}]
[]
[null,"Indici rotazione capitale circolante",null,null,{"$f":"+B13","v":"Indici rotazione capitale circolante"}]
[null,"Tempo medio incasso","TMI","Clienti/(Ricavi/360)",{"$f":"+CONCATENATE(C14,\" ; \",B14,\" ; \",D14)","v":"TMI ; Tempo medio incasso ; Clienti/(Ricavi/360)"}]
[null,"Tempo medio pagamenti","TMP","Fornitori/(Costi materie e servizi/360)",{"$f":"+CONCATENATE(C15,\" ; \",B15,\" ; \",D15)","v":"TMP ; Tempo medio pagamenti ; Fornitori/(Costi materie e servizi/360)"}]
[null,"Tempo medio giacenza scorte","TMGS","Magazzino/(Costo venduto/360)","TMGS ; Tempo medio giacenza scorte ; Magazzino/(Costo venduto/360)"]
[null,"Tempo medio giacenze materie prime","TMGM","Magazzino matierie prime/(Acquisti/360)","TMGM ; Tempo medio giacenze materie prime ; Magazzino matierie prime/(Acquisti/360)"]
[null,"Tempo medio prodotti finiti","TMPF","Magazzino prodotti finiti/(Coste del venduto/360)","TMPF ; Tempo medio prodotti finiti ; Magazzino prodotti finiti/(Coste del venduto/360)"]
[null,"Tempo medio giacenze semilavorati","TMGS","Magazzino semilavorati/(% costo del venduto/360)","TMGS ; Tempo medio giacenze semilavorati ; Magazzino semilavorati/(% costo del venduto/360)"]
[]
[]
[null,"Indici liquidità e copertura",null,null,{"$f":"+B22","v":"Indici liquidità e copertura"}]
[null,"Indice copertura oneri finanziari o Interest Coverage Ratio","ICR","Reddito Operativo EBIT/Oneri finanziari",{"$f":"+CONCATENATE(C23,\" ; \",B23,\" ; \",D23)","v":"ICR ; Indice copertura oneri finanziari o Interest Coverage Ratio ; Reddito Operativo EBIT/Oneri finanziari"}]
[null,"Indice copertura debito o Debti Servise Coverage Ratio","DSCR","Margine Operativo Lordo EBITDA/(Quote capitale debito + Oneri finanziari)","DSCR ; Indice copertura debito o Debti Servise Coverage Ratio ; Margine Operativo Lordo EBITDA/(Quote capitale debito + Oneri finanziari)"]
[null,"Indice copertura della liquidità oneri finanziari ","ICR*","Margine Operativo Lordo EBITDA/Oneri finanziari","ICR* ; Indice copertura della liquidità oneri finanziari  ; Margine Operativo Lordo EBITDA/Oneri finanziari"]
[null,"Indice copertura posizione finanziaria netta","ICPFN","Margine Operativo Lordo EBITDA/Posizione Finanziaria Netta","ICPFN ; Indice copertura posizione finanziaria netta ; Margine Operativo Lordo EBITDA/Posizione Finanziaria Netta"]
[null,"Indice liquidità primaria o immediata o acid test","ILI","(Cassa+Attività immediate)/Passività a breve termine","ILI ; Indice liquidità primaria o immediata o acid test ; (Cassa+Attività immediate)/Passività a breve termine"]
[null,"Indice liquidità secondaria o disponibilità","ID","Attività a breve termine/Passività a breve termine","ID ; Indice liquidità secondaria o disponibilità ; Attività a breve termine/Passività a breve termine"]
[null,"Indice copertura immobilizzazioni","IC","Attività a lungo termine/(Passività a lungo termine+Capitale Netto)","IC ; Indice copertura immobilizzazioni ; Attività a lungo termine/(Passività a lungo termine+Capitale Netto)"]
[]
[]
[null,"Indici struttura finanziaria",null,null,{"$f":"+B32","v":"Indici struttura finanziaria"}]
[null,"Posizione Finanziaria Netta su Capitale netto o Leverage/Equity o Debt Equity","Debt/Equity","PFN/Capitale netto",{"$f":"+CONCATENATE(C33,\" ; \",B33,\" ; \",D33)","v":"Debt/Equity ; Posizione Finanziaria Netta su Capitale netto o Leverage/Equity o Debt Equity ; PFN/Capitale netto"}]
[null,"Posizione Finanziaria Netta su Capitale netto e PFN o Leverage/Capital o Debt Capital","Debt Capital","PFN/(Capitale netto+Posizione finanziaria Netta)","Debt Capital ; Posizione Finanziaria Netta su Capitale netto e PFN o Leverage/Capital o Debt Capital ; PFN/(Capitale netto+Posizione finanziaria Netta)"]
[]
[]
[null,"Indici redditività",null,null,{"$f":"+B37","v":"Indici redditività"}]
[null,"Rendimento Investimenti o Return On Investment","ROI","Reddito Operativo EBIT/Capitale Investito Netto Operativo",{"$f":"+CONCATENATE(C38,\" ; \",B38,\" ; \",D38)","v":"ROI ; Rendimento Investimenti o Return On Investment ; Reddito Operativo EBIT/Capitale Investito Netto Operativo"}]
[null,"Rendimento Netto o Return On Equity","ROE","Utile netto/Capitale proprio","ROE ; Rendimento Netto o Return On Equity ; Utile netto/Capitale proprio"]
[null,"Rendimento Vendite o Return On Sales","ROS","Reddito Operativo EBIT/Ricavi","ROS ; Rendimento Vendite o Return On Sales ; Reddito Operativo EBIT/Ricavi"]
[null,"Turnover Capitale Investito Netto Operativo","Turnover/CINO","Ricavi/Capitale Investito Netto Operativo","Turnover/CINO ; Turnover Capitale Investito Netto Operativo ; Ricavi/Capitale Investito Netto Operativo"]
[]
[]
[null,"Indici di merato (multipli di Borsa)",null,null,{"$f":"+B44","v":"Indici di merato (multipli di Borsa)"}]
[null,"Rapporto Prezzo - Utili","P/E","Prezzo per Azione / Utili per Azione (EPS)"]
[null,"Rapporto valore di mercato su valore contabile","Pm/Pc","Prezzo per Azione / Valore contabile per azione"]
[null,"Multiplo EV/EBIT","EV/EBIT","Enterprise value / Reddito operativo"]
[null,"Multiplo EV/EBITDA","EV/EBITDA","Enterprise value / Margine Operativo Lordo"]