{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"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":"Hoja1","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,null,"Proyecto 1","Proyecto 2"]
[null,"Año","Flujo de efectivo esperado"]
[null,0,-11.4,-15]
[null,1,-7.9,-20]
[null,{"$f":"B4+1","v":2},3,5]
[null,3,3.5,9]
[null,4,4,11]
[null,5,4.5,13]
[null,6,5,15]
[null,7,7,17]
[null,8,null,19]
[null,9,null,21]
[null,10,null,59]
[]
["Payback (años) ",null,{"$f":"IF(SUM(C3:C4)>=0,(1-((SUM(C3:C4)/C4))),IF(SUM(C3:C5)>=0,(2-((SUM(C3:C5)/C5))),IF(SUM(C3:C6)>=0,(3-((SUM(C3:C6)/C6))),IF(SUM(C3:C7)>=0,(4-((SUM(C3:C7)/C7))),IF(SUM(C3:C8)>=0,(5-((SUM(C3:C8)/C8))),IF(SUM(C3:C9)>=0,(6-((SUM(C3:C9)/C9))),IF(SUM(C3:C10)>=0,(7-((SUM(C3:C10)/C10))),IF(SUM(C3:C11)>=0,(8-((SUM(C3:C11)/C11))),IF(SUM(C3:C12)>=0,(9-((SUM(C3:C12)/C12))),IF(SUM(C3:C13)>=0,10,\"más de 10 años\"))))))))))","v":5.86},{"$f":"IF(SUM(D3:D4)>=0,(1-((SUM(D3:D4)/D4))),IF(SUM(D3:D5)>=0,(2-((SUM(D3:D5)/D5))),IF(SUM(D3:D6)>=0,(3-((SUM(D3:D6)/D6))),IF(SUM(D3:D7)>=0,(4-((SUM(D3:D7)/D7))),IF(SUM(D3:D8)>=0,(5-((SUM(D3:D8)/D8))),IF(SUM(D3:D9)>=0,(6-((SUM(D3:D9)/D9))),IF(SUM(D3:D10)>=0,(7-((SUM(D3:D10)/D10))),IF(SUM(D3:D11)>=0,(8-((SUM(D3:D11)/D11))),IF(SUM(D3:D12)>=0,(9-((SUM(D3:D12)/D12))),IF(SUM(D3:D13)>=0,10,\"más de 10 años\"))))))))))","v":4.7692307692307692}]
[]
["WACC",0.106]
[]
["TIR",null,{"$f":"IRR(C3:C13,$B$17)","v":7.8318528637851381E-2},{"$f":"IRR(D3:D13,$B$17)","v":0.28718244643619562}]
[]
["VAN",null,{"$f":"C3+NPV($B$17,C4:C13)","v":-1.9212490817152332},{"$f":"D3+NPV($B$17,D4:D13)","v":47.965962093094376}]