{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pagina Iniziale","TIR e REA","TRM e PP"],"not_rendered":{"images":5,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Pagina Iniziale","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
[]
[]
[null,"Manuale di"]
[null,"Matematica finanziaria"]
[null,"Carocci editore - 2012"]
[]
[null,"Marco Micocci - Giovanni Masala"]
[]
[null,"Capitolo 4"]

{"sheet":"TIR e REA","index":1,"n_rows":22,"n_cols":11,"rows_kept":22}
[null,"Calcolo del TIR e del REA"]
[null,"Importi",-2000,450,550,650,600,500,400,300,200]
[null,"Epoche",0,1,2,3,4,5,6,7,8]
[]
[null,"Tasso",0.1]
[]
[null,"REA",{"$f":"NPV(C5,D2:K2)+C2","v":{"v":545.2982025036781,"d":"545.30"}}]
[null,"TIR",{"$f":"IRR(C2:K2)","v":{"v":0.17921386148371043,"d":"17.92%"}}]
[]
[]
[null,"Epoche t","Importi","i(0, t-1, t)","v(0,t)","Importi att.ti"]
[null,0,-2000,null,{"v":1,"d":"1.00000"},{"$f":"+C12*E12","v":{"v":-2000,"d":"-2000.0"}}]
[null,1,450,0.095,{"$f":"1/(1+D13)","v":{"v":0.9132420091324202,"d":"0.91324"}},{"$f":"+C13*E13","v":{"v":410.95890410958907,"d":"411.0"}}]
[null,2,550,{"v":0.08,"d":"0.080"},{"$f":"+E13*(1/(1+D14))","v":{"v":0.8455944529003889,"d":"0.84559"}},{"v":465.07694909521393,"d":"465.1"}]
[null,3,650,{"v":0.12,"d":"0.120"},{"$f":"+E14*(1/(1+D15))","v":{"v":0.7549950472324901,"d":"0.75500"}},{"v":490.74678070111855,"d":"490.7"}]
[null,4,600,{"v":0.11,"d":"0.110"},{"v":0.6801757182274685,"d":"0.68018"},{"v":408.10543093648107,"d":"408.1"}]
[null,5,500,{"v":0.1,"d":"0.100"},{"v":0.6183415620249714,"d":"0.61834"},{"v":309.1707810124857,"d":"309.2"}]
[null,6,400,{"v":0.09,"d":"0.090"},{"v":0.5672858367201572,"d":"0.56729"},{"v":226.91433468806287,"d":"226.9"}]
[null,7,300,0.095,{"v":0.5180692572786824,"d":"0.51807"},{"v":155.4207771836047,"d":"155.4"}]
[null,8,200,0.087,{"v":0.47660465251028733,"d":"0.47660"},{"v":95.32093050205746,"d":"95.3"}]
[]
[{"$nulls":4},"REA",{"$f":"SUM(F12:F20)","v":{"v":561.7148882286133,"d":"561.7"}}]

{"sheet":"TRM e PP","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Calcolo del TRM"]
[null,"Epoche","Importi",null,"Montante finale"]
[null,0,-1100,null,{"$f":"+C3","v":{"v":-1100,"d":"-1100.0"}}]
[null,1,750,null,{"$f":"IF(E3>0,+E3*(1+$C$13)^(B4-B3)+C4,+E3*(1+$C$14)^(B4-B3)+C4)","v":{"v":-515,"d":"-515.0"}}]
[null,2,580,null,{"$f":"IF(E4>0,+E4*(1+$C$13)^(B5-B4)+C5,+E4*(1+$C$14)^(B5-B4)+C5)","v":{"v":-12.25,"d":"-12.3"}}]
[null,3,-420,null,{"v":-434.0875,"d":"-434.1"}]
[null,4,200,null,{"v":-299.20062499999995,"d":"-299.2"}]
[null,5,100,null,{"v":-244.0807187499999,"d":"-244.1"}]
[null,6,200,null,{"v":-80.69282656249987,"d":"-80.7"}]
[null,7,200,null,{"v":107.20324945312515,"d":"107.2"}]
[null,8,30,null,{"v":147.92357439843767,"d":"147.9"}]
[]
[null,"tasso creditore",{"v":0.1,"d":"0.10"}]
[null,"tasso debitore",0.15]
[]
[null,"Calcolo del Payback Period"]
[null,"Epoche","Importi",null,"Cumulato","Segno"]
[null,0,-1100,null,{"$f":"+C18","v":-1100},{"$f":"IF(E18>0, \"+\",\" -\")","v":" -"}]
[null,1,750,null,{"$f":"+E18+C19","v":-350},{"$f":"IF(E19>0, \"+\",\" -\")","v":" -"}]
[null,2,580,null,{"$f":"+E19+C20","v":230},"+"]
[null,3,-420,null,-190," -"]
[null,4,200,null,10,"+"]
[null,5,100,null,110,"+"]
[null,6,200,null,310,"+"]
[null,7,200,null,510,"+"]
[null,8,30,null,540,"+"]