{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["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":"Sheet1","index":0,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Press the button to copy the function"]
[null,null,null,null,null,"Then, press CNTL A on the code and copy it to VBA in your sheet"]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Cash Flow",-100,9,{"$f":"C7","v":9},{"$f":"D7","v":9},9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]
[]
["Payback",{"$f":"payback(7:7)","v":11.111110687255859},{"$f":"_xlfn.FORMULATEXT(B9)","v":"=payback(7:7)"},null,null,{"$f":"payback(B7:U7)","v":11.111110687255859},{"$f":"_xlfn.FORMULATEXT(F9)","v":"=payback(B7:U7)"}]
[]
["Discount Rate",0.05]
[]
["Discounted Payback",{"$f":"dpayback(B11,7:7)","v":16.626503804057997},{"$f":"_xlfn.FORMULATEXT(B13)","v":"=dpayback(B11,7:7)"}]
[]
[null,{"$f":"dpayback(B11,B7:U7)","v":16.626503804057997},{"$f":"_xlfn.FORMULATEXT(B15)","v":"=dpayback(B11,B7:U7)"}]